Microsoft 70-768 - Developing SQL Data Models Exam
Page: 3 / 8
Total 38 questions
Question #11 (Topic: Topic 4)
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 administer a Microsoft SQL Server Analysis Services (SSAS) tabular model for a travel
agency that specializes in vacation packages. Vacation bookings and packages are stored
in a SQL Server database. You use the model as the basis for customer emails that
highlight vacation packages that are currently underbooked, or projected to be
underbooked.
The company plans to incorporate cruise ship vacation packages. Cruise ship vacation
packages include new features such as region availability and cruise line specialties that
require changes to the tabular model.
You must ensure that the tabular model reflects the new vacation packages.
You need to configure the tabular data model.
What should you do?
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 administer a Microsoft SQL Server Analysis Services (SSAS) tabular model for a travel
agency that specializes in vacation packages. Vacation bookings and packages are stored
in a SQL Server database. You use the model as the basis for customer emails that
highlight vacation packages that are currently underbooked, or projected to be
underbooked.
The company plans to incorporate cruise ship vacation packages. Cruise ship vacation
packages include new features such as region availability and cruise line specialties that
require changes to the tabular model.
You must ensure that the tabular model reflects the new vacation packages.
You need to configure the tabular data model.
What should you do?
A. Ensure that DirectQuery is enabled for the model.
B. Ensure that DirectQuery is disabled for the model.
C. Ensure that the Transactional Deployment property is set to True.
D. Ensure that the Transactional Deployment property is set to False.
E. Process the model in Process Full mode.
F. Process the model in Process Data mode.
G. Process the model in Process Defrag mode.
Answer: E
Question #12 (Topic: Topic 4)
You are a business analyst for a retail company that uses a Microsoft SQL Server Analysis
Services (SSAS) multidimensional database for reporting. The database contains the
following objects:
[Microsoft-70-768-7.0/Microsoft-70-768-26_2.png]
You must create a report that shows, for each month, the Internet sales for that month and
the total Internet sales for the calendar year up to and including the current month.
You create the following MDX statement (Line numbers are included for reference only.):
[Microsoft-70-768-7.0/Microsoft-70-768-26_3.png]
You need to complete the MDX statement to return data for the report.
Which MDX segment should you use in line 01?
Services (SSAS) multidimensional database for reporting. The database contains the
following objects:
[Microsoft-70-768-7.0/Microsoft-70-768-26_2.png]
You must create a report that shows, for each month, the Internet sales for that month and
the total Internet sales for the calendar year up to and including the current month.
You create the following MDX statement (Line numbers are included for reference only.):
[Microsoft-70-768-7.0/Microsoft-70-768-26_3.png]
You need to complete the MDX statement to return data for the report.
Which MDX segment should you use in line 01?
A.
B.
C.
D.
Answer: B
Question #13 (Topic: Topic 4)
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?
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. Ensure that DirectQuery is enabled for the model.
B. Ensure that DirectQuery is disabled for the model.
C. Ensure that the Transactional Deployment property is set to True.
D. Ensure that the Transactional Deployment property is set to False.
E. Process the model in Process Full mode.
F. Process the model in Process Data mode.
G. Process the model in Process Defrag mode.
Answer: A
Question #14 (Topic: Topic 4)
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 administer a Microsoft SQL Server Analysis Services (SSAS) tabular model for a retail
company. The model is the basis for reports on inventory levels, popular products, and
regional store performance.
The company recently split up into multiple companies based on product lines. Each
company starts with a copy of the database and tabular model that contains data for a
specific product line.
You need to optimize performance of queries that use the copied tabular models while
minimizing downtime.
What should you do?
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 administer a Microsoft SQL Server Analysis Services (SSAS) tabular model for a retail
company. The model is the basis for reports on inventory levels, popular products, and
regional store performance.
The company recently split up into multiple companies based on product lines. Each
company starts with a copy of the database and tabular model that contains data for a
specific product line.
You need to optimize performance of queries that use the copied tabular models while
minimizing downtime.
What should you do?
A. Ensure that DirectQuery is enabled for the model.
B. Ensure that DirectQuery is disabled for the model.
C. Ensure that the Transactional Deployment property is set to True.
D. Ensure that the Transactional Deployment property is set to False.
E. Process the model in Process Full mode.
F. Process the model in Process Data mode.
G. Process the model in Process Defrag mode.
Answer: C
Question #15 (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 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:
[Microsoft-70-768-7.0/Microsoft-70-768-30_2.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 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:
[Microsoft-70-768-7.0/Microsoft-70-768-30_2.png]
Does the solution meet the goal?
A. Yes
B. No
Answer: B
