70-768 · Question #28
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 A. Ensure that DirectQuery is enabled for the model. DAX originally emerged from a Power Pivot add-in for Excel, as a formula language extension for creating calculated columns and measures for data analysis (which are also integral elements of one SSAS Tabular model database, too), but when Microsoft added support for DAX…
Question
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
(35 responses)- A71% (25)
- C3% (1)
- D9% (3)
- E14% (5)
- F3% (1)
Explanation
DAX originally emerged from a Power Pivot add-in for Excel, as a formula language extension for creating calculated columns and measures for data analysis (which are also integral elements of one SSAS Tabular model database, too), but when Microsoft added support for DAX queries in SQL Server 2012, BI experts started "daxing" data from Tabular model databases. That trend continues, because of simplicity and fast query execution (related to DirectQuery mode in SSAS Tabular).
Topics
Community Discussion
No community discussion yet for this question.