70-470 無料問題集「Microsoft Recertification for MCSE: Business Intelligence」
HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube.
You are writing the following Multidimensional Expressions (MDX) statement for use by a calculated measure. The measure computes the sales amount for the same time period of the previous year. (Line numbers are included for reference only.)
You need to complete the MDX statement.
Which MDX function should you use in line 03? To answer, select the appropriate MDX function in the functions list.
You are developing a SQL Server Analysis Services (SSAS) cube.
You are writing the following Multidimensional Expressions (MDX) statement for use by a calculated measure. The measure computes the sales amount for the same time period of the previous year. (Line numbers are included for reference only.)
You need to complete the MDX statement.
Which MDX function should you use in line 03? To answer, select the appropriate MDX function in the functions list.
正解：
DRAG DROP
You are the administrator of a SQL Server Integration Services (SSIS) catalog. You have access to the original password that was used to create the SSIS catalog.
A full database backup of the SSISDB database on the production server is made each day. The server used for disaster recovery has an operational SSIS catalog.
Information that is encrypted in the SSISDB database must not be lost.
You need to document the disaster recovery solution that restores the production SSIS catalog to the disaster recovery server.
Which three steps should you document 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 the administrator of a SQL Server Integration Services (SSIS) catalog. You have access to the original password that was used to create the SSIS catalog.
A full database backup of the SSISDB database on the production server is made each day. The server used for disaster recovery has an operational SSIS catalog.
Information that is encrypted in the SSISDB database must not be lost.
You need to document the disaster recovery solution that restores the production SSIS catalog to the disaster recovery server.
Which three steps should you document 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.)
正解：
DRAG DROP
Several reports are based on the same SQL Server Analysis Services (SSAS) cube. Each report has several datasets defined with complex Multidimensional Expressions (MDX) queries. The company maintains separate development, test and production environments.
The reports are running slowly. You plan to analyze report performance. You have the following requirements:
- Monitor query statistics on the production server with as little server overhead as possible. - Gather, replay, and analyze statistics on the test server with as little administrative
effort as possible.
- Identify the longest-running queries on both servers.
- Document statistics on disk reads on both servers.
You need to gather statistics and meet the requirements.
Which features should you use?
To answer, drag the appropriate feature or features to the correct location or locations in the answer area. (Use only features that apply.)
Several reports are based on the same SQL Server Analysis Services (SSAS) cube. Each report has several datasets defined with complex Multidimensional Expressions (MDX) queries. The company maintains separate development, test and production environments.
The reports are running slowly. You plan to analyze report performance. You have the following requirements:
- Monitor query statistics on the production server with as little server overhead as possible. - Gather, replay, and analyze statistics on the test server with as little administrative
effort as possible.
- Identify the longest-running queries on both servers.
- Document statistics on disk reads on both servers.
You need to gather statistics and meet the requirements.
Which features should you use?
To answer, drag the appropriate feature or features to the correct location or locations in the answer area. (Use only features that apply.)
正解：
You are developing a SQL Server Analysis Services (SSAS) cube.
The data warehouse has a table named FactStock that is used to track movements of stock. A column named MovementQuantity contains quantities of stock. A positive quantity is used for input and negative quantity is used for output. A column named MovementDate is related to the time dimension. The quantity in stock, at a given point in time, can be evaluated as the sum of all MovementQuantity values at that point in time.
You need to create a measure that calculates the quantity in stock value.
What should you do?
The data warehouse has a table named FactStock that is used to track movements of stock. A column named MovementQuantity contains quantities of stock. A positive quantity is used for input and negative quantity is used for output. A column named MovementDate is related to the time dimension. The quantity in stock, at a given point in time, can be evaluated as the sum of all MovementQuantity values at that point in time.
You need to create a measure that calculates the quantity in stock value.
What should you do?
正解：D
解答を投票する
DRAG DROP
You are creating a SQL Server Integration Services (SSIS) package to populate a fact table from a source table. The fact table and source table are located in a Windows Azure SQL Database. The source table has a price field and a tax field. The OLE DB source uses the data access mode of Table.
You have the following requirements:
- The fact table must populate a column named TotalCost that computes the sum of the price and tax columns. - Before the sum is calculated, any records that have a price of zero must be discarded.
You need to create the SSIS package in SQL Server Data Tools.
In what sequence should you order four of the listed components for the data flow task? (To answer, move the appropriate components from the list of components to the answer area and arrange them in the correct order.)
You are creating a SQL Server Integration Services (SSIS) package to populate a fact table from a source table. The fact table and source table are located in a Windows Azure SQL Database. The source table has a price field and a tax field. The OLE DB source uses the data access mode of Table.
You have the following requirements:
- The fact table must populate a column named TotalCost that computes the sum of the price and tax columns. - Before the sum is calculated, any records that have a price of zero must be discarded.
You need to create the SSIS package in SQL Server Data Tools.
In what sequence should you order four of the listed components for the data flow task? (To answer, move the appropriate components from the list of components to the answer area and arrange them in the correct order.)
正解：
---
You are developing a SQL Server Analysis Services (SSAS) multidimensional project.
A fact table is related to a dimension table named DimScenario by a column named ScenarioKey.
The dimension table contains three rows for the following scenarios:
Actual
Budget Q1
Budget Q3
You need to create a dimension to allow users to view and compare data by scenario.
What should you do?
You are developing a SQL Server Analysis Services (SSAS) multidimensional project.
A fact table is related to a dimension table named DimScenario by a column named ScenarioKey.
The dimension table contains three rows for the following scenarios:
Actual
Budget Q1
Budget Q3
You need to create a dimension to allow users to view and compare data by scenario.
What should you do?
正解：C
解答を投票する
DRAG DROP
You need to configure the attribute relationship types for the Salesperson dimension. Which configuration should you use?
To answer, drag the appropriate pair of attributes and attribute relationships from the list to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)
You need to configure the attribute relationship types for the Salesperson dimension. Which configuration should you use?
To answer, drag the appropriate pair of attributes and attribute relationships from the list to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)
正解：
DRAG DROP
You are creating a SQL Server Integration Services (SSIS) package to populate a fact table from a source table. The fact table and source table are located in a SQL Azure database. The source table has a price field and a tax field. The OLE DB source uses the data access mode of Table.
You have the following requirements:
- The fact table must populate a column named TotalCost that computes the sum of the price and tax columns. - Before the sum is calculated, any records that have a price of zero must be discarded.
You need to create the SSIS package in SQL Server Data Tools.
In what sequence should you order four of the listed components for the data flow task? (To answer, move the appropriate components from the list of components to the answer area and arrange them in the correct order.)
You are creating a SQL Server Integration Services (SSIS) package to populate a fact table from a source table. The fact table and source table are located in a SQL Azure database. The source table has a price field and a tax field. The OLE DB source uses the data access mode of Table.
You have the following requirements:
- The fact table must populate a column named TotalCost that computes the sum of the price and tax columns. - Before the sum is calculated, any records that have a price of zero must be discarded.
You need to create the SSIS package in SQL Server Data Tools.
In what sequence should you order four of the listed components for the data flow task? (To answer, move the appropriate components from the list of components to the answer area and arrange them in the correct order.)
正解：
