Exam 70-768 topic 1 question 22 discussion

Actual exam question from Microsoft's 70-768

Question #: 22
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 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.

Show Suggested Answer

Suggested Answer: E 🗳️
Process Full processes an Analysis Services object and all the objects that it contains. 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.
Incorrect Answers:
A, B: DirectQuery is just used to make queries run faster.
F: Process Data: Processes data only without building aggregations or indexes. If there is data is in the partitions, it will be dropped before re-populating the partition with source data.
G: There is no processing option named Process Defrag.
References:https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/processing-options-and-settings-analysis-services

by HaJee at Sept. 6, 2020, 7:48 a.m.

Comments

Submit Cancel

panal

4 years, 7 months ago

I Think Answer is correct

upvoted 2 times

...

HaJee

4 years, 9 months ago

How is A not correct? Direct Query ensures that the tabular model always reflects the current state of the data source.

upvoted 2 times

null

4 years, 9 months ago

'...that require changes to the tabular model.' So you need to reprocess the model structure. Direct Query is about querying the data directly and not storing it in memory and doesn't have anything to do with the structure.

upvoted 5 times

...