Microsoft 70-466 Actual Free Exam Questions & Community Discussion

You need to modify the Sales Regions hierarchy to meet the reporting requirements.
Which SSAS feature should you use?

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?

You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSAS) cube. The cube is used to measure sales growth by salesperson.
The cube contains a Key Performance Indicator (KPI) to show if a salesperson's sales are off target slightly off target, or on target.
You need to add a report item that visually displays the KPI status value as a red, yellow, or green flag.
Which report item should you add?

A multidimensional SQL Server Analysis Services (SSAS) database will be tested next week.
During the test period, users will access the database for 30 days. Multidimensional Expressions (MDX) queries generated during the test period must represent the variety of queries that will be used in the production environment.
After testing completes, you need to implement aggregations for every partition in the solution while minimizing development effort. You need to ensure that the aggregations are optimal.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT).
The report contains tables, images, charts, page breaks, gauges, and indicators.
You need to ensure that the reports can be exported to Microsoft Excel and PDF formats and do not have any layout issues.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are modifying a SQL Server Analysis Services (SSAS) cube.
The cube consists 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?

You have a database named database1. Database developers report that there are many deadlocks. You need to implement a solution to monitor the deadlocks.
The solution must meet the following requirements:
Support real-time monitoring.
Be enabled and disabled easily.
Support querying of the monitored data.
What should you implement? More than one answer choice may achieve the goal. Select the BEST answer.

You need to recommend a solution for the sales department that meets the security requirements.
What should you recommend?

You are developing a multidimensional project that includes a dimension named Organization. The dimension is based on the DimOrganization table in the data warehouse.
The following diagram illustrates the table design.

The Organization dimension includes a parent-child hierarchy named Organizations. The dimension includes the following dimension attributes:
* Organization, which is a key attribute
* Organizations, which defines the parent-child hierarchy
* Currency Code, which is a regular attribute
* PercentageOfOwnership, which is a regular attribute
When users browse the dimension, four hierarchies are visible to them.
You need to ensure that the Organization and PercentageOfOwnership hierarchies are not visible to users.
What should you do?

HOTSPOT
You create a new report in SQL Server Data Tools (SSDT). The report queries a Microsoft Azure SQL Database database table.
In a report table showing sales by cities, you need to enable users to interactively drill through to another report to show details of the customer sales within a chosen city.
Which text box property page should you use? (To answer, select the appropriate tab in the answer area.)