PDF Version DemoPhone, tablet, laptop, desktop: the ActualPDF online version runs the Microsoft Developing SQL Data Models simulation on any operating system, so 070-768 practice happens wherever you happen to be.
Microsoft 070-768 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Developing SQL Data Models |
| Exam Number: | 70-768 |
| Related Certifications: | MCSA: SQL 2016 BI Development |
| Exam Format: | Multiple choice, Scenario-based, Performance-based |
| Available Languages: | English |
| Exam Price: | USD 165 |
| Certificate Validity Period: | Retired (no longer available for new exam takers; previously counted toward MCSA credential) |
| Passing Score: | 700 |
| Exam Duration: | 120 minutes |
| Real Exam Qty: | 40–60 |
| Sample Questions: |  |
| Exam Way: | Previously taken at Pearson VUE test centers or online proctored; now retired and no longer available for new registrations. |
| Pre Condition: | Experience in business intelligence (BI) development, SQL Server Analysis Services (SSAS), MDX and DAX. |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/learn/certifications/exams/70-768 |
Microsoft 070-768 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| 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 |
| Develop queries using MDX and DAX | - Implement custom MDX solutions - Create basic MDX queries - Create formulas using the DAX language |
| Configure and maintain SQL Server Analysis Services (SSAS) | - Configure and manage processing - Monitor and optimize performance - Create key performance indicators and translations - Plan and deploy SSAS |
| Design a tabular BI semantic model | - Develop a tabular model to access data in near real time - Configure, manage and secure a tabular model - Design and publish a tabular data model |
Microsoft 070-768 Exam: FAQ for Serious Candidates
Microsoft Developing SQL Data Models is an official Microsoft exam, listed under exam code 070-768. A passing result earns you the MCSA certification at the MCSA (Microsoft Certified Solutions Associate) level. It also ties into MCSA: SQL 2016 BI Development, extending its value across your certification roadmap. Employers read this credential as verified competence, which is why it keeps appearing in job requirements.
Expect 40–60 questions inside 120 minutes on the Microsoft Developing SQL Data Models exam. That pace punishes hesitation, so rehearse it: the ActualPDF software engine simulates the real exam scene, reminds you of the questions you got wrong, and pushes you to re-practice them until the clock stops being your enemy.
Passing Microsoft Developing SQL Data Models requires 700, and the official registration fee is USD 165. Retakes charge the full USD 165 again, which is why experienced candidates treat preparation as the cheaper exam fee. Verify your readiness with repeated ActualPDF practice scores above the requirement before you commit to a date.
Experience in business intelligence (BI) development, SQL Server Analysis Services (SSAS), MDX and DAX.
Requirements evolve, so confirm the current conditions before registering on the official exam page.
Yes. ActualPDF provides a free download demo of the Microsoft Developing SQL Data Models material, so you can check the content before choosing a version. After purchase, a one-year warranty covers you: the latest version is sent to you as it releases, free for 365 days, and after expiry you can extend the update service at a 50% discount.
Your purchase is covered by a 100% money-back guarantee with clear conditions. Take the Microsoft Developing SQL Data Models exam within 60 days of purchase; if you fail, provide your unqualified result by submitting a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and the full refund is processed within 7 days. The exam must match your product, candidate and payer names must match, and attempts within 3 days of purchase, unused downloads, free materials, and expired orders are not covered. Alternatively, exchange for two other exam products of equal value, free, or wait for updates while keeping your original product's update service.
Delivery is instant: files unlock for download at payment and are emailed within one minute. If nothing arrives within 2 hours, check spam and contact customer service, which works 7/24 and normally replies within two hours. Installation is unlimited across your computers.
The Microsoft Developing SQL Data Models syllabus spans 4 domains, led by Design a tabular BI semantic model, Develop queries using MDX and DAX, and Design a multidimensional BI semantic model. The complete topic list is published above; candidates who study the map first rarely get lost later.
Microsoft Developing SQL Data Models Sample Questions:
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.
You have an existing multidimensional cube that provides sales analysis. The users can slice by date, product, location, customer, and employee.
The management team plans to evaluate sales employee performance relative to sales targets.
You identify the following metrics for employees:
You need to implement the KPI based on the Status expression.
Solution: You design the following solution:
Does the solution meet the goal?
- A. No
- B. Yes
Correct Answer: B 🗳️
You are optimizing a Microsoft SQL Server Analysis Services (SSAS) multidimensional model over a SQL Server database.
You have a table named City which has several dimensions that do not contain a space in their names.
One dimension is named SalesTerritory rather than Sales Territory.
You need to ensure that Report developers can drag the attribute name to the report rather than having to re-label the attributes by implementing spaces.
You must minimize administrative effort and not break any upstream processes.
What should you do?
- A. In SQL Server Management Studio, navigate to the City table, expand the columns, press F2, and rename the columns in the base tables.
- B. In the SQL Server database, implement a view over the City table that aliases the columns in the tables.
- C. In the SQL Server database, run the system procedure sp_rename to rename the columns in the base tables with the target name.
- D. In the SQL Server database, implement a SYNONYM.
Correct Answer: B 🗳️
You are developing a SQL Server Analysis Services (SSAS) tabular project for a Power View solution.
You need to grant permission for salespersons to view only the data based on their sales territory.
What should you do?
- A. Use SQL Server Management Studio to create a role. Then create a Data Analysis Expressions (DAX) filter.
- B. Use SQL Server Management Studio to create a role. Then create a Multidimensional Expressions (MDX) filter.
- C. Create a member and then create a Multidimensional Expressions (MDX) filter.
- D. Create a member and then create a Data Analysis Expressions (DAX) filter.
Correct Answer: A 🗳️
Which of the following object types do you add to the cube?
- A. Calculated measure
- B. Dynamic named set
- C. Static named set
- D. Calculated member set
Correct Answer: B 🗳️
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a Microsoft SQL Server Analysis Services (SSAS) instance that is configured to use multidimensional mode. You create the following cube:
Users need to be able to analyze sales by color.
You need to create a dimension that contains all of the colors for products sold by the company.
Which relationship type should you use between the InternetSales table and the new dimension?
- A. many-to-many
- B. referenced
- C. fact
- D. regular
- E. no relationship
- F. data mining
Correct Answer: D 🗳️
Explanation: Only visible for ActualPDF members. You can sign-up / login (it's free).
