{"id":7116,"date":"2020-06-15T04:44:51","date_gmt":"2020-06-15T04:44:51","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=7116"},"modified":"2021-05-27T14:06:26","modified_gmt":"2021-05-27T14:06:26","slug":"exam-70-768-developing-sql-data-models","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-768-developing-sql-data-models\/","title":{"rendered":"Exam 70-768: Developing SQL Data Models"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Developing-SQL-Data-Models-3.png\" alt=\"Developing SQL Data Models\" class=\"wp-image-7118\"\/><\/figure><\/div>\n\n\n\n<p>Microsoft 70-768 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. The exam measures the ability to design multidimensional BI models and tabular models and develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Who should take the exam?<\/strong><\/h3>\n\n\n\n<p>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.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Learning Objectives<\/strong><\/h3>\n\n\n\n<p>Microsoft being a dominant player constantly provides relevant and required documentation to meet the needs of all of today\u2019s diverse learners and&nbsp;therefore, helping&nbsp;them to build a life in the world of cloud computing. As a result, the potential aspirants are easily able to locate the required detailed information along with the subtopics included in each domain.<\/p>\n\n\n\n<p>The Microsoft 70-768 exam focuses on four key areas:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Design a multidimensional business intelligence (BI) semantic model<\/li><li>Design a tabular (BI) semantic model<\/li><li>Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)<\/li><li>configure and maintain SQL Server Analysis Services (SSAS)<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to prepare for SQL Data Models (70-768) ?\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/pwpkIV4TeI0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Format<\/strong><\/h3>\n\n\n\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/learning\/exam-70-768.aspx\">Microsoft 70-768<\/a> exam consists of around 40-60 questions covering all topics and their respective subtopics. And to complete these questions, a candidate is given only 120 minutes. Candidates have to secure a score of 700 or more points in order to pass the exam. The fee for this examination is $165 USD. Further, the exam is only available in the&nbsp;English language.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Exam Name: Developing SQL Data Models<\/li><li>Exam Code: 70-768<\/li><li>Exam Price: $165 USD<\/li><li>Exam Duration: 120 minutes<\/li><li>Passing score: 700 or more <\/li><li>Language Available: English<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Schedule the exam<\/strong><\/h3>\n\n\n\n<p>Candidates can schedule their exam at the <a href=\"https:\/\/www.microsoft.com\/en-us\/learning\/exam-70-768.aspx\">Microsoft portal<\/a>&nbsp;and schedule their exam by clicking on the \u201cschedule exam\u201d link.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Course Structure<\/strong><\/h3>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"594\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Modules-of-70-768-594x400.png\" alt=\"Modules of Microsoft 70-768\" class=\"wp-image-7129\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Modules-of-70-768-594x400.png 594w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Modules-of-70-768.png 1500w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Design a multidimensional business intelligence (BI) semantic model<\/strong><\/h4>\n\n\n\n<p>1.1 <em>Create a multidimensional database by using Microsoft SQL Server Analysis Services (SSAS)<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Design, develop, and create multidimensional databases; select a storage model (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/creating-multidimensional-models-using-sql-server-data-tools-ssdt?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Creating Multidimensional Models Using SQL Server Data Tools<\/a>)<\/li><\/ul>\n\n\n\n<p>1.2 <em>Design and implement dimensions in a cube<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>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 (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models-olap-logical-dimension-objects\/dimensions-introduction?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Dimensions<\/a>)<\/li><\/ul>\n\n\n\n<p>1.3 <em>Implement measures and measure groups in a cube<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Design and implement measures, measure groups, granularity, calculated measures, and aggregate functions; define semi-additive behavior (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/measures-and-measure-groups?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Measures and Measure Groups<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Design a tabular BI semantic model<\/strong><\/h4>\n\n\n\n<p>2.1 <em>Design and publish a tabular data model<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>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 (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/tabular-models\/tabular-model-designer-ssas?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Tabular model designer<\/a>)<\/li><\/ul>\n\n\n\n<p>2.2 <em>Configure, manage, and secure a tabular model<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Configure tabular model storage and data refresh, configure refresh interval settings, configure user security and permissions, configure row-level security (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/tabular-models\/roles-ssas-tabular?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Roles<\/a>)<\/li><\/ul>\n\n\n\n<p>2.3 <em>Develop a tabular model to access data in near real time<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Use DirectQuery with Oracle, Teradata, Excel, and PivotTables; convert in-memory queries to DirectQuery (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/tutorial-tabular-1400\/as-lesson-1-create-a-new-tabular-model-project?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Create a tabular model project<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)<\/strong><\/h4>\n\n\n\n<p>3.1 <em>Create basic MDX queries<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Implement basic MDX structures and functions, including tuples, sets, and TopCount (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/mdx\/mdx-query-the-basic-query?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">MDX Query &#8211; The Basic Query<\/a>)<\/li><\/ul>\n\n\n\n<p>3.2 <em>Implement custom MDX solutions<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Create custom MDX or logical solutions for pre-prepared case tasks or business rules, define a SCOPE statement (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/comparing-tabular-and-multidimensional-solutions-ssas?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Comparing tabular and multidimensional solutions<\/a>)<\/li><\/ul>\n\n\n\n<p>3.3 <em>Create formulas by using the DAX language<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Use the EVALUATE and CALCULATE functions, filter DAX queries, create calculated measures, perform data analysis by using DAX (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/desktop-quickstart-learn-dax-basics\" target=\"_blank\" rel=\"noreferrer noopener\">Apply DAX basics in Power BI Desktop<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Configure and maintain SQL Server Analysis Services (SSAS)<\/strong><\/h4>\n\n\n\n<p>4.1 <em>Plan and deploy SSAS<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Configure memory limits, configure Non-Union Memory Architecture (NUMA), configure disk layout, determine SSAS instance placement (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/tutorial-tabular-1400\/as-lesson-13-deploy?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Deploy<\/a>)<\/li><\/ul>\n\n\n\n<p><em>4.2 Monitor and optimize performance<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>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 (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/data-integration\/gateway\/service-gateway-performance\" target=\"_blank\" rel=\"noreferrer noopener\">Monitor and optimize on-premises data gateway performance<\/a>)<\/li><\/ul>\n\n\n\n<p><em>4.3 Configure and manage processing<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>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 (<strong>Microsoft Documentation: <\/strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/paths\/configure-use-process-manufacturing-dyn365-supply-chain-mgmt\/\" target=\"_blank\" rel=\"noreferrer noopener\">Configure and use process manufacturing in Dynamics 365 Supply Chain Management<\/a>) <\/li><\/ul>\n\n\n\n<p>4.4 <em>Create Key Performance Indicators (KPIs) and translations<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>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 (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/tabular-models\/kpis-ssas-tabular?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">KPIs<\/a>)<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Policies<\/strong><\/h3>\n\n\n\n<p>Microsoft is well aware of its responsibilities towards its candidates, thus, it provides exam policies with a view to enabling the candidates to plan and manage their activities with respect to Microsoft.&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/certification-exam-policies\">Microsoft Certification exam policies<\/a>&nbsp;are an appropriate blend of all the exam-related details, accompanying the before and after exam procedures. These exam policies include a set of rules that need to be followed during the exam time or at testing centres.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/faq-11.png\" alt=\"Microsoft 70-768 FAQs\" class=\"wp-image-7137\"\/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>For More Queries Visit:&nbsp;<a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/developing-sql-data-models-70-768-faqs\/\">Developing SQL Data Models (70-768) Exam FAQs<\/a><\/strong><\/h4>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Microsoft 70-768 Exam Preparation <\/strong><\/h3>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Preparatory-Guide-5.png\" alt=\"Preparatory Guide for Microsoft 70-768\" class=\"wp-image-7131\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Preparatory-Guide-5.png 1080w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Preparatory-Guide-5-225x400.png 225w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Online Training<\/strong><\/h4>\n\n\n\n<p>The&nbsp;Microsoft Learning Platform&nbsp;provides the most authentic access to candidates to get information about the exam. Candidates appearing for the 70-768 exam can refer to these study resources that can be accessed easily at the official exam page. That is to say, you just have to search for the 70-768 exam and the essential information will be provided that will help you in understanding it better.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Books<\/strong><\/h4>\n\n\n\n<p>Books help you acquire more and more knowledge through training. They are your oldest yet best friends who are always happy to help you with your preparation process. As you know, Books are a good resource to acquire knowledge without any disturbance. So here are a few books that would be a good option for you people out there.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Exam Ref 70-768 Developing SQL Data Models by Stacia Varga.<\/li><li>Designing Data-Intensive Applications: The Big Ideas behind Reliable, Scalable, and Maintainable Systems by Martin Kleppmann.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"318\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/book-3-318x400.jpg\" alt=\"Microsoft (70-768) Book\" class=\"wp-image-7168\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/book-3-318x400.jpg 318w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/book-3-scaled.jpg 796w\" sizes=\"auto, (max-width: 318px) 100vw, 318px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Instructor Led Training<\/strong><\/h4>\n\n\n\n<p>You will feel lucky to know that Microsoft provides free online training as well as&nbsp;<a href=\"https:\/\/www.microsoft.com\/en-us\/learning\/course.aspx?cid=20768\">instructor-led training<\/a>&nbsp;to its potential candidates. These are basically online learning and training sessions by industry-recognized experts and certified instructors. This training also comes with few benefits such as- increased convenience, flexible scheduling, and quick responses as well. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Practice Tests<\/strong><\/h4>\n\n\n\n<p>Practice tests are perfect to get an insight into the topics in which you are lacking. However, these practice tests should only be performed after you have gone through the whole syllabus. Practice tests are intended to help candidates encounter the real exam environment around them. After completing practice tests you can easily understand the areas you\u2019re lacking behind and work upon them. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Get ready to Practice and Prepare for Developing SQL Data Models (70-768) Exam<\/strong><\/h4>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/developing-sql-data-models-70-768-free-practice-test\"><img loading=\"lazy\" decoding=\"async\" width=\"728\" height=\"90\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/practice-test.png\" alt=\"Free Practice Test\" class=\"wp-image-7139\"\/><\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft 70-768 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. The exam measures the ability to design multidimensional BI models and tabular models and develop queries using Multidimensional Expressions (MDX) and Data Analysis&#8230;<\/p>\n","protected":false},"author":1,"featured_media":7118,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[5720,174],"tags":[1001,4,1002,1012,1003],"class_list":["post-7116","page","type-page","status-publish","has-post-thumbnail","hentry","category-database","category-microsoft-azure","tag-developing-sql-data-models","tag-m4f","tag-microsoft-70-768-exam","tag-microsoft-70-768-exam-tutorials","tag-microsoft-70-768-study-guide"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Exam 70-768: Developing SQL Data Models - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Enrich your profile with advanced learning skills and expert tutorials on (70-768) Exam. Prepare and become a Microsoft Certified Now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-768-developing-sql-data-models\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exam 70-768: Developing SQL Data Models - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Enrich your profile with advanced learning skills and expert tutorials on (70-768) Exam. Prepare and become a Microsoft Certified Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-768-developing-sql-data-models\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-27T14:06:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Developing-SQL-Data-Models-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-768-developing-sql-data-models\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-768-developing-sql-data-models\/\",\"name\":\"Exam 70-768: Developing SQL Data Models - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2020-06-15T04:44:51+00:00\",\"dateModified\":\"2021-05-27T14:06:26+00:00\",\"description\":\"Enrich your profile with advanced learning skills and expert tutorials on (70-768) Exam. Prepare and become a Microsoft Certified Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-768-developing-sql-data-models\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-768-developing-sql-data-models\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-768-developing-sql-data-models\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exam 70-768: Developing SQL Data Models\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exam 70-768: Developing SQL Data Models - Testprep Training Tutorials","description":"Enrich your profile with advanced learning skills and expert tutorials on (70-768) Exam. Prepare and become a Microsoft Certified Now!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-768-developing-sql-data-models\/","og_locale":"en_US","og_type":"article","og_title":"Exam 70-768: Developing SQL Data Models - Testprep Training Tutorials","og_description":"Enrich your profile with advanced learning skills and expert tutorials on (70-768) Exam. Prepare and become a Microsoft Certified Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-768-developing-sql-data-models\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-05-27T14:06:26+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/Developing-SQL-Data-Models-3.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-768-developing-sql-data-models\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-768-developing-sql-data-models\/","name":"Exam 70-768: Developing SQL Data Models - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2020-06-15T04:44:51+00:00","dateModified":"2021-05-27T14:06:26+00:00","description":"Enrich your profile with advanced learning skills and expert tutorials on (70-768) Exam. Prepare and become a Microsoft Certified Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-768-developing-sql-data-models\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-768-developing-sql-data-models\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-768-developing-sql-data-models\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Exam 70-768: Developing SQL Data Models"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/7116","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=7116"}],"version-history":[{"count":11,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/7116\/revisions"}],"predecessor-version":[{"id":42604,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/7116\/revisions\/42604"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media\/7118"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=7116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=7116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=7116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}