You use Microsoft SQL Server Profile to evaluate a query named Query.
The Profiler report indicates the following issues:
- At each level of the query plan, a low total number of rows are
processed.
- The query uses many operations.
This results in a high overall cost for the query.
You need to identify the information that will be useful for the optimizer.
What should you do?

• A. Create one Extended Events session with the sqlserver.missing_join_predicate event added.
• B. Create one Extended Events session with the sqlserver.missing_column_statistics eventadded.
• C. Start a SQL Server Profiler trace for the event class Soft Warnings in the Errors and Warnings event category.
• D. Start a SQL Server Profiler trace for the event class Auto Stats in the Performance event category.

Drag and Drop Question
You need to resolve the issues that the users report.
Which processing options should you use? To answer, drag the appropriate processing option to the correct location or locations. Each processing option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

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 MOLAP storage mode
• B. a tabular project that uses the DirectQuery query mode
• C. a tabular project that uses the In-Memory query mode
• D. a PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010
• E. a multidimensional project that uses the ROLAP storage mode

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 that will be used by the finance, sales, and marketing teams.
The sales team reports that the model is too complex and difficult to use. The sales team does not need any information other than sales-related resources in the tabular model. The finance and marketing teams need to see all the resources in the tabular model.
You need to implement a solution that meets the needs of the sales team while minimizing development and administrative effort.
What should you do?

• A. Enable client side security to filter non-sales data.
• B. Create a separate data source for each team.
• C. Create a separate partition for each team.
• D. Create a perspective for the sales team.