The people behind the product matter as much as the product: every PassExamDumps support member completes rigorous training before taking on real customer questions, and the whole team approaches 070-768 candidates with genuine enthusiasm.
Microsoft 070-768 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Design a tabular BI semantic model | - Design and publish a tabular data model - Configure, manage and secure a tabular model - Develop a tabular model to access data in near real time |
| Develop queries using MDX and DAX | - Create basic MDX queries - Implement custom MDX solutions - Create formulas using the DAX language |
| Design a multidimensional BI semantic model | - Create a multidimensional database using SQL Server Analysis Services - Design and implement dimensions in a cube - Implement measures and measure groups in a cube |
| Configure and maintain SQL Server Analysis Services (SSAS) | - Create key performance indicators and translations - Monitor and optimize performance - Configure and manage processing - Plan and deploy SSAS |
070-768 Exam Facts Under Deadline Pressure
- Design a multidimensional BI semantic model ()
- Develop queries using MDX and DAX ()
- Design a tabular BI semantic model ()
Microsoft Developing SQL Data Models Sample Questions:
You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML.
The report includes a dataset with fields named Description, Price, and Color.
The report layout includes a table that displays product details and also includes columns named Description, Price, and Color.
You need to modify the report so that users can sort products by the Price column.
What should you do?
- A. In the Interactive Sorting page of the Price text box properties, select the Enable interactive sorting on this text box check box, and then select the Price field for the Sort by property.
- B. Add a group for the Price field.
- C. Add a custom action to the Price text box.
- D. Set the SortExpression property to =Fields!Price.Name for the Price text box.
- E. Set the SortExpression property to =Fields!Price.Value for the Price text box.
Correct Answer: A,E 🗳️
Drag and Drop Question
You are a business analyst for a company that uses a Microsoft SQL Server Analysis Services (SSAS) tabular database for reporting. The database model contains the following tables:
You have been asked to write a query for a report that returns the total sales for each product subcategory, as well as for each product category.
You need to write the query to return the data for the report.
How should you complete the DAX statement? To answer, drag the appropriate DAX segment to the correct locations. Each DAX segment 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.
Correct Answer:

Explanation:
Box 1:EVALUATE
Box 2:SUMMERIZE
Box 3:ROLLUP
Box 4:'Product Subcategory' ['Product Subcategory Name]
Note: The behavior of SUMMARIZE is similar to the GROUP BY syntax of a SELECT statement in SQL. For example, consider the following query.
EVALUATE
SUMMARIZE(
'Internet Sales',
'Internet Sales'[Order Date],
"Sales Amount", SUM( 'Internet Sales'[Sales Amount] ) )
This query calculates the total of Sales Amount for each date in which there is at least one order, producing this result.
You are building a Microsoft SQL Server Analysis Services multidimensional model over a SQL Server database.
In a cube named OrderAnalysis, there is a standard cube dimension named Stock Item.
This dimension has the following attributes:
Users report that the attributes Stock Item Key and Photo are distracting and are not providing any value.
They have asked for the attributes to be removed. However, these attributes are needed by other cubes.
You need to hide the specified attributes from the end users of the OrderAnalysis cube. You do not want to change the structure of the dimension.
Which change should you make to the properties for the Stock Item Key and Photo attributes?
- A. Set the AttributeHierarchyVisible property to False.
- B. Set the AttributeVisibility property to Hidden.
- C. Set the AttributeHierarchyDisplayFolder property to Hidden.
- D. Set the AttributeHierarchyEnabledproperty to False.
- E. Set the Usage property to Regular.
Correct Answer: A 🗳️
Explanation: Only visible for PassExamDumps members. You can sign-up / login (it's free).
You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant the minimum permissions necessary to enable users to query data in a data model.
Which role permission should you use?
- A. Browser
- B. Read
- C. Explorer
- D. Process
- E. Select
- F. Administrator
Correct Answer: B 🗳️
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 a hierarchy.
- B. Partition the table.
- C. Define relationships.
- D. Create a perspective.
Correct Answer: B 🗳️
Viewing page 1 out of 14 pages.
Viewing questions 1-5 out of 70 questions.
PDF Version Demo


