Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals…

Question

Options

• AYes
• BNo

• A
  76% (31)
• B
  24% (10)

Explanation

By default, tabular models use an in-memory cache to store and query data. When tabular models query data residing in-memory, even complex queries can be incredibly fast. However, there are some limitations to using cached data. Namely, large data sets can exceed available memory, and data freshness requirements can be difficult if not impossible to achieve on a regular processing schedule. DirectQuery overcomes these limitations while also leveraging RDBMS features making query execution more efficient. With DirectQuery: + Data is up-to-date, and there is no extra management overhead of having to maintain a separate copy of the data (in the in-memory cache). Changes to the underlying source data can be immediately reflected in queries against the data model. Datasets can be larger than the memory capacity of an Analysis Services server. https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/directquery-mode-ssas-

No community discussion yet for this question.