Microsoft 70-768 - Developing SQL Data Models Exam
Page: 2 / 8
Total 38 questions
Question #6 (Topic: Topic 2)
You need to configure the CoffeeSale fact table environment.
Which four actions should you perform in sequence? To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of
the correct orders you select.
[Microsoft-70-768-7.0/Microsoft-70-768-14_2.png]
Which four actions should you perform in sequence? To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of
the correct orders you select.
[Microsoft-70-768-7.0/Microsoft-70-768-14_2.png]
Answer: [Microsoft-70-768-7.0/Microsoft-70-768-14_3.png]
Question #7 (Topic: Topic 3)
A database named DB2 uses the InMemory query mode. Users frequently run the following
query:
[Microsoft-70-768-7.0/Microsoft-70-768-17_2.png]
You need to configure SQL Server Profiler to determine why the query is performing poorly.
Which three event should you monitor on the SQL Server Profiler trace events
configuration page? To answer, select the appropriate options in the answer area.
[Microsoft-70-768-7.0/Microsoft-70-768-18_2.png]
query:
[Microsoft-70-768-7.0/Microsoft-70-768-17_2.png]
You need to configure SQL Server Profiler to determine why the query is performing poorly.
Which three event should you monitor on the SQL Server Profiler trace events
configuration page? To answer, select the appropriate options in the answer area.
[Microsoft-70-768-7.0/Microsoft-70-768-18_2.png]
Answer: [Microsoft-70-768-7.0/Microsoft-70-768-18_3.png]
Question #8 (Topic: Topic 3)
A database named DB2 uses the InMemory query mode. Users frequently run the following
query:
[Microsoft-70-768-7.0/Microsoft-70-768-20_2.png]
You need to reconfigure the SSAS instance that hosts DB1.
Which three actions should perform in sequence? To answer, move the appropriate actions
from the list of actions to the answer area and arrange them in the correct order.
[Microsoft-70-768-7.0/Microsoft-70-768-21_2.png]
query:
[Microsoft-70-768-7.0/Microsoft-70-768-20_2.png]
You need to reconfigure the SSAS instance that hosts DB1.
Which three actions should perform in sequence? To answer, move the appropriate actions
from the list of actions to the answer area and arrange them in the correct order.
[Microsoft-70-768-7.0/Microsoft-70-768-21_2.png]
Answer: [Microsoft-70-768-7.0/Microsoft-70-768-21_3.png]
Question #9 (Topic: Topic 3)
A database named DB2 uses the InMemory query mode. Users frequently run the following
query:
[Microsoft-70-768-7.0/Microsoft-70-768-22_2.png]
You need to ensure no users see the PriorYearSales measure in the field list for the Sales
table.
What should you do?
query:
[Microsoft-70-768-7.0/Microsoft-70-768-22_2.png]
You need to ensure no users see the PriorYearSales measure in the field list for the Sales
table.
What should you do?
A. Create a perspective, and ensure that the PriorYearSales measure is not added to the perspective. Ensure that users connect to the model by using the perspective.
B. Set the Display Folder property for PriorYearSales toHidden.
C. Remove the PriorYearSales measure from the default field set of the Sales table.
D. Create a role using Read permissions, and define a DAX expression to filter out the PriorYearSales measure. Add all users to the role.
Answer: A
Question #10 (Topic: Topic 4)
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:
[Microsoft-70-768-7.0/Microsoft-70-768-24_2.png]
You must create a KPI named Large Sales Target that uses the Traffic Light indicator to
display status. The KPI must contain:
[Microsoft-70-768-7.0/Microsoft-70-768-24_3.png]
You need to create the KPI.
Solution: You set the value of the Status expression to:
[Microsoft-70-768-7.0/Microsoft-70-768-24_4.png]
Does the solution meet the goal?
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:
[Microsoft-70-768-7.0/Microsoft-70-768-24_2.png]
You must create a KPI named Large Sales Target that uses the Traffic Light indicator to
display status. The KPI must contain:
[Microsoft-70-768-7.0/Microsoft-70-768-24_3.png]
You need to create the KPI.
Solution: You set the value of the Status expression to:
[Microsoft-70-768-7.0/Microsoft-70-768-24_4.png]
Does the solution meet the goal?
A. Yes
B. No
Answer: B
