Preparing for the Microsoft Developing SQL Data Models exam while holding down a job leaves little room for wasted effort. 2Pass4sure condenses 70 carefully verified practice questions into a focused 70-768 study package, so every hour you invest actually moves you toward a passing score.

Microsoft 70-768 Exam Overview:

Microsoft 70-768 Exam Syllabus Topics:

Microsoft 70-768 Exam: Everything You Wanted to Ask

Microsoft Developing SQL Data Models Sample Questions:

Question 1

You are administrating a SQL Server Analysis Services (SSAS) tabular database.
You need to create a new role that allows its members to query data and to refresh data in the model.
Which permission should you use? (More than one answer choice may achieve the goal.
Select the BEST answer.)

A. Read and Process
B. Explore and Manage
C. Administrator
D. Browse and Manage

Question 2

You are managing a SQL Server Analysis Services (SSAS) tabular database.
The database must meet the following requirements:
- The processing must load data into partitions or tables.
- The processing must not rebuild hierarchies or relationships.
- The processing must not recalculate calculated columns.
You need to implement a processing strategy for the database to meet the requirements.
Which processing mode should you use?

A. Process Data
B. Process Add
C. Process Clear
D. Process Full
E. Process Default

Question 3

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

Question 4

You manage your department's SQL Server Analysis Services (SSAS) projects. The sales department uses a tabular model to analyze sales data. Users report excessive wait times when updating the model.
You need to improve the performance of the model. What should you do?

A. Define relationships.
B. Create a perspective.
C. Define a hierarchy.
D. Partition the table.

Question 5

Hotspot Question
You have a Microsoft SQL Server Analysis Services (SSAS) multidimensional project.
You are developing a dimension that uses data from the following table:

The ManagerKey column defines a foreign key constraint that references the EmployeeKey column. The table stores employee history information by using slowly changing dimensions (SCD). Changes to EmployeeName, Phone, or ManagerKey are managed as SCD Type 1 changes. Changes to SalesRegion are managed as SCD Type 2 changes.
You create the following attributes, and set the KeyColumns and NameColumn properties to the columns listed in the table below:

You need to add a parent-child hierarchy to the dimension to enable navigating the organization hierarchy.
In the table below, identify the attribute that you must use for each attribute usage type.
NOTE: Make only one selection in each column.

Solutions: