{"id":13241,"date":"2020-07-24T19:27:29","date_gmt":"2020-07-24T19:27:29","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=13241"},"modified":"2021-05-27T13:59:54","modified_gmt":"2021-05-27T13:59:54","slug":"exam-70-767-implementing-a-sql-data-warehouse","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-767-implementing-a-sql-data-warehouse\/","title":{"rendered":"Exam 70-767: Implementing a SQL Data Warehouse"},"content":{"rendered":"\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/n.png\" alt=\"Microsoft Exam 70-767 Online Tutorial \" class=\"wp-image-13295\"\/><\/figure><\/div>\n\n\n\n<p>The <strong><a href=\"https:\/\/www.testpreptraining.ai\/implementing-a-sql-data-warehouse-70-767-practice-exam\" target=\"_blank\" rel=\"noreferrer noopener\">Exam 70-767 Implementing a SQL Data Warehouse<\/a><\/strong> certification by Microsoft is really rewarding in terms of entry-level tech work, learnable, and a clear path to a good career. This certification validates your proficiency in building a data warehouse with the implementation of ELTs (Extract, Transform and Load), interaction with Azure technologies like Big Data, Azure DW, maintaining the data with DQS (Data Quality Services) as well as implementing a data warehouse design. The certification is primarily introduced for BI developers, ETL administrators, and developers. It helps candidates acquire an array of knowledge in working and designing with SQL SSIS (Server Integration Services), performance, table design, and others.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"alignright is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/images.youracclaim.com\/images\/17e00076-e4aa-4e21-a7ca-671428e61567\/Implementing%2Ba%2BData%2BWarehouse-01.png\" alt=\"Exam 767: Implementing a Data Warehouse - Acclaim\" width=\"164\" height=\"164\"\/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Recommended Knowledge<\/strong><\/h3>\n\n\n\n<p>This examination has certain objectives and it prefers candidates to have brains in topics like designing, implementing, and maintenance of a data warehouse, building data quality solutions and transforming, extracting, and loading data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Target Audience<\/strong><\/h3>\n\n\n\n<p>The <strong><a href=\"https:\/\/www.testpreptraining.ai\/implementing-a-sql-data-warehouse-70-767-free-practice-test\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft 70-767: Implementing a SQL Data Warehouse<\/a><\/strong> certification aims at targeting those prospective candidates who are willing to build their career in Microsoft SQL Server domain. This exam is intended for those who are ETL (Extract, transform, and load) developer or an administrator, or a business intelligence developer. Those developers who have the willingness to perform the data cleansing function additionally with ETL and data warehouse implementation. Hence, it is intended for them who create business intelligence (BI) solutions.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Overview<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Exam Code:&nbsp;70-767<\/li><li>Number of Questions: 40-60 Multiple Choice and Multi-Response Questions<\/li><li>Time Limit: 120 minutes<\/li><li>Passing score: 700 (on a scale of 1-1000)<\/li><li>Language: English<\/li><li>Exam Type:&nbsp;SQL Server 2016\/2017\/2019<\/li><li>Price: USD $165<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Schedule Your Exam<\/strong><\/h3>\n\n\n\n<p>Follow the steps below to schedule your Microsoft certification exam \u2013<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Go to the Microsoft portal, to register yourself<\/li><li>Click on \u201cSchedule Exam\u201d to schedule an exam date at your convenience<\/li><li>Fill all your details asked in the next page that appears<\/li><li>Select the exam delivery option on the Pearson VUE page<\/li><li>Pay your exam fees. You have successfully registered for the MS 70-767 Exam<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Cancellation Policy<\/strong><\/h3>\n\n\n\n<p>Microsoft offers candidates to cancel or reschedule their exams within a minimum of 24 hours prior to the exam date. However, to prevent any cancellation fee, you must cancel or reschedule your exam, at least 6 business days prior to the date scheduled for your exam. Also, if you fail to appear in the exam, then you will not receive any refund of the exam fee.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Result<\/strong><\/h3>\n\n\n\n<p>Right after successfully completing your Exam 70-767 Implementing a SQL Data Warehouse, you will be notified of your pass or fail status within a few minutes of completing your exam. Also, printed reports providing your exam score and feedback on your performance will also be provided to you. Your score will be forwarded to Microsoft within five business days.<br>As far as Beta exam results are concerned, your result will be visible on your Microsoft transcript. However, you will see your result only if you\u2019ve achieved a passing score. Also, this result will be published on Pearson VUE\u2019s site within 14 business days, after the live exam is published.<br><strong>Note<\/strong>&nbsp;\u2013 If you are able to clear the beta exam, you will earn Microsoft credit for that exam and will also receive a resulting certification. Moreover, you are not required to retake the exam in its live version after clearing its beta version.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Retake Policy<\/strong><\/h3>\n\n\n\n<p>If anyhow you are not able to achieve a passing score in the Microsoft 70-767 exam. However, you will have to wait for a minimum of 24 hours before you become eligible for a retake. Failure in the second attempt will result in a waiting time of 14 days before rescheduling your third attempt. The waiting period for the fourth and the fifth attempts will also be 14 days. All candidates are allowed a maximum of five attempts per year.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/n-3.png\" alt=\"Microsoft Exam 70-767 FAQ\" class=\"wp-image-13296\"\/><\/figure><\/div>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>For More Details See &#8211; <\/strong><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-70-767-implementing-a-sql-data-warehouse-faq\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Microsoft 70-767: Implementing a SQL Data Warehouse<\/strong> <strong>FAQ<\/strong><\/a><\/h5>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Course Outline<\/strong><\/h3>\n\n\n\n<p>The Microsoft 70-767 Exam covers the following domains &#8211; <\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Design, implement, and maintain a data warehouse (35-40%)<\/strong><\/h4>\n\n\n\n<p>Designing and implementing dimension tables<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Design shared and conformed dimensions<\/li><li>determine support requirements for slowly changing dimensions (<strong>Microsoft Documentation: <\/strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/data-flow\/transformations\/slowly-changing-dimension-transformation?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Slowly Changing Dimension Transformation<\/a>)<\/li><li>determine attributes<\/li><li>design hierarchies (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/tutorial-tabular-1200\/lesson-9-create-hierarchies?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Create Hierarchies<\/a>)<\/li><li>determine star or snowflake schema requirements (<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 &#8211; Introduction<\/a>)<\/li><li>determine the granularity of the relationship by using fact tables (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models-olap-logical-cube-objects\/dimension-relationships?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Dimension Relationships<\/a>)<\/li><li>determine auditing or lineage requirements<\/li><li>determine keys and key relationships for a data warehouse<\/li><li>implement dimensions<\/li><li>implement data lineage of a dimension table<\/li><\/ul>\n\n\n\n<p>Designing and implementing fact tables<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Identify measures<\/li><li>identify dimension table relationships (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-tutorial\/lesson-5-2-defining-a-fact-relationship?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Defining a Fact Relationship<\/a>)<\/li><li>create composite keys (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/ef\/core\/modeling\/keys?tabs=data-annotations\" target=\"_blank\" rel=\"noreferrer noopener\">Keys<\/a>) <\/li><li>design a data warehouse that supports many-to-many relationships (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/define-a-many-to-many-relationship-and-many-to-many-relationship-properties?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Define a Many-to-Many Relationship and Many-to-Many Relationship Properties<\/a>)<\/li><li>implement semi-additive measures (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/define-semiadditive-behavior?view=asallproducts-allversions\" target=\"_blank\" rel=\"noreferrer noopener\">Define Semiadditive Behavior<\/a>)<\/li><li>implement non-additive measures<\/li><\/ul>\n\n\n\n<p>Designing and implementing indexes for a data warehouse workload<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Design an indexing solution (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/sql-server-index-design-guide?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server Index Architecture and Design Guide<\/a>)<\/li><li>select appropriate indexes<\/li><li>implement clustered, non-clustered, filtered, and columnstore indexes (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/indexes\/columnstore-indexes-overview?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Columnstore indexes: Overview<\/a>)<\/li><\/ul>\n\n\n\n<p>Designing storage for a data warehouse<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Design an appropriate storage solution, including hardware, disk, and file layout (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sharepoint\/administration\/storage-and-sql-server-capacity-planning-and-configuration\" target=\"_blank\" rel=\"noreferrer noopener\">Storage and SQL Server capacity planning and configuration<\/a>)<\/li><\/ul>\n\n\n\n<p>Designing and implementing partitioned tables and views<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Design a partition structure to support a data warehouse (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/synapse-analytics\/sql-data-warehouse\/sql-data-warehouse-tables-partition\" target=\"_blank\" rel=\"noreferrer noopener\">Partitioning tables in Synapse SQL pool<\/a>)<\/li><li>implement sliding windows (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/stream-analytics-query\/sliding-window-azure-stream-analytics\" target=\"_blank\" rel=\"noreferrer noopener\">Sliding Window<\/a>)<\/li><li>implement partition elimination<\/li><li>design a partition structure that supports the quick loading and scale-out of data<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Extract, transform, and load data (40-45%)<\/strong><\/h4>\n\n\n\n<p>Designing and implement an extract, transform, and load (ETL) control flow by using a SQL Server Integration Services (SSIS) package<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Design and implement ETL control flow elements, including containers, tasks, and precedence constraints (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/control-flow\/control-flow?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Control Flow<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/control-flow\/precedence-constraints?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Precedence Constraints<\/a>)<\/li><li>create variables and parameters (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-resource-manager\/templates\/parameter-files\" target=\"_blank\" rel=\"noreferrer noopener\">Create Resource Manager parameter file<\/a>)<\/li><li>create checkpoints, sequence and loop containers, and variables in SSIS (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/control-flow\/for-loop-container?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">For Loop Container<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/troubleshooting\/debugging-control-flow?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Debugging Control Flow<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/control-flow\/integration-services-containers?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Integration Services Containers<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/packages\/restart-packages-by-using-checkpoints?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Restart Packages by Using Checkpoints<\/a>)<\/li><li>implement data profiling, parallelism, transactions, logging, and security (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/query-processing-architecture-guide?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Query Processing Architecture Guide<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/control-flow\/data-profiling-task?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Data Profiling Task<\/a>)<\/li><\/ul>\n\n\n\n<p>Design and implement an ETL data flow by using an SSIS package<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Implement slowly changing dimension, fuzzy grouping, fuzzy lookup, audit, blocking, nonblocking, and term lookup transformations (<strong>Microsoft Documentation: <\/strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/data-flow\/transformations\/fuzzy-lookup-transformation?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Fuzzy Lookup Transformation<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/data-flow\/transformations\/fuzzy-grouping-transformation?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Fuzzy Grouping Transformation<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/openspecs\/sql_data_portability\/ms-dtsx2\/9e412a0f-209e-46ab-aeb6-2c9ce2ccdd82\" target=\"_blank\" rel=\"noreferrer noopener\">Lookup and Fuzzy Lookup Components with Error Output<\/a>)<\/li><li>map columns (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/data-flow\/transformations\/map-columns-to-composite-domains?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Map Columns to Composite Domains<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/dotnet\/api\/microsoft.spark.sql.functions.map?view=spark-dotnet\" target=\"_blank\" rel=\"noreferrer noopener\">Functions.Map(Column[])&nbsp;Method<\/a>)<\/li><li>determine the appropriate transform object for a given task (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/data-flow\/transformations\/transformation-custom-properties?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Transformation Custom Properties<\/a>)<\/li><li>determine appropriate scenarios for Transact-SQL joins vs. SSIS lookup (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/joins?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Joins (SQL Server)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/data-flow\/transformations\/lookup-transformation?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Lookup Transformation<\/a>)<\/li><li>design table loading by using bulk loading or standard loading (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/synapse-analytics\/sql-data-warehouse\/guidance-for-loading-data\" target=\"_blank\" rel=\"noreferrer noopener\">Best practices for loading data using Synapse SQL pool<\/a>)<\/li><li>remove extra rows or bad rows by using de-duplication <\/li><\/ul>\n\n\n\n<p>Implement an ETL solution that supports incremental data extraction<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Design fact table patterns (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/synapse-analytics\/sql-data-warehouse\/sql-data-warehouse-tables-overview\" target=\"_blank\" rel=\"noreferrer noopener\">Design tables in Synapse SQL pool<\/a>)<\/li><li>enable Change Data Capture (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/track-changes\/enable-and-disable-change-data-capture-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Enable and Disable Change Data Capture (SQL Server)<\/a>)<\/li><li>create a SQL MERGE statement (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/merge-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">MERGE (Transact-SQL)<\/a>)<\/li><\/ul>\n\n\n\n<p>Implement an ETL solution that supports incremental data loading<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Design a control flow to load change data (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/change-data-capture\/change-data-capture-ssis?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Change Data Capture (SSIS)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/control-flow\/control-flow?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Control Flow<\/a>)<\/li><li>load data by using Transact-SQL Change Data Capture functions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/track-changes\/about-change-data-capture-sql-server?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">About Change Data Capture (SQL Server)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/system-functions\/change-data-capture-functions-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Change Data Capture Functions (Transact-SQL)<\/a>)<\/li><li>load data by using Change Data Capture in SSIS <\/li><\/ul>\n\n\n\n<p>Debug SSIS packages<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Fix performance, connectivity, execution, and failed logic issues by using the debugger<\/li><li>enable logging for package execution (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/performance\/integration-services-ssis-logging?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Integration Services (SSIS) Logging<\/a>)<\/li><li>implement error handling for data types (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/data-flow\/error-handling-in-data?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Error Handling in Data<\/a>)<\/li><li>implement breakpoints (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/visualstudio\/debugger\/using-breakpoints?view=vs-2019\" target=\"_blank\" rel=\"noreferrer noopener\">Use breakpoints in the Visual Studio debugger<\/a>)<\/li><li>add data viewers (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/data-flow\/data-viewer?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Data Viewer<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/troubleshooting\/debugging-data-flow?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Debugging Data Flow<\/a>)<\/li><li>profile data with different tools (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/control-flow\/data-profiling-task?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Data Profiling Task<\/a><\/li><li>perform batch clean-up <\/li><\/ul>\n\n\n\n<p>Deploy and configure SSIS packages and projects<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Create an SSIS catalog (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/catalog\/ssis-catalog?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SSIS Catalog<\/a>)<\/li><li>deploy packages by using the deployment utility, SQL Server, and file systems (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/deploy-packages-with-ssis?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Deploy Packages with SSIS<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/packages\/deploy-integration-services-ssis-projects-and-packages?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Deploy Integration Services (SSIS) Projects and Packages<\/a>)<\/li><li>run and customize packages by using DTUTIL (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/dtutil-utility?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">dtutil Utility<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Build data quality solutions (15-20%)<\/strong><\/h4>\n\n\n\n<p>Create a knowledge base<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Create a Data Quality Services (DQS) knowledgebase (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/data-quality-services\/dqs-knowledge-bases-and-domains?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">DQS Knowledge Bases and Domains<\/a>)<\/li><li>determine appropriate use cases for a DQS knowledge base (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/data-quality-services\/dqs-knowledge-bases-and-domains?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">DQS Knowledge Bases and Domains<\/a>)<\/li><li>perform knowledge discovery (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/data-quality-services\/perform-knowledge-discovery?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Perform Knowledge Discovery<\/a>)<\/li><li>perform domain management<\/li><\/ul>\n\n\n\n<p>Maintain data quality by using DQS<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Add matching knowledge to a knowledge base (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/data-quality-services\/adding-knowledge-to-a-knowledge-base?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Adding Knowledge to a Knowledge Base<\/a>)<\/li><li>prepare a DQS for data deduplication (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/data-quality-services\/data-quality-services-concepts?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Data Quality Services Concepts<\/a>)<\/li><li>create a matching policy (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/data-quality-services\/create-a-matching-policy?view=sql-server-ver15#:~:text=In%20the%20Data%20Quality%20Client,Matching%20Policy%20for%20the%20activity.\" target=\"_blank\" rel=\"noreferrer noopener\">Create a Matching Policy<\/a>)<\/li><li>clean data by using DQS knowledge (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/data-quality-services\/cleanse-data-using-dqs-internal-knowledge?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Cleanse Data Using DQS (Internal) Knowledge<\/a>)<\/li><li>clean data by using the SSIS DQS task (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/data-flow\/transformations\/dqs-cleansing-transformation?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">DQS Cleansing Transformation<\/a>)<\/li><li>install DQS (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/data-quality-services\/install-windows\/install-data-quality-services?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Install Data Quality Services<\/a>)<\/li><\/ul>\n\n\n\n<p>Implement a Master Data Services (MDS) model<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Install MDS (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/master-data-services\/master-data-services-installation-and-configuration?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Master Data Services Installation and Configuration<\/a>)<\/li><li>implement MDS <\/li><li>create models, entities, hierarchies, collections, and attributes (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/master-data-services\/models-master-data-services?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Models (Master Data Services)<\/a>)<\/li><li>define security roles<\/li><li>import and export data (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/import-export-data\/import-and-export-data-with-the-sql-server-import-and-export-wizard?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Import and Export Data with the SQL Server Import and Export Wizard<\/a>)<\/li><li>create and edit a subscription <\/li><li>implement entities, attributes, hierarchies, and business rules (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/master-data-services\/business-rule-examples-master-data-services?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Business Rule Examples (Master Data Services)<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/master-data-services\/master-data-services-overview-mds?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Master Data Services Overview (MDS)<\/a>)<\/li><\/ul>\n\n\n\n<p>Manage data by using MDS<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Use MDS tools (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/master-data-services\/master-data-services-overview-mds?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Master Data Services Overview (MDS)<\/a>)<\/li><li>use the Master Data Services Configuration Manager  (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/master-data-services\/master-data-services-installation-and-configuration?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Master Data Services Installation and Configuration<\/a>)<\/li><li>create a Master Data Manager database and web application (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/master-data-services\/install-windows\/create-a-master-data-manager-web-application-master-data-services?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Create a master data manager web application (Master Data Services)<\/a>)<\/li><li>deploy a sample model using MDSModelDeploy.exe (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/master-data-services\/deploy-a-model-deployment-package-by-using-mdsmodeldeploy?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Deploy a Model Deployment Package by Using MDSModelDeploy<\/a>)<\/li><li>use the Master Data Services web application<\/li><li>use the Master Data Services Add-in for Excel (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/master-data-services\/microsoft-excel-add-in\/master-data-services-add-in-for-microsoft-excel?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Master Data Services Add-in for Microsoft Excel<\/a>)<\/li><li>create a Master Data Management hub (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/openspecs\/sql_server_protocols\/ms-ssso\/17748f36-32b5-438a-b6dc-d97b2440419b\" target=\"_blank\" rel=\"noreferrer noopener\">Master Data Services<\/a>)<\/li><li>stage and load data <\/li><li>create subscription views (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/master-data-services\/create-a-subscription-view-to-export-data-master-data-services?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Create a Subscription View to Export Data (Master Data Services)<\/a>)<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Preparation Guide<\/strong> <strong>for Microsoft Exam 70-767: Implementing a SQL Data Warehouse <\/strong><\/h2>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1587\" height=\"2245\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Implementing-a-SQL-Data-Warehouse-2.png\" alt=\"Microsoft Exam 70-767 Preparation Guide\" class=\"wp-image-13385\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Implementing-a-SQL-Data-Warehouse-2.png 1587w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Implementing-a-SQL-Data-Warehouse-2-283x400.png 283w\" sizes=\"auto, (max-width: 1587px) 100vw, 1587px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Instructor-led Training<\/strong><\/h4>\n\n\n\n<p>This five days instructor-led training course equips the participants with the skills and studies to provision a Microsoft SQL Server database. Through this 14 modules course, a learner can focus on SQL Server provision both on-premise and in Azure and goes on to cover installing from new and migrating from an existing install. Through this course a learner gains how to implement a logical design for a data warehouse, describing the core elements of a data warehousing solution and explaining the important hardware considerations required to build a data warehouse. The participants must focus on hands-on work creating BI solutions.<\/p>\n\n\n\n<p><strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/courses\/20767\" target=\"_blank\" rel=\"noreferrer noopener\">Course 20767-C: Implementing a SQL Data Warehouse<\/a><\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Microsoft Books<\/strong><\/h4>\n\n\n\n<p>Microsoft provides reference books that can be helpful while studying for the exam. These books contain various useful resources that can be used while studying. Visit <a rel=\"noreferrer noopener\" href=\"https:\/\/www.microsoftpressstore.com\/search\/index.aspx?query=Windows+Operating+System+Fundamentals\" target=\"_blank\"><strong>Microsoft Press books<\/strong><\/a>, to find relevant books to get a deeper insight into the exam objectives, and hence crack the test, and earn your certification. Some highly recommended books include:<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Exam Ref 70-767 Implementing a SQL Data Warehouse<\/strong><\/h5>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"alignleft is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/images-eu.ssl-images-amazon.com\/images\/I\/51y1y8naCPL._SX342_QL70_ML2_.jpg\" alt=\"Exam Ref 70-767 Implementing a SQL Data Warehouse\" width=\"163\" height=\"200\"\/><\/figure><\/div>\n\n\n\n<p>Direct from Microsoft, this Exam Ref is an official study guide for the new Microsoft 70-767 Implementing a SQL Data Warehouse certification exam. Professional and advanced level preparation is provided by this book to broaden the horizon of the candidate`s skills and maximize their chances of scoring high in the examination. <\/p>\n\n\n\n<p>The book is specially written to lay emphasis on specific areas of expertise modern IT professionals that need to successfully build modern data warehouses supporting advanced business intelligence solutions.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Microsoft Community<\/strong><\/h5>\n\n\n\n<p>Discussion is a great way for people to connect over shared experiences. This is a great way to ensure that the members stay engaged. A key part of your communication plan could be an online forum. Rather than searching through emails, you can simply ask a question within the forum and see everyone\u2019s responses in a clear, chronological order. 75% of the employer rate teamwork as \u201cvery important.\u201d Collaboration can help bring out the creative sides of your team members, as you can work together and bring new ideas to the table. It gives you a platform to express your views and creativity and hence train you. Therefore, joining online forums will ultimately help you to achieve the training experience necessary to crack the Microsoft 70-767 Certification Exam.<\/p>\n\n\n\n<p>One big advantage offered by online study forums is that you get to know your stand in the competition. Furthermore, you also get to know how your competitors are preparing, and this will boost up your enthusiasm, and keep your motivation throughout the journey. <\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Practice Tests<\/strong><\/h5>\n\n\n\n<p>You must take practice tests to build your own exam-taking endurance. The more you practice, the easier you&#8217;ll find taking the actual exam. Solving practice tests will help you learn the quirks of the actual exam. As, these tests are designed to identify what you know and what you don&#8217;t. This will help you become more comfortable with the process, and also helps you prepare your own study strategies. The results of practice tests can confirm that you&#8217;re as knowledgeable as you think, or that you need to step up your studying game. <\/p>\n\n\n\n<p>One way to ensure maximum comfort and minimal anxiety are to practice. The more often you sit for a practice test, the more natural it will feel the day of the actual test. This will also assist in tracking your progress, to know which study strategies are helpful and which should be abandoned. Solving Practice tests can provide you with the confidence you need to be stress-free. <\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.testpreptraining.ai\/implementing-a-sql-data-warehouse-70-767-free-practice-test\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"150\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Microsoft-Implementing-a-SQL-Data-Warehouse-1.png\" alt=\"Microsoft 70-767 Free Practice Tests\" class=\"wp-image-13305\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Microsoft-Implementing-a-SQL-Data-Warehouse-1.png 960w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Microsoft-Implementing-a-SQL-Data-Warehouse-1-750x117.png 750w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/a><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Enrich and Upgrade your profile to pass&nbsp;<a href=\"https:\/\/www.testpreptraining.ai\/implementing-a-sql-data-warehouse-70-767-free-practice-test\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft 70-767: Implementing a SQL Data Warehouse<\/a>&nbsp;exam with hundreds of practice Exams. Start Preparing Now!<\/strong><\/h4>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Exam 70-767 Implementing a SQL Data Warehouse certification by Microsoft is really rewarding in terms of entry-level tech work, learnable, and a clear path to a good career. This certification validates your proficiency in building a data warehouse with the implementation of ELTs (Extract, Transform and Load), interaction with Azure technologies like Big Data,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":42602,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[5720,1226],"tags":[2009,2007,2008,4],"class_list":["post-13241","page","type-page","status-publish","has-post-thumbnail","hentry","category-database","category-microsoft","tag-exam-70-767-implementing-a-sql-data-warehouse-practice-tests","tag-exam-70-767-implementing-a-sql-data-warehouse-preparation-guide","tag-exam-70-767-implementing-a-sql-data-warehouse-study-tutorial","tag-m4f"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Exam 70-767: Implementing a SQL Data Warehouse | Prep Guide<\/title>\n<meta name=\"description\" content=\"Enhance your proficiency and gain expertise to qualify for the Microsoft Exam 70-767 Implementing a SQL Data Warehouse. Try our free practice tests 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-767-implementing-a-sql-data-warehouse\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exam 70-767: Implementing a SQL Data Warehouse | Prep Guide\" \/>\n<meta property=\"og:description\" content=\"Enhance your proficiency and gain expertise to qualify for the Microsoft Exam 70-767 Implementing a SQL Data Warehouse. Try our free practice tests Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-767-implementing-a-sql-data-warehouse\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-27T13:59:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/70-767.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"758\" \/>\n\t<meta property=\"og:image:height\" content=\"418\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"12 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-767-implementing-a-sql-data-warehouse\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-767-implementing-a-sql-data-warehouse\/\",\"name\":\"Exam 70-767: Implementing a SQL Data Warehouse | Prep Guide\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2020-07-24T19:27:29+00:00\",\"dateModified\":\"2021-05-27T13:59:54+00:00\",\"description\":\"Enhance your proficiency and gain expertise to qualify for the Microsoft Exam 70-767 Implementing a SQL Data Warehouse. Try our free practice tests Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-767-implementing-a-sql-data-warehouse\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-767-implementing-a-sql-data-warehouse\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-767-implementing-a-sql-data-warehouse\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exam 70-767: Implementing a SQL Data Warehouse\"}]},{\"@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-767: Implementing a SQL Data Warehouse | Prep Guide","description":"Enhance your proficiency and gain expertise to qualify for the Microsoft Exam 70-767 Implementing a SQL Data Warehouse. Try our free practice tests 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-767-implementing-a-sql-data-warehouse\/","og_locale":"en_US","og_type":"article","og_title":"Exam 70-767: Implementing a SQL Data Warehouse | Prep Guide","og_description":"Enhance your proficiency and gain expertise to qualify for the Microsoft Exam 70-767 Implementing a SQL Data Warehouse. Try our free practice tests Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-767-implementing-a-sql-data-warehouse\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-05-27T13:59:54+00:00","og_image":[{"width":758,"height":418,"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/05\/70-767.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-767-implementing-a-sql-data-warehouse\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-767-implementing-a-sql-data-warehouse\/","name":"Exam 70-767: Implementing a SQL Data Warehouse | Prep Guide","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2020-07-24T19:27:29+00:00","dateModified":"2021-05-27T13:59:54+00:00","description":"Enhance your proficiency and gain expertise to qualify for the Microsoft Exam 70-767 Implementing a SQL Data Warehouse. Try our free practice tests Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-767-implementing-a-sql-data-warehouse\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-767-implementing-a-sql-data-warehouse\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-70-767-implementing-a-sql-data-warehouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Exam 70-767: Implementing a SQL Data Warehouse"}]},{"@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\/13241","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=13241"}],"version-history":[{"count":28,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/13241\/revisions"}],"predecessor-version":[{"id":42603,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/13241\/revisions\/42603"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media\/42602"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=13241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=13241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=13241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}