Microsoft
70-466 · Question #57
70-466 Question #57: Real Exam Question with Answer & Explanation
Sign in or unlock 70-466 to reveal the answer and full explanation for question #57. The question stem and answer options stay visible for context.
Build a tabular data model
Question
You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server. The data size and complexity of the data relationships will not change. The model will be used to produce reports in Power View. You need to use an appropriate project type. Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)
Options
- Aa tabular project that uses the DirectQuery query mode
- Ba tabular project that uses the In-Memory query mode
- Ca multidimensional project that uses the ROLAP storage mode
- Da PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010
- Ea multidimensional project that uses the MOLAP storage mode
Unlock 70-466 to see the answer
You've previewed enough free 70-466 questions. Unlock 70-466 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#BISM project type#tabular model#Power View#DirectQuery vs In-Memory