070-768 Exam Question 56
DRAG DROP
You are a business analyst for a company that uses a Microsoft SQL Server Analysis Services (SSAS) tabular database for reporting. The database model contains the following tables:
You have been asked to write a query for a report that returns the total sales for each product subcategory, as well as for each product category.
You need to write the query to return the data for the report.
How should you complete the DAX statement? To answer, drag the appropriate DAX segment to the correct locations. Each DAX segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:
You are a business analyst for a company that uses a Microsoft SQL Server Analysis Services (SSAS) tabular database for reporting. The database model contains the following tables:
You have been asked to write a query for a report that returns the total sales for each product subcategory, as well as for each product category.
You need to write the query to return the data for the report.
How should you complete the DAX statement? To answer, drag the appropriate DAX segment to the correct locations. Each DAX segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:
070-768 Exam Question 57
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You have an existing multidimensional cube that provides sales analysis. The users can slice by date, product, location, customer, and employee.
The management team plans to evaluate sales employee performance relative to sales targets.
You identify the following metrics for employees:
You need to implement the KPI based on the Status expression.
Solution: You design the following solution:
Does the solution meet the goal?
You have an existing multidimensional cube that provides sales analysis. The users can slice by date, product, location, customer, and employee.
The management team plans to evaluate sales employee performance relative to sales targets.
You identify the following metrics for employees:
You need to implement the KPI based on the Status expression.
Solution: You design the following solution:
Does the solution meet the goal?
070-768 Exam Question 58
What property do you set for each measure to improve the legibility of values in a client application?
070-768 Exam Question 59
HOTSPOT
You are deploying a multidimensional Microsoft SQL Server Analysis Services (SSAS) project. You add two new role-playing dimensions named Picker and Salesperson to the cube. Both of the cube dimensions are based upon the underlying dimension named
Employee in the data source view.
Users report that they are unable to differentiate the Salesperson attributes from the Picker attributes.
You need to ensure that the Salesperson and Picker attributes in each dimension use unique names.
In the table below, identify an option that you would use as part of the process to alter the names of the attributes for each of the dimensions.
NOTE: Make only one selection in each column.
You are deploying a multidimensional Microsoft SQL Server Analysis Services (SSAS) project. You add two new role-playing dimensions named Picker and Salesperson to the cube. Both of the cube dimensions are based upon the underlying dimension named
Employee in the data source view.
Users report that they are unable to differentiate the Salesperson attributes from the Picker attributes.
You need to ensure that the Salesperson and Picker attributes in each dimension use unique names.
In the table below, identify an option that you would use as part of the process to alter the names of the attributes for each of the dimensions.
NOTE: Make only one selection in each column.
070-768 Exam Question 60
DRAG DROP
You are a business analyst for a retail company that uses a Microsoft SQL Server Analysis Services (SSAS) multidimensional database to track sales. The database contains the following objects:
Your company is developing a promotional plaque to recognize the top resellers in the top
1 0 cities where the company does business. Each plaque must display the sales total for all resellers in the city. In addition, the plaque must display a total for all cities not in the top
1 0.
You have the following requirements:
You need to provide the information needed for the promotional plaques.
How should you complete the MDX statement? To answer, drag the appropriate MDX segments to the correct locations. Each MDX segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
You are a business analyst for a retail company that uses a Microsoft SQL Server Analysis Services (SSAS) multidimensional database to track sales. The database contains the following objects:
Your company is developing a promotional plaque to recognize the top resellers in the top
1 0 cities where the company does business. Each plaque must display the sales total for all resellers in the city. In addition, the plaque must display a total for all cities not in the top
1 0.
You have the following requirements:
You need to provide the information needed for the promotional plaques.
How should you complete the MDX statement? To answer, drag the appropriate MDX segments to the correct locations. Each MDX segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
