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