{"id":3820,"date":"2019-06-13T06:38:24","date_gmt":"2019-06-13T06:38:24","guid":{"rendered":"https:\/\/www.dumpsbase.com\/freedumps\/?p=3820"},"modified":"2019-06-13T06:41:11","modified_gmt":"2019-06-13T06:41:11","slug":"2019-new-azure-exam-dp-201-dumps-questions","status":"publish","type":"post","link":"https:\/\/www.dumpsbase.com\/freedumps\/2019-new-azure-exam-dp-201-dumps-questions.html","title":{"rendered":"2019 New Azure Exam DP-201 Dumps Questions"},"content":{"rendered":"\n<p>Go on talking about Microsoft Certified: Azure Data Engineer Associate certification. DP-200 and DP-201 are the two exams for Azure Data Engineer certification. In my last post, we have shared <a href=\"https:\/\/www.dumpsbase.com\/freedumps\/2019-new-azure-exam-dp-200-dumps-questions.html\"><strong>new DP-200 dumps questions<\/strong><\/a>. Here we go on to share new Azure exam DP-201 dumps questions. Main tasks of DP-201 exam are below:<\/p>\n<ul>\n<li>Design Azure data storage solutions<\/li>\n<li>Design data processing solutions<\/li>\n<li>Design for data security and compliance<\/li>\n<li>Design for high availability and disaster recovery<\/li>\n<\/ul>\n<p>The same as DP-200 dumps questions, DP-201 questions are based on the Azure exam DP-201 exam measure skills and tasks. With our new Azure exam DP-201 dumps questions, you can pass Designing an Azure Data Solution DP-201 exam successfully.<\/p>\n<h2><span style=\"color: #0000ff;\">Free DP-201 Dumps Questions Online<\/span>, Read Immediately<\/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=\"submittingExam2305\" 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-2305\"><\/div>\n\n<form action=\"\" method=\"post\" class=\"quiz-form\" id=\"quiz-2305\"  enctype=\"multipart\/form-data\" >\n<div class='watu-question ' id='question-1' style=';'><div id='questionWrap-1'  class='   watupro-question-id-68804'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>1. <\/span>Topic 1, Trey Research Case study <br \/>\r<br><br \/>\r<br>This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. <br \/>\r<br>However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. <br \/>\r<br><br \/>\r<br>To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other question on this case study. <br \/>\r<br><br \/>\r<br>At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next sections of the exam. After you begin a new section, you cannot return to this section. <br \/>\r<br><br \/>\r<br>To start the case study <br \/>\r<br>To display the first question on this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. <br \/>\r<br><br \/>\r<br>Background <br \/>\r<br>Trey Research is a technology innovator. The company partners with regional transportation department office to build solutions that improve traffic flow and safety. <br \/>\r<br>The company is developing the following solutions: <br \/>\r<br><br><img decoding=\"async\" width=616 height=345 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-201%20V8.files\/image002.jpg\" v:shapes=\"_x0000_i1025\"><br><br \/>\r<br><br \/>\r<br>Regional transportation departments installed traffic sensor systems on major highways across North America. Sensors record the following information each time a vehicle passes in front of a sensor: <br \/>\r<br>- Time <br \/>\r<br>- Location in latitude and longitude <br \/>\r<br>- Speed in kilometers per second (kmps) <br \/>\r<br>- License plate number -Length of vehicle in meters <br \/>\r<br>Sensors provide data by using the following structure: <br \/>\r<br><br><img decoding=\"async\" width=397 height=262 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-201%20V8.files\/image004.jpg\" v:shapes=\"_x0000_i1026\"><br><br \/>\r<br>Traffic sensors will occasionally capture an image of a vehicle for debugging purposes. You must optimize performance of saving\/storing vehicle images. <br \/>\r<br><br \/>\r<br>Traffic sensor data <br \/>\r<br>- Sensors must have permission only to add items to the SensorData collection. <br \/>\r<br>- Traffic data insertion rate must be maximized. <br \/>\r<br>- Once every three months all traffic sensor data must be analyzed to look for data patterns that indicate sensor malfunctions. <br \/>\r<br>- Sensor data must be stored in a Cosmos DB named treydata in a collection named SensorData <br \/>\r<br>- The impact of vehicle images on sensor data throughout must be minimized. <br \/>\r<br><br \/>\r<br>Backtrack <br \/>\r<br>This solution reports on all data related to a specific vehicle license plate. The report must use data from the SensorData collection. Users must be able to filter vehicle data in the following ways: <br \/>\r<br>- vehicles on a specific road <br \/>\r<br>- vehicles driving above the speed limit <br \/>\r<br><br \/>\r<br>Planning Assistance <br \/>\r<br>Data used for Planning Assistance must be stored in a sharded Azure SQL Database. <br \/>\r<br>Data from the Sensor Data collection will automatically be loaded into the Planning Assistance database once a week by using Azure Data Factory. You must be able to manually trigger the data load process. <br \/>\r<br><br \/>\r<br>Privacy and security policy <br \/>\r<br>- Azure Active Directory must be used for all services where it is available. <br \/>\r<br>- For privacy reasons, license plate number information must not be accessible in Planning Assistance. <br \/>\r<br>- Unauthorized usage of the Planning Assistance data must be detected as quickly as possible. Unauthorized usage is determined by looking for an unusual pattern of usage. <br \/>\r<br>- Data must only be stored for seven years. <br \/>\r<br><br \/>\r<br>Performance and availability <br \/>\r<br>- The report for Backtrack must execute as quickly as possible. <br \/>\r<br>- The SLA for Planning Assistance is 70 percent, and multiday outages are permitted. <br \/>\r<br>- All data must be replicated to multiple geographic regions to prevent data loss. <br \/>\r<br>- You must maximize the performance of the Real Time Response system. <br \/>\r<br><br \/>\r<br>Financial requirements <br \/>\r<br>Azure resource costs must be minimized where possible. <br \/>\r<br><br \/>\r<br>You need to design the vehicle images storage solution. <br \/>\r<br>What should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_1' value='68804' \/><input type='hidden' id='answerType68804' 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-68804[]' id='answer-id-283368' class='answer   answerof-68804 ' value='283368'   \/><label for='answer-id-283368' id='answer-label-283368' class=' answer'><span>Azure Media Services<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68804[]' id='answer-id-283369' class='answer   answerof-68804 ' value='283369'   \/><label for='answer-id-283369' id='answer-label-283369' class=' answer'><span>Azure Premium Storage account<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68804[]' id='answer-id-283370' class='answer   answerof-68804 ' value='283370'   \/><label for='answer-id-283370' id='answer-label-283370' class=' answer'><span>Azure Redis Cache<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68804[]' id='answer-id-283371' class='answer   answerof-68804 ' value='283371'   \/><label for='answer-id-283371' id='answer-label-283371' class=' answer'><span>Azure Cosmos DB<\/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-68806'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>2. <\/span>You need to design a sharding strategy for the Planning Assistance database. <br \/>\r<br>What should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_2' value='68806' \/><input type='hidden' id='answerType68806' 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-68806[]' id='answer-id-283376' class='answer   answerof-68806 ' value='283376'   \/><label for='answer-id-283376' id='answer-label-283376' class=' answer'><span>a list mapping shard map on the binary representation of the License Plate column<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68806[]' id='answer-id-283377' class='answer   answerof-68806 ' value='283377'   \/><label for='answer-id-283377' id='answer-label-283377' class=' answer'><span>a range mapping shard map on the binary representation of the speed column<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68806[]' id='answer-id-283378' class='answer   answerof-68806 ' value='283378'   \/><label for='answer-id-283378' id='answer-label-283378' class=' answer'><span>a list mapping shard map on the location column<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68806[]' id='answer-id-283379' class='answer   answerof-68806 ' value='283379'   \/><label for='answer-id-283379' id='answer-label-283379' class=' answer'><span>a range mapping shard map on the time column<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-3' style=';'><div id='questionWrap-3'  class='   watupro-question-id-68808'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>3. <\/span>HOTSPOT <br \/>\r<br>You need to design the SensorData collection. <br \/>\r<br>What should you recommend? To answer, select the appropriate options in the answer area. <br \/>\r<br>NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=544 height=377 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-201%20V8.files\/image006.jpg\" v:shapes=\"_x0000_i1027\"><br><\/div><input type='hidden' name='question_id[]' id='qID_3' value='68808' \/><input type='hidden' id='answerType68808' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68808[]' id='textarea_q_68808' 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-68810'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>4. <\/span>You need to recommend an Azure SQL Database pricing tier for Planning Assistance. <br \/>\r<br>Which pricing tier should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_4' value='68810' \/><input type='hidden' id='answerType68810' 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-68810[]' id='answer-id-283388' class='answer   answerof-68810 ' value='283388'   \/><label for='answer-id-283388' id='answer-label-283388' class=' answer'><span>Business critical Azure SQL Database single database<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68810[]' id='answer-id-283389' class='answer   answerof-68810 ' value='283389'   \/><label for='answer-id-283389' id='answer-label-283389' class=' answer'><span>General purpose Azure SQL Database Managed Instance<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68810[]' id='answer-id-283390' class='answer   answerof-68810 ' value='283390'   \/><label for='answer-id-283390' id='answer-label-283390' class=' answer'><span>Business critical Azure SQL Database Managed Instance<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68810[]' id='answer-id-283391' class='answer   answerof-68810 ' value='283391'   \/><label for='answer-id-283391' id='answer-label-283391' class=' answer'><span>General purpose Azure SQL Database single database<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-5' style=';'><div id='questionWrap-5'  class='   watupro-question-id-68812'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>5. <\/span>HOTSPOT <br \/>\r<br>You need to design the Planning Assistance database. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=630 height=216 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-201%20V8.files\/image010.jpg\" v:shapes=\"_x0000_i1029\"><br><\/div><input type='hidden' name='question_id[]' id='qID_5' value='68812' \/><input type='hidden' id='answerType68812' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68812[]' id='textarea_q_68812' 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-68814'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>6. <\/span>HOTSPOT <br \/>\r<br>You need to design the data loading pipeline for Planning Assistance. <br \/>\r<br>What should you recommend? To answer, drag the appropriate technologies to the correct locations. Each technology may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. <br \/>\r<br>NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=650 height=184 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-201%20V8.files\/image014.jpg\" v:shapes=\"_x0000_i1031\"><br><\/div><input type='hidden' name='question_id[]' id='qID_6' value='68814' \/><input type='hidden' id='answerType68814' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68814[]' id='textarea_q_68814' 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-68815'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>7. <\/span>You need to design the runtime environment for the Real Time Response system. <br \/>\r<br>What should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_7' value='68815' \/><input type='hidden' id='answerType68815' 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-68815[]' id='answer-id-283402' class='answer   answerof-68815 ' value='283402'   \/><label for='answer-id-283402' id='answer-label-283402' class=' answer'><span>General Purpose nodes without the Enterprise Security package<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68815[]' id='answer-id-283403' class='answer   answerof-68815 ' value='283403'   \/><label for='answer-id-283403' id='answer-label-283403' class=' answer'><span>Memory Optimized Nodes without the Enterprise Security package<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68815[]' id='answer-id-283404' class='answer   answerof-68815 ' value='283404'   \/><label for='answer-id-283404' id='answer-label-283404' class=' answer'><span>Memory Optimized nodes with the Enterprise Security package<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68815[]' id='answer-id-283405' class='answer   answerof-68815 ' value='283405'   \/><label for='answer-id-283405' id='answer-label-283405' class=' answer'><span>General Purpose nodes with the Enterprise Security package<\/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-68817'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>8. <\/span>HOTSPOT <br \/>\r<br>You need to ensure that emergency road response vehicles are dispatched automatically. <br \/>\r<br>How should you design the processing system? 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=650 height=171 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-201%20V8.files\/image018.jpg\" v:shapes=\"_x0000_i1033\"><br><\/div><input type='hidden' name='question_id[]' id='qID_8' value='68817' \/><input type='hidden' id='answerType68817' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68817[]' id='textarea_q_68817' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-9' style=';'><div id='questionWrap-9'  class='   watupro-question-id-68819'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>9. <\/span>DRAG DROP <br \/>\r<br>You need to ensure that performance requirements for Backtrack reports are met. <br \/>\r<br>What should you recommend? To answer, drag the appropriate technologies to the correct locations. Each technology may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. <br \/>\r<br>NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=650 height=208 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-201%20V8.files\/image026.jpg\" v:shapes=\"_x0000_i1037\"><br><\/div><input type='hidden' name='question_id[]' id='qID_9' value='68819' \/><input type='hidden' id='answerType68819' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68819[]' id='textarea_q_68819' 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-10' style=';'><div id='questionWrap-10'  class='   watupro-question-id-68821'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>10. <\/span>HOTSPOT <br \/>\r<br>You need to design the authentication and authorization methods for sensors. <br \/>\r<br>What should you recommend? 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=527 height=348 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-201%20V8.files\/image030.jpg\" v:shapes=\"_x0000_i1039\"><br><\/div><input type='hidden' name='question_id[]' id='qID_10' value='68821' \/><input type='hidden' id='answerType68821' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68821[]' id='textarea_q_68821' 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-11' style=';'><div id='questionWrap-11'  class='   watupro-question-id-68823'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>11. <\/span>HOTSPOT <br \/>\r<br>You need to ensure that security policies for the unauthorized detection system are met. <br \/>\r<br>What should you recommend? 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=486 height=329 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-201%20V8.files\/image034.jpg\" v:shapes=\"_x0000_i1041\"><br><\/div><input type='hidden' name='question_id[]' id='qID_11' value='68823' \/><input type='hidden' id='answerType68823' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68823[]' id='textarea_q_68823' 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-68825'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>12. <\/span>Topic 2, Case study 1 <br \/>\r<br>This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. <br \/>\r<br>However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. <br \/>\r<br><br \/>\r<br>To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other question on this case study. <br \/>\r<br><br \/>\r<br>At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next sections of the exam. After you begin a new section, you cannot return to this section. <br \/>\r<br><br \/>\r<br>To start the case study <br \/>\r<br>To display the first question on this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. <br \/>\r<br><br \/>\r<br>Requirements <br \/>\r<br>Business <br \/>\r<br>The company identifies the following business requirements: <br \/>\r<br>- You must transfer all images and customer data to cloud storage and remove on-premises servers. <br \/>\r<br>- You must develop an analytical processing solution for transforming customer data. <br \/>\r<br>- You must develop an image object and color tagging solution. <br \/>\r<br>- Capital expenditures must be minimized. <br \/>\r<br>- Cloud resource costs must be minimized. <br \/>\r<br><br \/>\r<br>Technical <br \/>\r<br>The solution has the following technical requirements: <br \/>\r<br>- Tagging data must be uploaded to the cloud from the New York office location. <br \/>\r<br>- Tagging data must be replicated to regions that are geographically close to company office locations. <br \/>\r<br>- Image data must be stored in a single data store at minimum cost. <br \/>\r<br>- Customer data must be analyzed using managed Spark clusters. <br \/>\r<br>- Power BI must be used to visualize transformed customer data. <br \/>\r<br>- All data must be backed up in case disaster recovery is required. <br \/>\r<br><br \/>\r<br>Security and optimization <br \/>\r<br>All cloud data must be encrypted at rest and in transit. <br \/>\r<br>The solution must support: <br \/>\r<br>- parallel processing of customer data <br \/>\r<br>- hyper-scale storage of images <br \/>\r<br>- global region data replication of processed image data <br \/>\r<br><br \/>\r<br>You need to recommend a solution for storing the image tagging data. <br \/>\r<br>What should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_12' value='68825' \/><input type='hidden' id='answerType68825' 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-68825[]' id='answer-id-283429' class='answer   answerof-68825 ' value='283429'   \/><label for='answer-id-283429' id='answer-label-283429' class=' answer'><span>Azure File Storage<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68825[]' id='answer-id-283430' class='answer   answerof-68825 ' value='283430'   \/><label for='answer-id-283430' id='answer-label-283430' class=' answer'><span>Azure Cosmos DB<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68825[]' id='answer-id-283431' class='answer   answerof-68825 ' value='283431'   \/><label for='answer-id-283431' id='answer-label-283431' class=' answer'><span>Azure Blob Storage<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68825[]' id='answer-id-283432' class='answer   answerof-68825 ' value='283432'   \/><label for='answer-id-283432' id='answer-label-283432' class=' answer'><span>Azure SQL Database<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68825[]' id='answer-id-283433' class='answer   answerof-68825 ' value='283433'   \/><label for='answer-id-283433' id='answer-label-283433' class=' answer'><span>Azure SQL Data Warehouse<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-13' style=';'><div id='questionWrap-13'  class='   watupro-question-id-68827'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>13. <\/span>You need to design the solution for analyzing customer data. <br \/>\r<br>What should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_13' value='68827' \/><input type='hidden' id='answerType68827' 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-68827[]' id='answer-id-283436' class='answer   answerof-68827 ' value='283436'   \/><label for='answer-id-283436' id='answer-label-283436' class=' answer'><span>Azure Databricks<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68827[]' id='answer-id-283437' class='answer   answerof-68827 ' value='283437'   \/><label for='answer-id-283437' id='answer-label-283437' class=' answer'><span>Azure Data Lake Storage<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68827[]' id='answer-id-283438' class='answer   answerof-68827 ' value='283438'   \/><label for='answer-id-283438' id='answer-label-283438' class=' answer'><span>Azure SQL Data Warehouse<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68827[]' id='answer-id-283439' class='answer   answerof-68827 ' value='283439'   \/><label for='answer-id-283439' id='answer-label-283439' class=' answer'><span>Azure Cognitive Services<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68827[]' id='answer-id-283440' class='answer   answerof-68827 ' value='283440'   \/><label for='answer-id-283440' id='answer-label-283440' class=' answer'><span>Azure Batch<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-14' style=';'><div id='questionWrap-14'  class='   watupro-question-id-68829'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>14. <\/span>DRAG DROP <br \/>\r<br>You need to design the image processing solution to meet the optimization requirements for image tag data. <br \/>\r<br>What should you configure? To answer, drag the appropriate setting to the correct drop targets. <br \/>\r<br>Each source may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. <br \/>\r<br>NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=489 height=243 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-201%20V8.files\/image038.jpg\" v:shapes=\"_x0000_i1043\"><br><\/div><input type='hidden' name='question_id[]' id='qID_14' value='68829' \/><input type='hidden' id='answerType68829' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68829[]' id='textarea_q_68829' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-15' style=';'><div id='questionWrap-15'  class='   watupro-question-id-68831'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>15. <\/span>DRAG DROP <br \/>\r<br>You need to design the encryption strategy for the tagging data and customer data. <br \/>\r<br>What should you recommend? To answer, drag the appropriate setting to the correct drop targets. Each source may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. <br \/>\r<br>NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=649 height=144 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-201%20V8.files\/image042.jpg\" v:shapes=\"_x0000_i1045\"><br><\/div><input type='hidden' name='question_id[]' id='qID_15' value='68831' \/><input type='hidden' id='answerType68831' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68831[]' id='textarea_q_68831' 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-16' style=';'><div id='questionWrap-16'  class='   watupro-question-id-68833'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>16. <\/span>You need to design a backup solution for the processed customer data. <br \/>\r<br>What should you include in the design?<\/div><input type='hidden' name='question_id[]' id='qID_16' value='68833' \/><input type='hidden' id='answerType68833' 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-68833[]' id='answer-id-283450' class='answer   answerof-68833 ' value='283450'   \/><label for='answer-id-283450' id='answer-label-283450' class=' answer'><span>AzCopy<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68833[]' id='answer-id-283452' class='answer   answerof-68833 ' value='283452'   \/><label for='answer-id-283452' id='answer-label-283452' class=' answer'><span>AdlCopy<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68833[]' id='answer-id-283454' class='answer   answerof-68833 ' value='283454'   \/><label for='answer-id-283454' id='answer-label-283454' class=' answer'><span>Geo-Redundancy<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68833[]' id='answer-id-283456' class='answer   answerof-68833 ' value='283456'   \/><label for='answer-id-283456' id='answer-label-283456' class=' answer'><span>Geo-Replication<\/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-68834'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>17. <\/span>Topic 3, Case study 2 <br \/>\r<br>This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. <br \/>\r<br>However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided. <br \/>\r<br><br \/>\r<br>To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other question on this case study. <br \/>\r<br><br \/>\r<br>At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next sections of the exam. After you begin a new section, you cannot return to this section. <br \/>\r<br><br \/>\r<br>To start the case study <br \/>\r<br>To display the first question on this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question. <br \/>\r<br><br \/>\r<br>Background <br \/>\r<br>Current environment <br \/>\r<br>The company has the following virtual machines (VMs): <br \/>\r<br><br><img decoding=\"async\" width=616 height=166 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-201%20V8.files\/image046.jpg\" v:shapes=\"_x0000_i1047\"><br><br \/>\r<br><br \/>\r<br>Requirements <br \/>\r<br>Storage and processing <br \/>\r<br>You must be able to use a file system view of data stored in a blob. <br \/>\r<br>You must build an architecture that will allow Contoso to use the DB FS filesystem layer over a blob store. The architecture will need to support data files, libraries, and images. Additionally, it must provide a web-based interface to documents that contain runnable command, visualizations, and narrative text such as a notebook. <br \/>\r<br>CONT_SQL3 requires an initial scale of 35000 IOPS. <br \/>\r<br>CONT_SQL1 and CONT_SQL2 must use the vCore model and should include replicas. The solution must support 8000 IOPS. <br \/>\r<br>The storage should be configured to optimized storage for database OLTP workloads. <br \/>\r<br><br \/>\r<br>Migration <br \/>\r<br>- You must be able to independently scale compute and storage resources. <br \/>\r<br>- You must migrate all SQL Server workloads to Azure. You must identify related machines in the on-premises environment, get disk size data usage information. <br \/>\r<br>- Data from SQL Server must include zone redundant storage. <br \/>\r<br>- You need to ensure that app components can reside on-premises while interacting with components that run in the Azure public cloud. <br \/>\r<br>- SAP data must remain on-premises. <br \/>\r<br>- The Azure Site Recovery (ASR) results should contain per-machine data. <br \/>\r<br><br \/>\r<br>Business requirements <br \/>\r<br>- You must design a regional disaster recovery topology. <br \/>\r<br>- The database backups have regulatory purposes and must be retained for seven years. <br \/>\r<br>- CONT_SQL1 stores customers sales data that requires ETL operations for data analysis. A solution is required that reads data from SQL, performs ETL, and outputs to Power BI. The solution should use managed clusters to minimize costs. To optimize logistics, Contoso needs to analyze customer sales data to see if certain products are tied to specific times in the year. <br \/>\r<br>- The analytics solution for customer sales data must be available during a regional outage. <br \/>\r<br><br \/>\r<br>Security and auditing <br \/>\r<br>- Contoso requires all corporate computers to enable Windows Firewall. <br \/>\r<br>- Azure servers should be able to ping other Contoso Azure servers. <br \/>\r<br>- Employee PII must be encrypted in memory, in motion, and at rest. Any data encrypted by SQL Server must support equality searches, grouping, indexing, and joining on the encrypted data. <br \/>\r<br>- Keys must be secured by using hardware security modules (HSMs). <br \/>\r<br>- CONT_SQL3 must not communicate over the default ports <br \/>\r<br><br \/>\r<br>Cost <br \/>\r<br>- All solutions must minimize cost and resources. <br \/>\r<br>- The organization does not want any unexpected charges. <br \/>\r<br>- The data engineers must set the SQL Data Warehouse compute resources to consume 300 DWUs. <br \/>\r<br>- CONT_SQL2 is not fully utilized during non-peak hours. You must minimize resource costs for during non-peak hours. <br \/>\r<br><br \/>\r<br>You need to design a solution to meet the SQL Server storage requirements for CONT_SQL3. <br \/>\r<br>Which type of disk should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_17' value='68834' \/><input type='hidden' id='answerType68834' 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-68834[]' id='answer-id-283459' class='answer   answerof-68834 ' value='283459'   \/><label for='answer-id-283459' id='answer-label-283459' class=' answer'><span>Standard SSD Managed Disk<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68834[]' id='answer-id-283461' class='answer   answerof-68834 ' value='283461'   \/><label for='answer-id-283461' id='answer-label-283461' class=' answer'><span>Premium SSD Managed Disk<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68834[]' id='answer-id-283463' class='answer   answerof-68834 ' value='283463'   \/><label for='answer-id-283463' id='answer-label-283463' class=' answer'><span>Ultra SSD Managed Disk<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-18' style=';'><div id='questionWrap-18'  class='   watupro-question-id-68836'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>18. <\/span>You need to recommend an Azure SQL Database service tier. <br \/>\r<br>What should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_18' value='68836' \/><input type='hidden' id='answerType68836' 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-68836[]' id='answer-id-283466' class='answer   answerof-68836 ' value='283466'   \/><label for='answer-id-283466' id='answer-label-283466' class=' answer'><span>Business Critical<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68836[]' id='answer-id-283467' class='answer   answerof-68836 ' value='283467'   \/><label for='answer-id-283467' id='answer-label-283467' class=' answer'><span>General Purpose<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68836[]' id='answer-id-283468' class='answer   answerof-68836 ' value='283468'   \/><label for='answer-id-283468' id='answer-label-283468' class=' answer'><span>Premium<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68836[]' id='answer-id-283470' class='answer   answerof-68836 ' value='283470'   \/><label for='answer-id-283470' id='answer-label-283470' class=' answer'><span>Standard<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68836[]' id='answer-id-283472' class='answer   answerof-68836 ' value='283472'   \/><label for='answer-id-283472' id='answer-label-283472' class=' answer'><span>Basic<\/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-68838'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>19. <\/span>You need to recommend the appropriate storage and processing solution? <br \/>\r<br>What should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_19' value='68838' \/><input type='hidden' id='answerType68838' 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-68838[]' id='answer-id-283475' class='answer   answerof-68838 ' value='283475'   \/><label for='answer-id-283475' id='answer-label-283475' class=' answer'><span>Enable auto-shrink on the database.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68838[]' id='answer-id-283476' class='answer   answerof-68838 ' value='283476'   \/><label for='answer-id-283476' id='answer-label-283476' class=' answer'><span>Flush the blob cache using Windows PowerShell.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68838[]' id='answer-id-283478' class='answer   answerof-68838 ' value='283478'   \/><label for='answer-id-283478' id='answer-label-283478' class=' answer'><span>Enable Apache Spark RDD (RDD) caching.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68838[]' id='answer-id-283480' class='answer   answerof-68838 ' value='283480'   \/><label for='answer-id-283480' id='answer-label-283480' class=' answer'><span>Enable Databricks IO (DBIO) caching.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68838[]' id='answer-id-283482' class='answer   answerof-68838 ' value='283482'   \/><label for='answer-id-283482' id='answer-label-283482' class=' answer'><span>Configure the reading speed using Azure Data Studio.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-20' style=';'><div id='questionWrap-20'  class='   watupro-question-id-68840'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>20. <\/span>You need to optimize storage for CONT_SQL3. <br \/>\r<br>What should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_20' value='68840' \/><input type='hidden' id='answerType68840' 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-68840[]' id='answer-id-283484' class='answer   answerof-68840 ' value='283484'   \/><label for='answer-id-283484' id='answer-label-283484' class=' answer'><span>AlwaysOn<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68840[]' id='answer-id-283486' class='answer   answerof-68840 ' value='283486'   \/><label for='answer-id-283486' id='answer-label-283486' class=' answer'><span>Transactional processing<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68840[]' id='answer-id-283488' class='answer   answerof-68840 ' value='283488'   \/><label for='answer-id-283488' id='answer-label-283488' class=' answer'><span>General<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68840[]' id='answer-id-283490' class='answer   answerof-68840 ' value='283490'   \/><label for='answer-id-283490' id='answer-label-283490' class=' answer'><span>Data warehousing<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-21' style=';'><div id='questionWrap-21'  class='   watupro-question-id-68842'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>21. <\/span>HOTSPOT <br \/>\r<br>You need to design network access to the SQL Server data. <br \/>\r<br>What should you recommend? 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=649 height=210 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-201%20V8.files\/image052.jpg\" v:shapes=\"_x0000_i1050\"><br><\/div><input type='hidden' name='question_id[]' id='qID_21' value='68842' \/><input type='hidden' id='answerType68842' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68842[]' id='textarea_q_68842' 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-68844'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>22. <\/span>A company stores sensitive information about customers and employees in Azure SQL Database. <br \/>\r<br>You need to ensure that the sensitive data remains encrypted in transit and at rest. <br \/>\r<br>What should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_22' value='68844' \/><input type='hidden' id='answerType68844' 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-68844[]' id='answer-id-283497' class='answer   answerof-68844 ' value='283497'   \/><label for='answer-id-283497' id='answer-label-283497' class=' answer'><span>Transparent Data Encryption<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68844[]' id='answer-id-283498' class='answer   answerof-68844 ' value='283498'   \/><label for='answer-id-283498' id='answer-label-283498' class=' answer'><span>Always Encrypted with secure enclaves<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68844[]' id='answer-id-283499' class='answer   answerof-68844 ' value='283499'   \/><label for='answer-id-283499' id='answer-label-283499' class=' answer'><span>Azure Disk Encryption<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68844[]' id='answer-id-283500' class='answer   answerof-68844 ' value='283500'   \/><label for='answer-id-283500' id='answer-label-283500' class=' answer'><span>SQL Server AlwaysOn<\/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-68846'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>23. <\/span>DRAG DROP <br \/>\r<br>You are designing an Azure SQL Data Warehouse for a financial services company. Azure Active Directory will be used to authenticate the users. <br \/>\r<br>You need to ensure that the following security requirements are met: <br \/>\r<br>- Department managers must be able to create new database. <br \/>\r<br>- The IT department must assign users to databases. <br \/>\r<br>- Permissions granted must be minimized. <br \/>\r<br>Which role memberships should you recommend? To answer, drag the appropriate roles to the correct groups. Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. <br \/>\r<br>NOTE: Each correct selection is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=594 height=336 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/DP-201%20V8.files\/image056.jpg\" v:shapes=\"_x0000_i1052\"><br><\/div><input type='hidden' name='question_id[]' id='qID_23' value='68846' \/><input type='hidden' id='answerType68846' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-68846[]' id='textarea_q_68846' 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-24' style=';'><div id='questionWrap-24'  class='   watupro-question-id-68848'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>24. <\/span>You plan to use Azure SQL Database to support a line of business app. <br \/>\r<br>You need to identify sensitive data that is stored in the database and monitor access to the data. <br \/>\r<br>Which three actions should you recommend? Each correct answer presents part of the solution. <br \/>\r<br>NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_24' value='68848' \/><input type='hidden' id='answerType68848' 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-68848[]' id='answer-id-283511' class='answer   answerof-68848 ' value='283511'   \/><label for='answer-id-283511' id='answer-label-283511' class=' answer'><span>Enable Data Discovery and Classification.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68848[]' id='answer-id-283512' class='answer   answerof-68848 ' value='283512'   \/><label for='answer-id-283512' id='answer-label-283512' class=' answer'><span>Implement Transparent Data Encryption (TDE).<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68848[]' id='answer-id-283513' class='answer   answerof-68848 ' value='283513'   \/><label for='answer-id-283513' id='answer-label-283513' class=' answer'><span>Enable Auditing.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68848[]' id='answer-id-283514' class='answer   answerof-68848 ' value='283514'   \/><label for='answer-id-283514' id='answer-label-283514' class=' answer'><span>Run Vulnerability Assessment.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68848[]' id='answer-id-283515' class='answer   answerof-68848 ' value='283515'   \/><label for='answer-id-283515' id='answer-label-283515' class=' answer'><span>Use Advanced Threat Protection.<\/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-68850'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>25. <\/span>You need to recommend a backup strategy for CONT_SQL1 and CONT_SQL2. <br \/>\r<br>What should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_25' value='68850' \/><input type='hidden' id='answerType68850' 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-68850[]' id='answer-id-283520' class='answer   answerof-68850 ' value='283520'   \/><label for='answer-id-283520' id='answer-label-283520' class=' answer'><span>Use AzCopy and store the data in Azure.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68850[]' id='answer-id-283521' class='answer   answerof-68850 ' value='283521'   \/><label for='answer-id-283521' id='answer-label-283521' class=' answer'><span>Configure Azure SQL Database long-term retention for all databases.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68850[]' id='answer-id-283522' class='answer   answerof-68850 ' value='283522'   \/><label for='answer-id-283522' id='answer-label-283522' class=' answer'><span>Configure Accelerated Database Recovery.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68850[]' id='answer-id-283523' class='answer   answerof-68850 ' value='283523'   \/><label for='answer-id-283523' id='answer-label-283523' class=' answer'><span>Use DWLoader.<\/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-68852'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>26. <\/span>You need to design the disaster recovery solution for customer sales data analytics. <br \/>\r<br>Which three actions should you recommend? Each correct answer presents part of the solution. <br \/>\r<br>NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_26' value='68852' \/><input type='hidden' id='answerType68852' 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-68852[]' id='answer-id-283525' class='answer   answerof-68852 ' value='283525'   \/><label for='answer-id-283525' id='answer-label-283525' class=' answer'><span>Provision multiple Azure Databricks workspaces in separate Azure regions.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68852[]' id='answer-id-283526' class='answer   answerof-68852 ' value='283526'   \/><label for='answer-id-283526' id='answer-label-283526' class=' answer'><span>Migrate users, notebooks, and cluster configurations from one workspace to another in the same region.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68852[]' id='answer-id-283527' class='answer   answerof-68852 ' value='283527'   \/><label for='answer-id-283527' id='answer-label-283527' class=' answer'><span>Use zone redundant storage.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68852[]' id='answer-id-283528' class='answer   answerof-68852 ' value='283528'   \/><label for='answer-id-283528' id='answer-label-283528' class=' answer'><span>Migrate users, notebooks, and cluster configurations from one region to another.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68852[]' id='answer-id-283530' class='answer   answerof-68852 ' value='283530'   \/><label for='answer-id-283530' id='answer-label-283530' class=' answer'><span>Use Geo-redundant storage.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-68852[]' id='answer-id-283532' class='answer   answerof-68852 ' value='283532'   \/><label for='answer-id-283532' id='answer-label-283532' class=' answer'><span>Provision a second Azure Databricks workspace in the same region.<\/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-68853'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>27. <\/span>Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. <br \/>\r<br>After you answer a question in this section, you will NOT be able to return to it. As a result, these <br \/>\r<br>questions will not appear in the review screen. <br \/>\r<br>You are designing an HDInsight\/Hadoop cluster solution that uses Azure Data Lake Gen1 Storage. <br \/>\r<br>The solution requires POSIX permissions and enables diagnostics logging for auditing. <br \/>\r<br>You need to recommend solutions that optimize storage. <br \/>\r<br>Proposed Solution: Ensure that files stored are larger than 250MB. <br \/>\r<br>Does the solution meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_27' value='68853' \/><input type='hidden' id='answerType68853' 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-68853[]' id='answer-id-283534' class='answer   answerof-68853 ' value='283534'   \/><label for='answer-id-283534' id='answer-label-283534' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68853[]' id='answer-id-283535' class='answer   answerof-68853 ' value='283535'   \/><label for='answer-id-283535' id='answer-label-283535' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-28' style=';'><div id='questionWrap-28'  class='   watupro-question-id-68855'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>28. <\/span>Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. <br \/>\r<br>After you answer a question in this section, you will NOT be able to return to it. As a result, these <br \/>\r<br>questions will not appear in the review screen. <br \/>\r<br>You are designing an HDInsight\/Hadoop cluster solution that uses Azure Data Lake Gen1 Storage. <br \/>\r<br>The solution requires POSIX permissions and enables diagnostics logging for auditing. <br \/>\r<br>You need to recommend solutions that optimize storage. <br \/>\r<br>Proposed Solution: Implement compaction jobs to combine small files into larger files. <br \/>\r<br>Does the solution meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_28' value='68855' \/><input type='hidden' id='answerType68855' 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-68855[]' id='answer-id-283541' class='answer   answerof-68855 ' value='283541'   \/><label for='answer-id-283541' id='answer-label-283541' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-68855[]' id='answer-id-283542' class='answer   answerof-68855 ' value='283542'   \/><label for='answer-id-283542' id='answer-label-283542' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div style='display:none' id='question-29'>\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=\"watuPROButtons2305\" >\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=\"2305\" id=\"watuPROExamID\"\/>\n\t<input type=\"hidden\" name=\"start_time\" id=\"startTime\" value=\"2026-05-11 21:38:53\" \/>\n\t<input type=\"hidden\" name=\"start_timestamp\" id=\"startTimeStamp\" value=\"1778535533\" \/>\n\t<input type=\"hidden\" name=\"question_ids\" value=\"\" \/>\n\t<input type=\"hidden\" name=\"watupro_questions\" value=\"68804:283368,283369,283370,283371 | 68806:283376,283377,283378,283379 | 68808:283383 | 68810:283388,283389,283390,283391 | 68812:283396 | 68814:283397 | 68815:283402,283403,283404,283405 | 68817:283410 | 68819:283415 | 68821:283421 | 68823:283426 | 68825:283429,283430,283431,283432,283433 | 68827:283436,283437,283438,283439,283440 | 68829:283445 | 68831:283448 | 68833:283450,283452,283454,283456 | 68834:283459,283461,283463 | 68836:283466,283467,283468,283470,283472 | 68838:283475,283476,283478,283480,283482 | 68840:283484,283486,283488,283490 | 68842:283493 | 68844:283497,283498,283499,283500 | 68846:283506 | 68848:283511,283512,283513,283514,283515 | 68850:283520,283521,283522,283523 | 68852:283525,283526,283527,283528,283530,283532 | 68853:283534,283535 | 68855:283541,283542\" \/>\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 = \"68804,68806,68808,68810,68812,68814,68815,68817,68819,68821,68823,68825,68827,68829,68831,68833,68834,68836,68838,68840,68842,68844,68846,68848,68850,68852,68853,68855\";\nWatuPROSettings[2305] = {};\nWatuPRO.qArr = question_ids.split(',');\nWatuPRO.exam_id = 2305;\t    \nWatuPRO.post_id = 3820;\nWatuPRO.store_progress = 0;\nWatuPRO.curCatPage = 1;\nWatuPRO.requiredIDs=\"0\".split(\",\");\nWatuPRO.hAppID = \"0.31873300 1778535533\";\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(2305);\nWatuPRO.inCategoryPages=1;});    \t \n<\/script>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[101,6074],"tags":[6740,6748,6749,6750,6752,6753,6751],"class_list":["post-3820","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-data-certification","tag-azure-data-engineer","tag-dp-201","tag-dp-201-dumps","tag-dp-201-dumps-questions","tag-dp-201-exam-dumps","tag-dp-201-questions","tag-new-dp-201-dumps"],"_links":{"self":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/3820","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=3820"}],"version-history":[{"count":2,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/3820\/revisions"}],"predecessor-version":[{"id":3825,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/3820\/revisions\/3825"}],"wp:attachment":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/media?parent=3820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/categories?post=3820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/tags?post=3820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}