You have been hired as a Business Intelligence (BI) developer at ABC.com. The company uses a
Microsoft SQL Server 2012 infrastructure.
The data warehouse contains a database with 10 terabytes of data. The volume of data is
forecast to increase by 10% every week.
You are developing a BISM model to analyze the database. The model will be queried by users
using Microsoft Excel 2010. A Windows Server 2008 R2 server with dual quad-core processors
and 32GB of RAM has been purchased to host the model.
Queries to your model must be scalable and run as quickly as possible.
What should you do?
A.
You should create a multidimensional project.
B.
You should create configure a tabular model using an in-memory cache.
C.
You should configure InMemory With DirectQuery in a tabular model.
D.
You should configure DirectQuery in a tabular model.
Explanation:
hi
NO the answer is B because we haven’t requirement on real time reporting!
A?
32GB of RAM vs 10 terabytes of data + 10% each month, also “model must be scalable and run as quickly as possible”
The right answer could not be D, because “The model will be queried by users
using Microsoft Excel 2010”. Excel generates MDX queries only, but a tabular model in DirectQuery mode supports only DAX.
So the right answer could be A only.
A