| Exam Code/Number: | 070-466Join the discussion |
| Exam Name: | Implementing Data Models and Reports with Microsoft SQL Server |
| Certification: | Microsoft |
| Question Number: | 186 |
| Publish Date: | Aug 29, 2026 |
|
Rating
100%
|
|
You need to develop an SSRS report that retrieves currency exchange rate data.
How should you configure the data source for the report?
You are modifying a SQL Server Analysis Services (SSAS) cube that aggregates order data from a Microsoft Azure SQL Database database. The existing database contains a customer dimension.
The marketing team has requested that customer marketing categories be added to the database.
The marketing categories must meet the following requirements:
* A customer member must be able to belong to multiple category members.
* A category member must be able to group several customer members.
* The marketing team must be able to create new categories every month in the data source.
You need to implement the appropriate solution to meet the requirements while ensuring that the amount of development and maintenance time is minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions.
You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis.
What should you do before the partition can be write-enabled?
You are developing a SQL Server Analysis Services (SSAS) tabular project. The model has tables named Invoice Line Items and Products.
The Invoice Line Items table has the following columns:
* Product Id
* Unit Sales Price
The Unit Sales Price column stores the unit price of the product sold.
The Products table has the following columns:
* Product Id
* Maximum Sales Price
The Maximum Sales Price column is available only in the Products table.
You add a column named Is Overpriced to the Invoice Line Items table. The Is Overpriced column must store a value of TRUE if the value of the Unit Sales Price is greater than the value of the Maximum Sales Price. Otherwise, a value of FALSE must be stored.
You need to define the Data Analysis Expressions (DAX) expression for the Is Overpriced column.
Which DAX formula should you use? (Each answer represents a complete solution.
Choose all that apply.)
You have a server that has SQL Server 2012 installed.
You need to identify which parallel execution plans are running in serial.
Which tool should you use?
