PrepAway - Latest Free Exam Questions & Answers

You need to configure the tabular data model.What shoul…

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? 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. partitions, it will be dropped before re-populating the partition with source data.

PrepAway - Latest Free Exam Questions & Answers

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.

Explanation:

Process Full processes an Analysis Services object and all the objects that it contains. When Process Full is
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
G: There is no processing option named Process Defrag.
References:https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/processingoptions-and-settings-analysis-services


Leave a Reply