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.
The explanation does not make any sense to me. It is a definition instead of an explanation.
Replying to myself. I would go for Process Defrag.
Here we have a model with many tables (“The model is the basis for reports on inventory levels, popular products, and regional store performance.”)
from which lots of data have been removed (“Each company starts with a copy of the database and tabular model that contains data for a specific product line.”)
Process Defrag operation removes all dictionary entries that no longer exist in the data set and rebuilds the partition data based on the new dictionaries.
Do not hesitate to prove me wrong.
If Transactional Deployment is set to True, Analysis Services deploys all metadata changes and all process commands within a single transaction.
Regarding the “correct answer” – what has the ‘Transactional Deployment’ setting got to do with optimising query performance?!!