Microsoft Recertification for MCSE: Business Intelligence - 070-470무료 덤프문제 풀어보기
HOTSPOT
You are designing aggregations for a SQL Server Analysis Services (SSAS) cube. You need to ensure that every aggregation excludes the Category attribute. Which option should you select?
To answer, select the appropriate option in the answer area.
You are designing aggregations for a SQL Server Analysis Services (SSAS) cube. You need to ensure that every aggregation excludes the Category attribute. Which option should you select?
To answer, select the appropriate option in the answer area.
정답:
You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML. The report includes a dataset with fields named Description, Price, and Color. The report layout includes a table that displays product details and also includes columns named Description, Price, and Color.
You need to modify the report so that users can sort products by the Price column.
What should you do?
You need to modify the report so that users can sort products by the Price column.
What should you do?
정답: D
You need to implement the aggregation designs for the cube. What should you do?
정답: D
You are designing a SQL Server Integration Services (SSIS) solution. The solution will
contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables.
You have the following requirements:
Ensure that the deployment model supports changing the content of connection
strings by using parameters at execution time.
Ensure that the deployment model automatically starts from calls to the
catalog.start_execution stored procedure in the SSISDB database.
--
--
Maximize performance at execution time. Minimize development effort.
You need to design a solution that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables.
You have the following requirements:
Ensure that the deployment model supports changing the content of connection
strings by using parameters at execution time.
Ensure that the deployment model automatically starts from calls to the
catalog.start_execution stored procedure in the SSISDB database.
--
--
Maximize performance at execution time. Minimize development effort.
You need to design a solution that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
정답: C
You are creating a calculated measure in a sales cube by using a Multidimensional Expressions (MDX) calculation. The cube includes a date dimension. The date dimension has a hierarchy named Calendar that includes Calendar Year, Month, and Day attributes.
The calculated measure must calculate the year-to-date sales for the current slicer. The MDX calculation must work for as many hierarchy levels as possible.
You need to create a calculated measure for the cube that meets the requirements.
Which expression should you use in the calculation designer? (More than one answer choice may achieve the goal. Select the BEST answer.)
The calculated measure must calculate the year-to-date sales for the current slicer. The MDX calculation must work for as many hierarchy levels as possible.
You need to create a calculated measure for the cube that meets the requirements.
Which expression should you use in the calculation designer? (More than one answer choice may achieve the goal. Select the BEST answer.)
정답: D
---
You are designing a complex report that displays sales metrics for a customer hierarchy. The customer hierarchy has six levels and contains approximately 1 million members.
You have the following requirements:
Allow users to easily display and navigate data.
Minimize report processing time.
Simplify the report design and maintenance processes.
You need to design a report that meets the requirements.
How should you design the report? (More than one answer choice may achieve the goal. Select the BEST answer.)
You are designing a complex report that displays sales metrics for a customer hierarchy. The customer hierarchy has six levels and contains approximately 1 million members.
You have the following requirements:
Allow users to easily display and navigate data.
Minimize report processing time.
Simplify the report design and maintenance processes.
You need to design a report that meets the requirements.
How should you design the report? (More than one answer choice may achieve the goal. Select the BEST answer.)
정답: B
You are designing an extract, transform, load (ETL) process for loading data from a SQL
Azure database into a large fact table in a data warehouse each day with the prior day's
----
sales data.
The ETL process for the fact table must meet the following requirements:
Load new data in the shortest possible time.
Remove data that is more than 36 months old.
Minimize record locking.
Minimize impact on the transaction log.
You need to design an ETL process that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Azure database into a large fact table in a data warehouse each day with the prior day's
----
sales data.
The ETL process for the fact table must meet the following requirements:
Load new data in the shortest possible time.
Remove data that is more than 36 months old.
Minimize record locking.
Minimize impact on the transaction log.
You need to design an ETL process that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
정답: C
DRAG DROP
You are planning the installation of PowerPivot for SharePoint that will be used by your company's sales and marketing team.
You install SharePoint Server 2010 Enterprise Edition with Service Pack 1.
You need to install the PowerPivot for SharePoint instance. Then you need to configure the Default Account username used to provision shared services in the SharePoint farm.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
You are planning the installation of PowerPivot for SharePoint that will be used by your company's sales and marketing team.
You install SharePoint Server 2010 Enterprise Edition with Service Pack 1.
You need to install the PowerPivot for SharePoint instance. Then you need to configure the Default Account username used to provision shared services in the SharePoint farm.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
정답:
DRAG DROP
You are designing a SQL Server Reporting Services (SSRS) solution.
An existing report aggregates data from a SQL Server database in a chart.
You need to use the chart in a new report and ensure that other users can use the chart in
their reports.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
You are designing a SQL Server Reporting Services (SSRS) solution.
An existing report aggregates data from a SQL Server database in a chart.
You need to use the chart in a new report and ensure that other users can use the chart in
their reports.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
정답:
You need to implement the date dimension in the Operations database.
What should you do?
What should you do?
정답: D
HOTSPOT
You are configuring the partition storage settings for a SQL Server Analysis Services (SSAS) cube.
The partition storage must meet the following requirements:
Optimize the storage of source data and aggregations in the cube.
Use proactive caching.
Drop cached data that is more than 30 minutes old.
Update the cache when data changes, with a silence interval of 10 seconds.
You need to select the partition storage setting.
Which setting should you select?
To answer, select the appropriate setting in the answer area.
----
You are configuring the partition storage settings for a SQL Server Analysis Services (SSAS) cube.
The partition storage must meet the following requirements:
Optimize the storage of source data and aggregations in the cube.
Use proactive caching.
Drop cached data that is more than 30 minutes old.
Update the cache when data changes, with a silence interval of 10 seconds.
You need to select the partition storage setting.
Which setting should you select?
To answer, select the appropriate setting in the answer area.
----
정답:
You need to restrict access to data in the tables in the data warehouse.
What should you do?
What should you do?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
A hospital has a relational data warehouse, a SQL Server Analysis Services (SSAS) database, and a SQL Server Reporting Services (SSRS) instance. The SSAS database contains a cube named Pharmacy. Shared data sources exist in SSRS for the relational and SSAS databases. Each hospital department has its own report writers.
Report writers in the Human Resources (HR) department want to create new reports by using Report Builder. Many reports will include data generated by a custom formula that references data stored either in a data warehouse table or in the Pharmacy cube. The custom formula will compare time periods across multiple products, categories, and employees.
You have the following requirements:
Ensure that only the HR department report writers can access the custom formula.
Implement only one dataset.
Ensure that the dataset references the data source that will provide the fastest
data retrieval.
You need to meet the requirements to support the HR department report writers.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
---
Report writers in the Human Resources (HR) department want to create new reports by using Report Builder. Many reports will include data generated by a custom formula that references data stored either in a data warehouse table or in the Pharmacy cube. The custom formula will compare time periods across multiple products, categories, and employees.
You have the following requirements:
Ensure that only the HR department report writers can access the custom formula.
Implement only one dataset.
Ensure that the dataset references the data source that will provide the fastest
data retrieval.
You need to meet the requirements to support the HR department report writers.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
---
정답: D
You are deploying the Research model.
You need to ensure that the data contained in the model can be refreshed.
What should you do?
You need to ensure that the data contained in the model can be refreshed.
What should you do?
정답: A