Free Microsoft 070-768 Exam Dumps Questions & Answers

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be used in the definition of a hierarchy. The City column exists in the Geography table that is related to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?

• A.=VALUES(Geography[City])
• B.City:= LOOKUP(Geography[City],Geography[GeographyKey],[GeographyKey])
• C.City:= LOOKUPVALUE(Geography[City],Geography[GeographyKey],[GeographyKey]) C .=RELATED(Geography[City])
• D.=RELATED(Geography.City)
• E.City:=VALUES(Geography[City])

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_column_statistics eventadded.
• B.Start a SQL Server Profiler trace for the event class Auto Stats in the Performance event category.
• C.Create one Extended Events session with the sqlserver.missing_join_predicate event added.
• D.Start a SQL Server Profiler trace for the event class Soft Warnings in the Errors and Warnings event category.

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

Hotspot Question
You are a database administrator in a company that uses Microsoft SharePoint Server for all intranet sites. You are responsible for the installation of new database server instances.
You must install Microsoft SQL Server Analysis Server (SSAS) to support deployment of the following projects. You develop both projects by using SQL Server Data Tools.
You need to install the appropriate services to support both projects.
What should you do? In the table below, select the appropriate services for each project. NOTE:
Make only one selection in each column. Each correct selection is worth one point.

Correct Answer:

Explanation:
Project1:
Project2: Multidimensional
Note: Analysis Services can be installed in one of three server modes: Multidimensional and Data Mining (default), Power Pivot for SharePoint, and Tabular.

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

• A.Yes
• B.No