Microsoft Developing SQL Data Models - 070-768 Exam Questions [2026]

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

Correct Answer: A,C,E

QUESTION NO: 2
Which is the easiest option for configuring and maintaining security for each salesperson?

A. Create a role for each salesperson with a row filter restricting the user to a specific sales territory in the Direct Sales table. B. Create a permissions table, add it to the tabular model, and define a relationship between it and the Direct Sales table. C. Create a one role for the salesperson group with a row filter on the Direct Sales table that uses the CONTAINS and USERNAME functions to find the user's sales territory in the Salesperson table. D. Create one role for the salesperson group with a row filter on the Direct Sales table that uses the CUSTOMDATA function.

Correct Answer: C

QUESTION NO: 3
You need to configure the server to optimize the afternoon report generation based on the OrderAnalysis cube.
Which property should you configure?

A. LowMemoryLimit B. VirtualMemoryLimit C. TotalMemoryLimit D. VertiPaqPagingPolicy

Correct Answer: A

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 4
What property do you set to hide the phone number attribute in the customer dimension from slicing and dicing operations, but allows it to be included in the dimension as a member property?

A. IsAggregatable B. AttributeHierarchyOrdered C. AttributeHierarchyVisible D. AttributeHierarchyEnabled

Correct Answer: D

QUESTION NO: 5
Hotspot Question
A company has a multidimensional cube that is used for analyzing sales data.
You add a new measure named Transaction ?Total Including Tax and include the Supplier, Payment Method, and Transaction Type dimensions in the data model. The Transaction ?Total Including Tax measure uses the existing Customer and Date dimensions.
When users have queried the new measure in the past, they saw results as shown in the existing query output exhibit. (Click the Exhibit button.)

The overall total is incorrectly displayed on every row. In addition, the results are no longer formatted correctly.
The query result should appear as shown in the desired query output exhibit. (Click the Exhibit button.)

You need to ensure the table is displayed correctly.
What should you do? Use drop-down menus to select the answer choice that answers each question based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Box 1: Enter a custom MeasureExpression property on the measure
Calculated measures use MDX expressions to supply their values, instead of binding to columns in a data source. The Expression property contains the MDX expression used to supply the values for a Measure only if the Measure is a calculated measure. Otherwise, this property contains an empty string ("").

QUESTION NO: 6
You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named Sales.
The Sales table includes a single date column.
The Sales table must meet the following requirements:
- Queries must be able to return all rows.
- Must be able to support four different processing schedules for
different date ranges.
- Date ranges must not include any overlapping data.
You need to implement a solution that meets the requirements.What should you do?

A. Create four partitions for the Sales table. Create four roles. Use the same row filter queries for each role and partition. B. Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for all four tables. C. Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for each of the four tables. D. Create four partitions for the Sales table. Use row filter queries for each partition.

Correct Answer: D

QUESTION NO: 7
Hotspot Question
A database named DB2 uses the InMemory query mode. Users frequently run the following query:

You need to configure SQL Server Profiler to determine why the query is performing poorly.
Which three event should you monitor on the SQL Server Profiler trace events configuration page? To answer, select the appropriate options in the answer area.

Correct Answer:

Explanation:
By using SQL Profiler, you can intercept two classes of trace events from Analysis Services, DAX Query Plan and DirectQuery events, both generated by the DirectQuery engine. Here, in this scenario we have a DAX Query.
DAX Query Plan events are generated by the DAX formula. By using the In-Memory mode, you store a copy of data in the xVelocity (VertiPaq) storage engine.
Figure: This is how a query is executed by using In-Memory mode.