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
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
If you want to pass 070-768 real exam, selecting the appropriate training tools is necessary. And the 070-768 real questions from our Real4Prep are very important part. Real4Prep can provide valid 070-768 exam materials to help you pass 070-768 exam. The IT experts in Real4Prep are experienced and professional. Their research materials are very similar with the real exam questions.
The updated Microsoft 070-768 study materials and exam dumps of Real4Prep are composed by professionals and IT specialists; our Real4Prep provides a remarkable experience to anyone who are preparing for 070-768 exam. Our Real4Prep site is one of the best exam questions providers of 070-768 exam in IT industry which guarantees your success in your 070-768 real exam for your first attempt. The authority and reliability of our dumps have been recognized by those who have cleared the 070-768 exam with our latest 070-768 practice questions and dumps.
The 070-768 practice questions from our Real4Prep come along with correct answers and detailed answer explanations and analysis created for any level of experience of Real4Prep 070-768 exam questions. You can try our free demo questions of 070-768 to test your knowledge. Just try out our 070-768 free exam demo, you will be not disappointed. You will be happy to use our Microsoft 070-768 dumps.
Once you purchase 070-768 real dumps on our Real4Prep, you will be granted access to all the updates available of 070-768 test answers on our website in one year. Our testing engine version of 070-768 test answers is user-friendly, easy to install and upon comprehension of your practice tests, so that it will be a data to calculate your final score which you can use as reference for the real exam of 070-768.
Unlike other providers on other websites, we have a 24/7 Customer Service assisting you with any problem you may encounter regarding 070-768 real dumps. Our Live Support team offers you a 10%+ Discount code that you can use when you decide to buy Microsoft 070-768 real dumps on our site. If you don't pass the exam for your first attempt with our dump, you can get your money back. So you have nothing to worry and have no lost.
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.)
