70-466 Exam
[Printable] 70-466 Microsoft exam question 21-30 (Mar 2021)
Exam Code: 70-466 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Implementing Data Models and Reports with Microsoft SQL Server 2012
Certification Provider: Microsoft
Free Today! Guaranteed Training- Pass 70-466 Exam.
Q21. - (Topic 2)
You need to modify the Sales cube to support the planning requirements.
Which SSAS feature should you use?
A. At KPI
B. A translation
C. A perspective
D. A writeback partition
Answer: D
Q22. - (Topic 4)
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?
A. The Sales partition
B. The Regions dimension
C. The Customers dimension
D. The Orders partition
Answer: C
Q23. - (Topic 4)
You are modifying a SQL Server Analysis Service (SSAS) cube.
The cube consist of a single measure group that contains the following measures:
. Total Quantity On Hand
. Average Quantity On Hand
The measure group has a single partition that uses the MOLAP storage mode.
You need to modify the cube design to ensure that the Total Quantity On Hand measure is updated in real-time and that Average Quantity On Hand measure is updated hourly.
What should you do?
A. Change the storage mode of the partition to use proactive caching with minimum latency.
B. Create an XMLA script that will process the cube and then use SQL Server Agent to execute the script continuously.
C. Create a new measure group for the Average Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.
D. Create a new measure group for the Total Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.
Answer: D
Q24. - (Topic 4)
You are adding dimensions and a new measure group named Service Quality to an existing SQL Server Analysis Services (SSAS) cube.
Date is one of the existing dimensions in the SSAS database. The underlying fact table for the measure group is associated with multiple dates, including FirstServiceDate, SecondServiceDate, and ThirdServiceDate.
You need to ensure that users can slice the Service Quality measures by FirstServiceDate, SecondServiceDate, and ThirdServiceDate. You also need to ensure that the time required to process the database is minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create cube dimensions named FirstServiceDate. SecondServiceDate, and ThirdServiceDate by using the existing date dimension in the database.
B. Create three independent dimensions named FirstServiceDate, SecondServiceDate, and ThirdServiceDate and then link all three of them to the Service Quality measure group.
C. Create three new perspectives named FirstServiceDate. SecondServiceDate, and ThirdServiceDate.
D. Add three attributes named FirstServiceDate. SecondServiceDate, and ThirdServiceDate to the existing date dimension in the database.
Answer: C
Q25. DRAG DROP - (Topic 4)
You manage a SQL Server Reporting Services (SSRS) instance running in native mode.
You are troubleshooting a performance problem and need to know which reports are frequently executed. You discover that the report server execution logs are empty, despite significant report activity.
You need to ensure that the server is configured for report execution logging.
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.)
Answer:
Q26. HOTSPOT - (Topic 4)
You are designing a SQL Server Analysis Services (SSAS) cube that contains two measure groups named Sales History and Current Sales.
The Sales History measure group has the following characteristics:
....
Data changes on a monthly basis.
The measure group contains a very high data volume.
Queries that use the measure group only reference aggregate data.
The measure group includes SUM, MIN, MAX, and COUNT aggregate functions.
The Current Sales measure group has the following characteristics:
....
Data changes frequently.
The measure group contains a low data volume.
Queries that use the measure group often reference non-aggregate data.
The measure group includes SUM, MIN, MAX, and COUNT aggregate functions.
You need to select a storage mode for each measure group. The solution must meet the following requirements:
..
For the Sales History measure group, query performance must be optimized over
data latency.
For the Current Sales measure group, data latency must be optimized over query
performance.
What should you do? To answer, select the appropriate storage mode for each measure
group in the answer area.
Answer:
Q27. - (Topic 4)
You develop a SQL Server Analysis Services (SSAS) stored procedure.
You need to ensure that developers can create Multidimensional Expressions (MDX) calculations that use the stored procedure.
What should you do?
A. Register the assembly on the SSAS server instance.
B. Copy the assembly to the SSAS installation directory and register it by using the CREATE ASSEMBLY T-SQL command.
C. Register the assembly on the SSAS server by using regedit.exe.
D. Register the assembly on the SharePoint server by using regeditexe.
Answer: B
Q28. - (Topic 4)
You are modifying a SQL Server Analysis Services (SSAS) multidimensional database.
You have identified a dimension that is no longer used by any cubes.
You need to delete the dimension.
What should you do?
A. Write a Multidimensional Expressions (MDX) command to drop the dimension from the database.
B. Write a Data Mining Extensions (DMX) command to drop the dimension from the database.
C. Script the deletion of the dimension as an XMLA command for execution against the production model.
D. Write a T-SQL command to drop the dimension from the database.
Answer: C
Q29. - (Topic 4)
...
A large manufacturing company has manufacturing plants in many states. Each state has a dedicated SQL Server instance that stores its manufacturing data. Each SQL Server instance is configured identically and all instances have identical database structures.
You are developing a daily report that summarizes information on manufacturing activity.
The report has the following requirements:
It must have a stale name as one of the report parameters.
It must provide a daily summary of manufacturing activity of a selected state.
It must require minimal development and maintenance effort.
You need to develop the report to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Build one report for each state and instruct users to execute reports as needed.
B. Use a report-specific data source that defines an expression-based connection string based on the state parameter.
C. Build a centralized data repository, schedule a regular Extract Transform, and Load (ETL) process on all manufacturing data, and then use the repository to generate the report.
D. Use a shared data source that defines an expression-based connection string based on the state parameter.
Answer: B
Q30. - (Topic 4)
You are creating a new report in SQL Server Report Builder. You add a Microsoft Azure SQL Database data source. Then you add a dataset that has four fields named Year. Country, Category, and Sales.
You must design a matrix as shown in the following table.
The category rows (the first three rows as shown in the diagram) must present total sales amount by category. The country rows {the next six rows as shown in the diagram) must present total sales amount by country. The total row must present the total sales for each year.
You add a matrix to the report. You add a grouping of the Category field on the rows and a grouping of the Year field on the columns.
You need to add the countries on the rows of the matrix.
Which Row Group option should you select when you add the group?
A. Adjacent Below
B. Child Group
C. Parent Group
D. Adjacent Above
Answer: A