You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server.
The data size and complexity of the data relationships will not change.
The model will be used to produce reports in Power View.
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)

• A. a multidimensional project that uses the ROLAP storage mode
• B. a tabular project that uses the In-Memory query mode
• C. a multidimensional project that uses the MOLAP storage mode
• D. a PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010
• E. a tabular project that uses the DirectQuery query mode

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model defines a measure named Profit and includes a table named Date.
The table includes year, semester, quarter, month, and date columns.
The Date column is of data type Date.
The table contains a set of contiguous dates.
You need to create a measure to report on year-over-year growth of profit.
What should you do? (Each answer presents a complete solution. Choose all that apply.)

• A. Use the Business Intelligence Wizard and then use the Define time intelligence enhancement.
• B. Define the following calculation. Year Over Year Profit Growth:=CALCULATE([Profit], DATEADD('Date'[Date], 1, YEAR))
• C. Define the following calculation. Year Over Year Profit Growth:=[Profit] - CALCULATE([Profit], PARALLELPERIOD('Date'[Date], -12, MONTH))
• D. Define the following calculation. Year Over Year Profit Growth:=[Profit] - CALCULATE([Profit], SAMEPERIODLASTYEAR('Date'[Date]))

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.
You have an existing multidimensional cube that provides sales analysis. The users can slice by date, product, location, customer, and employee.
The management team plans to evaluate sales employee performance relative to sales targets.
You identify the following metrics for employees:
You need to implement the KPI based on the Status expression.
Solution: You design the following solution:

Does the solution meet the goal?

• A. Yes
• B. No

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You administer a Microsoft SQL Server Analysis Services (SSAS) tabular model for a retail company.
The model is the basis for reports on inventory levels, popular products, and regional store performance.
The company recently split up into multiple companies based on product lines.
Each company starts with a copy of the database and tabular model that contains data for a specific product line.
You need to optimize performance of queries that use the copied tabular models while minimizing downtime.
What should you do?

• A. Process the model in Process Data mode.
• B. Ensure that the Transactional Deployment property is set to True.
• C. Process the model in Process Full mode.
• D. Ensure that DirectQuery is disabled for the model.
• E. Ensure that the Transactional Deployment property is set to False.
• F. Ensure that DirectQuery is enabled for the model.
• G. Process the model in Process Defrag mode.