[Retired Exam] Microsoft Practice Test 70-768: Developing SQL Data Models
The MeasureUp 70-768: Developing SQL Data Models practice test is designed to help candidates prepare for and pass Microsoft's 70-768 exam.
Candidates should be business intelligence (BI) developers who create BI solutions. Candidates should have experience configuring and maintaining SQL Server Analysis Services (SSAS). Candidates should be able to design multidimensional BI models and tabular models and develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX).
Certification: This exam counts as credit toward the following certifications:
MCSA
"This exam was retired in January 2021. MeasureUp will not update this practice test and any purchases of it will not be refundable."
Are you familiar with the MeasureUp Pricing Plans?
Discover our Subscription Plans.
Job Role: Data Analyst
Language: English
This test contains 150 questions and covers the following objectives:
- Design a multidimensional business intelligence (BI) semantic model - 35
- Design a tabular BI semantic model - 35
- Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) - 29
- Configure and maintain SQL Server Analysis Services (SSAS) - 51
This test includes references to the following media:
- MSDN
- Microsoft.com
- Microsoft TechNet
- SQLBI
- Office.com
- Web resource