You are developing a SQL Server Analysis Services (SSAS) tabular database.
To maximize performance, queries must be resolved only by using cache.
You need to configure the appropriate query mode.
Which query mode should you select?

• A. DirectQuery with In-Memory
• B. DirectQuery
• C. In-Memory with DirectQuery
• D. In-Memory

You are developing a SQL Server Analysis Services (SSAS) tabular project.
In the data warehouse, a table named Sales Persons and Territories defines a relationship between a salesperson's name, logon ID, and assigned sales territory.
You need to ensure that each salesperson has access to data from only the sales territory assigned to that salesperson. You need to use the least amount of development effort to achieve this goal.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Create a separate tabular model for each sales territory and assign each tabular model a corresponding sales territory name.
  Grant each salesperson access to the corresponding tabular model of the assigned sales territory.
• B. Add the Sales Persons and Territories table to the model, define the relationships, and then implement dynamic security by using row filters.
  Grant each salesperson access to the model.
• C. Create a new Active Directory Domain Services (AD DS) security group and add each salesperson as a member.
  Then create a new role named Sales Persons with Read permission.
  Add the group as a member to the new role.
• D. Create a new role named Sales Persons with Read permission.
  Add each salesperson's logon as a member to the role.

You are developing a BI Semantic Model (BISM) that retrieves data from several sources including a SQL Azure database and an OData data feed.
The model will be deployed to a server with significantly more memory than the total size of the source data.
You have the data feed URL, which you will use when developing the model in SQL Server Data Tools (SSDT).
The model must meet the following requirements:
- Maximize performance
- Data latency of up to one month is acceptable
You need to choose a project type and a data access mode to meet the requirements.
What should you do?

• A. Select the multidimensional project type and use the MOLAP storage mode.
• B. Select the multidimensional project type and use the ROLAP storage mode.
• C. Select the tabular project type and use the DirectQuery query mode.
• D. Select the tabular project type and use the In-Memory query mode.

Drag and Drop Question
You need to configure the CoffeeSale fact table environment.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.