070-768 Exam Question 36
You are responsible for installing new database server instances.
You must install Microsoft SQL Server Analysis Services (SSAS) to support deployment of the following projects. You develop both projects by using SQL Server Data Tools.
You need to install the appropriate services to support both projects.
Which two actions should you perform? Each correct answer presents part of the solution.
You must install Microsoft SQL Server Analysis Services (SSAS) to support deployment of the following projects. You develop both projects by using SQL Server Data Tools.
You need to install the appropriate services to support both projects.
Which two actions should you perform? Each correct answer presents part of the solution.
070-768 Exam Question 37
Hotspot Question
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 38
Drag and Drop Question
You are writing a MDX query to retrieve data from a Microsoft SQL Server Analysis Services (SSAS) cube named Channel Sales. The cube defines two measures named Sales and Cost.
The cube also defines a Date dimension and a Product dimension.
You need to retrieve profit values for a year named CY2016.
How should you complete the MDX statement? To answer, drag the appropriate MDX segment 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.
You are writing a MDX query to retrieve data from a Microsoft SQL Server Analysis Services (SSAS) cube named Channel Sales. The cube defines two measures named Sales and Cost.
The cube also defines a Date dimension and a Product dimension.
You need to retrieve profit values for a year named CY2016.
How should you complete the MDX statement? To answer, drag the appropriate MDX segment 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.
070-768 Exam Question 39
You are optimizing a Microsoft SQL Server Analysis Services (SSAS) multidimensional model over a SQL Server database. You have a table named City which has several dimensions that do not contain a space in their names. One dimension is named SalesTerritory rather than Sales Territory.
You need to ensure that Report developers can drag the attribute name to the report rather than having to re-label the attributes by implementing spaces. You must minimize administrative effort and not break any upstream processes.
What should you do?
You need to ensure that Report developers can drag the attribute name to the report rather than having to re-label the attributes by implementing spaces. You must minimize administrative effort and not break any upstream processes.
What should you do?
070-768 Exam Question 40
You are responsible for installing new database server instances.
You must install Microsoft SQL Server Analysis Services (SSAS) to support deployment of the following projects. You develop both projects by using SQL Server Data Tools.
Project1 uses the tabular data model.
Project2 uses SQL Server data mining to predict customer-purchasing intentions by using the Decision
Trees algorithm.
You need to install the appropriate services to support both projects.
Which two actions should you perform? Each correct answer presents part of the solution.
You must install Microsoft SQL Server Analysis Services (SSAS) to support deployment of the following projects. You develop both projects by using SQL Server Data Tools.
Project1 uses the tabular data model.
Project2 uses SQL Server data mining to predict customer-purchasing intentions by using the Decision
Trees algorithm.
You need to install the appropriate services to support both projects.
Which two actions should you perform? Each correct answer presents part of the solution.