This eBook includes the following formats, accessible from your Account page after purchase:
EPUB The open industry format known for its reflowable content and usability on supported mobile devices.
MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.
PDF The popular standard, used most often with the free Adobe® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
About the Book:
Prepare for Microsoft Exam 70-768—and help demonstrate your real-world mastery of Business Intelligence (BI) solutions development with SQL Server 2016 Analysis Services (SSAS), including modeling and queries. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level.
Focus on the expertise measured by these objectives:
• Design a multidimensional BI semantic model
• Design a tabular BI semantic model
• Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)
• Configure and maintain SSAS
This Microsoft Exam Ref:
• Organizes its coverage by exam objectives
• Features strategic, what-if scenarios to challenge you
• Assumes you are a database or BI professional with experience creating models, writing MDX or DAX queries, and using SSAS
This test contains 150 questions and covers the following objectives:
This test includes references to the following media:
Why Choose MeasureUp Practice Tests?
Quality test content is extremely important to us so that you will be prepared on exam day. We ensure that all objectives of the exam are covered in depth so you'll be ready for any question on the exam. Our practice tests are written by industry experts in the subject matter. They work closely with certification providers to understand the exam objectives, participate in beta testing and take the exam themselves before creating new practice tests. MeasureUp's quality content and innovative technology have earned the prestigious credential of Microsoft Official Practice Test and is the Official VMware Practice Test.
1: Design a Multidimensional Business Intelligence (BI) Semantic Model
Skill 1.1. Create a Multidimensional Database by Using Microsoft SQL Server Analysis Services (SSAS)
Skill 1.2. Design and Implement Dimensions in a Cube
Skill 1.3. Implement Measures and Measure Groups in a Cube
2: Design a Tabular BI Semantic Model
Skill 2.1. Design and Publish a Tabular Data Model
Skill 2.2. Configure, Manage, and Secure a Tabular Model
Skill 2.3. Develop a tabular model to access data in near real time
3: Develop Queries Using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)
Skill 3.1. Create Basic MDX Queries
Skill 3.2. Implement Custom MDX Solutions
Skill 3.3. Create formulas by using the DAX language
4: Configure and Maintain SQL Server Analysis Services (SSAS)
Skill 4.1. Plan and Deploy SSAS
Skill 4.2. Monitor and Optimize Performance
Skill 4.3. Configure and Manage Processing
Skill 4.4. Create Key Performance Indicators (KPIs) and Translations