nerdexam
Exams70-466Questions#50
Microsoft

70-466 · Question #50

70-466 Question #50: Real Exam Question with Answer & Explanation

The correct answer is A: Select the tabular project type and use the In-Memory query mode.. When maximizing performance is the goal and data latency is acceptable, the tabular In-Memory mode is optimal because it caches the entire dataset in RAM and queries run against that cache without touching source systems.

Build a tabular data model

Question

You are developing a BI Semantic Model (BISM) that retrieves data from several sources including a SQL Azure database and an OData data feed. The model will be deployed to a server with significantly more memory than the total size of the source data. You have the data feed URL, which you will use when developing the model in SQL Server Data Tools (SSDT). The model must meet the following requirements: - Maximize performance - Data latency of up to one month is acceptable You need to choose a project type and a data access mode to meet the requirements. What should you do?

Options

  • ASelect the tabular project type and use the In-Memory query mode.
  • BSelect the multidimensional project type and use the MOLAP storage mode.
  • CSelect the tabular project type and use the DirectQuery query mode.
  • DSelect the multidimensional project type and use the ROLAP storage mode.

Explanation

When maximizing performance is the goal and data latency is acceptable, the tabular In-Memory mode is optimal because it caches the entire dataset in RAM and queries run against that cache without touching source systems.

Common mistakes.

  • B. The multidimensional project type does not natively support OData data feeds as a direct data source, making this option impractical for the stated requirements.
  • C. DirectQuery mode forwards every query to the source system in real time, which maximizes data freshness but does not maximize performance compared to In-Memory caching.
  • D. ROLAP storage mode in a multidimensional project queries the relational source at query time, providing the worst query performance among the options and also lacks native OData support.

Concept tested. Tabular vs multidimensional model and query mode selection

Reference. https://learn.microsoft.com/en-us/analysis-services/tabular-models/directquery-mode-ssas-tabular

Topics

#BISM#tabular model#In-Memory mode#OData data feed

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice
You are developing a BI Semantic Model (BISM) that retrieves data... | 70-466 Q#50 Answer | NerdExam