nerdexam
Microsoft

70-768 · Question #17

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals. A…

The correct answer is B. No. With In Memory with DirectQuery: Queries use the cache by default, unless otherwise specified in the connection string from the client. https://msdn.microsoft.com/en-us/library/hh230898(v=sql.120).aspx

Monitor and maintain the software-defined datacenter

Question

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals. A company has an e-commerce website. When a customer places an order, information about the transaction is inserted into tables in a Microsoft SQL Server relational database named OLTP1. The company has a SQL Server Analysis Services (SSAS) instance that is configured to use Tabular mode. SSAS uses data from OLTP1 to populate a data model. Sales analysts build reports based on the SSAS model. Reports must be able to access data as soon as it is available in the relational database. You need to configure and deploy an Analysis Services project to the Analysis Services instance that allows near real-time data source access. Solution: In the Deployment Option property for the report, you set the Query Mode to InMemory with DirectQuery. Does the solution meet the goal?

Options

  • AYes
  • BNo

How the community answered

(36 responses)
  • A
    19% (7)
  • B
    81% (29)

Explanation

With In Memory with DirectQuery: Queries use the cache by default, unless otherwise specified in the connection string from the client. https://msdn.microsoft.com/en-us/library/hh230898(v=sql.120).aspx

Topics

#SSAS tabular#DirectQuery#OLTP data source#data freshness

Community Discussion

No community discussion yet for this question.

Full 70-768 Practice