HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) tabular project. The
DirectQuery Mode property of the data model has been set to On. The current partition for
the table is configured as the DirectQuery partition.
Data is loaded into a data mart throughout the day and must be available in the data model
as soon as possible. The model must support querying by clients that issue both Data
Analysis Expressions (DAX) queries and Multidimensional Expressions (MDX) queries.
Clients issuing DAX queries must receive real-time query results.
You need to select the appropriate Query Mode property for deployment.
Which query mode should you select?
To answer, select the appropriate query mode from the drop-down list in the dialog box.
Explanation:
ok
Agree.
http://www.sqlservercentral.com/blogs/jamesserra/2012/06/18/tabular-query-modes-directquery-vs-in-memory/
yes, need to use directquery with in-memory to overcome MDX limitation.
https://msdn.microsoft.com/en-us/library/hh230898.aspx