Exam 70-768: Developing SQL Data Models
This exam retired on January 31, 2021. For currently available options, please refer to the Browse Certifications and Exams page.
This exam is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multidimensional data models, implementing and maintaining OLAP cubes, and implementing tabular data models.
Part of the requirements for: MCSA: SQL 2016 BI Development MCSE: Data Management and Analytics
Microsoft 70-768 Exam Syllabus Topics:
| Topic | Details |
|---|---|
Design a multidimensional business intelligence (BI) semantic model (25–30%) | |
| Create a multidimensional database by using Microsoft SQL Server Analysis Services (SSAS) | -Design, develop, and create multidimensional databases; select a storage model |
| Design and implement dimensions in a cube | -Select an appropriate dimension model, such as fact, parent-child, roleplaying, reference, data mining, many-to-many, and slowly changing dimension; implement a dimension type; define attribute relationships |
| Implement measures and measure groups in a cube | -Design and implement measures, measure groups, granularity, calculated measures, and aggregate functions; define semi-additive behavior |
Design a tabular BI semantic model (20–25%) | |
| Design and publish a tabular data model | -Design measures, relationships, hierarchies, partitions, perspectives, and calculated columns; create a time table; publish from Microsoft Visual Studio; import from Microsoft PowerPivot; select a deployment option, including Processing Option, Transactional Deployment, and Query Mode |
| Configure, manage, and secure a tabular model | -Configure tabular model storage and data refresh, configure refresh interval settings, configure user security and permissions, configure row-level security |
| Develop a tabular model to access data in near real time | -Use DirectQuery with Oracle, Teradata, Excel, and PivotTables; convert in-memory queries to DirectQuery |
Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) (15–20%) | |
| Create basic MDX queries | -Implement basic MDX structures and functions, including tuples, sets, and TopCount |
| Implement custom MDX solutions | -Create custom MDX or logical solutions for pre-prepared case tasks or business rules, define a SCOPE statement |
| Create formulas by using the DAX language | -Use the EVALUATE and CALCULATE functions, filter DAX queries, create calculated measures, perform data analysis by using DAX |
Configure and maintain SQL Server Analysis Services (SSAS) (30–35%) | |
| Plan and deploy SSAS | -Configure memory limits, configure Non-Union Memory Architecture (NUMA), configure disk layout, determine SSAS instance placement |
| Monitor and optimize performance | -Monitor performance and analyze query plans by using Extended Events and Profiler, identify bottlenecks in SSAS queries, monitor processing and query performance, resolve performance issues, configure usability limits, optimize and manage model design |
| Configure and manage processing | -Configure partition processing; configure dimension processing; use Process Default, Process Full, Process Clear, Process Data, Process Add, Process Update, Process Index, Process Structure, and Process Clear Structure processing methods; configure Parallel, Sequential, and Writeback processing settings |
| Create Key Performance Indicators (KPIs) and translations | -Configure KPI options, including Associated measure group, Value Expression, Goal Expression, Status, Status expression, Trend, Trend expression, and Weight; create KPIs in multidimensional models and tabular models; create and develop translations |
Reference: https://www.microsoft.com/en-us/learning/exam-70-768.aspx
Time has witness all our effort to make 070-768日本語 test braindumps: Developing SQL Data Models (070-768日本語版) a brilliance in getting thousands of candidates out of the boring traditional study and paving the efficient and easy path for the Microsoft Developing SQL Data Models (070-768日本語版) actual test to get the certification. The increasing high comments on our 070-768日本語 study guide remark that the every work of our staff workers do for the test users is indispensable. We not only put high values on the practical effects of our 070-768日本語 exam cram: Developing SQL Data Models (070-768日本語版), but also try our best to meet all candidates need both in technological aspects and service experience. As a consequence, we have been improving the quality and strengthening service of our 070-768日本語 exam dumps questions for so many years, making them nearly perfect to satisfy our users.
24/7 online customer service
We appreciate every comment our users of 070-768日本語 exam guide make as much as we value each effort we do for our users. We do hope that all our users of 070-768日本語 test braindumps: Developing SQL Data Models (070-768日本語版) enjoy the best experience in their learning and practicing and are trying our best effort to achieve this. For that reason, we establish the special online customer service center to work with all the problem and trouble of the users of 070-768日本語 study guide. Whatever the case is, our customer service staffs will never be absent there from receiving the users' information and find out the solution with their heart and soul.
Reliable and safe
Online privacy problem increasingly about purchasing 070-768日本語 exam dumps become a hot issue in the modern life so that almost all shoppers worry about the privacy leaking when they take on the businesses on online payment platform. Among these people there is a part of our users of 070-768日本語 test braindumps: Developing SQL Data Models (070-768日本語版) unsurprisingly. However, the payment platform that our 070-768日本語 study guide questions base on is quietly reliable and safe for at the present, which avoid the fraud transaction and guarantee the safety for our users of 070-768日本語 exam guide questions. In addition, we keep the principle and follow it in our practical wok that under no circumstances, will we share the users'information of 070-768日本語 test braindumps: Developing SQL Data Models (070-768日本語版) with the third party without their consent.
After purchase, Instant Download: Upon successful payment, Our systems will automatically send the product you have purchased to your mailbox by email. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)
Latest questions and answers
Our exam materials designers will check all 070-768日本語 test braindumps: Developing SQL Data Models (070-768日本語版) regularly to ensure the update of practice questions and answers, after which the 070-768日本語 exam guide questions users can get the latest information and most authentic materials so that contribute to the highest efficiency and the most excellent quality of study. So that never the users of 070-768日本語 study guide questions will worry that the test out of date and miss the latest information. What If the customers purchase for 070-768日本語 dumps torrent: Developing SQL Data Models (070-768日本語版) a long time but within one year? Don't worry, neither, we also offer the free update for one year. What's more if you become the regular customers of our 070-768日本語 VCE dumps questions, there will be more membership discount available.
Schedule exam
Languages: English
This exam is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multidimensional data models, implementing and maintaining OLAP cubes, and implementing tabular data models.
Skills measured
- Configure and maintain SQL Server Analysis Services (SSAS) (30-35%)
- Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) (15-20%)
- Design a multidimensional business intelligence (BI) semantic model (25-30%)
- Design a tabular BI semantic model (20-25%)
