![Für diesen Artikel ist leider kein Bild verfügbar.](/img/platzhalter480px.png)
Exam Ref 70-768 Developing SQL Data Models with Practice Test
Microsoft Press (Hersteller)
978-1-5093-0562-9 (ISBN)
- Keine Verlagsinformationen verfügbar
- Artikel merken
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
About the Practice Test: 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 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
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.
Online performance-based simulations give hands on work environment experience
Practice test experience prepares you for the real exam and builds your knowledge of exam objectives
All question types found on the vendor exam are included in your practice test
Detailed explanations for both correct and distractor answers reinforce the material
Practice Mode covers all objectives ensuring topics are covered
Certification Mode (timed) prepares you "exam taking" conditions
Instant, drill-down score reports tell you exactly the areas to focus on
Additional related Web references included
How to obtain the Practice Test: The Official Microsoft Practice Test offered with this book is fulfilled by MeasureUp.com. With your order, you will receive a product key on your Account Page. Registering the product key at MeasureUp.com will give you access to a downloadable practice test which does not expire as well as 30-day access to the online version. Before accessing your practice test, you will be required to create an account at MeasureUp.com if you don't already have one. The downloadable practice test is licensed by MeasureUp for a single user and can be downloaded on up to three different devices. Downloading practice tests to virtual machines is prohibited.
Stacia Varga is a consultant, educator, mentor, and author specializing in business intelligence and performance management solutions using Microsoft technologies. She has over 25 years of experience with improving business practices through technology. Her exclusive focus has been on business intelligence since 1999. Also, she is a co-author of various editions of the free ebook "Introducing Microsoft SQL Server," published by Microsoft Press.
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
Erscheint lt. Verlag | 13.7.2017 |
---|---|
Reihe/Serie | Exam Ref |
Verlagsort | Boston |
Sprache | englisch |
Themenwelt | Informatik ► Datenbanken ► SQL Server |
Mathematik / Informatik ► Informatik ► Software Entwicklung | |
Informatik ► Weitere Themen ► Zertifizierung | |
ISBN-10 | 1-5093-0562-9 / 1509305629 |
ISBN-13 | 978-1-5093-0562-9 / 9781509305629 |
Zustand | Neuware |
Haben Sie eine Frage zum Produkt? |