You need to create the KPI in the AdhocReports project.
What should you do?

• A. Create a KPI based on the OrderQuantity column and then set the target value.
• B. Create a measure by using the COUNT([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value.
• C. Create a measure by using the SUM([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value.
• D. Create a measure by using the SUM([OrderQuantity]) expression. Then use the CREATE KPI CURRENTCUBE statement to define the KPI and target value.

DRAG DROP
You have a single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are planning to upgrade the instance to SQL Server 2014.
You need to import an existing PowerPivot workbook to create a tabular project.
Which three 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.)

You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model will be deployed to a server with 28 GB of RAM.
The source data, located in a SQL Server data warehouse, is currently using 15 terabytes of disk space and is doubling in size every month. The model will be queried by staff in the accounting department by using Microsoft Excel 2010.
You need to ensure the highest query performance and scalability for the accounting department queries.
Which project type should you choose?

• A. Tabular project that uses the DirectQuery query mode
• B. Tabular project that uses the In-Memory query mode
• C. Multidimensional project
• D. PowerPivot workbook deployed to SharePoint

You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named DimEmployee. The table contains employee details, including the sales territory for each employee. The table also defines a column named EmployeeAlias which contains the Active Directory Domain Services (AD DS) domain and logon name for each employee. You create a role named Employees.
You need to configure the Employees roles so that users can query only sales orders for their respective sales territory.
What should you do?

• A. Add a row filter that implements the LOOKUPVALUE and CUSTOMDATA functions.
• B. Add a row filter that implements only the USERNAME function.
• C. Add a row filter that implements only the CUSTOMDATA function.
• D. Add a row filter that implements the LOOKUPVALUE and USERNAME functions.