{"id":2902,"date":"2019-10-25T03:05:54","date_gmt":"2019-10-25T03:05:54","guid":{"rendered":"https:\/\/davidpapkin.net\/?p=2902"},"modified":"2019-10-25T03:05:54","modified_gmt":"2019-10-25T03:05:54","slug":"microsoft-dp-200-exam-info-by-david-papkin","status":"publish","type":"post","link":"https:\/\/davidpapkin.com\/?p=2902","title":{"rendered":"Microsoft DP-200 Exam Info by David Papkin"},"content":{"rendered":"<p>This post by\u00a0<a href=\"https:\/\/davidpapkin.net\/about-us\/\">David\u00a0<\/a>Papkin is\u00a0about exam info for\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-gb\/learn\/certifications\/exams\/dp-200?wt.mc_id=learningredirect_certs-web-wwl\">Microsoft DP-200<\/a>\u00a0exam.<\/p>\n<p>This post is derived from the following link Microsoft Azure certification exams Exam DP-200.<\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-gb\/learn\/certifications\/exams\/dp-200?wt.mc_id=learningredirect_certs-web-wwl\">Exam DP-200: Implementing an Azure Data Solution<\/a><\/p>\n<div class=\"msl-cp-contentblock-section msl-cp-contentblock-section-right\">\n<div class=\"msl-cp-contentblock-section-content-two\"><\/div>\n<\/div>\n<div class=\"cert-exam-banner-left\"><strong>Skills Measured<\/strong><\/div>\n<h6 class=\"cert-exam-banner-left\"><strong style=\"font-family: Ubuntu, sans-serif; font-size: 19px; font-style: normal;\"><span style=\"font-family: Helvetica, sans-serif; font-size: 14px; font-style: normal;\">IMPLEMENT DATA STORAGE SOLUTIONS (40-45%)<\/span><\/strong><\/h6>\n<div class=\"cert-exam-banner-left\">Implement non-relational data stores<br \/>\n\uf0b7 implement a solution that uses Cosmos DB, Data Lake Storage Gen2, or Blob storage<br \/>\n\uf0b7 implement data distribution and partitions<br \/>\n\uf0b7 implement a consistency model in CosmosDB<br \/>\n\uf0b7 provision a non-relational data store<br \/>\n\uf0b7 provide access to data to meet security requirements<br \/>\n\uf0b7 implement for high availability, disaster recovery, and global distribution<br \/>\nImplement relational data stores<br \/>\n\uf0b7 configure elastic pools<br \/>\n\uf0b7 configure geo-replication<br \/>\n\uf0b7 provide access to data to meet security requirements<br \/>\n\uf0b7 implement for high availability, disaster recovery, and global distribution<br \/>\n\uf0b7 implement data distribution and partitions for SQL Data Warehouse<br \/>\n\uf0b7 Implement PolyBase<br \/>\nManage data security<br \/>\n\uf0b7 implement data masking<br \/>\n\uf0b7 encrypt data at rest and in motion<\/div>\n<h6 class=\"cert-exam-banner-left\"><strong><span style=\"font-family: Helvetica, sans-serif; font-size: 14px; font-style: normal;\">Manage and develop data processing (25-30%)<\/span><\/strong><\/h6>\n<div class=\"cert-exam-banner-left\">Develop batch processing solutions<br \/>\n\uf0b7 develop batch processing solutions by using Data Factory and Azure Databricks<br \/>\n\uf0b7 ingest data by using PolyBase<br \/>\n\uf0b7 implement the integration runtime for Data Factory<br \/>\n\uf0b7 create linked services and datasets<br \/>\n\uf0b7 create pipelines and activities<br \/>\n\uf0b7 create and schedule triggers<br \/>\n\uf0b7 implement Azure Databricks clusters, notebooks, jobs, and autoscaling<br \/>\n\uf0b7 ingest data into Azure Databricks<br \/>\nDevelop streaming solutions<br \/>\n\uf0b7 configure input and output<br \/>\n\uf0b7 select the appropriate windowing functions<br \/>\n\uf0b7 implement event processing using Stream Analytics<\/div>\n<h6 class=\"cert-exam-banner-left\"><strong>Monitor and optimize data solutions (30-35%)<\/strong><\/h6>\n<div class=\"cert-exam-banner-left\"><span style=\"font-family: Helvetica, sans-serif; font-size: 14px; font-style: normal; font-weight: 400;\">Monitor data storage<\/span><br \/>\n\uf0b7 monitor relational and non-relational data sources<br \/>\n\uf0b7 implement BLOB storage monitoring<br \/>\n\uf0b7 implement Data Lake Store monitoring<br \/>\n\uf0b7 implement SQL Database monitoring<br \/>\n\uf0b7 implement SQL Data Warehouse monitoring<br \/>\n\uf0b7 implement Cosmos DB monitoring<br \/>\n\uf0b7 configure Azure Monitor alerts<br \/>\n\uf0b7 implement auditing by using Azure Log Analytics<br \/>\nMonitor data processing<br \/>\n\uf0b7 design and implement Data Factory monitoring<br \/>\n\uf0b7 monitor Azure Databricks<br \/>\n\uf0b7 monitor HDInsight processing<br \/>\n\uf0b7 monitor stream analytics<br \/>\nOptimize Azure data solutions<br \/>\n\uf0b7 troubleshoot data partitioning bottlenecks<br \/>\n\uf0b7 optimize Data Lake Storage<br \/>\n\uf0b7 optimize Stream Analytics<br \/>\n\uf0b7 optimize SQL Data Warehouse<br \/>\n\uf0b7 optimize SQL Database<br \/>\n\uf0b7 manage data life cycle<\/div>\n<div><\/div>\n<div class=\"cert-exam-banr-test\">\n<div class=\"msl-cp-contentblock-section msl-cp-contentblock-section-right\">\n<div class=\"msl-cp-contentblock-section-content-two\">\n<div class=\"msl-cp-contentblock-section msl-cp-contentblock-section-middle\">\n<div class=\"msl-cp-contentblock-section-content-two\">\n<div class=\"msl-cp-contentblock-section msl-cp-contentblock-section-middle\">\n<div class=\"msl-cp-contentblock-section-content-two\">\n<div class=\"msl-cp-contentblock-section msl-cp-contentblock-section-middle\">\n<div class=\"msl-cp-contentblock-section-content-two\">\n<div class=\"msl-cp-contentblock-section msl-cp-contentblock-section-right\">\n<div>\n<p>End of David Papkin post about exam info for\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-gb\/learn\/certifications\/exams\/dp-200?wt.mc_id=learningredirect_certs-web-wwl\">Microsoft DP-200<\/a>\u00a0exam.<\/p>\n<\/div>\n<p><a href=\"http:\/\/davidpapkin.org\/\">http:\/\/davidpapkin.org\/<\/a><\/p>\n<p><strong>David Papkin favorite movies<\/strong><\/p>\n<p><a href=\"https:\/\/en.wikipedia.org\/wiki\/GoodFellas\">Robert Deniro in GoodFellas<\/a><\/p>\n<p><a href=\"https:\/\/en.wikipedia.org\/wiki\/Singapore_(1947_film)\">Ava Gardner in Singapore (Flim Noir)<\/a><\/p>\n<p><a href=\"https:\/\/en.wikipedia.org\/wiki\/China_Seas_(film)\">Clarke Gable in China Seas<\/a><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This post by\u00a0David\u00a0Papkin is\u00a0about exam info for\u00a0Microsoft DP-200\u00a0exam. This post is derived from the following link Microsoft Azure certification exams Exam DP-200. Exam DP-200: Implementing an Azure Data Solution Skills Measured IMPLEMENT DATA STORAGE SOLUTIONS (40-45%) Implement non-relational data stores&hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24,25,27,8],"tags":[48,53,70,74,75,108,119],"class_list":["post-2902","post","type-post","status-publish","format-standard","hentry","category-azure","category-big-data","category-data-science","category-microsoft","tag-azure","tag-bigdata","tag-davidpapkin","tag-dp-200","tag-dp200","tag-microsoft","tag-microsoftazure"],"_links":{"self":[{"href":"https:\/\/davidpapkin.com\/index.php?rest_route=\/wp\/v2\/posts\/2902","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/davidpapkin.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/davidpapkin.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/davidpapkin.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/davidpapkin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2902"}],"version-history":[{"count":0,"href":"https:\/\/davidpapkin.com\/index.php?rest_route=\/wp\/v2\/posts\/2902\/revisions"}],"wp:attachment":[{"href":"https:\/\/davidpapkin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/davidpapkin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/davidpapkin.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}