{"id":26926,"date":"2021-08-02T01:41:48","date_gmt":"2021-08-02T01:41:48","guid":{"rendered":"https:\/\/www.dumpsbase.com\/freedumps\/?p=26926"},"modified":"2021-08-02T01:41:50","modified_gmt":"2021-08-02T01:41:50","slug":"dp-200-microsoft-implementing-an-azure-data-solution-exam-dumps-updated","status":"publish","type":"post","link":"https:\/\/www.dumpsbase.com\/freedumps\/dp-200-microsoft-implementing-an-azure-data-solution-exam-dumps-updated.html","title":{"rendered":"DP-200 Microsoft Implementing an Azure Data Solution Exam Dumps Updated"},"content":{"rendered":"\n<p>Even DP-200 Implementing an Azure Data Solution exam will be retired on August 31, 2021, there are still some candidates fedback that the exam questions have been changed. Based on the latest reviews and date, we have updated Microsoft DP-200 dumps with 242 practice exam questions and answers to ensure that you can complete Microsoft DP-200 exam before the retirement. Come to read DP-200 updated dumps questions to prepare for Implementing an Azure Data Solution exam well.<\/p>\n<h2>No need to worry about the quality, we have <span style=\"color: #ff0000;\">DP-200 free dumps<\/span> online for checking.<\/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=\"submittingExam5617\" 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-5617\"><\/div>\n\n<form action=\"\" method=\"post\" class=\"quiz-form\" id=\"quiz-5617\"  enctype=\"multipart\/form-data\" >\n<div class='watu-question ' id='question-1' style=';'><div id='questionWrap-1'  class='   watupro-question-id-186813'>\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><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 <br \/>\r<br><br \/>\r<br>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><br \/>\r<br>Phone-based polling <br \/>\r<br>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 storage account. The storage must be available in the event of a regional disaster. The solution must minimize costs. <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>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_1' value='186813' \/><input type='hidden' id='answerType186813' 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-186813[]' id='answer-id-751777' class='answer   answerof-186813 ' value='751777'   \/><label for='answer-id-751777' id='answer-label-751777' class=' answer'><span>Use a tumbling schedule trigger<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186813[]' id='answer-id-751778' class='answer   answerof-186813 ' value='751778'   \/><label for='answer-id-751778' id='answer-label-751778' class=' answer'><span>Use an event-based trigger<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186813[]' id='answer-id-751779' class='answer   answerof-186813 ' value='751779'   \/><label for='answer-id-751779' id='answer-label-751779' class=' answer'><span>Use a schedule trigger<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186813[]' id='answer-id-751780' class='answer   answerof-186813 ' value='751780'   \/><label for='answer-id-751780' id='answer-label-751780' class=' answer'><span>Use manual execution<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-2' style=';'><div id='questionWrap-2'  class='   watupro-question-id-186814'>\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. NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=528 height=290 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image002-38.jpg\" v:shapes=\"_x0000_i1025\"><br><\/div><input type='hidden' name='question_id[]' id='qID_2' value='186814' \/><input type='hidden' id='answerType186814' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186814[]' id='textarea_q_186814' 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-186815'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>3. <\/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 from the list of actions to the answer are and arrange them in the correct order. <br \/>\r<br><br><img decoding=\"async\" width=636 height=519 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image006-32.jpg\" v:shapes=\"_x0000_i1027\"><br><\/div><input type='hidden' name='question_id[]' id='qID_3' value='186815' \/><input type='hidden' id='answerType186815' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186815[]' id='textarea_q_186815' 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-186816'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>4. <\/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. NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=310 height=220 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image010-24.jpg\" v:shapes=\"_x0000_i1029\"><br><\/div><input type='hidden' name='question_id[]' id='qID_4' value='186816' \/><input type='hidden' id='answerType186816' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186816[]' id='textarea_q_186816' 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-186817'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>5. <\/span>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. 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\/2021\/07\/image014-20.jpg\" v:shapes=\"_x0000_i1031\"><br><\/div><input type='hidden' name='question_id[]' id='qID_5' value='186817' \/><input type='hidden' id='answerType186817' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186817[]' id='textarea_q_186817' 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-6' style=';'><div id='questionWrap-6'  class='   watupro-question-id-186818'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>6. <\/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\/2021\/07\/image018-17.jpg\" v:shapes=\"_x0000_i1033\"><br><\/div><input type='hidden' name='question_id[]' id='qID_6' value='186818' \/><input type='hidden' id='answerType186818' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186818[]' id='textarea_q_186818' 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-186819'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>7. <\/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_7' value='186819' \/><input type='hidden' id='answerType186819' 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-186819[]' id='answer-id-751786' class='answer   answerof-186819 ' value='751786'   \/><label for='answer-id-751786' id='answer-label-751786' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186819[]' id='answer-id-751787' class='answer   answerof-186819 ' value='751787'   \/><label for='answer-id-751787' id='answer-label-751787' class=' answer'><span>No<\/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-186820'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>8. <\/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_8' value='186820' \/><input type='hidden' id='answerType186820' 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-186820[]' id='answer-id-751788' class='answer   answerof-186820 ' value='751788'   \/><label for='answer-id-751788' id='answer-label-751788' class=' answer'><span>self-hosted integration runtime<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186820[]' id='answer-id-751789' class='answer   answerof-186820 ' value='751789'   \/><label for='answer-id-751789' id='answer-label-751789' class=' answer'><span>Azure-SSIS Integration Runtime<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186820[]' id='answer-id-751790' class='answer   answerof-186820 ' value='751790'   \/><label for='answer-id-751790' id='answer-label-751790' class=' answer'><span>.NET Common Language Runtime (CLR)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186820[]' id='answer-id-751791' class='answer   answerof-186820 ' value='751791'   \/><label for='answer-id-751791' id='answer-label-751791' class=' answer'><span>Azure integration runtime<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-9' style=';'><div id='questionWrap-9'  class='   watupro-question-id-186821'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>9. <\/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_9' value='186821' \/><input type='hidden' id='answerType186821' 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-186821[]' id='answer-id-751792' class='answer   answerof-186821 ' value='751792'   \/><label for='answer-id-751792' id='answer-label-751792' 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='checkbox' name='answer-186821[]' id='answer-id-751793' class='answer   answerof-186821 ' value='751793'   \/><label for='answer-id-751793' id='answer-label-751793' 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='checkbox' name='answer-186821[]' id='answer-id-751794' class='answer   answerof-186821 ' value='751794'   \/><label for='answer-id-751794' id='answer-label-751794' 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='checkbox' name='answer-186821[]' id='answer-id-751795' class='answer   answerof-186821 ' value='751795'   \/><label for='answer-id-751795' id='answer-label-751795' 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='checkbox' name='answer-186821[]' id='answer-id-751796' class='answer   answerof-186821 ' value='751796'   \/><label for='answer-id-751796' id='answer-label-751796' 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-10' style=';'><div id='questionWrap-10'  class='   watupro-question-id-186822'>\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='186822' \/><input type='hidden' id='answerType186822' 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-186822[]' id='answer-id-751797' class='answer   answerof-186822 ' value='751797'   \/><label for='answer-id-751797' id='answer-label-751797' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186822[]' id='answer-id-751798' class='answer   answerof-186822 ' value='751798'   \/><label for='answer-id-751798' id='answer-label-751798' 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-186823'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>11. <\/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\" width=649 height=422 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image033-6.jpg\" v:shapes=\"_x0000_i1041\"><br><\/div><input type='hidden' name='question_id[]' id='qID_11' value='186823' \/><input type='hidden' id='answerType186823' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186823[]' id='textarea_q_186823' 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-12' style=';'><div id='questionWrap-12'  class='   watupro-question-id-186824'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>12. <\/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\" width=545 height=263 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image037-6.jpg\" v:shapes=\"_x0000_i1043\"><br><\/div><input type='hidden' name='question_id[]' id='qID_12' value='186824' \/><input type='hidden' id='answerType186824' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186824[]' id='textarea_q_186824' 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-13' style=';'><div id='questionWrap-13'  class='   watupro-question-id-186825'>\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. NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=429 height=439 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image042-9.jpg\" v:shapes=\"_x0000_i1046\"><br><\/div><input type='hidden' name='question_id[]' id='qID_13' value='186825' \/><input type='hidden' id='answerType186825' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186825[]' id='textarea_q_186825' 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-186826'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>14. <\/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_14' value='186826' \/><input type='hidden' id='answerType186826' 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-186826[]' id='answer-id-751802' class='answer   answerof-186826 ' value='751802'   \/><label for='answer-id-751802' id='answer-label-751802' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186826[]' id='answer-id-751803' class='answer   answerof-186826 ' value='751803'   \/><label for='answer-id-751803' id='answer-label-751803' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-15' style=';'><div id='questionWrap-15'  class='   watupro-question-id-186827'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>15. <\/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. NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_15' value='186827' \/><input type='hidden' id='answerType186827' 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-186827[]' id='answer-id-751804' class='answer   answerof-186827 ' value='751804'   \/><label for='answer-id-751804' id='answer-label-751804' class=' answer'><span>Azure Notification Hub<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186827[]' id='answer-id-751805' class='answer   answerof-186827 ' value='751805'   \/><label for='answer-id-751805' id='answer-label-751805' class=' answer'><span>Transact-SQL statements<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186827[]' id='answer-id-751806' class='answer   answerof-186827 ' value='751806'   \/><label for='answer-id-751806' id='answer-label-751806' class=' answer'><span>Azure Cache for Redis<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186827[]' id='answer-id-751807' class='answer   answerof-186827 ' value='751807'   \/><label for='answer-id-751807' id='answer-label-751807' class=' answer'><span>Apache Kafka statements<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186827[]' id='answer-id-751808' class='answer   answerof-186827 ' value='751808'   \/><label for='answer-id-751808' id='answer-label-751808' class=' answer'><span>Azure Event Grid<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186827[]' id='answer-id-751809' class='answer   answerof-186827 ' value='751809'   \/><label for='answer-id-751809' id='answer-label-751809' class=' answer'><span>Azure Stream Analytics<\/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-186828'>\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 <br \/>\r<br>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_16' value='186828' \/><input type='hidden' id='answerType186828' 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-186828[]' id='answer-id-751810' class='answer   answerof-186828 ' value='751810'   \/><label for='answer-id-751810' id='answer-label-751810' class=' answer'><span>RequestSteps<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186828[]' id='answer-id-751811' class='answer   answerof-186828 ' value='751811'   \/><label for='answer-id-751811' id='answer-label-751811' class=' answer'><span>DmsWorkers<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186828[]' id='answer-id-751812' class='answer   answerof-186828 ' value='751812'   \/><label for='answer-id-751812' id='answer-label-751812' class=' answer'><span>SqlRequests<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186828[]' id='answer-id-751813' class='answer   answerof-186828 ' value='751813'   \/><label for='answer-id-751813' id='answer-label-751813' class=' answer'><span>ExecRequests<\/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-186829'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>17. <\/span>Topic 3, Litware, inc <br \/>\r<br><br \/>\r<br>Overview <br \/>\r<br>General Overview <br \/>\r<br>Litware, Inc. is an international car racing and manufacturing company that has 1,000 employees. Most employees are located in Europe. The company supports racing teams that complete in a worldwide racing series. <br \/>\r<br><br \/>\r<br>Physical Locations <br \/>\r<br>Litware has two main locations: a main office in London, England, and a manufacturing plant in Berlin, Germany. <br \/>\r<br><br \/>\r<br>During each race weekend, 100 engineers set up a remote portable office by using a VPN to connect the datacenter in the London office. The portable office is set up and torn down in approximately 20 different countries each year. <br \/>\r<br><br \/>\r<br>Existing environment <br \/>\r<br>Race Central <br \/>\r<br>During race weekends, Litware uses a primary application named Race Central. Each car has several sensors that send real-time telemetry data to the London datacentre. The data is used for real-time tracking of the cars. <br \/>\r<br><br \/>\r<br>Race Central also sends batch updates to an application named Mechanical Workflow by using Microsoft SQL Server Integration Services (SSIS). <br \/>\r<br><br \/>\r<br>The telemetry data is sent to a MongoDB database. A custom application then moves the data to databases in SQL Server 2017. The telemetry data in MongoDB has more than 500 attributes. The application changes the attribute names when the data is moved to SQL Server 2017. <br \/>\r<br><br \/>\r<br>The database structure contains both OLAP and OLTP databases. <br \/>\r<br><br \/>\r<br>Mechanical Workflow <br \/>\r<br>Mechanical Workflow is used to track changes and improvements made to the cars during their lifetime. <br \/>\r<br>Currently, Mechanical Workflow runs on SQL Server 2017 as an OLAP system. <br \/>\r<br>Mechanical Workflow has a table named Table1 that is 1 TB. Large aggregations are performed on a single column of Table1. <br \/>\r<br><br \/>\r<br>Requirements <br \/>\r<br>Planned Changes <br \/>\r<br>Litware is in the process of rearchitecting its data estate to be hosted in Azure. The company plans to decommission the London datacentre and move all its applications to an Azure datacenter. <br \/>\r<br><br \/>\r<br>Technical Requirements <br \/>\r<br>Litware identifies the following technical requirements: <br \/>\r<br>- Data collection for Race Central must be moved to Azure Cosmos DB and Azure SQL Database. The data must be written to the Azure datacenter closest to each race and must converge in the least amount of time. <br \/>\r<br>- The query performance of Race Central must be stable, and the administrative time it takes to perform optimizations must be minimized. <br \/>\r<br>- The database for Mechanical Workflow must be moved to Azure SQL Data Warehouse. <br \/>\r<br>- Transparent data encryption (TDE) must be enabled on all data stores, whenever possible. <br \/>\r<br>- An Azure Data Factory pipeline must be used to move data from Cosmos DB to SQL Database for Race Central. If the data load takes longer than 20 minutes, configuration changes must be made to Data Factory. <br \/>\r<br>- The telemetry data must migrate toward a solution that is native to Azure. <br \/>\r<br>- The telemetry data must be monitored for performance issues. You must adjust the Cosmos DB Request Units per second (RU\/s) to maintain a performance SLA while minimizing the cost of the RU\/s. <br \/>\r<br><br \/>\r<br>Data Masking Requirements <br \/>\r<br>During race weekends, visitors will be able to enter the remote portable offices. Litware is concerned that some proprietary information might be exposed. <br \/>\r<br>The company identifies the following data masking requirements for the Race Central data that will be stored in SQL Database: <br \/>\r<br>- Only show the last four digits of the values in a column named SuspensionSprings. <br \/>\r<br>- Only show a zero value for the values in a column named ShockOilWeight. <br \/>\r<br><br \/>\r<br>HOTSPOT <br \/>\r<br>Which masking functions should you implement for each column to meet the data masking requirements? 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=574 height=352 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image051-4.jpg\" v:shapes=\"_x0000_i1052\"><br><\/div><input type='hidden' name='question_id[]' id='qID_17' value='186829' \/><input type='hidden' id='answerType186829' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186829[]' id='textarea_q_186829' 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-18' style=';'><div id='questionWrap-18'  class='   watupro-question-id-186830'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>18. <\/span>What should you implement to optimize SQL Database for Race Central to meet the technical requirements?<\/div><input type='hidden' name='question_id[]' id='qID_18' value='186830' \/><input type='hidden' id='answerType186830' 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-186830[]' id='answer-id-751815' class='answer   answerof-186830 ' value='751815'   \/><label for='answer-id-751815' id='answer-label-751815' class=' answer'><span>the sp_update stored procedure<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186830[]' id='answer-id-751816' class='answer   answerof-186830 ' value='751816'   \/><label for='answer-id-751816' id='answer-label-751816' class=' answer'><span>automatic tuning<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186830[]' id='answer-id-751817' class='answer   answerof-186830 ' value='751817'   \/><label for='answer-id-751817' id='answer-label-751817' class=' answer'><span>Query Store<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186830[]' id='answer-id-751818' class='answer   answerof-186830 ' value='751818'   \/><label for='answer-id-751818' id='answer-label-751818' class=' answer'><span>the dbcc checkdb command<\/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-186831'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>19. <\/span>HOTSPOT <br \/>\r<br>Which masking functions should you implement for each column to meet the data masking requirements? 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=430 height=331 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image055-4.jpg\" v:shapes=\"_x0000_i1054\"><br><\/div><input type='hidden' name='question_id[]' id='qID_19' value='186831' \/><input type='hidden' id='answerType186831' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186831[]' id='textarea_q_186831' 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-20' style=';'><div id='questionWrap-20'  class='   watupro-question-id-186832'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>20. <\/span>HOTSPOT <br \/>\r<br>You need to build a solution to collect the telemetry data for Race Control. <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\" width=579 height=348 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image059-4.jpg\" v:shapes=\"_x0000_i1056\"><br><\/div><input type='hidden' name='question_id[]' id='qID_20' value='186832' \/><input type='hidden' id='answerType186832' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186832[]' id='textarea_q_186832' 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-21' style=';'><div id='questionWrap-21'  class='   watupro-question-id-186833'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>21. <\/span>HOTSPOT <br \/>\r<br>You are building the data store solution for Mechanical Workflow. <br \/>\r<br>How should you configure Table1? 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=463 height=300 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image063-4.jpg\" v:shapes=\"_x0000_i1058\"><br><\/div><input type='hidden' name='question_id[]' id='qID_21' value='186833' \/><input type='hidden' id='answerType186833' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186833[]' id='textarea_q_186833' 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-22' style=';'><div id='questionWrap-22'  class='   watupro-question-id-186834'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>22. <\/span>On which data store you configure TDE to meet the technical requirements?<\/div><input type='hidden' name='question_id[]' id='qID_22' value='186834' \/><input type='hidden' id='answerType186834' 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-186834[]' id='answer-id-751822' class='answer   answerof-186834 ' value='751822'   \/><label for='answer-id-751822' id='answer-label-751822' class=' answer'><span>Cosmos DB<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186834[]' id='answer-id-751823' class='answer   answerof-186834 ' value='751823'   \/><label for='answer-id-751823' id='answer-label-751823' class=' answer'><span>SQL Data Warehouse<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186834[]' id='answer-id-751824' class='answer   answerof-186834 ' value='751824'   \/><label for='answer-id-751824' id='answer-label-751824' class=' answer'><span>SQL Database<\/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-186835'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>23. <\/span>What should you include in the Data Factory pipeline for Race Central?<\/div><input type='hidden' name='question_id[]' id='qID_23' value='186835' \/><input type='hidden' id='answerType186835' 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-186835[]' id='answer-id-751825' class='answer   answerof-186835 ' value='751825'   \/><label for='answer-id-751825' id='answer-label-751825' class=' answer'><span>a copy activity that uses a stored procedure as a source<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186835[]' id='answer-id-751826' class='answer   answerof-186835 ' value='751826'   \/><label for='answer-id-751826' id='answer-label-751826' class=' answer'><span>a copy activity that contains schema mappings<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186835[]' id='answer-id-751827' class='answer   answerof-186835 ' value='751827'   \/><label for='answer-id-751827' id='answer-label-751827' class=' answer'><span>a delete activity that has logging enabled<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186835[]' id='answer-id-751828' class='answer   answerof-186835 ' value='751828'   \/><label for='answer-id-751828' id='answer-label-751828' class=' answer'><span>a filter activity that has a condition<\/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-186836'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>24. <\/span>You are monitoring the Data Factory pipeline that runs from Cosmos DB to SQL Database for Race Central. <br \/>\r<br>You discover that the job takes 45 minutes to run. <br \/>\r<br>What should you do to improve the performance of the job?<\/div><input type='hidden' name='question_id[]' id='qID_24' value='186836' \/><input type='hidden' id='answerType186836' 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-186836[]' id='answer-id-751829' class='answer   answerof-186836 ' value='751829'   \/><label for='answer-id-751829' id='answer-label-751829' class=' answer'><span>Decrease parallelism for the copy activities.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186836[]' id='answer-id-751830' class='answer   answerof-186836 ' value='751830'   \/><label for='answer-id-751830' id='answer-label-751830' class=' answer'><span>Increase that data integration units.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186836[]' id='answer-id-751831' class='answer   answerof-186836 ' value='751831'   \/><label for='answer-id-751831' id='answer-label-751831' class=' answer'><span>Configure the copy activities to use staged copy.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186836[]' id='answer-id-751832' class='answer   answerof-186836 ' value='751832'   \/><label for='answer-id-751832' id='answer-label-751832' class=' answer'><span>Configure the copy activities to perform compression.<\/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-186837'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>25. <\/span>Which two metrics should you use to identify the appropriate RU\/s for the telemetry data? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_25' value='186837' \/><input type='hidden' id='answerType186837' 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-186837[]' id='answer-id-751833' class='answer   answerof-186837 ' value='751833'   \/><label for='answer-id-751833' id='answer-label-751833' class=' answer'><span>Number of requests<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186837[]' id='answer-id-751834' class='answer   answerof-186837 ' value='751834'   \/><label for='answer-id-751834' id='answer-label-751834' class=' answer'><span>Number of requests exceeded capacity<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186837[]' id='answer-id-751835' class='answer   answerof-186837 ' value='751835'   \/><label for='answer-id-751835' id='answer-label-751835' class=' answer'><span>End to end observed read latency at the 99th percentile<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186837[]' id='answer-id-751836' class='answer   answerof-186837 ' value='751836'   \/><label for='answer-id-751836' id='answer-label-751836' class=' answer'><span>Session consistency<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186837[]' id='answer-id-751837' class='answer   answerof-186837 ' value='751837'   \/><label for='answer-id-751837' id='answer-label-751837' class=' answer'><span>Data + Index storage consumed<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186837[]' id='answer-id-751838' class='answer   answerof-186837 ' value='751838'   \/><label for='answer-id-751838' id='answer-label-751838' class=' answer'><span>Avg Troughput\/s<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-26' style=';'><div id='questionWrap-26'  class='   watupro-question-id-186838'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>26. <\/span>Topic 4, ADatum Corporation <br \/>\r<br><br \/>\r<br>Case study <br \/>\r<br>Overview <br \/>\r<br>ADatum Corporation is a retailer that sells products through two sales channels: retail stores and a website. <br \/>\r<br><br \/>\r<br>Existing Environment <br \/>\r<br>ADatum has one database server that has Microsoft SQL Server 2016 installed. The server hosts three mission-critical databases named SALESDB, DOCDB, and REPORTINGDB. <br \/>\r<br><br \/>\r<br>SALESDB collects data from the stored and the website. <br \/>\r<br><br \/>\r<br>DOCDB stored documents that connect to the sales data in SALESDB. The documents are stored in two different JSON formats based on the sales channel. <br \/>\r<br><br \/>\r<br>REPORTINGDB stores reporting data and contains server columnstore indexes. A daily process creates reporting data in REPORTINGDB from the data in SALESDB. The process is implemented as a SQL Server Integration Services (SSIS) package that runs a stored procedure from SALESDB. <br \/>\r<br><br \/>\r<br>Requirements <br \/>\r<br>Planned Changes <br \/>\r<br>ADatum plans to move the current data infrastructure to Azure. <br \/>\r<br>The new infrastructure has the following requirements: <br \/>\r<br>- Migrate SALESDB and REPORTINGDB to an Azure SQL database. <br \/>\r<br>- Migrate DOCDB to Azure Cosmos DB. <br \/>\r<br>- The sales data including the documents in JSON format, must be gathered as it arrives and analyzed online by using Azure Stream Analytics. The analytic process will perform aggregations that must be done continuously, without gaps, and without overlapping. <br \/>\r<br>- As they arrive, all the sales documents in JSON format must be transformed into one consistent format. <br \/>\r<br>- Azure Data Factory will replace the SSIS process of copying the data from SALESDB to REPORTINGDB. <br \/>\r<br><br \/>\r<br>Technical Requirements <br \/>\r<br>The new Azure data infrastructure must meet the following technical requirements: <br \/>\r<br>- Data in SALESDB must encrypted by using Transparent Data Encryption (TDE). The encryption must use your own key. <br \/>\r<br>- SALESDB must be restorable to any given minute within the past three weeks. <br \/>\r<br>- Real-time processing must be monitored to ensure that workloads are sized properly based on actual usage patterns. <br \/>\r<br>- Missing indexes must be created automatically for REPORTINGDB. <br \/>\r<br>- Disk IO, CPU, and memory usage must be monitored for SALESDB. <br \/>\r<br><br \/>\r<br>You need to implement event processing by using Stream Analytics to produce consistent JSON documents. <br \/>\r<br>Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_26' value='186838' \/><input type='hidden' id='answerType186838' 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-186838[]' id='answer-id-751839' class='answer   answerof-186838 ' value='751839'   \/><label for='answer-id-751839' id='answer-label-751839' class=' answer'><span>Define an output to Cosmos D<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186838[]' id='answer-id-751840' class='answer   answerof-186838 ' value='751840'   \/><label for='answer-id-751840' id='answer-label-751840' class=' answer'><span>Define a query that contains a JavaScript user-defined aggregates (UDA) function.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186838[]' id='answer-id-751841' class='answer   answerof-186838 ' value='751841'   \/><label for='answer-id-751841' id='answer-label-751841' class=' answer'><span>Define a reference input.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186838[]' id='answer-id-751842' class='answer   answerof-186838 ' value='751842'   \/><label for='answer-id-751842' id='answer-label-751842' class=' answer'><span>Define a transformation query.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186838[]' id='answer-id-751843' class='answer   answerof-186838 ' value='751843'   \/><label for='answer-id-751843' id='answer-label-751843' class=' answer'><span>Define an output to Azure Data Lake Storage Gen2.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186838[]' id='answer-id-751844' class='answer   answerof-186838 ' value='751844'   \/><label for='answer-id-751844' id='answer-label-751844' class=' answer'><span>Define a stream input.<\/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-186839'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>27. <\/span>DRAG DROP <br \/>\r<br>You need to replace the SSIS process by using Data Factory. <br \/>\r<br>Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. <br \/>\r<br><br><img decoding=\"async\" width=650 height=288 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image067-3.jpg\" v:shapes=\"_x0000_i1060\"><br><\/div><input type='hidden' name='question_id[]' id='qID_27' value='186839' \/><input type='hidden' id='answerType186839' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186839[]' id='textarea_q_186839' 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-28' style=';'><div id='questionWrap-28'  class='   watupro-question-id-186840'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>28. <\/span>DRAG DROP <br \/>\r<br>You need to implement the encryption for SALESDB. <br \/>\r<br>Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. <br \/>\r<br><br><img decoding=\"async\" width=649 height=348 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image071-3.jpg\" v:shapes=\"_x0000_i1062\"><br><\/div><input type='hidden' name='question_id[]' id='qID_28' value='186840' \/><input type='hidden' id='answerType186840' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186840[]' id='textarea_q_186840' 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-29' style=';'><div id='questionWrap-29'  class='   watupro-question-id-186841'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>29. <\/span>Which windowing function should you use to perform the streaming aggregation of the sales data?<\/div><input type='hidden' name='question_id[]' id='qID_29' value='186841' \/><input type='hidden' id='answerType186841' 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-186841[]' id='answer-id-751847' class='answer   answerof-186841 ' value='751847'   \/><label for='answer-id-751847' id='answer-label-751847' class=' answer'><span>Tumbling<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186841[]' id='answer-id-751848' class='answer   answerof-186841 ' value='751848'   \/><label for='answer-id-751848' id='answer-label-751848' class=' answer'><span>Hopping<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186841[]' id='answer-id-751849' class='answer   answerof-186841 ' value='751849'   \/><label for='answer-id-751849' id='answer-label-751849' class=' answer'><span>Sliding<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186841[]' id='answer-id-751850' class='answer   answerof-186841 ' value='751850'   \/><label for='answer-id-751850' id='answer-label-751850' class=' answer'><span>Session<\/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-186842'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>30. <\/span>How should you monitor SALESDB to meet the technical requirements?<\/div><input type='hidden' name='question_id[]' id='qID_30' value='186842' \/><input type='hidden' id='answerType186842' 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-186842[]' id='answer-id-751851' class='answer   answerof-186842 ' value='751851'   \/><label for='answer-id-751851' id='answer-label-751851' class=' answer'><span>Query the sys.resource_stats dynamic management view.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186842[]' id='answer-id-751852' class='answer   answerof-186842 ' value='751852'   \/><label for='answer-id-751852' id='answer-label-751852' class=' answer'><span>Review the Query Performance Insights for SALESD<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186842[]' id='answer-id-751853' class='answer   answerof-186842 ' value='751853'   \/><label for='answer-id-751853' id='answer-label-751853' class=' answer'><span>Query the sys.dm_os_wait_stats dynamic management view.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186842[]' id='answer-id-751854' class='answer   answerof-186842 ' value='751854'   \/><label for='answer-id-751854' id='answer-label-751854' class=' answer'><span>Review the auditing information of SALESD<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-31' style=';'><div id='questionWrap-31'  class='   watupro-question-id-186843'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>31. <\/span>Which counter should you monitor for real-time processing to meet the technical requirements?<\/div><input type='hidden' name='question_id[]' id='qID_31' value='186843' \/><input type='hidden' id='answerType186843' 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-186843[]' id='answer-id-751855' class='answer   answerof-186843 ' value='751855'   \/><label for='answer-id-751855' id='answer-label-751855' class=' answer'><span>Concurrent users<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186843[]' id='answer-id-751856' class='answer   answerof-186843 ' value='751856'   \/><label for='answer-id-751856' id='answer-label-751856' class=' answer'><span>SU% Utilization<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186843[]' id='answer-id-751857' class='answer   answerof-186843 ' value='751857'   \/><label for='answer-id-751857' id='answer-label-751857' class=' answer'><span>Data Conversion Errors<\/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-186844'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>32. <\/span>You need to implement event processing by using Stream Analytics to produce consistent JSON documents. <br \/>\r<br>Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. <br \/>\r<br>You need to ensure that the missing indexes for REPORTINGDB are added. <br \/>\r<br>What should you use?<\/div><input type='hidden' name='question_id[]' id='qID_32' value='186844' \/><input type='hidden' id='answerType186844' 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-186844[]' id='answer-id-751858' class='answer   answerof-186844 ' value='751858'   \/><label for='answer-id-751858' id='answer-label-751858' class=' answer'><span>SQL Database Advisor<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186844[]' id='answer-id-751859' class='answer   answerof-186844 ' value='751859'   \/><label for='answer-id-751859' id='answer-label-751859' class=' answer'><span>extended events<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186844[]' id='answer-id-751860' class='answer   answerof-186844 ' value='751860'   \/><label for='answer-id-751860' id='answer-label-751860' class=' answer'><span>Query Performance Insight<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186844[]' id='answer-id-751861' class='answer   answerof-186844 ' value='751861'   \/><label for='answer-id-751861' id='answer-label-751861' class=' answer'><span>automatic tuning<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-33' style=';'><div id='questionWrap-33'  class='   watupro-question-id-186845'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>33. <\/span>You need to configure a disaster recovery solution for SALESDB to meet the technical requirements. <br \/>\r<br>What should you configure in the backup policy?<\/div><input type='hidden' name='question_id[]' id='qID_33' value='186845' \/><input type='hidden' id='answerType186845' 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-186845[]' id='answer-id-751862' class='answer   answerof-186845 ' value='751862'   \/><label for='answer-id-751862' id='answer-label-751862' class=' answer'><span>weekly long-term retention backups that are retained for three weeks<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186845[]' id='answer-id-751863' class='answer   answerof-186845 ' value='751863'   \/><label for='answer-id-751863' id='answer-label-751863' class=' answer'><span>failover groups<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186845[]' id='answer-id-751864' class='answer   answerof-186845 ' value='751864'   \/><label for='answer-id-751864' id='answer-label-751864' class=' answer'><span>a point-in-time restore<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186845[]' id='answer-id-751865' class='answer   answerof-186845 ' value='751865'   \/><label for='answer-id-751865' id='answer-label-751865' class=' answer'><span>geo-replication<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-34' style=';'><div id='questionWrap-34'  class='   watupro-question-id-186846'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>34. <\/span>Topic 5, Misc Questions <br \/>\r<br><br \/>\r<br>CORRECT TEXT <br \/>\r<br>Use the following login credentials as needed: <br \/>\r<br>Azure Username: xxxxx <br \/>\r<br>Azure Password: xxxxx <br \/>\r<br>The following information is for technical support purposes only: <br \/>\r<br>Lab Instance: 10543936 <br \/>\r<br><br><img decoding=\"async\" width=580 height=554 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image074-6.jpg\" v:shapes=\"_x0000_i1064\"><br><br \/>\r<br>You need to double the available processing resources available to an Azure SQL data warehouse named datawarehouse. <br \/>\r<br>To complete this task, sign in to the Azure portal. NOTE: This task might take several minutes to complete. You can perform other tasks while the task completes or end this section of the exam.<\/div><input type='hidden' name='question_id[]' id='qID_34' value='186846' \/><input type='hidden' id='answerType186846' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186846[]' id='textarea_q_186846' 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-35' style=';'><div id='questionWrap-35'  class='   watupro-question-id-186847'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>35. <\/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 scenario, 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 have a container named Sales in an Azure Cosmos DB database. Sales has 120 GB of data. Each entry in Sales has the following structure. <br \/>\r<br><br><img decoding=\"async\" width=373 height=135 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image080-3.jpg\" v:shapes=\"_x0000_i1068\"><br><br \/>\r<br>The partition key is set to the OrderId attribute. <br \/>\r<br>Users report that when they perform queries that retrieve data by ProductName, the queries take longer than expected to complete. <br \/>\r<br>You need to reduce the amount of time it takes to execute the problematic queries. <br \/>\r<br>Solution: You create a lookup collection that uses ProductName as a partition key. <br \/>\r<br>Does this meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_35' value='186847' \/><input type='hidden' id='answerType186847' 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-186847[]' id='answer-id-751867' class='answer   answerof-186847 ' value='751867'   \/><label for='answer-id-751867' id='answer-label-751867' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186847[]' id='answer-id-751868' class='answer   answerof-186847 ' value='751868'   \/><label for='answer-id-751868' id='answer-label-751868' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-36' style=';'><div id='questionWrap-36'  class='   watupro-question-id-186848'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>36. <\/span>You have an Azure Stream Analytics job that receives clickstream data from an Azure event hub. <br \/>\r<br>You need to define a query in the Stream Analytics job. <br \/>\r<br>The query must meet the following requirements: <br \/>\r<br>&#10001; Count the number of clicks within each 10-second window based on the country of a visitor. <br \/>\r<br>&#10001; Ensure that each click is NOT counted more than once. <br \/>\r<br>How should you define the query?<\/div><input type='hidden' name='question_id[]' id='qID_36' value='186848' \/><input type='hidden' id='answerType186848' 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-186848[]' id='answer-id-751869' class='answer   answerof-186848 ' value='751869'   \/><label for='answer-id-751869' id='answer-label-751869' class=' answer'><span>SELECT Country, Count(*) AS Count FROM ClickStream TIMESTAMP BY CreatedAt GROUP BY Country, TumblingWindow(second, 10)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186848[]' id='answer-id-751870' class='answer   answerof-186848 ' value='751870'   \/><label for='answer-id-751870' id='answer-label-751870' class=' answer'><span>SELECT Country, Count(*) AS Count FROM ClickStream TIMESTAMP BY CreatedAt GROUP BY Country, SessionWindow(second, 5, 10)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186848[]' id='answer-id-751871' class='answer   answerof-186848 ' value='751871'   \/><label for='answer-id-751871' id='answer-label-751871' class=' answer'><span>SELECT Country, Avg(*) AS Average FROM ClickStream TIMESTAMP BY CreatedAt GROUP BY Country, SlidingWindow(second, 10)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186848[]' id='answer-id-751872' class='answer   answerof-186848 ' value='751872'   \/><label for='answer-id-751872' id='answer-label-751872' class=' answer'><span>SELECT Country, Avg(*) AS Average FROM ClickStream TIMESTAMP BY CreatedAt GROUP BY Country, HoppingWindow(second, 10, 2)<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-37' style=';'><div id='questionWrap-37'  class='   watupro-question-id-186849'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>37. <\/span>You have an Azure Cosmos DB database that uses the SQL API. <br \/>\r<br>You need to delete stale data from the database automatically. <br \/>\r<br>What should you use?<\/div><input type='hidden' name='question_id[]' id='qID_37' value='186849' \/><input type='hidden' id='answerType186849' 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-186849[]' id='answer-id-751873' class='answer   answerof-186849 ' value='751873'   \/><label for='answer-id-751873' id='answer-label-751873' class=' answer'><span>soft delete<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186849[]' id='answer-id-751874' class='answer   answerof-186849 ' value='751874'   \/><label for='answer-id-751874' id='answer-label-751874' class=' answer'><span>Low Latency Analytical Processing (LLAP)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186849[]' id='answer-id-751875' class='answer   answerof-186849 ' value='751875'   \/><label for='answer-id-751875' id='answer-label-751875' class=' answer'><span>schema on read<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186849[]' id='answer-id-751876' class='answer   answerof-186849 ' value='751876'   \/><label for='answer-id-751876' id='answer-label-751876' class=' answer'><span>Time to Live (TTL)<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-38' style=';'><div id='questionWrap-38'  class='   watupro-question-id-186850'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>38. <\/span>You need to develop a pipeline for processing data. <br \/>\r<br>The pipeline must meet the following requirements. <br \/>\r<br>&#8226; Scale up and down resources for cost reduction. <br \/>\r<br>&#8226; Use an in-memory data processing engine to speed up ETL and machine learning operations. <br \/>\r<br>&#8226; Use streaming capabilities. <br \/>\r<br>&#8226; Provide the ability to code in SQL, Python, Scala, and R. <br \/>\r<br>&#8226; Integrate workspace collaboration with Git. <br \/>\r<br>What should you use?<\/div><input type='hidden' name='question_id[]' id='qID_38' value='186850' \/><input type='hidden' id='answerType186850' 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-186850[]' id='answer-id-751877' class='answer   answerof-186850 ' value='751877'   \/><label for='answer-id-751877' id='answer-label-751877' class=' answer'><span>HDInsight Spark Cluster<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186850[]' id='answer-id-751878' class='answer   answerof-186850 ' value='751878'   \/><label for='answer-id-751878' id='answer-label-751878' class=' answer'><span>Azure Stream Analytics<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186850[]' id='answer-id-751879' class='answer   answerof-186850 ' value='751879'   \/><label for='answer-id-751879' id='answer-label-751879' class=' answer'><span>HDInsight Hadoop Cluster<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186850[]' id='answer-id-751880' class='answer   answerof-186850 ' value='751880'   \/><label for='answer-id-751880' id='answer-label-751880' class=' answer'><span>Azure SQL Data Warehouse<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-39' style=';'><div id='questionWrap-39'  class='   watupro-question-id-186851'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>39. <\/span>You develop data engineering solutions for a company. The company has on-premises Microsoft SQL Server databases at multiple locations. <br \/>\r<br>The company must integrate data with Microsoft Power BI and Microsoft Azure Logic Apps. <br \/>\r<br>The solution must avoid single points of failure during connection and transfer to the cloud. <br \/>\r<br>The solution must also minimize latency. <br \/>\r<br>You need to secure the transfer of data between on-premises databases and Microsoft Azure. <br \/>\r<br>What should you do?<\/div><input type='hidden' name='question_id[]' id='qID_39' value='186851' \/><input type='hidden' id='answerType186851' 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-186851[]' id='answer-id-751881' class='answer   answerof-186851 ' value='751881'   \/><label for='answer-id-751881' id='answer-label-751881' class=' answer'><span>Install a standalone on-premises Azure data gateway at each location<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186851[]' id='answer-id-751882' class='answer   answerof-186851 ' value='751882'   \/><label for='answer-id-751882' id='answer-label-751882' class=' answer'><span>Install an on-premises data gateway in personal mode at each location<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186851[]' id='answer-id-751883' class='answer   answerof-186851 ' value='751883'   \/><label for='answer-id-751883' id='answer-label-751883' class=' answer'><span>Install an Azure on-premises data gateway at the primary location<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186851[]' id='answer-id-751884' class='answer   answerof-186851 ' value='751884'   \/><label for='answer-id-751884' id='answer-label-751884' class=' answer'><span>Install an Azure on-premises data gateway as a cluster at each location<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-40' style=';'><div id='questionWrap-40'  class='   watupro-question-id-186852'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>40. <\/span>DRAG DROP <br \/>\r<br>You plan to create a new single database instance of Microsoft Azure SQL Database. <br \/>\r<br>The database must only allow communication from the data engineer\u2019s workstation. You must connect directly to the instance by using Microsoft SQL Server Management Studio. <br \/>\r<br>You need to create and configure the Database. <br \/>\r<br>Which three Azure PowerShell cmdlets should you use to develop the solution? To answer, move the appropriate cmdlets from the list of cmdlets to the answer area and arrange them in the correct order. <br \/>\r<br><br><img decoding=\"async\" width=650 height=304 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image082-3.jpg\" v:shapes=\"_x0000_i1069\"><br><\/div><input type='hidden' name='question_id[]' id='qID_40' value='186852' \/><input type='hidden' id='answerType186852' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186852[]' id='textarea_q_186852' 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-41' style=';'><div id='questionWrap-41'  class='   watupro-question-id-186853'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>41. <\/span>DRAG DROP <br \/>\r<br>You need to create an Azure Cosmos DB account that will use encryption keys managed by your organization. <br \/>\r<br>Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select. <br \/>\r<br><br><img decoding=\"async\" width=650 height=389 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image086-3.jpg\" v:shapes=\"_x0000_i1071\"><br><\/div><input type='hidden' name='question_id[]' id='qID_41' value='186853' \/><input type='hidden' id='answerType186853' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186853[]' id='textarea_q_186853' 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-42' style=';'><div id='questionWrap-42'  class='   watupro-question-id-186854'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>42. <\/span>You have an Azure subscription that contains an Azure Data Factory version 2 (V2) data factory named df1. Df1 contains a linked service. <br \/>\r<br>You have an Azure Key vault named vault1 that contains an encryption key named key1. <br \/>\r<br>You need to encrypt df1 by using key1. <br \/>\r<br>What should you do first?<\/div><input type='hidden' name='question_id[]' id='qID_42' value='186854' \/><input type='hidden' id='answerType186854' 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-186854[]' id='answer-id-751887' class='answer   answerof-186854 ' value='751887'   \/><label for='answer-id-751887' id='answer-label-751887' class=' answer'><span>Disable purge protection on vault1.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186854[]' id='answer-id-751888' class='answer   answerof-186854 ' value='751888'   \/><label for='answer-id-751888' id='answer-label-751888' class=' answer'><span>Create a self-hosted integration runtime.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186854[]' id='answer-id-751889' class='answer   answerof-186854 ' value='751889'   \/><label for='answer-id-751889' id='answer-label-751889' class=' answer'><span>Disable soft delete on vault1.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186854[]' id='answer-id-751890' class='answer   answerof-186854 ' value='751890'   \/><label for='answer-id-751890' id='answer-label-751890' class=' answer'><span>Remove the linked service from df1.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-43' style=';'><div id='questionWrap-43'  class='   watupro-question-id-186855'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>43. <\/span>HOTSPOT <br \/>\r<br>A company plans to analyze a continuous flow of data from a social media platform by using Microsoft Azure Stream Analytics. The incoming data is formatted as one record per row. <br \/>\r<br>You need to create the input stream. <br \/>\r<br>How should you complete the REST API segment? To answer, select the appropriate configuration in the answer area. NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=553 height=700 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image090-2.jpg\" v:shapes=\"_x0000_i1073\"><br><\/div><input type='hidden' name='question_id[]' id='qID_43' value='186855' \/><input type='hidden' id='answerType186855' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186855[]' id='textarea_q_186855' 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-44' style=';'><div id='questionWrap-44'  class='   watupro-question-id-186856'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>44. <\/span>You manage an enterprise data warehouse in Azure Synapse Analytics. <br \/>\r<br>Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries. <br \/>\r<br>You need to monitor resource utilization to determine the source of the performance issues. <br \/>\r<br>Which metric should you monitor?<\/div><input type='hidden' name='question_id[]' id='qID_44' value='186856' \/><input type='hidden' id='answerType186856' 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-186856[]' id='answer-id-751892' class='answer   answerof-186856 ' value='751892'   \/><label for='answer-id-751892' id='answer-label-751892' class=' answer'><span>Data Warehouse Units (DWU) used<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186856[]' id='answer-id-751893' class='answer   answerof-186856 ' value='751893'   \/><label for='answer-id-751893' id='answer-label-751893' class=' answer'><span>DWU limit<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186856[]' id='answer-id-751894' class='answer   answerof-186856 ' value='751894'   \/><label for='answer-id-751894' id='answer-label-751894' class=' answer'><span>Cache hit percentage<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186856[]' id='answer-id-751895' class='answer   answerof-186856 ' value='751895'   \/><label for='answer-id-751895' id='answer-label-751895' class=' answer'><span>Data IO percentage<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-45' style=';'><div id='questionWrap-45'  class='   watupro-question-id-186857'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>45. <\/span>HOTSPOT <br \/>\r<br>You are building an Azure Stream Analytics job that queries reference data from a product catalog file. The file is updated daily. <br \/>\r<br>The reference data input details for the file are shown in the Input exhibit. <br \/>\r<br><br><img decoding=\"async\" width=619 height=766 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image094-3.jpg\" v:shapes=\"_x0000_i1075\"><br><br \/>\r<br>The storage account container view is shown in the Refdata exhibit. <br \/>\r<br><br><img decoding=\"async\" width=622 height=199 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image096-4.jpg\" v:shapes=\"_x0000_i1076\"><br><br \/>\r<br>You need to configure the Stream Analytics job to pick up the new reference data. <br \/>\r<br>What should you configure? 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=421 height=360 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image098-3.jpg\" v:shapes=\"_x0000_i1077\"><br><\/div><input type='hidden' name='question_id[]' id='qID_45' value='186857' \/><input type='hidden' id='answerType186857' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186857[]' id='textarea_q_186857' 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-46' style=';'><div id='questionWrap-46'  class='   watupro-question-id-186858'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>46. <\/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_46' value='186858' \/><input type='hidden' id='answerType186858' 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-186858[]' id='answer-id-751897' class='answer   answerof-186858 ' value='751897'   \/><label for='answer-id-751897' id='answer-label-751897' class=' answer'><span>Azure Automation<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186858[]' id='answer-id-751898' class='answer   answerof-186858 ' value='751898'   \/><label for='answer-id-751898' id='answer-label-751898' class=' answer'><span>Log Analytics<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186858[]' id='answer-id-751899' class='answer   answerof-186858 ' value='751899'   \/><label for='answer-id-751899' id='answer-label-751899' class=' answer'><span>Application Insights<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-47' style=';'><div id='questionWrap-47'  class='   watupro-question-id-186859'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>47. <\/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 have an Azure subscription that contains an Azure Storage account. <br \/>\r<br>You plan to implement changes to a data storage solution to meet regulatory and compliance standards. <br \/>\r<br>Every day, Azure needs to identify and delete blobs that were NOT modified during the last 100 days. <br \/>\r<br>Solution: You schedule an Azure Data Factory pipeline. <br \/>\r<br>Does this meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_47' value='186859' \/><input type='hidden' id='answerType186859' 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-186859[]' id='answer-id-751900' class='answer   answerof-186859 ' value='751900'   \/><label for='answer-id-751900' id='answer-label-751900' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186859[]' id='answer-id-751901' class='answer   answerof-186859 ' value='751901'   \/><label for='answer-id-751901' id='answer-label-751901' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-48' style=';'><div id='questionWrap-48'  class='   watupro-question-id-186860'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>48. <\/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 scenario, 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 plan to create an Azure Databricks workspace that has a tiered structure. <br \/>\r<br>The workspace will contain the following three workloads: <br \/>\r<br>&#10001; A workload for data engineers who will use Python and SQL <br \/>\r<br>&#10001; A workload for jobs that will run notebooks that use Python, Spark, Scala, and SQL <br \/>\r<br>&#10001; A workload that data scientists will use to perform ad hoc analysis in Scala and R <br \/>\r<br>The enterprise architecture team at your company identifies the following standards for Databricks environments: <br \/>\r<br>&#10001; The data engineers must share a cluster. <br \/>\r<br>&#10001; The job cluster will be managed by using a request process whereby data scientists and data engineers provide packaged notebooks for deployment to the cluster. <br \/>\r<br>&#10001; All the data scientists must be assigned their own cluster that terminates automatically after 120 minutes of inactivity. Currently, there are three data scientists. <br \/>\r<br>You need to create the Databrick clusters for the workloads. <br \/>\r<br>Solution: You create a Standard cluster for each data scientist, a High Concurrency cluster for the data engineers, and a Standard cluster for the jobs. <br \/>\r<br>Does this meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_48' value='186860' \/><input type='hidden' id='answerType186860' 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-186860[]' id='answer-id-751902' class='answer   answerof-186860 ' value='751902'   \/><label for='answer-id-751902' id='answer-label-751902' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186860[]' id='answer-id-751903' class='answer   answerof-186860 ' value='751903'   \/><label for='answer-id-751903' id='answer-label-751903' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-49' style=';'><div id='questionWrap-49'  class='   watupro-question-id-186861'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>49. <\/span>HOTSPOT <br \/>\r<br>You have an Azure data factory that has two pipelines named PipelineA and PipelineB. <br \/>\r<br>PipelineA has four activities as shown in the following exhibit. <br \/>\r<br><br><img decoding=\"async\" width=638 height=58 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image102-3.jpg\" v:shapes=\"_x0000_i1079\"><br><br \/>\r<br>PipelineB has two activities as shown in the following exhibit. <br \/>\r<br><br><img decoding=\"async\" width=306 height=58 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image104-3.jpg\" v:shapes=\"_x0000_i1080\"><br><br \/>\r<br>You create an alert for the data factory that uses Failed pipeline runs metrics for both pipelines and all failure types. <br \/>\r<br>The metric has the following settings: <br \/>\r<br>&#10001; Operator: Greater than <br \/>\r<br>&#10001; Aggregation type: Total <br \/>\r<br>&#10001; Threshold value: 2 <br \/>\r<br>&#10001; Aggregation granularity (Period): 5 minutes <br \/>\r<br>&#10001; Frequency of evaluation: Every 5 minutes <br \/>\r<br>Data Factory monitoring records the failures shown in the following table. <br \/>\r<br><br><img decoding=\"async\" width=642 height=129 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image106-3.jpg\" v:shapes=\"_x0000_i1081\"><br><br \/>\r<br>For each of the following statements, select yes if the statement is true. Otherwise, select no. NOTE: Each correct answer selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=650 height=116 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image108-2.jpg\" v:shapes=\"_x0000_i1082\"><br><\/div><input type='hidden' name='question_id[]' id='qID_49' value='186861' \/><input type='hidden' id='answerType186861' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186861[]' id='textarea_q_186861' 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-50' style=';'><div id='questionWrap-50'  class='   watupro-question-id-186862'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>50. <\/span>DRAG DROP <br \/>\r<br>You develop data engineering solutions for a company. <br \/>\r<br>You need to deploy a Microsoft Azure Stream Analytics job for an IoT solution. <br \/>\r<br>The solution must: <br \/>\r<br>&#8226; Minimize latency. <br \/>\r<br>&#8226; Minimize bandwidth usage between the job and IoT device. <br \/>\r<br>Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. <br \/>\r<br><br><img decoding=\"async\" width=642 height=401 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image112-2.jpg\" v:shapes=\"_x0000_i1084\"><br><\/div><input type='hidden' name='question_id[]' id='qID_50' value='186862' \/><input type='hidden' id='answerType186862' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186862[]' id='textarea_q_186862' 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-51' style=';'><div id='questionWrap-51'  class='   watupro-question-id-186863'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>51. <\/span>You are designing an enterprise data warehouse in Azure Synapse Analytics. You plan to load millions of rows of data into the data warehouse each day. <br \/>\r<br>You must ensure that staging tables are optimized for data loading. <br \/>\r<br>You need to design the staging tables. <br \/>\r<br>What type of tables should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_51' value='186863' \/><input type='hidden' id='answerType186863' 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-186863[]' id='answer-id-751906' class='answer   answerof-186863 ' value='751906'   \/><label for='answer-id-751906' id='answer-label-751906' class=' answer'><span>Round-robin distributed table<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-186863[]' id='answer-id-751907' class='answer   answerof-186863 ' value='751907'   \/><label for='answer-id-751907' id='answer-label-751907' class=' answer'><span>Hash-distributed table<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-186863[]' id='answer-id-751908' class='answer   answerof-186863 ' value='751908'   \/><label for='answer-id-751908' id='answer-label-751908' class=' answer'><span>Replicated table<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-186863[]' id='answer-id-751909' class='answer   answerof-186863 ' value='751909'   \/><label for='answer-id-751909' id='answer-label-751909' class=' answer'><span>External table<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-52' style=';'><div id='questionWrap-52'  class='   watupro-question-id-186864'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>52. <\/span>HOTSPOT <br \/>\r<br>A company runs Microsoft Dynamics CRM with Microsoft SQL Server on-premises. SQL Server Integration Services (SSIS) packages extract data from Dynamics CRM APIs, and load the data into a SQL Server data warehouse. <br \/>\r<br>The datacenter is running out of capacity. Because of the network configuration, you must extract on premises data to the cloud over https. You cannot open any additional ports. The solution must implement the least amount of effort. <br \/>\r<br>You need to create the pipeline system. <br \/>\r<br>Which component should you use? To answer, select the appropriate technology in the dialog box in the answer area. NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=595 height=262 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image116-2.jpg\" v:shapes=\"_x0000_i1086\"><br><\/div><input type='hidden' name='question_id[]' id='qID_52' value='186864' \/><input type='hidden' id='answerType186864' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186864[]' id='textarea_q_186864' 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-53' style=';'><div id='questionWrap-53'  class='   watupro-question-id-186865'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>53. <\/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_53' value='186865' \/><input type='hidden' id='answerType186865' 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-186865[]' id='answer-id-751911' class='answer   answerof-186865 ' value='751911'   \/><label for='answer-id-751911' id='answer-label-751911' class=' answer'><span>Azure SQL Data Sync<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186865[]' id='answer-id-751912' class='answer   answerof-186865 ' value='751912'   \/><label for='answer-id-751912' id='answer-label-751912' class=' answer'><span>SQL Vulnerability Assessment (VA)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186865[]' id='answer-id-751913' class='answer   answerof-186865 ' value='751913'   \/><label for='answer-id-751913' id='answer-label-751913' class=' answer'><span>SQL Server Migration Assistant (SSMA)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186865[]' id='answer-id-751914' class='answer   answerof-186865 ' value='751914'   \/><label for='answer-id-751914' id='answer-label-751914' class=' answer'><span>Microsoft Assessment and Planning Toolkit<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186865[]' id='answer-id-751915' class='answer   answerof-186865 ' value='751915'   \/><label for='answer-id-751915' id='answer-label-751915' class=' answer'><span>Data Migration Assistant (DMA)<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-54' style=';'><div id='questionWrap-54'  class='   watupro-question-id-186866'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>54. <\/span>CORRECT TEXT <br \/>\r<br>Use the following login credentials as needed: <br \/>\r<br>Azure Username: xxxxx <br \/>\r<br>Azure Password: xxxxx <br \/>\r<br>The following information is for technical support purposes only: <br \/>\r<br>Lab Instance: 10543936 <br \/>\r<br><br><img decoding=\"async\" width=580 height=554 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image120-1.jpg\" v:shapes=\"_x0000_i1088\"><br><br \/>\r<br>You plan to enable Azure Multi-Factor Authentication (MFA). <br \/>\r<br>You need to ensure that User1-10543936@ExamUsers.com can manage any databases hosted on an Azure SQL server named SQL10543936 by signing in using his Azure Active Directory (Azure AD) user account. <br \/>\r<br>To complete this task, sign in to the Azure portal.<\/div><input type='hidden' name='question_id[]' id='qID_54' value='186866' \/><input type='hidden' id='answerType186866' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186866[]' id='textarea_q_186866' 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-55' style=';'><div id='questionWrap-55'  class='   watupro-question-id-186867'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>55. <\/span>HOTSPOT <br \/>\r<br>You have an Azure SQL database that contains a table named Employee. Employee contains sensitive data in a decimal (10,2) column named Salary. <br \/>\r<br>You need to ensure that nonprivileged users can view the table data, but Salary must display a number from 0 to 100. <br \/>\r<br>What should you configure? 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=409 height=307 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image130-2.jpg\" v:shapes=\"_x0000_i1094\"><br><\/div><input type='hidden' name='question_id[]' id='qID_55' value='186867' \/><input type='hidden' id='answerType186867' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186867[]' id='textarea_q_186867' 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-56' style=';'><div id='questionWrap-56'  class='   watupro-question-id-186868'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>56. <\/span>DRAG DROP <br \/>\r<br>You manage security for a database that supports a line of business application. <br \/>\r<br>Private and personal data stored in the database must be protected and encrypted. <br \/>\r<br>You need to configure the database to use Transparent Data Encryption (TDE). <br \/>\r<br>Which five actions should you perform in sequence? To answer, select the appropriate actions from the list of actions to the answer area and arrange them in the correct order. <br \/>\r<br><br><img decoding=\"async\" width=650 height=491 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image136-2.jpg\" v:shapes=\"_x0000_i1097\"><br><\/div><input type='hidden' name='question_id[]' id='qID_56' value='186868' \/><input type='hidden' id='answerType186868' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186868[]' id='textarea_q_186868' 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-57' style=';'><div id='questionWrap-57'  class='   watupro-question-id-186869'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>57. <\/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 scenario, 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 are developing a solution that will use Azure Stream Analytics. The solution will accept an Azure Blob storage file named Customers. The file will contain both in-store and online customer details. The online customers will provide a mailing address. <br \/>\r<br>You have a file in Blob storage named LocationIncomes that contains based on location. <br \/>\r<br>The file rarely changes. <br \/>\r<br>You need to use an address to look up a median income based on location. You must <br \/>\r<br>output the data to Azure SQL Database for immediate use and to Azure Data Lake Storage Gen2 for long-term retention. <br \/>\r<br>Solution: You implement a Stream Analytics job that has one streaming input, one reference input, one query, and two outputs. <br \/>\r<br>Does this meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_57' value='186869' \/><input type='hidden' id='answerType186869' 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-186869[]' id='answer-id-751919' class='answer   answerof-186869 ' value='751919'   \/><label for='answer-id-751919' id='answer-label-751919' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186869[]' id='answer-id-751920' class='answer   answerof-186869 ' value='751920'   \/><label for='answer-id-751920' id='answer-label-751920' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-58' style=';'><div id='questionWrap-58'  class='   watupro-question-id-186870'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>58. <\/span>CORRECT TEXT <br \/>\r<br><br><img decoding=\"async\" width=403 height=412 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image139-2.jpg\" v:shapes=\"_x0000_i1099\"><br><br \/>\r<br>Use the following login credentials as needed: <br \/>\r<br>Azure Username: xxxxx <br \/>\r<br>Azure Password: xxxxx <br \/>\r<br>The following information is for technical support purposes only: <br \/>\r<br>Lab Instance: 10277521 <br \/>\r<br>You need to generate an email notification to admin@contoso.com if the available storage in an Azure Cosmos DB database named cosmos10277521 is less than 100,000,000 bytes. <br \/>\r<br>To complete this task, sign in to the Azure portal.<\/div><input type='hidden' name='question_id[]' id='qID_58' value='186870' \/><input type='hidden' id='answerType186870' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-186870[]' id='textarea_q_186870' 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-59' style=';'><div id='questionWrap-59'  class='   watupro-question-id-186871'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>59. <\/span>You have an Azure Storage account. <br \/>\r<br>You need to configure the storage account to send an email when an administrative action is performed on the account. <br \/>\r<br>What should you do?<\/div><input type='hidden' name='question_id[]' id='qID_59' value='186871' \/><input type='hidden' id='answerType186871' 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-186871[]' id='answer-id-751922' class='answer   answerof-186871 ' value='751922'   \/><label for='answer-id-751922' id='answer-label-751922' class=' answer'><span>Enable Azure Advanced Threat Protection (ATP).<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186871[]' id='answer-id-751923' class='answer   answerof-186871 ' value='751923'   \/><label for='answer-id-751923' id='answer-label-751923' class=' answer'><span>Create an alert based on a metric.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186871[]' id='answer-id-751924' class='answer   answerof-186871 ' value='751924'   \/><label for='answer-id-751924' id='answer-label-751924' class=' answer'><span>Create an alert based on the activity log.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-186871[]' id='answer-id-751925' class='answer   answerof-186871 ' value='751925'   \/><label for='answer-id-751925' id='answer-label-751925' class=' answer'><span>Create a custom role for the storage account.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-60' style=';'><div id='questionWrap-60'  class='   watupro-question-id-186872'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>60. <\/span>You have an Azure subscription that contains the resources shown in the following table. <br \/>\r<br><br><img decoding=\"async\" width=455 height=118 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/07\/image144.jpg\" v:shapes=\"_x0000_i1103\"><br><br \/>\r<br>All the resources have the default encryption settings.<\/div><input type='hidden' name='question_id[]' id='qID_60' value='186872' \/><input type='hidden' id='answerType186872' 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-186872[]' id='answer-id-751926' class='answer   answerof-186872 ' value='751926'   \/><label for='answer-id-751926' id='answer-label-751926' class=' answer'><span>Enable Azure Storage encryption for storageaccount1.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-186872[]' id='answer-id-751927' class='answer   answerof-186872 ' value='751927'   \/><label for='answer-id-751927' id='answer-label-751927' class=' answer'><span>Enable Transparent Data Encryption (TDE) for synapsedb1.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-186872[]' id='answer-id-751928' class='answer   answerof-186872 ' value='751928'   \/><label for='answer-id-751928' id='answer-label-751928' class=' answer'><span>Enable encryption at rest for cosmosdb1.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-186872[]' id='answer-id-751929' class='answer   answerof-186872 ' value='751929'   \/><label for='answer-id-751929' id='answer-label-751929' class=' answer'><span>Enable Azure Storage encryption for storageaccount2.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div style='display:none' id='question-61'>\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=\"watuPROButtons5617\" >\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=\"5617\" id=\"watuPROExamID\"\/>\n\t<input type=\"hidden\" name=\"start_time\" id=\"startTime\" value=\"2026-05-01 03:32:22\" \/>\n\t<input type=\"hidden\" name=\"start_timestamp\" id=\"startTimeStamp\" value=\"1777606342\" \/>\n\t<input type=\"hidden\" name=\"question_ids\" value=\"\" \/>\n\t<input type=\"hidden\" name=\"watupro_questions\" value=\"186813:751777,751778,751779,751780 | 186814:751781 | 186815:751782 | 186816:751783 | 186817:751784 | 186818:751785 | 186819:751786,751787 | 186820:751788,751789,751790,751791 | 186821:751792,751793,751794,751795,751796 | 186822:751797,751798 | 186823:751799 | 186824:751800 | 186825:751801 | 186826:751802,751803 | 186827:751804,751805,751806,751807,751808,751809 | 186828:751810,751811,751812,751813 | 186829:751814 | 186830:751815,751816,751817,751818 | 186831:751819 | 186832:751820 | 186833:751821 | 186834:751822,751823,751824 | 186835:751825,751826,751827,751828 | 186836:751829,751830,751831,751832 | 186837:751833,751834,751835,751836,751837,751838 | 186838:751839,751840,751841,751842,751843,751844 | 186839:751845 | 186840:751846 | 186841:751847,751848,751849,751850 | 186842:751851,751852,751853,751854 | 186843:751855,751856,751857 | 186844:751858,751859,751860,751861 | 186845:751862,751863,751864,751865 | 186846:751866 | 186847:751867,751868 | 186848:751869,751870,751871,751872 | 186849:751873,751874,751875,751876 | 186850:751877,751878,751879,751880 | 186851:751881,751882,751883,751884 | 186852:751885 | 186853:751886 | 186854:751887,751888,751889,751890 | 186855:751891 | 186856:751892,751893,751894,751895 | 186857:751896 | 186858:751897,751898,751899 | 186859:751900,751901 | 186860:751902,751903 | 186861:751904 | 186862:751905 | 186863:751906,751907,751908,751909 | 186864:751910 | 186865:751911,751912,751913,751914,751915 | 186866:751916 | 186867:751917 | 186868:751918 | 186869:751919,751920 | 186870:751921 | 186871:751922,751923,751924,751925 | 186872:751926,751927,751928,751929\" \/>\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 = \"186813,186814,186815,186816,186817,186818,186819,186820,186821,186822,186823,186824,186825,186826,186827,186828,186829,186830,186831,186832,186833,186834,186835,186836,186837,186838,186839,186840,186841,186842,186843,186844,186845,186846,186847,186848,186849,186850,186851,186852,186853,186854,186855,186856,186857,186858,186859,186860,186861,186862,186863,186864,186865,186866,186867,186868,186869,186870,186871,186872\";\nWatuPROSettings[5617] = {};\nWatuPRO.qArr = question_ids.split(',');\nWatuPRO.exam_id = 5617;\t    \nWatuPRO.post_id = 26926;\nWatuPRO.store_progress = 0;\nWatuPRO.curCatPage = 1;\nWatuPRO.requiredIDs=\"0\".split(\",\");\nWatuPRO.hAppID = \"0.66438900 1777606342\";\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(5617);\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":[6741,6742,7719,13030],"class_list":["post-26926","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-data-certification","tag-dp-200","tag-dp-200-dumps","tag-dp-200-free-dumps","tag-dp-200-updated-dumps"],"_links":{"self":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/26926","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=26926"}],"version-history":[{"count":1,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/26926\/revisions"}],"predecessor-version":[{"id":26927,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/26926\/revisions\/26927"}],"wp:attachment":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/media?parent=26926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/categories?post=26926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/tags?post=26926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}