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? connection string from the client.
A.
Yes
B.
No
Explanation:
With InMemory with DirectQuery: Queries use the cache by default, unless otherwise specified in the
References: https://msdn.microsoft.com/en-us/library/hh230898(v=sql.120).aspx