Exam 70-768 All Questions

View all questions & answers for the 70-768 exam

Exam 70-768 topic 1 question 23 discussion

Actual exam question from Microsoft's 70-768

Question #: 23
Topic #: 1

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?

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.

Show Suggested Answer

Suggested Answer: C 🗳️
The Transactional Deployment setting controls whether the deployment of metadata changes and process commands occurs in a single transaction or in separate transactions.
If this option is True (default), Analysis Services deploys all metadata changes and all process commands within a single transaction.
If this option is False, Analysis Services deploys the metadata changes in a single transaction, and deploys each processing command in its own transaction.
References:https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/deployment-script-files-specifying-processing-options

by kosa at July 27, 2019, 6:22 a.m.

Comments

Submit Cancel

othman_ee

4 years, 6 months ago

going with C

upvoted 1 times

...

clement_

4 years, 7 months ago

I don't get this one. There is nothing in explanation or comments yet that refer to the company split scenario. In my view, we are talking only about a reduced data volume (only one product line left) and from what I understand in the docs, the Process Defrag is there to handle such situation. G then, but I would need clarification on this one.

upvoted 2 times

...

panal

4 years, 7 months ago

I think Answer is correct

upvoted 1 times

...

Torent2005

4 years, 11 months ago

Transactional deployment prevents before deployment of empty or unprocessed cube. And it's related only with deployment and not with queries. To rise performance you should enable DirectQuery

upvoted 1 times

HaJee

4 years, 9 months ago

DirectQuery adversely impacts performance of queries.

upvoted 2 times

melvin9900

4 years, 8 months ago

Correct . In-memory is better with performance than DirectQuery.

upvoted 2 times

...

kosa

5 years, 11 months ago

Shouldn't it be D?

upvoted 1 times

z8zhong

5 years, 4 months ago

I think minimize downtime should set all in a single transaction cuz committing multiple transactions could rise downtime

upvoted 7 times

Anette

4 years, 11 months ago

yes, C is correct

upvoted 1 times

...

melvin9900

4 years, 8 months ago

If we set the TransactionalDeployment flag in our deployment settings, we can do a refresh with minimal downtime. https://notesfromthelifeboat.com/post/analysis-services-1-deployment/

upvoted 3 times

...