Online Access Free 70-768 Exam Questions

You are designing a SQL Server Analysis Services (SSAS) cube.You need to create a measure to count unique customers.What should you do?

• A.Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.
• B.Create a dimension. Then add a cube dimension and link it several times to the measure group.
• C.Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• D.Create several dimensions. Add each dimension to the cube.

Drag and Drop Question
You need to resolve the issues that the users report.
Which processing options should you use? To answer, drag the appropriate processing option to the correct location or locations. Each processing option 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.

Correct Answer:

Explanation:
Box1: Process Full:
When Process Full is executed against an object that has already been processed, Analysis Services drops all data in the object, and then processes the object.
This kind of processing is required when a structural change has been made to an object, for example, when an attribute hierarchy is added, deleted, or renamed.
Box 2: Process Default
Detects the process state of database objects, and performs processing necessary to deliver unprocessed or partially processed objects to a fully processed state.
If you change a data binding, Process Default will do a Process Full on the affected object.
Box 3:
Not Process Update: Forces a re-read of data and an update of dimension attributes. Flexible aggregations and indexes on related partitions will be dropped.

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a Microsoft SQL Server Analysis Services (SSAS) instance that is configured to use multidimensional mode. You create the following cube:

You need to create a new dimension that allows users to list shipments by the country where the product is shipped.
Which relationship type should you use between the Shipment table and the new dimension?

• A.no relationship
• B.referenced
• C.many-to-many
• D.data mining
• E.regular
• F.fact

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 a Microsoft SQL Server Analysis Services (SSAS) multidimensional database that stores customer and order data for customers in the United States only. The database contains the following objects:

You must create a KPI named Large Sales Target that uses the Traffic Light indicator to display status. The KPI must contain:

You need to create the KPI.
Solution: You set the value of the Status expression to:

Does the solution meet the goal?

• A.Yes
• B.No

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are developing Microsoft SQL Server Analysis Services (SSAS) tabular model.
The model must meet the following requirements:
You need to configure model.
What should you do?

• A.Process the model in Process Data mode.
• B.Ensure that the Transactional Deployment property is set to False.
• C.Ensure that the Transactional Deployment property is set to True.
• D.Process the model in Process Full mode.
• E.Ensure that DirectQuery is enabled for the model.
• F.Process the model in Process Defrag mode.
• G.Ensure that DirectQuery is disabled for the model.