{"id":3817,"date":"2019-06-13T06:30:17","date_gmt":"2019-06-13T06:30:17","guid":{"rendered":"https:\/\/www.dumpsbase.com\/freedumps\/?p=3817"},"modified":"2019-06-13T06:40:09","modified_gmt":"2019-06-13T06:40:09","slug":"2019-new-azure-exam-dp-200-dumps-questions","status":"publish","type":"post","link":"https:\/\/www.dumpsbase.com\/freedumps\/2019-new-azure-exam-dp-200-dumps-questions.html","title":{"rendered":"2019 New Azure Exam DP-200 Dumps Questions"},"content":{"rendered":"\n<p>DP-200 Implementing an Azure Data Solution is one of the two exams for Microsoft Certified: Azure Data Engineer Associate certification.<\/p>\n<h2 data-tadv-p=\"keep\">What are two exams for Azure Data Engineer?<\/h2>\n<p>DP-200 Implementing an Azure Data Solution<\/p>\n<p><a href=\"https:\/\/www.dumpsbase.com\/freedumps\/2019-new-azure-exam-dp-201-dumps-questions.html\"><em><strong>DP-201 Designing an Azure Data Solution<\/strong><\/em><\/a><\/p>\n<p>Today we share new Azure exam DP-200 dumps questions to help you prepare for DP-200 exam well. DP-200 exam measures your ability to accomplish the following technical tasks:<\/p>\n<ul>\n<li data-tadv-p=\"keep\">Implement data storage solutions<\/li>\n<li data-tadv-p=\"keep\">Manage and develop data processing<\/li>\n<li data-tadv-p=\"keep\">Manage data security<\/li>\n<li data-tadv-p=\"keep\">Monitor data solutions<\/li>\n<li data-tadv-p=\"keep\">Manage and troubleshoot Azure data solutions<\/li>\n<\/ul>\n<p>New DP-200 dumps questions are real and accurate, which was cracked to match the exam objectives and tasks for passing successfully.<\/p>\n<h2>You can <span style=\"color: #339966;\">read DP-200 free questions online<\/span> before buying.<\/h2>\n<script>\n\t  window.fbAsyncInit = function() {\n\t    FB.init({\n\t      appId            : '622169541470367',\n\t      autoLogAppEvents : true,\n\t      xfbml            : true,\n\t      version          : 'v3.1'\n\t    });\n\t  };\n\t\n\t  (function(d, s, id){\n\t     var js, fjs = d.getElementsByTagName(s)[0];\n\t     if (d.getElementById(id)) {return;}\n\t     js = d.createElement(s); js.id = id;\n\t     js.src = \"https:\/\/connect.facebook.net\/en_US\/sdk.js\";\n\t     fjs.parentNode.insertBefore(js, fjs);\n\t   }(document, 'script', 'facebook-jssdk'));\n\t<\/script><script type=\"text\/javascript\" >\ndocument.addEventListener(\"DOMContentLoaded\", function(event) { \nif(!window.jQuery) alert(\"The important jQuery library is not properly loaded in your site. Your WordPress theme is probably missing the essential wp_head() call. You can switch to another theme and you will see that the plugin works fine and this notice disappears. If you are still not sure what to do you can contact us for help.\");\n});\n<\/script>  \n  \n<div  id=\"watupro_quiz\" class=\"quiz-area single-page-quiz\">\n<p id=\"submittingExam2308\" style=\"display:none;text-align:center;\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watupro\/img\/loading.gif\" width=\"16\" height=\"16\"><\/p>\n\n<div class=\"watupro-exam-description\" id=\"description-quiz-2308\"><\/div>\n\n<form action=\"\" method=\"post\" class=\"quiz-form\" id=\"quiz-2308\"  enctype=\"multipart\/form-data\" >\n<div class='watu-question ' id='question-1' style=';'><div id='questionWrap-1'  class='   watupro-question-id-68858'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>1. <\/span>Topic 1, Proseware Inc <br \/>\r<br><br \/>\r<br>Background <br \/>\r<br>Proseware, Inc, develops and manages a product named Poll Taker. The product is used for delivering public opinion polling and analysis. <br \/>\r<br>Polling data comes from a variety of sources, including online surveys, house-to-house interviews, and booths at public events. <br \/>\r<br><br \/>\r<br>Polling data <br \/>\r<br>Polling data is stored in one of the two locations: <br \/>\r<br>- An on-premises Microsoft SQL Server 2019 database named PollingData <br \/>\r<br>- Azure Data Lake Gen 2 Data in Data Lake is queried by using PolyBase <br \/>\r<br><br \/>\r<br>Poll metadata <br \/>\r<br>Each poll has associated metadata with information about the poll including the date and number of respondents. The data is stored as JSON. <br \/>\r<br>Phone-based polling Security <br \/>\r<br>- Phone-based poll data must only be uploaded by authorized users from authorized devices <br \/>\r<br>- Contractors must not have access to any polling data other than their own <br \/>\r<br>- Access to polling data must set on a per-active directory user basis <br \/>\r<br><br \/>\r<br>Data migration and loading <br \/>\r<br>- All data migration processes must use Azure Data Factory <br \/>\r<br>- All data migrations must run automatically during non-business hours <br \/>\r<br>- Data migrations must be reliable and retry when needed <br \/>\r<br><br \/>\r<br>Performance <br \/>\r<br>After six months, raw polling data should be moved to a lower-cost storage solution. <br \/>\r<br><br \/>\r<br>Deployments <br \/>\r<br>- All deployments must be performed by using Azure DevOps. Deployments must use templates used in multiple environments <br \/>\r<br>- No credentials or secrets should be used during deployments <br \/>\r<br><br \/>\r<br>Reliability <br \/>\r<br>All services and processes must be resilient to a regional Azure outage. <br \/>\r<br><br \/>\r<br>Monitoring <br \/>\r<br>All Azure services must be monitored by using Azure Monitor. On-premises SQL Server performance must be monitored. <br \/>\r<br><br \/>\r<br>HOTSPOT <br \/>\r<br>You need to ensure that Azure Data Factory pipelines can be deployed. <br \/>\r<br>How should you configure authentication and authorization for deployments? To answer, select the appropriate options in the answer choices. <br \/>\r<br>NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=393 height=237 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-200%20V8.files\/image002.jpg\" v:shapes=\"_x0000_i1025\"><br><\/div><input type='hidden' name='question_id[]' id='qID_1' value='68858' \/><input type='hidden' id='answerType68858' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68858[]' id='textarea_q_68858' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-2' style=';'><div id='questionWrap-2'  class='   watupro-question-id-68860'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>2. <\/span>DRAG DROP <br \/>\r<br>You need to provision the polling data storage account. <br \/>\r<br>How should you configure the storage account? To answer, drag the appropriate Configuration Value to the correct Setting. Each Configuration Value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. <br \/>\r<br>NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=650 height=265 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-200%20V8.files\/image006.jpg\" v:shapes=\"_x0000_i1027\"><br><\/div><input type='hidden' name='question_id[]' id='qID_2' value='68860' \/><input type='hidden' id='answerType68860' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68860[]' id='textarea_q_68860' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-3' style=';'><div id='questionWrap-3'  class='   watupro-question-id-68862'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>3. <\/span>HOTSPOT <br \/>\r<br>You need to ensure polling data security requirements are met. <br \/>\r<br>Which security technologies should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=390 height=222 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-200%20V8.files\/image010.jpg\" v:shapes=\"_x0000_i1029\"><br><\/div><input type='hidden' name='question_id[]' id='qID_3' value='68862' \/><input type='hidden' id='answerType68862' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68862[]' id='textarea_q_68862' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-4' style=';'><div id='questionWrap-4'  class='   watupro-question-id-68863'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>4. <\/span>DRAG DROP <br \/>\r<br>You need to ensure that phone-based polling data can be analyzed in the PollingData database. <br \/>\r<br>Which three actions should you perform in sequence? To answer, move the appropriate actions <br \/>\r<br>from the list of actions to the answer are and arrange them in the correct order. <br \/>\r<br><br><img decoding=\"async\" border=0 width=648 height=516 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-200%20V8.files\/image014.jpg\" v:shapes=\"_x0000_i1031\"><br><\/div><input type='hidden' name='question_id[]' id='qID_4' value='68863' \/><input type='hidden' id='answerType68863' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68863[]' id='textarea_q_68863' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-5' style=';'><div id='questionWrap-5'  class='   watupro-question-id-68865'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>5. <\/span>You need to ensure that phone-based poling data can be analyzed in the PollingData database. <br \/>\r<br>How should you configure Azure Data Factory?<\/div><input type='hidden' name='question_id[]' id='qID_5' value='68865' \/><input type='hidden' id='answerType68865' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68865[]' id='answer-id-283563' class='answer   answerof-68865 ' value='283563'   \/><label for='answer-id-283563' id='answer-label-283563' class=' answer'><span>Use a tumbling schedule trigger<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68865[]' id='answer-id-283564' class='answer   answerof-68865 ' value='283564'   \/><label for='answer-id-283564' id='answer-label-283564' class=' answer'><span>Use an event-based trigger<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68865[]' id='answer-id-283565' class='answer   answerof-68865 ' value='283565'   \/><label for='answer-id-283565' id='answer-label-283565' class=' answer'><span>Use a schedule trigger<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68865[]' id='answer-id-283566' class='answer   answerof-68865 ' value='283566'   \/><label for='answer-id-283566' id='answer-label-283566' class=' answer'><span>Use manual execution<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-6' style=';'><div id='questionWrap-6'  class='   watupro-question-id-68867'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>6. <\/span>HOTSPOT <br \/>\r<br>You need to ensure phone-based polling data upload reliability requirements are met. <br \/>\r<br>How should you configure monitoring? To answer, select the appropriate options in the answer area. <br \/>\r<br>NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" border=0 width=310 height=220 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-200%20V8.files\/image018.jpg\" v:shapes=\"_x0000_i1033\"><br><\/div><input type='hidden' name='question_id[]' id='qID_6' value='68867' \/><input type='hidden' id='answerType68867' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68867[]' id='textarea_q_68867' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-7' style=';'><div id='questionWrap-7'  class='   watupro-question-id-68869'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>7. <\/span>You need to process and query ingested Tier 9 data. <br \/>\r<br>Which two options should you use? Each correct answer presents part of the solution. <br \/>\r<br>NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_7' value='68869' \/><input type='hidden' id='answerType68869' value='checkbox'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68869[]' id='answer-id-283576' class='answer   answerof-68869 ' value='283576'   \/><label for='answer-id-283576' id='answer-label-283576' class=' answer'><span>Azure Notification Hub<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68869[]' id='answer-id-283577' class='answer   answerof-68869 ' value='283577'   \/><label for='answer-id-283577' id='answer-label-283577' class=' answer'><span>Transact-SQL statements<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68869[]' id='answer-id-283578' class='answer   answerof-68869 ' value='283578'   \/><label for='answer-id-283578' id='answer-label-283578' class=' answer'><span>Azure Cache for Redis<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68869[]' id='answer-id-283579' class='answer   answerof-68869 ' value='283579'   \/><label for='answer-id-283579' id='answer-label-283579' class=' answer'><span>Apache Kafka statements<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68869[]' id='answer-id-283580' class='answer   answerof-68869 ' value='283580'   \/><label for='answer-id-283580' id='answer-label-283580' class=' answer'><span>Azure Event Grid<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68869[]' id='answer-id-283582' class='answer   answerof-68869 ' value='283582'   \/><label for='answer-id-283582' id='answer-label-283582' class=' answer'><span>Azure Stream Analytics<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-8' style=';'><div id='questionWrap-8'  class='   watupro-question-id-68871'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>8. <\/span>HOTSPOT <br \/>\r<br>You need set up the Azure Data Factory JSON definition for Tier 10 data. <br \/>\r<br>What should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" border=0 width=545 height=263 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-200%20V8.files\/image030.jpg\" v:shapes=\"_x0000_i1039\"><br><\/div><input type='hidden' name='question_id[]' id='qID_8' value='68871' \/><input type='hidden' id='answerType68871' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68871[]' id='textarea_q_68871' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-9' style=';'><div id='questionWrap-9'  class='   watupro-question-id-68873'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>9. <\/span>You need to set up Azure Data Factory pipelines to meet data movement requirements. <br \/>\r<br>Which integration runtime should you use?<\/div><input type='hidden' name='question_id[]' id='qID_9' value='68873' \/><input type='hidden' id='answerType68873' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68873[]' id='answer-id-283592' class='answer   answerof-68873 ' value='283592'   \/><label for='answer-id-283592' id='answer-label-283592' class=' answer'><span>self-hosted integration runtime<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68873[]' id='answer-id-283593' class='answer   answerof-68873 ' value='283593'   \/><label for='answer-id-283593' id='answer-label-283593' class=' answer'><span>Azure-SSIS Integration Runtime<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68873[]' id='answer-id-283594' class='answer   answerof-68873 ' value='283594'   \/><label for='answer-id-283594' id='answer-label-283594' class=' answer'><span>.NET Common Language Runtime (CLR)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68873[]' id='answer-id-283595' class='answer   answerof-68873 ' value='283595'   \/><label for='answer-id-283595' id='answer-label-283595' class=' answer'><span>Azure integration runtime<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-10' style=';'><div id='questionWrap-10'  class='   watupro-question-id-68875'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>10. <\/span>Validate configuration results and deploy the solution <br \/>\r<br>Does the solution meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_10' value='68875' \/><input type='hidden' id='answerType68875' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68875[]' id='answer-id-283600' class='answer   answerof-68875 ' value='283600'   \/><label for='answer-id-283600' id='answer-label-283600' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68875[]' id='answer-id-283601' class='answer   answerof-68875 ' value='283601'   \/><label for='answer-id-283601' id='answer-label-283601' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-11' style=';'><div id='questionWrap-11'  class='   watupro-question-id-68877'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>11. <\/span>Validate configuration results and deploy the solution <br \/>\r<br>Does the solution meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_11' value='68877' \/><input type='hidden' id='answerType68877' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68877[]' id='answer-id-283604' class='answer   answerof-68877 ' value='283604'   \/><label for='answer-id-283604' id='answer-label-283604' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68877[]' id='answer-id-283606' class='answer   answerof-68877 ' value='283606'   \/><label for='answer-id-283606' id='answer-label-283606' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-12' style=';'><div id='questionWrap-12'  class='   watupro-question-id-68878'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>12. <\/span>Validate configuration results and deploy the solution <br \/>\r<br>Does the solution meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_12' value='68878' \/><input type='hidden' id='answerType68878' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68878[]' id='answer-id-283609' class='answer   answerof-68878 ' value='283609'   \/><label for='answer-id-283609' id='answer-label-283609' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68878[]' id='answer-id-283611' class='answer   answerof-68878 ' value='283611'   \/><label for='answer-id-283611' id='answer-label-283611' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-13' style=';'><div id='questionWrap-13'  class='   watupro-question-id-68880'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>13. <\/span>HOTSPOT <br \/>\r<br>You need to mask tier 1 data. <br \/>\r<br>Which functions should you use? To answer, select the appropriate option in the answer area. <br \/>\r<br>NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" border=0 width=284 height=293 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-200%20V8.files\/image041.jpg\" v:shapes=\"_x0000_i1046\"><br><\/div><input type='hidden' name='question_id[]' id='qID_13' value='68880' \/><input type='hidden' id='answerType68880' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68880[]' id='textarea_q_68880' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-14' style=';'><div id='questionWrap-14'  class='   watupro-question-id-68882'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>14. <\/span>DRAG DROP <br \/>\r<br>You need to set up access to Azure SQL Database for Tier 7 and Tier 8 partners. <br \/>\r<br>Which three actions should you perform in sequence? To answer, move the appropriate three actions from the list of actions to the answer area and arrange them in the correct order. <br \/>\r<br><br><img decoding=\"async\" border=0 width=649 height=422 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-200%20V8.files\/image046.jpg\" v:shapes=\"_x0000_i1049\"><br><\/div><input type='hidden' name='question_id[]' id='qID_14' value='68882' \/><input type='hidden' id='answerType68882' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68882[]' id='textarea_q_68882' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-15' style=';'><div id='questionWrap-15'  class='   watupro-question-id-68884'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>15. <\/span>Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some questions sets might have more than one correct solution, while others might not have a correct solution. <br \/>\r<br>After you answer a question in this section, you will NOT be able to return to it. As a result, these <br \/>\r<br>questions will not appear in the review screen. <br \/>\r<br>You need to implement diagnostic logging for Data Warehouse monitoring. <br \/>\r<br>Which log should you use?<\/div><input type='hidden' name='question_id[]' id='qID_15' value='68884' \/><input type='hidden' id='answerType68884' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68884[]' id='answer-id-283624' class='answer   answerof-68884 ' value='283624'   \/><label for='answer-id-283624' id='answer-label-283624' class=' answer'><span>RequestSteps<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68884[]' id='answer-id-283625' class='answer   answerof-68884 ' value='283625'   \/><label for='answer-id-283625' id='answer-label-283625' class=' answer'><span>DmsWorkers<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68884[]' id='answer-id-283626' class='answer   answerof-68884 ' value='283626'   \/><label for='answer-id-283626' id='answer-label-283626' class=' answer'><span>SqlRequests<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68884[]' id='answer-id-283627' class='answer   answerof-68884 ' value='283627'   \/><label for='answer-id-283627' id='answer-label-283627' class=' answer'><span>ExecRequests<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-16' style=';'><div id='questionWrap-16'  class='   watupro-question-id-68886'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>16. <\/span>Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some questions sets might have more than one correct solution, while others might not have a correct solution. <br \/>\r<br>After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. <br \/>\r<br>You need setup monitoring for tiers 6 through 8. <br \/>\r<br>What should you configure?<\/div><input type='hidden' name='question_id[]' id='qID_16' value='68886' \/><input type='hidden' id='answerType68886' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68886[]' id='answer-id-283632' class='answer   answerof-68886 ' value='283632'   \/><label for='answer-id-283632' id='answer-label-283632' class=' answer'><span>extended events for average storage percentage that emails data engineers<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68886[]' id='answer-id-283633' class='answer   answerof-68886 ' value='283633'   \/><label for='answer-id-283633' id='answer-label-283633' class=' answer'><span>an alert rule to monitor CPU percentage in databases that emails data engineers<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68886[]' id='answer-id-283634' class='answer   answerof-68886 ' value='283634'   \/><label for='answer-id-283634' id='answer-label-283634' class=' answer'><span>an alert rule to monitor CPU percentage in elastic pools that emails data engineers<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68886[]' id='answer-id-283635' class='answer   answerof-68886 ' value='283635'   \/><label for='answer-id-283635' id='answer-label-283635' class=' answer'><span>an alert rule to monitor storage percentage in databases that emails data engineers<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68886[]' id='answer-id-283636' class='answer   answerof-68886 ' value='283636'   \/><label for='answer-id-283636' id='answer-label-283636' class=' answer'><span>an alert rule to monitor storage percentage in elastic pools that emails data engineers<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-17' style=';'><div id='questionWrap-17'  class='   watupro-question-id-68888'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>17. <\/span>Topic 3, Misc Questions <br \/>\r<br><br \/>\r<br>Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals. <br \/>\r<br>You develop a data ingestion process that will import data to a Microsoft Azure SQL Data Warehouse. <br \/>\r<br>The data to be ingested resides in parquet files stored in an Azure Data lake Gen 2 storage account. <br \/>\r<br>You need to load the data from the Azure Data Lake Gen 2 storage account into the Azure SQL Data Warehouse. <br \/>\r<br>Solution; <br \/>\r<br>Create an external data source pointing to the Azure Data Lake Gen 2 storage account. <br \/>\r<br>Create an external tile format and external table using the external data source. <br \/>\r<br>Load the data using the CREATE TABLE AS SELECT statement. Does the solution meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_17' value='68888' \/><input type='hidden' id='answerType68888' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68888[]' id='answer-id-283642' class='answer   answerof-68888 ' value='283642'   \/><label for='answer-id-283642' id='answer-label-283642' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68888[]' id='answer-id-283643' class='answer   answerof-68888 ' value='283643'   \/><label for='answer-id-283643' id='answer-label-283643' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-18' style=';'><div id='questionWrap-18'  class='   watupro-question-id-68890'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>18. <\/span>Load the data using the CREATE TABLE AS SELECT statement. <br \/>\r<br>Does the solution meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_18' value='68890' \/><input type='hidden' id='answerType68890' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68890[]' id='answer-id-283649' class='answer   answerof-68890 ' value='283649'   \/><label for='answer-id-283649' id='answer-label-283649' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68890[]' id='answer-id-283650' class='answer   answerof-68890 ' value='283650'   \/><label for='answer-id-283650' id='answer-label-283650' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-19' style=';'><div id='questionWrap-19'  class='   watupro-question-id-68892'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>19. <\/span>Load the data using the CREATE TABLE AS SELECT statement. <br \/>\r<br>Does the solution meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_19' value='68892' \/><input type='hidden' id='answerType68892' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68892[]' id='answer-id-283656' class='answer   answerof-68892 ' value='283656'   \/><label for='answer-id-283656' id='answer-label-283656' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68892[]' id='answer-id-283657' class='answer   answerof-68892 ' value='283657'   \/><label for='answer-id-283657' id='answer-label-283657' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-20' style=';'><div id='questionWrap-20'  class='   watupro-question-id-68894'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>20. <\/span>Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. <br \/>\r<br>After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. A company uses Azure Data Lake Gen 1 Storage to store big data related to consumer behavior. You need to implement logging. <br \/>\r<br>Solution: Use information stored m Azure Active Directory reports. Does the solution meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_20' value='68894' \/><input type='hidden' id='answerType68894' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68894[]' id='answer-id-283660' class='answer   answerof-68894 ' value='283660'   \/><label for='answer-id-283660' id='answer-label-283660' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68894[]' id='answer-id-283661' class='answer   answerof-68894 ' value='283661'   \/><label for='answer-id-283661' id='answer-label-283661' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-21' style=';'><div id='questionWrap-21'  class='   watupro-question-id-68896'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>21. <\/span>Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. <br \/>\r<br>After you answer a question in this section, you will NOT be able to return to it As a result, these questions will not appear in the review screen. A company uses Azure Data Lake Gen 1 Storage to store big data related to consumer behavior. <br \/>\r<br>You need to implement logging. <br \/>\r<br>Solution: Configure Azure Data Late Storage diagnostics to store logs and metrics in a storage account. <br \/>\r<br>Does the solution meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_21' value='68896' \/><input type='hidden' id='answerType68896' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68896[]' id='answer-id-283666' class='answer   answerof-68896 ' value='283666'   \/><label for='answer-id-283666' id='answer-label-283666' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68896[]' id='answer-id-283667' class='answer   answerof-68896 ' value='283667'   \/><label for='answer-id-283667' id='answer-label-283667' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-22' style=';'><div id='questionWrap-22'  class='   watupro-question-id-68898'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>22. <\/span>Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. <br \/>\r<br>After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. A company uses Azure Data Lake Gen 1 Storage to store big data related to consumer behavior. You need to implement logging. <br \/>\r<br>Solution: Create an Azure Automation runbook to copy events. Does the solution meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_22' value='68898' \/><input type='hidden' id='answerType68898' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68898[]' id='answer-id-283669' class='answer   answerof-68898 ' value='283669'   \/><label for='answer-id-283669' id='answer-label-283669' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68898[]' id='answer-id-283671' class='answer   answerof-68898 ' value='283671'   \/><label for='answer-id-283671' id='answer-label-283671' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-23' style=';'><div id='questionWrap-23'  class='   watupro-question-id-68899'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>23. <\/span>A company has a Microsoft Azure HDInsight solution that uses different cluster types to process and analyze data. Operations are continuous. <br \/>\r<br>Reports indicate slowdowns during a specific lime window. <br \/>\r<br>You need to determine a monitoring solution to track down the issue in the least amount of time. <br \/>\r<br>What should you use?<\/div><input type='hidden' name='question_id[]' id='qID_23' value='68899' \/><input type='hidden' id='answerType68899' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68899[]' id='answer-id-283675' class='answer   answerof-68899 ' value='283675'   \/><label for='answer-id-283675' id='answer-label-283675' class=' answer'><span>Azure Log Analytics log search query<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68899[]' id='answer-id-283676' class='answer   answerof-68899 ' value='283676'   \/><label for='answer-id-283676' id='answer-label-283676' class=' answer'><span>Ambari REST API<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68899[]' id='answer-id-283678' class='answer   answerof-68899 ' value='283678'   \/><label for='answer-id-283678' id='answer-label-283678' class=' answer'><span>Azure Monitor Metrics<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68899[]' id='answer-id-283680' class='answer   answerof-68899 ' value='283680'   \/><label for='answer-id-283680' id='answer-label-283680' class=' answer'><span>HDInsight .NET SDK<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68899[]' id='answer-id-283682' class='answer   answerof-68899 ' value='283682'   \/><label for='answer-id-283682' id='answer-label-283682' class=' answer'><span>Azure Log Analytics alert rule query<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-24' style=';'><div id='questionWrap-24'  class='   watupro-question-id-68901'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>24. <\/span>Your company uses several Azure HDInsight clusters. <br \/>\r<br>The data engineering team reports several errors with some application using these clusters. <br \/>\r<br>You need to recommend a solution to review the health of the clusters. <br \/>\r<br>What should you include in you recommendation?<\/div><input type='hidden' name='question_id[]' id='qID_24' value='68901' \/><input type='hidden' id='answerType68901' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68901[]' id='answer-id-283691' class='answer   answerof-68901 ' value='283691'   \/><label for='answer-id-283691' id='answer-label-283691' class=' answer'><span>Azure Automation<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68901[]' id='answer-id-283692' class='answer   answerof-68901 ' value='283692'   \/><label for='answer-id-283692' id='answer-label-283692' class=' answer'><span>Log Analytics<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68901[]' id='answer-id-283693' class='answer   answerof-68901 ' value='283693'   \/><label for='answer-id-283693' id='answer-label-283693' class=' answer'><span>Application Insights<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-25' style=';'><div id='questionWrap-25'  class='   watupro-question-id-68903'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>25. <\/span>HOTSPOT <br \/>\r<br>A company is planning to use Microsoft Azure Cosmos DB as the data store for an application. You have the following Azure CLI command: <br \/>\r<br>az cosmosdb create -Cname &quot;cosmosdbdev1&quot; C-resource-group &quot;rgdev&quot; <br \/>\r<br>You need to minimize latency and expose the SQL API. <br \/>\r<br>How should you complete the command? To answer, select the appropriate options in the answer area. <br \/>\r<br>NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" border=0 width=538 height=252 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-200%20V8.files\/image052.jpg\" v:shapes=\"_x0000_i1052\"><br><\/div><input type='hidden' name='question_id[]' id='qID_25' value='68903' \/><input type='hidden' id='answerType68903' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68903[]' id='textarea_q_68903' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-26' style=';'><div id='questionWrap-26'  class='   watupro-question-id-68905'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>26. <\/span>A company manages several on-premises Microsoft SQL Server databases. <br \/>\r<br>You need to migrate the databases to Microsoft Azure by using the backup process of Microsoft SQL Server. <br \/>\r<br>Which data technology should you use?<\/div><input type='hidden' name='question_id[]' id='qID_26' value='68905' \/><input type='hidden' id='answerType68905' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68905[]' id='answer-id-283700' class='answer   answerof-68905 ' value='283700'   \/><label for='answer-id-283700' id='answer-label-283700' class=' answer'><span>Azure SQL Database Managed Instance<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68905[]' id='answer-id-283702' class='answer   answerof-68905 ' value='283702'   \/><label for='answer-id-283702' id='answer-label-283702' class=' answer'><span>Azure SQL Data Warehouse<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68905[]' id='answer-id-283704' class='answer   answerof-68905 ' value='283704'   \/><label for='answer-id-283704' id='answer-label-283704' class=' answer'><span>Azure Cosmos DB<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68905[]' id='answer-id-283706' class='answer   answerof-68905 ' value='283706'   \/><label for='answer-id-283706' id='answer-label-283706' class=' answer'><span>Azure SQL Database single database<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-27' style=';'><div id='questionWrap-27'  class='   watupro-question-id-68906'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>27. <\/span>You implement 3 Azure SQL Data Warehouse instance. <br \/>\r<br>You plan to migrate the largest fact table to Azure SQL Data Warehouse The table resides on Microsoft SQL Server on-premises and e 10 terabytes (TB) in size. <br \/>\r<br>Incoming queues use the primary key Sale Key column to retrieve data as displayed in the following table: You need to distribute the fact table across multiple nodes to optimize performance of the table. <br \/>\r<br><br><img decoding=\"async\" border=0 width=650 height=132 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-200%20V8.files\/image058.jpg\" v:shapes=\"_x0000_i1055\"><br><br \/>\r<br>Which technology should you use?<\/div><input type='hidden' name='question_id[]' id='qID_27' value='68906' \/><input type='hidden' id='answerType68906' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68906[]' id='answer-id-283710' class='answer   answerof-68906 ' value='283710'   \/><label for='answer-id-283710' id='answer-label-283710' class=' answer'><span>hash distributed table with clustered ColumnStore index<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68906[]' id='answer-id-283711' class='answer   answerof-68906 ' value='283711'   \/><label for='answer-id-283711' id='answer-label-283711' class=' answer'><span>hash distributed table with clustered index<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68906[]' id='answer-id-283712' class='answer   answerof-68906 ' value='283712'   \/><label for='answer-id-283712' id='answer-label-283712' class=' answer'><span>heap table with distribution replicate<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68906[]' id='answer-id-283713' class='answer   answerof-68906 ' value='283713'   \/><label for='answer-id-283713' id='answer-label-283713' class=' answer'><span>round robin distributed table with clustered index<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68906[]' id='answer-id-283714' class='answer   answerof-68906 ' value='283714'   \/><label for='answer-id-283714' id='answer-label-283714' class=' answer'><span>round robin distributed table with clustered ColumnStore index<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-28' style=';'><div id='questionWrap-28'  class='   watupro-question-id-68908'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>28. <\/span>An application will use Microsoft Azure Cosmos DB as its data solution. The application will use the Cassandra API to support a column-based database type that uses containers to store items. <br \/>\r<br>You need to provision Azure Cosmos DB. <br \/>\r<br>Which container name and item name should you use? Each correct answer presents part of the solutions. <br \/>\r<br>NOTE: Each correct answer selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_28' value='68908' \/><input type='hidden' id='answerType68908' value='checkbox'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68908[]' id='answer-id-283719' class='answer   answerof-68908 ' value='283719'   \/><label for='answer-id-283719' id='answer-label-283719' class=' answer'><span>table<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68908[]' id='answer-id-283720' class='answer   answerof-68908 ' value='283720'   \/><label for='answer-id-283720' id='answer-label-283720' class=' answer'><span>collection<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68908[]' id='answer-id-283721' class='answer   answerof-68908 ' value='283721'   \/><label for='answer-id-283721' id='answer-label-283721' class=' answer'><span>graph<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68908[]' id='answer-id-283722' class='answer   answerof-68908 ' value='283722'   \/><label for='answer-id-283722' id='answer-label-283722' class=' answer'><span>entities<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68908[]' id='answer-id-283723' class='answer   answerof-68908 ' value='283723'   \/><label for='answer-id-283723' id='answer-label-283723' class=' answer'><span>rows<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-29' style=';'><div id='questionWrap-29'  class='   watupro-question-id-68910'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>29. <\/span>A company is designing a hybrid solution to synchronize data and on-premises Microsoft SQL Server database to Azure SQL Database. <br \/>\r<br>You must perform an assessment of databases to determine whether data will move without compatibility issues. <br \/>\r<br>You need to perform the assessment. <br \/>\r<br>Which tool should you use?<\/div><input type='hidden' name='question_id[]' id='qID_29' value='68910' \/><input type='hidden' id='answerType68910' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68910[]' id='answer-id-283729' class='answer   answerof-68910 ' value='283729'   \/><label for='answer-id-283729' id='answer-label-283729' class=' answer'><span>Azure SQL Data Sync<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68910[]' id='answer-id-283730' class='answer   answerof-68910 ' value='283730'   \/><label for='answer-id-283730' id='answer-label-283730' class=' answer'><span>SQL Vulnerability Assessment (VA)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68910[]' id='answer-id-283731' class='answer   answerof-68910 ' value='283731'   \/><label for='answer-id-283731' id='answer-label-283731' class=' answer'><span>SQL Server Migration Assistant (SSMA)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68910[]' id='answer-id-283732' class='answer   answerof-68910 ' value='283732'   \/><label for='answer-id-283732' id='answer-label-283732' class=' answer'><span>Microsoft Assessment and Planning Toolkit<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68910[]' id='answer-id-283733' class='answer   answerof-68910 ' value='283733'   \/><label for='answer-id-283733' id='answer-label-283733' class=' answer'><span>Data Migration Assistant (DMA)<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-30' style=';'><div id='questionWrap-30'  class='   watupro-question-id-68912'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>30. <\/span>DRAG DROP <br \/>\r<br>You are developing the data platform for a global retail company. The company operates during normal working hours in each region. The analytical database is used once a week for building sales projections. <br \/>\r<br>Each region maintains its own private virtual network. <br \/>\r<br>Building the sales projections is very resource intensive are generates upwards of 20 terabytes (TB) of data. <br \/>\r<br>Microsoft Azure SQL Databases must be provisioned. <br \/>\r<br>- Database provisioning must maximize performance and minimize cost <br \/>\r<br>- The daily sales for each region must be stored in an Azure SQL Database instance <br \/>\r<br>- Once a day, the data for all regions must be loaded in an analytical Azure SQL Database instance <br \/>\r<br>You need to provision Azure SQL database instances. <br \/>\r<br>How should you provision the database instances? To answer, drag the appropriate Azure SQL products to the correct databases. Each Azure SQL product may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. <br \/>\r<br>NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" border=0 width=650 height=201 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-200%20V8.files\/image064.jpg\" v:shapes=\"_x0000_i1058\"><br><\/div><input type='hidden' name='question_id[]' id='qID_30' value='68912' \/><input type='hidden' id='answerType68912' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68912[]' id='textarea_q_68912' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-31' style=';'><div id='questionWrap-31'  class='   watupro-question-id-68914'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>31. <\/span>You are the data engineer tor your company. An application uses a NoSQL database to store data. The database uses the key-value and wide-column NoSQL database type. <br \/>\r<br>Developers need to access data in the database using an API. <br \/>\r<br>You need to determine which API to use for the database model and type. <br \/>\r<br>Which two APIs should you use? Each correct answer presents a complete solution. <br \/>\r<br>NOTE: Each correct selection s worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_31' value='68914' \/><input type='hidden' id='answerType68914' value='checkbox'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68914[]' id='answer-id-283744' class='answer   answerof-68914 ' value='283744'   \/><label for='answer-id-283744' id='answer-label-283744' class=' answer'><span>Table API<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68914[]' id='answer-id-283745' class='answer   answerof-68914 ' value='283745'   \/><label for='answer-id-283745' id='answer-label-283745' class=' answer'><span>MongoDB API<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68914[]' id='answer-id-283746' class='answer   answerof-68914 ' value='283746'   \/><label for='answer-id-283746' id='answer-label-283746' class=' answer'><span>Gremlin API<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68914[]' id='answer-id-283747' class='answer   answerof-68914 ' value='283747'   \/><label for='answer-id-283747' id='answer-label-283747' class=' answer'><span>SQL API<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68914[]' id='answer-id-283748' class='answer   answerof-68914 ' value='283748'   \/><label for='answer-id-283748' id='answer-label-283748' class=' answer'><span>Cassandra API<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-32' style=';'><div id='questionWrap-32'  class='   watupro-question-id-68916'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>32. <\/span>DRAG DROP <br \/>\r<br>Your company uses Microsoft Azure SQL Database configure with Elastic pool. You use Elastic Database jobs to run queries across all databases in the pod. <br \/>\r<br>You need to analyze, troubleshoot, and report on components responsible for running Elastic Database jobs. <br \/>\r<br>You need to determine the component responsible for running job service tasks. <br \/>\r<br>Which components should you use for each Elastic pool job services task? To answer, drag the appropriate component to the correct task. Each component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. <br \/>\r<br>NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" border=0 width=649 height=156 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-200%20V8.files\/image068.jpg\" v:shapes=\"_x0000_i1060\"><br><\/div><input type='hidden' name='question_id[]' id='qID_32' value='68916' \/><input type='hidden' id='answerType68916' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68916[]' id='textarea_q_68916' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-33' style=';'><div id='questionWrap-33'  class='   watupro-question-id-68918'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>33. <\/span>DRAG DROP <br \/>\r<br>You are developing a solution to visualize multiple terabytes of geospatial data. <br \/>\r<br>The solution has the following requirements: <br \/>\r<br>- Data must be encrypted. <br \/>\r<br>- Data must be accessible by multiple resources on Microsoft Azure. <br \/>\r<br>You need to provision storage for the solution. <br \/>\r<br>Which four actions should you perform in sequence? To answer, move the appropriate action from <br \/>\r<br>the list of actions to the answer area and arrange them in the correct order. <br \/>\r<br><br><img decoding=\"async\" border=0 width=650 height=278 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-200%20V8.files\/image072.jpg\" v:shapes=\"_x0000_i1062\"><br><\/div><input type='hidden' name='question_id[]' id='qID_33' value='68918' \/><input type='hidden' id='answerType68918' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68918[]' id='textarea_q_68918' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-34' style=';'><div id='questionWrap-34'  class='   watupro-question-id-68920'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>34. <\/span>You are developing a data engineering solution for a company. The solution will store a large set of key-value pair data by using Microsoft Azure Cosmos DB <br \/>\r<br>The solution has the following requirements: <br \/>\r<br>&#8226; Data must be partitioned into multiple containers. <br \/>\r<br>&#8226; Data containers must be configured separately. <br \/>\r<br>&#8226; Data must be accessible from applications hosted around the world. <br \/>\r<br>&#8226; The solution must minimize latency. <br \/>\r<br>You need to provision Azure Cosmos DB<\/div><input type='hidden' name='question_id[]' id='qID_34' value='68920' \/><input type='hidden' id='answerType68920' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68920[]' id='answer-id-283766' class='answer   answerof-68920 ' value='283766'   \/><label for='answer-id-283766' id='answer-label-283766' class=' answer'><span>Configure account-level throughput.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68920[]' id='answer-id-283767' class='answer   answerof-68920 ' value='283767'   \/><label for='answer-id-283767' id='answer-label-283767' class=' answer'><span>Provision an Azure Cosmos DB account with the Azure Table API Enable geo-redundancy.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68920[]' id='answer-id-283768' class='answer   answerof-68920 ' value='283768'   \/><label for='answer-id-283768' id='answer-label-283768' class=' answer'><span>Configure table-level throughput<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68920[]' id='answer-id-283769' class='answer   answerof-68920 ' value='283769'   \/><label for='answer-id-283769' id='answer-label-283769' class=' answer'><span>Replicate the data globally by manually adding regions lo the Azure Cosmos DB account.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68920[]' id='answer-id-283770' class='answer   answerof-68920 ' value='283770'   \/><label for='answer-id-283770' id='answer-label-283770' class=' answer'><span>Provision an Azure Cosmos DB account with the Azure Table AP<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68920[]' id='answer-id-283771' class='answer   answerof-68920 ' value='283771'   \/><label for='answer-id-283771' id='answer-label-283771' class=' answer'><span>Enable multi-region writes.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div style='display:none' id='question-35'>\n\t<div class='question-content'>\n\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watupro\/img\/loading.gif\" width=\"16\" height=\"16\" alt=\"Loading...\" title=\"Loading...\" \/>&nbsp;Loading...\t<\/div>\n<\/div>\n\n<br \/>\n\t\n\t\t\t<div class=\"watupro_buttons flex \" id=\"watuPROButtons2308\" >\n\t\t  <div id=\"prev-question\" style=\"display:none;\"><input type=\"button\" value=\"&lt; Previous\" onclick=\"WatuPRO.nextQuestion(event, 'previous');\"\/><\/div>\t\t  \t\t  \t\t   \n\t\t   \t  \t\t<div><input type=\"button\" name=\"action\" class=\"watupro-submit-button\" onclick=\"WatuPRO.submitResult(event)\" id=\"action-button\" value=\"View Results\"  \/>\n\t\t<\/div>\n\t\t<\/div>\n\t\t\n\t<input type=\"hidden\" name=\"quiz_id\" value=\"2308\" id=\"watuPROExamID\"\/>\n\t<input type=\"hidden\" name=\"start_time\" id=\"startTime\" value=\"2026-05-01 03:37:27\" \/>\n\t<input type=\"hidden\" name=\"start_timestamp\" id=\"startTimeStamp\" value=\"1777606647\" \/>\n\t<input type=\"hidden\" name=\"question_ids\" value=\"\" \/>\n\t<input type=\"hidden\" name=\"watupro_questions\" value=\"68858:283547 | 68860:283552 | 68862:283555 | 68863:283560 | 68865:283563,283564,283565,283566 | 68867:283571 | 68869:283576,283577,283578,283579,283580,283582 | 68871:283587 | 68873:283592,283593,283594,283595 | 68875:283600,283601 | 68877:283604,283606 | 68878:283609,283611 | 68880:283613 | 68882:283618 | 68884:283624,283625,283626,283627 | 68886:283632,283633,283634,283635,283636 | 68888:283642,283643 | 68890:283649,283650 | 68892:283656,283657 | 68894:283660,283661 | 68896:283666,283667 | 68898:283669,283671 | 68899:283675,283676,283678,283680,283682 | 68901:283691,283692,283693 | 68903:283699 | 68905:283700,283702,283704,283706 | 68906:283710,283711,283712,283713,283714 | 68908:283719,283720,283721,283722,283723 | 68910:283729,283730,283731,283732,283733 | 68912:283738 | 68914:283744,283745,283746,283747,283748 | 68916:283754 | 68918:283760 | 68920:283766,283767,283768,283769,283770,283771\" \/>\n\t<input type=\"hidden\" name=\"no_ajax\" value=\"0\">\t\t\t<\/form>\n\t<p>&nbsp;<\/p>\n<\/div>\n\n<script type=\"text\/javascript\">\n\/\/jQuery(document).ready(function(){\ndocument.addEventListener(\"DOMContentLoaded\", function(event) { \t\nvar question_ids = \"68858,68860,68862,68863,68865,68867,68869,68871,68873,68875,68877,68878,68880,68882,68884,68886,68888,68890,68892,68894,68896,68898,68899,68901,68903,68905,68906,68908,68910,68912,68914,68916,68918,68920\";\nWatuPROSettings[2308] = {};\nWatuPRO.qArr = question_ids.split(',');\nWatuPRO.exam_id = 2308;\t    \nWatuPRO.post_id = 3817;\nWatuPRO.store_progress = 0;\nWatuPRO.curCatPage = 1;\nWatuPRO.requiredIDs=\"0\".split(\",\");\nWatuPRO.hAppID = \"0.62591100 1777606647\";\nvar url = \"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watupro\/show_exam.php\";\nWatuPRO.examMode = 1;\nWatuPRO.siteURL=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-admin\/admin-ajax.php\";\nWatuPRO.emailIsNotRequired = 0;\nWatuPROIntel.init(2308);\nWatuPRO.inCategoryPages=1;});    \t \n<\/script>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[101,6074],"tags":[6740,6741,6742,6743,6746,6745,6744,6747],"class_list":["post-3817","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-data-certification","tag-azure-data-engineer","tag-dp-200","tag-dp-200-dumps","tag-dp-200-dumps-questions","tag-dp-200-exam-dumps","tag-dp-200-exam-questions","tag-dp-200-questions","tag-implementing-an-azure-data-solution"],"_links":{"self":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/3817","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/comments?post=3817"}],"version-history":[{"count":2,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/3817\/revisions"}],"predecessor-version":[{"id":3824,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/3817\/revisions\/3824"}],"wp:attachment":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/media?parent=3817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/categories?post=3817"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/tags?post=3817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}