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? commands occurs in a single transaction or in separate transactions. within a single transaction. each processing command in its own transaction.
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:
ExplanationExplanation/Reference:The Transactional Deployment setting controls whether the deployment of metadata changes and process
If this option is True (default), Analysis Services deploys all metadata changes and all process commands
If this option is False, Analysis Services deploys the metadata changes in a single transaction, and deploys
References:https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/deployment-scriptfiles-specifying-processing-options