Microsoft
70-466 · Question #31
70-466 Question #31: Real Exam Question with Answer & Explanation
Sign in or unlock 70-466 to reveal the answer and full explanation for question #31. The question stem and answer options stay visible for context.
Build an analysis services database
Question
You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financia database. The model will be deployed to a server with 32 GB of RAM. The source data, located in a SQL Server data warehouse, is currently using 10 terabytes of disk space and is doubling in size every three months. The model will be queried by staff in the accounting department by using Microsoft Excel 2010. You need to ensure the highest query performance and scalability for the accounting department queries. Which project type should you choose?
Options
- APowerPivot workbook
- Btabular project that uses the In-Memory query mode
- Cmultidimensional project
- Dtabular project that uses the DirectQuery query 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#multidimensional vs tabular#scalability#query performance