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 cache by default unless otherwise specified in the connection string from the
client.
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 cache by default unless otherwise specified in the connection string from the
client.
Which of the following options should you select?

A.
InMemory

B.
DirectQuerywithInMemory

C.
InMemorywithDirectQuery

D.
DirectQuery

Explanation:



Leave a Reply 1

Your email address will not be published. Required fields are marked *