nerdexam
Microsoft

70-768 · Question #33

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…

The correct answer is C. Ensure that the Transactional Deployment property is set to True. 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…

Configure and maintain SQL Server Analysis Services (SSAS)

Question

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?

Options

  • AEnsure that DirectQuery is enabled for the model.
  • BEnsure that DirectQuery is disabled for the model.
  • CEnsure that the Transactional Deployment property is set to True.
  • DEnsure that the Transactional Deployment property is set to False.
  • EProcess the model in Process Full mode.
  • FProcess the model in Process Data mode.
  • GProcess the model in Process Defrag mode.

How the community answered

(27 responses)
  • A
    4% (1)
  • B
    15% (4)
  • C
    70% (19)
  • E
    4% (1)
  • F
    7% (2)

Explanation

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. https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/deployment- script-files-specifying-processing-options

Topics

#transactional deployment#processing modes#tabular model administration#SSAS roles

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-768 Practice