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 are developing Microsoft SQL Server Analysis Services (SSAS) tabular model.
The model must meet the following requirements:
You need to configure model.
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.
Answer: A
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).
References:https://www.sqlshack.com/query-ssas-tabular-model-database-using-dax-functions/
Leave a Reply