Microsoft
70-467 · Question #94
70-467 Question #94: Real Exam Question with Answer & Explanation
The correct answer is B: Direct Query. Direct Query mode sends queries directly to the underlying data source at query time, making it suitable for large or real-time datasets that cannot be fully imported into memory.
Question
You need to select the appropriate mode for the Sales database. Which mode should you select?
Options
- AROLAP
- BDirect Query
- CMOLAP
- DIn-Memory
Explanation
Direct Query mode sends queries directly to the underlying data source at query time, making it suitable for large or real-time datasets that cannot be fully imported into memory.
Common mistakes.
- A. ROLAP stores aggregations in relational tables and queries the relational engine, but it still requires a defined cube structure in SSAS and does not provide the live pass-through query behavior needed here.
- C. MOLAP imports and pre-aggregates data into a multidimensional cube stored on disk, which means data is not real-time and imposes storage overhead unsuitable for a large Sales dataset requiring live access.
- D. In-Memory (VertiPaq) mode imports the entire dataset into compressed in-memory storage, which is impractical for very large Sales databases where live query pass-through is required.
Concept tested. SSAS storage mode selection - Direct Query
Reference. https://learn.microsoft.com/en-us/analysis-services/tabular-models/directquery-mode-ssas-tabular
Community Discussion
No community discussion yet for this question.