Microsoft Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence - 70-460 Exam Practice Test
DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) tabular project based on a Microsoft Azure SQL Database database. The ProcessingOption property for the project is set to Do Not Process.
Several calculated columns have been added to a table. The project has been deployed to the production server.
You need to ensure that newly added data is processed on the production server.
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 developing a SQL Server Analysis Services (SSAS) tabular project based on a Microsoft Azure SQL Database database. The ProcessingOption property for the project is set to Do Not Process.
Several calculated columns have been added to a table. The project has been deployed to the production server.
You need to ensure that newly added data is processed on the production server.
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.)
Correct Answer:
You need to define the trend calculation for the sales performance KPI. Which KPI trend MDX expression should you use?
Correct Answer: D
Vote an answer
You need to configure security for the SSRS instance on SSRS01 to connect to SSAS and minimize downtime.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
Correct Answer: A,B,D
Vote an answer
You need to implement the aggregation designs for the cube.
What should you do?
What should you do?
Correct Answer: A
Vote an answer
DRAG DROP
You need to recommend a solution to implement the data security requirements for CUBE1.
Which three actions should you recommend performing 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 recommend a solution to implement the data security requirements for CUBE1.
Which three actions should you recommend performing in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Correct Answer:
HOTSPOT
You are designing a dimension named Employee for a SQL Server Analysis Services
multidimensional project.
The Employee dimension contains a DateOfBirth attribute and a MaritalStatus attribute.
You need to minimize the amount of time required to process the cube.
What should you do? To answer, select the appropriate relationship type for each attribute
in the answer area.
You are designing a dimension named Employee for a SQL Server Analysis Services
multidimensional project.
The Employee dimension contains a DateOfBirth attribute and a MaritalStatus attribute.
You need to minimize the amount of time required to process the cube.
What should you do? To answer, select the appropriate relationship type for each attribute
in the answer area.
Correct Answer:
Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You are designing a SQL Server Analysis Services (SSAS) cube.
You need to create a measure to count unique customers.
What should you do?
You are designing a SQL Server Analysis Services (SSAS) cube.
You need to create a measure to count unique customers.
What should you do?
Correct Answer: D
Vote an answer
You create a materialized reference dimension between a dimension named Regions and a measure group named Orders.
You use a table named Customers as a bridge as shown in the exhibit. (Click the Exhibit button.)
You need to ensure that data is updated to reflect any changes in the relationship. The solution must NOT require that the entire cube be reprocessed.
What should you reprocess?
You use a table named Customers as a bridge as shown in the exhibit. (Click the Exhibit button.)
You need to ensure that data is updated to reflect any changes in the relationship. The solution must NOT require that the entire cube be reprocessed.
What should you reprocess?
Correct Answer: C
Vote an answer
You are modifying a star schema data mart that feeds order data from a Microsoft Azure SQL Database database into a SQL Server Analysis Services (SSAS) cube. The data mart contains two large tables that include flags and indicators for some orders. There are 100 different flag columns, each with 10 different indicator values. Some flags reuse indicators. The tables both have a granularity that matches the fact table.
You have the following requirements:
- Allow users to slice data by all flags and indicators. - Modify the date dimension table to include a surrogate key of a numeric data type and add the surrogate key to the fact table. - Use the most efficient design strategy for cube processing and queries.
You need to modify the schema.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You have the following requirements:
- Allow users to slice data by all flags and indicators. - Modify the date dimension table to include a surrogate key of a numeric data type and add the surrogate key to the fact table. - Use the most efficient design strategy for cube processing and queries.
You need to modify the schema.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Correct Answer: D
Vote an answer