PrepAway - Latest Free Exam Questions & Answers

Which of the following options should you select?

You work as a SQL Developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
You have a SQL Server Analysis Services (SSAS) tabular model.
You need to configure the model for DirectQuery mode to maximize performance.
You set the DirectQueryMode property to ON to enable Direct Query mode. You now need to set
the DirectQueryMode property to configure the preferred query data source.
Queries must use the relational data source by default unless otherwise specified in the
connection string from the client.
Which of the following options should you select?

PrepAway - Latest Free Exam Questions & Answers

A.
InMemory

B.
DirectQuerywithInMemory

C.
InMemorywithDirectQuery

D.
DirectQuery

Explanation:

One Comment on “Which of the following options should you select?


Leave a Reply