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.
You deploy a tabular data model to an instance of Microsoft SQL Server Analysis Services (SSAS). The model uses an in-memory cache to store and query data. The data set is already the same size as the available RAM on the server. Data volumes are likely to continue to increase rapidly.
Your data model contains multiple calculated tables.
The data model must begin processing each day at 2:00 and processing should be complete by
4:00 the same day. You observe that the data processing operation often does not complete before 7:00. This is adversely affecting team members.
You need to improve the performance.
Solution: Change the storage mode for the data model to DirectQuery.
Does the solution meet the goal?

• A. Yes
• B. No

A database named DB2 uses the InMemory query mode. Users frequently run the following query:

You need to ensure no users see the PriorYearSales measure in the field list for the Sales table.
What should you do?

• A. Set the Display Folder property for PriorYearSales toHidden.
• B. Create a perspective, and ensure that the PriorYearSales measure is not added to the perspective.
  Ensure that users connect to the model by using the perspective.
• C. Remove the PriorYearSales measure from the default field set of the Sales table.
• D. Create a role using Read permissions, and define a DAX expression to filter out the PriorYearSales measure. Add all users to the role.

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 DirectQuery with InMemory.
Does the solution meet the goal?

• A. Yes
• B. No

You are developing a SQL Server Analysis Services (SSAS) tabular project for a Power View solution.
You need to grant permission for salespersons to view only the data based on their sales territory.
What should you do?

• A. Create a member and then create a Multidimensional Expressions (MDX) filter.
• B. Use SQL Server Management Studio to create a role. Then create a Data Analysis Expressions (DAX) filter.
• C. Use SQL Server Management Studio to create a role. Then create a Multidimensional Expressions (MDX) filter.
• D. Create a member and then create a Data Analysis Expressions (DAX) filter.

You are managing a SQL Server Analysis Services (SSAS) tabular database.
The database must meet the following requirements:
- The processing must load data into partitions or tables.
- The processing must not rebuild hierarchies or relationships.
- The processing must not recalculate calculated columns.
You need to implement a processing strategy for the database to meet the requirements.
Which processing mode should you use?

• A. Process Default
• B. Process Clear
• C. Process Full
• D. Process Data
• E. Process Add