{"id":24478,"date":"2021-05-24T03:04:03","date_gmt":"2021-05-24T03:04:03","guid":{"rendered":"https:\/\/www.dumpsbase.com\/freedumps\/?p=24478"},"modified":"2021-05-24T03:04:08","modified_gmt":"2021-05-24T03:04:08","slug":"designing-an-azure-data-solution-dp-201-dumps-will-be-retired","status":"publish","type":"post","link":"https:\/\/www.dumpsbase.com\/freedumps\/designing-an-azure-data-solution-dp-201-dumps-will-be-retired.html","title":{"rendered":"Designing an Azure Data Solution DP-201 Dumps Will Be Retired"},"content":{"rendered":"\n<p>When IT examiners come for Microsoft Certified: Azure Data Engineer Associate certification, they usually choose to pass DP-200 and DP-201 exams. However, both <a href=\"https:\/\/www.dumpsbase.com\/freedumps\/microsoft-certified-azure-data-engineer-associate-dp-200-dumps-updated-v13-02.html\"><strong>DP-200<\/strong><\/a> and DP-201 exams will be retired on June 30, 2021. If you are planning to take the exams, please make sure you can complete before that day. More, we have updated DP-201 dumps with 208 practice exam questions and answers. You can choose the latest Microsoft DP-201 dumps questions as the preparation materials. By the way, if you are planning for DP-203 exam to complete Microsoft Certified: Azure Data Engineer Associate certification, you can get <a href=\"https:\/\/www.dumpsbase.com\/freedumps\/updated-dp-203-dumps-questions-for-microsoft-certified-azure-data-engineer-associate-certification.html\"><strong>valid DP-203 dumps<\/strong><\/a> from DumpsBase also.<\/p>\n<h2><strong>From this blog, you can check <span style=\"color: #ff6600;\">DP-201 free dumps<\/span> online.<\/strong><\/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=\"submittingExam5431\" 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-5431\"><\/div>\n\n<form action=\"\" method=\"post\" class=\"quiz-form\" id=\"quiz-5431\"  enctype=\"multipart\/form-data\" >\n<div class='watu-question ' id='question-1' style=';'><div id='questionWrap-1'  class='   watupro-question-id-178998'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>1. <\/span>Topic 1, Trey Research <br \/>\r<br><br \/>\r<br>Case study <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. 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 questions in 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 section 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 in 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><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\/2021\/05\/image002-42.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. <br \/>\r<br>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 <br \/>\r<br>- Length of vehicle in meters <br \/>\r<br><br \/>\r<br>Sensors provide data by using the following structure: <br \/>\r<br><br><img decoding=\"async\" width=397 height=261 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/05\/image004-42.jpg\" v:shapes=\"_x0000_i1026\"><br><br \/>\r<br><br \/>\r<br>Traffic sensors will occasionally capture an image of a vehicle for debugging purposes. <br \/>\r<br>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. <br \/>\r<br>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 a sharding strategy for the Planning Assistance database. <br \/>\r<br>What should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_1' value='178998' \/><input type='hidden' id='answerType178998' 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-178998[]' id='answer-id-721275' class='answer   answerof-178998 ' value='721275'   \/><label for='answer-id-721275' id='answer-label-721275' 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='checkbox' name='answer-178998[]' id='answer-id-721276' class='answer   answerof-178998 ' value='721276'   \/><label for='answer-id-721276' id='answer-label-721276' 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='checkbox' name='answer-178998[]' id='answer-id-721277' class='answer   answerof-178998 ' value='721277'   \/><label for='answer-id-721277' id='answer-label-721277' class=' answer'><span>a list mapping shard map on the location column<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-178998[]' id='answer-id-721278' class='answer   answerof-178998 ' value='721278'   \/><label for='answer-id-721278' id='answer-label-721278' 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-2' style=';'><div id='questionWrap-2'  class='   watupro-question-id-178999'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>2. <\/span>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_2' value='178999' \/><input type='hidden' id='answerType178999' 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-178999[]' id='answer-id-721279' class='answer   answerof-178999 ' value='721279'   \/><label for='answer-id-721279' id='answer-label-721279' class=' answer'><span>Azure Media Services<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-178999[]' id='answer-id-721280' class='answer   answerof-178999 ' value='721280'   \/><label for='answer-id-721280' id='answer-label-721280' class=' answer'><span>Azure Premium Storage account<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-178999[]' id='answer-id-721281' class='answer   answerof-178999 ' value='721281'   \/><label for='answer-id-721281' id='answer-label-721281' class=' answer'><span>Azure Redis Cache<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-178999[]' id='answer-id-721282' class='answer   answerof-178999 ' value='721282'   \/><label for='answer-id-721282' id='answer-label-721282' class=' answer'><span>Azure Cosmos DB<\/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-179000'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>3. <\/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\/2021\/05\/image006-37.jpg\" v:shapes=\"_x0000_i1027\"><br><\/div><input type='hidden' name='question_id[]' id='qID_3' value='179000' \/><input type='hidden' id='answerType179000' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179000[]' id='textarea_q_179000' 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-179001'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>4. <\/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\/2021\/05\/image010-34.jpg\" v:shapes=\"_x0000_i1029\"><br><\/div><input type='hidden' name='question_id[]' id='qID_4' value='179001' \/><input type='hidden' id='answerType179001' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179001[]' id='textarea_q_179001' 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-179002'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>5. <\/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\/2021\/05\/image014-32.jpg\" v:shapes=\"_x0000_i1031\"><br><\/div><input type='hidden' name='question_id[]' id='qID_5' value='179002' \/><input type='hidden' id='answerType179002' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179002[]' id='textarea_q_179002' 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-179003'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>6. <\/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_6' value='179003' \/><input type='hidden' id='answerType179003' 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-179003[]' id='answer-id-721286' class='answer   answerof-179003 ' value='721286'   \/><label for='answer-id-721286' id='answer-label-721286' class=' answer'><span>Business critical Azure SQL Database single database<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179003[]' id='answer-id-721287' class='answer   answerof-179003 ' value='721287'   \/><label for='answer-id-721287' id='answer-label-721287' class=' answer'><span>General purpose Azure SQL Database Managed Instance<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179003[]' id='answer-id-721288' class='answer   answerof-179003 ' value='721288'   \/><label for='answer-id-721288' id='answer-label-721288' class=' answer'><span>Business critical Azure SQL Database Managed Instance<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179003[]' id='answer-id-721289' class='answer   answerof-179003 ' value='721289'   \/><label for='answer-id-721289' id='answer-label-721289' 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-7' style=';'><div id='questionWrap-7'  class='   watupro-question-id-179004'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>7. <\/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. 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\/2021\/05\/image022-28.jpg\" v:shapes=\"_x0000_i1035\"><br><\/div><input type='hidden' name='question_id[]' id='qID_7' value='179004' \/><input type='hidden' id='answerType179004' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179004[]' id='textarea_q_179004' 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-8' style=';'><div id='questionWrap-8'  class='   watupro-question-id-179005'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>8. <\/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. 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\/2021\/05\/image026-26.jpg\" v:shapes=\"_x0000_i1037\"><br><\/div><input type='hidden' name='question_id[]' id='qID_8' value='179005' \/><input type='hidden' id='answerType179005' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179005[]' id='textarea_q_179005' 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-179006'>\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. 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\/2021\/05\/image030-26.jpg\" v:shapes=\"_x0000_i1039\"><br><\/div><input type='hidden' name='question_id[]' id='qID_9' value='179006' \/><input type='hidden' id='answerType179006' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179006[]' id='textarea_q_179006' 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-179007'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>10. <\/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_10' value='179007' \/><input type='hidden' id='answerType179007' 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-179007[]' id='answer-id-721293' class='answer   answerof-179007 ' value='721293'   \/><label for='answer-id-721293' id='answer-label-721293' 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-179007[]' id='answer-id-721294' class='answer   answerof-179007 ' value='721294'   \/><label for='answer-id-721294' id='answer-label-721294' 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-179007[]' id='answer-id-721295' class='answer   answerof-179007 ' value='721295'   \/><label for='answer-id-721295' id='answer-label-721295' 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-179007[]' id='answer-id-721296' class='answer   answerof-179007 ' value='721296'   \/><label for='answer-id-721296' id='answer-label-721296' 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-11' style=';'><div id='questionWrap-11'  class='   watupro-question-id-179008'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>11. <\/span>HOTSPOT <br \/>\r<br>You need to design the Planning Assistance database. <br \/>\r<br>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\/2021\/05\/image034-25.jpg\" v:shapes=\"_x0000_i1041\"><br><\/div><input type='hidden' name='question_id[]' id='qID_11' value='179008' \/><input type='hidden' id='answerType179008' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179008[]' id='textarea_q_179008' 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-179009'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>12. <\/span>Topic 2, Case study 1 <br \/>\r<br><br \/>\r<br>Case study <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. 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 questions in 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 section 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 in 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>Overview <br \/>\r<br>You develop data engineering solutions for Graphics Design Institute, a global media company with offices in New York City, Manchester, Singapore, and Melbourne. <br \/>\r<br><br \/>\r<br>The New York office hosts SQL Server databases that stores massive amounts of customer data. The company also stores millions of images on a physical server located in the New York office. More than 2 TB of image data is added each day. The images are transferred from customer devices to the server in New York. <br \/>\r<br><br \/>\r<br>Many images have been placed on this server in an unorganized manner, making it difficult for editors to search images. Images should automatically have object and color tags generated. The tags must be stored in a document database, and be queried by SQL <br \/>\r<br><br \/>\r<br>You are hired to design a solution that can store, transform, and visualize customer data. <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 da <br \/>\r<br><br \/>\r<br>You need to recommend a solution for storing customer data. <br \/>\r<br>What should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_12' value='179009' \/><input type='hidden' id='answerType179009' 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-179009[]' id='answer-id-721298' class='answer   answerof-179009 ' value='721298'   \/><label for='answer-id-721298' id='answer-label-721298' class=' answer'><span>Azure SQL Data Warehouse<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179009[]' id='answer-id-721299' class='answer   answerof-179009 ' value='721299'   \/><label for='answer-id-721299' id='answer-label-721299' class=' answer'><span>Azure Stream Analytics<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179009[]' id='answer-id-721300' class='answer   answerof-179009 ' value='721300'   \/><label for='answer-id-721300' id='answer-label-721300' class=' answer'><span>Azure Databricks<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179009[]' id='answer-id-721301' class='answer   answerof-179009 ' value='721301'   \/><label for='answer-id-721301' id='answer-label-721301' class=' answer'><span>Azure SQL Database<\/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-179010'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>13. <\/span>HOTSPOT <br \/>\r<br>You need to design storage for the solution. <br \/>\r<br>Which storage services should you recommend? 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=536 height=407 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/05\/image038-23.jpg\" v:shapes=\"_x0000_i1043\"><br><\/div><input type='hidden' name='question_id[]' id='qID_13' value='179010' \/><input type='hidden' id='answerType179010' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179010[]' id='textarea_q_179010' 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-179011'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>14. <\/span>HOTSPOT <br \/>\r<br>You need to design the image processing and storage solutions. <br \/>\r<br>What should you recommend? 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=649 height=304 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/05\/image042-20.jpg\" v:shapes=\"_x0000_i1045\"><br><\/div><input type='hidden' name='question_id[]' id='qID_14' value='179011' \/><input type='hidden' id='answerType179011' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179011[]' id='textarea_q_179011' 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-179012'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>15. <\/span>What should you recommend to prevent users outside the Litware on-premises network from accessing the analytical data store?<\/div><input type='hidden' name='question_id[]' id='qID_15' value='179012' \/><input type='hidden' id='answerType179012' 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-179012[]' id='answer-id-721304' class='answer   answerof-179012 ' value='721304'   \/><label for='answer-id-721304' id='answer-label-721304' class=' answer'><span>a server-level virtual network rule<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179012[]' id='answer-id-721305' class='answer   answerof-179012 ' value='721305'   \/><label for='answer-id-721305' id='answer-label-721305' class=' answer'><span>a database-level virtual network rule<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179012[]' id='answer-id-721306' class='answer   answerof-179012 ' value='721306'   \/><label for='answer-id-721306' id='answer-label-721306' class=' answer'><span>a database-level firewall IP rule<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179012[]' id='answer-id-721307' class='answer   answerof-179012 ' value='721307'   \/><label for='answer-id-721307' id='answer-label-721307' class=' answer'><span>a server-level firewall IP rule<\/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-179013'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>16. <\/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_16' value='179013' \/><input type='hidden' id='answerType179013' 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-179013[]' id='answer-id-721308' class='answer   answerof-179013 ' value='721308'   \/><label for='answer-id-721308' id='answer-label-721308' class=' answer'><span>Azure Databricks<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179013[]' id='answer-id-721309' class='answer   answerof-179013 ' value='721309'   \/><label for='answer-id-721309' id='answer-label-721309' class=' answer'><span>Azure Data Lake Storage<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179013[]' id='answer-id-721310' class='answer   answerof-179013 ' value='721310'   \/><label for='answer-id-721310' id='answer-label-721310' class=' answer'><span>Azure SQL Data Warehouse<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179013[]' id='answer-id-721311' class='answer   answerof-179013 ' value='721311'   \/><label for='answer-id-721311' id='answer-label-721311' class=' answer'><span>Azure Cognitive Services<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179013[]' id='answer-id-721312' class='answer   answerof-179013 ' value='721312'   \/><label for='answer-id-721312' id='answer-label-721312' class=' answer'><span>Azure Batch<\/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-179014'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>17. <\/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_17' value='179014' \/><input type='hidden' id='answerType179014' 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-179014[]' id='answer-id-721313' class='answer   answerof-179014 ' value='721313'   \/><label for='answer-id-721313' id='answer-label-721313' class=' answer'><span>AzCopy<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179014[]' id='answer-id-721314' class='answer   answerof-179014 ' value='721314'   \/><label for='answer-id-721314' id='answer-label-721314' class=' answer'><span>AdlCopy<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179014[]' id='answer-id-721315' class='answer   answerof-179014 ' value='721315'   \/><label for='answer-id-721315' id='answer-label-721315' class=' answer'><span>Geo-Redundancy<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179014[]' id='answer-id-721316' class='answer   answerof-179014 ' value='721316'   \/><label for='answer-id-721316' id='answer-label-721316' class=' answer'><span>Geo-Replication<\/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-179015'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>18. <\/span>DRAG DROP <br \/>\r<br>You discover that the highest chance of corruption or bad data occurs during nightly inventory loads. <br \/>\r<br>You need to ensure that you can quickly restore the data to its state before the nightly load and avoid missing any streaming data. <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=650 height=416 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/05\/image046-18.jpg\" v:shapes=\"_x0000_i1047\"><br><\/div><input type='hidden' name='question_id[]' id='qID_18' value='179015' \/><input type='hidden' id='answerType179015' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179015[]' id='textarea_q_179015' 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-19' style=';'><div id='questionWrap-19'  class='   watupro-question-id-179016'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>19. <\/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. 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\/2021\/05\/image050-17.jpg\" v:shapes=\"_x0000_i1049\"><br><\/div><input type='hidden' name='question_id[]' id='qID_19' value='179016' \/><input type='hidden' id='answerType179016' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179016[]' id='textarea_q_179016' 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-179017'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>20. <\/span>What should you recommend using to secure sensitive customer contact information?<\/div><input type='hidden' name='question_id[]' id='qID_20' value='179017' \/><input type='hidden' id='answerType179017' 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-179017[]' id='answer-id-721319' class='answer   answerof-179017 ' value='721319'   \/><label for='answer-id-721319' id='answer-label-721319' class=' answer'><span>data labels<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179017[]' id='answer-id-721320' class='answer   answerof-179017 ' value='721320'   \/><label for='answer-id-721320' id='answer-label-721320' class=' answer'><span>column-level security<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179017[]' id='answer-id-721321' class='answer   answerof-179017 ' value='721321'   \/><label for='answer-id-721321' id='answer-label-721321' class=' answer'><span>row-level security<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179017[]' id='answer-id-721322' class='answer   answerof-179017 ' value='721322'   \/><label for='answer-id-721322' id='answer-label-721322' class=' answer'><span>Transparent Data Encryption (TDE)<\/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-179018'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>21. <\/span>You plan to use an Azure SQL data warehouse to store the customer data. You need to recommend a disaster recovery solution for the data warehouse. <br \/>\r<br>What should you include in the recommendation?<\/div><input type='hidden' name='question_id[]' id='qID_21' value='179018' \/><input type='hidden' id='answerType179018' 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-179018[]' id='answer-id-721323' class='answer   answerof-179018 ' value='721323'   \/><label for='answer-id-721323' id='answer-label-721323' class=' answer'><span>AzCopy<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179018[]' id='answer-id-721324' class='answer   answerof-179018 ' value='721324'   \/><label for='answer-id-721324' id='answer-label-721324' class=' answer'><span>Read-only replicas<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179018[]' id='answer-id-721325' class='answer   answerof-179018 ' value='721325'   \/><label for='answer-id-721325' id='answer-label-721325' class=' answer'><span>AdICopy<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179018[]' id='answer-id-721326' class='answer   answerof-179018 ' value='721326'   \/><label for='answer-id-721326' id='answer-label-721326' class=' answer'><span>Geo-Redundant backups<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-22' style=';'><div id='questionWrap-22'  class='   watupro-question-id-179019'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>22. <\/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. 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\/2021\/05\/image054-16.jpg\" v:shapes=\"_x0000_i1051\"><br><\/div><input type='hidden' name='question_id[]' id='qID_22' value='179019' \/><input type='hidden' id='answerType179019' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179019[]' id='textarea_q_179019' 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-23' style=';'><div id='questionWrap-23'  class='   watupro-question-id-179020'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>23. <\/span>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_23' value='179020' \/><input type='hidden' id='answerType179020' 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-179020[]' id='answer-id-721328' class='answer   answerof-179020 ' value='721328'   \/><label for='answer-id-721328' id='answer-label-721328' class=' answer'><span>Azure File Storage<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179020[]' id='answer-id-721329' class='answer   answerof-179020 ' value='721329'   \/><label for='answer-id-721329' id='answer-label-721329' class=' answer'><span>Azure Cosmos DB<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179020[]' id='answer-id-721330' class='answer   answerof-179020 ' value='721330'   \/><label for='answer-id-721330' id='answer-label-721330' class=' answer'><span>Azure Blob Storage<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179020[]' id='answer-id-721331' class='answer   answerof-179020 ' value='721331'   \/><label for='answer-id-721331' id='answer-label-721331' class=' answer'><span>Azure SQL Database<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179020[]' id='answer-id-721332' class='answer   answerof-179020 ' value='721332'   \/><label for='answer-id-721332' id='answer-label-721332' class=' answer'><span>Azure SQL Data Warehouse<\/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-179021'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>24. <\/span>Topic 3, Case study 2 <br \/>\r<br><br \/>\r<br>Case study <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. 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 questions in 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 section 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 in 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\/2021\/05\/image058-16.jpg\" v:shapes=\"_x0000_i1053\"><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><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 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. NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_24' value='179021' \/><input type='hidden' id='answerType179021' 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-179021[]' id='answer-id-721333' class='answer   answerof-179021 ' value='721333'   \/><label for='answer-id-721333' id='answer-label-721333' class=' answer'><span>Enable Data Discovery and Classification.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179021[]' id='answer-id-721334' class='answer   answerof-179021 ' value='721334'   \/><label for='answer-id-721334' id='answer-label-721334' class=' answer'><span>Implement Transparent Data Encryption (TDE).<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179021[]' id='answer-id-721335' class='answer   answerof-179021 ' value='721335'   \/><label for='answer-id-721335' id='answer-label-721335' class=' answer'><span>Enable Auditing.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179021[]' id='answer-id-721336' class='answer   answerof-179021 ' value='721336'   \/><label for='answer-id-721336' id='answer-label-721336' class=' answer'><span>Run Vulnerability Assessment.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179021[]' id='answer-id-721337' class='answer   answerof-179021 ' value='721337'   \/><label for='answer-id-721337' id='answer-label-721337' 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-179022'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>25. <\/span>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_25' value='179022' \/><input type='hidden' id='answerType179022' 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-179022[]' id='answer-id-721338' class='answer   answerof-179022 ' value='721338'   \/><label for='answer-id-721338' id='answer-label-721338' class=' answer'><span>Standard SSD Managed Disk<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179022[]' id='answer-id-721339' class='answer   answerof-179022 ' value='721339'   \/><label for='answer-id-721339' id='answer-label-721339' class=' answer'><span>Premium SSD Managed Disk<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179022[]' id='answer-id-721340' class='answer   answerof-179022 ' value='721340'   \/><label for='answer-id-721340' id='answer-label-721340' class=' answer'><span>Ultra SSD Managed Disk<\/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-179023'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>26. <\/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>&#10001; Department managers must be able to create new database. <br \/>\r<br>&#10001; The IT department must assign users to databases. <br \/>\r<br>&#10001; 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. 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\/2021\/05\/image064-15.jpg\" v:shapes=\"_x0000_i1056\"><br><\/div><input type='hidden' name='question_id[]' id='qID_26' value='179023' \/><input type='hidden' id='answerType179023' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179023[]' id='textarea_q_179023' 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-27' style=';'><div id='questionWrap-27'  class='   watupro-question-id-179024'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>27. <\/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_27' value='179024' \/><input type='hidden' id='answerType179024' 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-179024[]' id='answer-id-721342' class='answer   answerof-179024 ' value='721342'   \/><label for='answer-id-721342' id='answer-label-721342' class=' answer'><span>Enable auto-shrink on the database.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179024[]' id='answer-id-721343' class='answer   answerof-179024 ' value='721343'   \/><label for='answer-id-721343' id='answer-label-721343' class=' answer'><span>Flush the blob cache using Windows PowerShell.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179024[]' id='answer-id-721344' class='answer   answerof-179024 ' value='721344'   \/><label for='answer-id-721344' id='answer-label-721344' class=' answer'><span>Enable Apache Spark RDD (RDD) caching.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179024[]' id='answer-id-721345' class='answer   answerof-179024 ' value='721345'   \/><label for='answer-id-721345' id='answer-label-721345' class=' answer'><span>Enable Databricks IO (DBIO) caching.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179024[]' id='answer-id-721346' class='answer   answerof-179024 ' value='721346'   \/><label for='answer-id-721346' id='answer-label-721346' 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-28' style=';'><div id='questionWrap-28'  class='   watupro-question-id-179025'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>28. <\/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_28' value='179025' \/><input type='hidden' id='answerType179025' 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-179025[]' id='answer-id-721347' class='answer   answerof-179025 ' value='721347'   \/><label for='answer-id-721347' id='answer-label-721347' class=' answer'><span>AlwaysOn<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179025[]' id='answer-id-721348' class='answer   answerof-179025 ' value='721348'   \/><label for='answer-id-721348' id='answer-label-721348' class=' answer'><span>Transactional processing<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179025[]' id='answer-id-721349' class='answer   answerof-179025 ' value='721349'   \/><label for='answer-id-721349' id='answer-label-721349' class=' answer'><span>General<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179025[]' id='answer-id-721350' class='answer   answerof-179025 ' value='721350'   \/><label for='answer-id-721350' id='answer-label-721350' class=' answer'><span>Data warehousing<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-29' style=';'><div id='questionWrap-29'  class='   watupro-question-id-179026'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>29. <\/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_29' value='179026' \/><input type='hidden' id='answerType179026' 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-179026[]' id='answer-id-721351' class='answer   answerof-179026 ' value='721351'   \/><label for='answer-id-721351' id='answer-label-721351' class=' answer'><span>Transparent Data Encryption<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179026[]' id='answer-id-721352' class='answer   answerof-179026 ' value='721352'   \/><label for='answer-id-721352' id='answer-label-721352' class=' answer'><span>Always Encrypted with secure enclaves<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179026[]' id='answer-id-721353' class='answer   answerof-179026 ' value='721353'   \/><label for='answer-id-721353' id='answer-label-721353' class=' answer'><span>Azure Disk Encryption<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179026[]' id='answer-id-721354' class='answer   answerof-179026 ' value='721354'   \/><label for='answer-id-721354' id='answer-label-721354' class=' answer'><span>SQL Server AlwaysOn<\/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-179027'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>30. <\/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_30' value='179027' \/><input type='hidden' id='answerType179027' 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-179027[]' id='answer-id-721355' class='answer   answerof-179027 ' value='721355'   \/><label for='answer-id-721355' id='answer-label-721355' class=' answer'><span>Use AzCopy and store the data in Azure.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179027[]' id='answer-id-721356' class='answer   answerof-179027 ' value='721356'   \/><label for='answer-id-721356' id='answer-label-721356' 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='checkbox' name='answer-179027[]' id='answer-id-721357' class='answer   answerof-179027 ' value='721357'   \/><label for='answer-id-721357' id='answer-label-721357' class=' answer'><span>Configure Accelerated Database Recovery.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179027[]' id='answer-id-721358' class='answer   answerof-179027 ' value='721358'   \/><label for='answer-id-721358' id='answer-label-721358' class=' answer'><span>Use DWLoader.<\/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-179028'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>31. <\/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\/2021\/05\/image068-13.jpg\" v:shapes=\"_x0000_i1058\"><br><\/div><input type='hidden' name='question_id[]' id='qID_31' value='179028' \/><input type='hidden' id='answerType179028' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179028[]' id='textarea_q_179028' 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-32' style=';'><div id='questionWrap-32'  class='   watupro-question-id-179029'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>32. <\/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_32' value='179029' \/><input type='hidden' id='answerType179029' 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-179029[]' id='answer-id-721360' class='answer   answerof-179029 ' value='721360'   \/><label for='answer-id-721360' id='answer-label-721360' class=' answer'><span>Business Critical<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179029[]' id='answer-id-721361' class='answer   answerof-179029 ' value='721361'   \/><label for='answer-id-721361' id='answer-label-721361' class=' answer'><span>General Purpose<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179029[]' id='answer-id-721362' class='answer   answerof-179029 ' value='721362'   \/><label for='answer-id-721362' id='answer-label-721362' class=' answer'><span>Premium<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179029[]' id='answer-id-721363' class='answer   answerof-179029 ' value='721363'   \/><label for='answer-id-721363' id='answer-label-721363' class=' answer'><span>Standard<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179029[]' id='answer-id-721364' class='answer   answerof-179029 ' value='721364'   \/><label for='answer-id-721364' id='answer-label-721364' class=' answer'><span>Basic<\/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-179030'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>33. <\/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. NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_33' value='179030' \/><input type='hidden' id='answerType179030' 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-179030[]' id='answer-id-721365' class='answer   answerof-179030 ' value='721365'   \/><label for='answer-id-721365' id='answer-label-721365' 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-179030[]' id='answer-id-721366' class='answer   answerof-179030 ' value='721366'   \/><label for='answer-id-721366' id='answer-label-721366' 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-179030[]' id='answer-id-721367' class='answer   answerof-179030 ' value='721367'   \/><label for='answer-id-721367' id='answer-label-721367' class=' answer'><span>Use zone redundant storage.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179030[]' id='answer-id-721368' class='answer   answerof-179030 ' value='721368'   \/><label for='answer-id-721368' id='answer-label-721368' 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-179030[]' id='answer-id-721369' class='answer   answerof-179030 ' value='721369'   \/><label for='answer-id-721369' id='answer-label-721369' class=' answer'><span>Use Geo-redundant storage.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179030[]' id='answer-id-721370' class='answer   answerof-179030 ' value='721370'   \/><label for='answer-id-721370' id='answer-label-721370' 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-34' style=';'><div id='questionWrap-34'  class='   watupro-question-id-179031'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>34. <\/span>Topic 4, ADatum Corporation <br \/>\r<br>Case study <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. 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 questions in 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 section 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 in 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>Overview <br \/>\r<br>General Overview <br \/>\r<br>ADatum Corporation is a medical company that has 5,000 physicians located in more than 300 hospitals across the US. The company has a medical department, a sales department, a marketing department, a medical research department, and a human resources department. <br \/>\r<br><br \/>\r<br>You are redesigning the application environment of ADatum. <br \/>\r<br><br \/>\r<br>Physical Locations <br \/>\r<br>ADatum has three main offices in New York, Dallas, and Los Angeles. The offices connect to each other by using a WAN link. Each office connects directly to the Internet. The Los Angeles office also has a datacenter that hosts all the company's applications. <br \/>\r<br><br \/>\r<br>Existing Environment <br \/>\r<br>Health Review <br \/>\r<br>ADatum has a critical OLTP web application named Health Review that physicians use to track billing, patient care, and overall physician best practices. <br \/>\r<br><br \/>\r<br>Health Interface <br \/>\r<br>ADatum has a critical application named Health Interface that receives hospital messages related to patient care and status updates. The messages are sent in batches by each hospital's enterprise relationship management (ERM) system by using a VPN. The data sent from each hospital can have varying columns and formats. <br \/>\r<br><br \/>\r<br>Currently, a custom C# application is used to send the data to Health Interface. The application uses deprecated libraries and a new solution must be designed for this functionality. <br \/>\r<br><br \/>\r<br>Health Insights <br \/>\r<br>ADatum has a web-based reporting system named Health Insights that shows hospital and patient insights to physicians and business users. The data is created from the data in Health Review and Health Interface, as well as manual entries. <br \/>\r<br><br \/>\r<br>Database Platform <br \/>\r<br>Currently, the databases for all three applications are hosted on an out-of-date VMware cluster that has a single instance of Microsoft SQL Server 2012. <br \/>\r<br><br \/>\r<br>Problem Statements <br \/>\r<br>ADatum identifies the following issues in its current environment: <br \/>\r<br>- Over time, the data received by Health Interface from the hospitals has slowed, and the number of messages has increased. <br \/>\r<br>- When a new hospital joins ADatum, Health Interface requires a schema modification due to the lack of data standardization. <br \/>\r<br>- The speed of batch data processing is inconsistent. <br \/>\r<br><br \/>\r<br>Business Requirements <br \/>\r<br>Business Goals <br \/>\r<br>ADatum identifies the following business goals: <br \/>\r<br>- Migrate the applications to Azure whenever possible. <br \/>\r<br>- Minimize the development effort required to perform data movement. <br \/>\r<br>- Provide continuous integration and deployment for development, test, and production environments. <br \/>\r<br>- Provide faster access to the applications and the data and provide more consistent application performance. <br \/>\r<br>- Minimize the number of services required to perform data processing, development, scheduling, monitoring, and the operationalizing of pipelines. <br \/>\r<br><br \/>\r<br>Health Review Requirements <br \/>\r<br>ADatum identifies the following requirements for the Health Review application: <br \/>\r<br>- Ensure that sensitive health data is encrypted at rest and in transit. <br \/>\r<br>- Tag all the sensitive health data in Health Review. The data will be used for auditing. <br \/>\r<br><br \/>\r<br>Health Interface Requirements <br \/>\r<br>ADatum identifies the following requirements for the Health Interface application: <br \/>\r<br>- Upgrade to a data storage solution that will provide flexible schemas and increased throughput for writing data. Data must be regionally located close to each hospital, and reads must display be the most recent committed version of an item. <br \/>\r<br>- Reduce the amount of time it takes to add data from new hospitals to Health Interface. <br \/>\r<br>- Support a more scalable batch processing solution in Azure. <br \/>\r<br>- Reduce the amount of development effort to rewrite existing SQL queries. <br \/>\r<br><br \/>\r<br>Health Insights Requirements <br \/>\r<br>ADatum identifies the following requirements for the Health Insights application: <br \/>\r<br>- The analysis of events must be performed over time by using an organizational date dimension table. <br \/>\r<br>- The data from Health Interface and Health Review must be available in Health Insights within 15 minutes of being committed. <br \/>\r<br>- The new Health Insights application must be built on a massively parallel processing (MPP) architecture that will support the high performance of joins on large fact tables. <br \/>\r<br><br \/>\r<br>HOTSPOT <br \/>\r<br>Which Azure data storage solution should you recommend for each application? 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=532 height=427 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/05\/image072-11.jpg\" v:shapes=\"_x0000_i1060\"><br><\/div><input type='hidden' name='question_id[]' id='qID_34' value='179031' \/><input type='hidden' id='answerType179031' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179031[]' id='textarea_q_179031' 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-179032'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>35. <\/span>You need to recommend a security solution that meets the requirements of Health Review. <br \/>\r<br>What should you include in the recommendation?<\/div><input type='hidden' name='question_id[]' id='qID_35' value='179032' \/><input type='hidden' id='answerType179032' 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-179032[]' id='answer-id-721372' class='answer   answerof-179032 ' value='721372'   \/><label for='answer-id-721372' id='answer-label-721372' class=' answer'><span>dynamic data masking<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179032[]' id='answer-id-721373' class='answer   answerof-179032 ' value='721373'   \/><label for='answer-id-721373' id='answer-label-721373' class=' answer'><span>Transport Layer Security (TLS)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179032[]' id='answer-id-721374' class='answer   answerof-179032 ' value='721374'   \/><label for='answer-id-721374' id='answer-label-721374' class=' answer'><span>Always Encrypted<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179032[]' id='answer-id-721375' class='answer   answerof-179032 ' value='721375'   \/><label for='answer-id-721375' id='answer-label-721375' class=' answer'><span>row-level security<\/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-179033'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>36. <\/span>You need to recommend a solution that meets the data platform requirements of Health Interface. The solution must minimize redevelopment efforts for the application. <br \/>\r<br>What should you include in the recommendation?<\/div><input type='hidden' name='question_id[]' id='qID_36' value='179033' \/><input type='hidden' id='answerType179033' 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-179033[]' id='answer-id-721376' class='answer   answerof-179033 ' value='721376'   \/><label for='answer-id-721376' id='answer-label-721376' class=' answer'><span>Azure SQL Data Warehouse<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179033[]' id='answer-id-721377' class='answer   answerof-179033 ' value='721377'   \/><label for='answer-id-721377' id='answer-label-721377' class=' answer'><span>Azure SQL Database<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179033[]' id='answer-id-721378' class='answer   answerof-179033 ' value='721378'   \/><label for='answer-id-721378' id='answer-label-721378' class=' answer'><span>Azure Cosmos DB that uses the SQL API<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179033[]' id='answer-id-721379' class='answer   answerof-179033 ' value='721379'   \/><label for='answer-id-721379' id='answer-label-721379' class=' answer'><span>Azure Cosmos DB that uses the Table API<\/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-179034'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>37. <\/span>Which consistency level should you use for Health Interface?<\/div><input type='hidden' name='question_id[]' id='qID_37' value='179034' \/><input type='hidden' id='answerType179034' 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-179034[]' id='answer-id-721380' class='answer   answerof-179034 ' value='721380'   \/><label for='answer-id-721380' id='answer-label-721380' class=' answer'><span>Consistent Prefix<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179034[]' id='answer-id-721381' class='answer   answerof-179034 ' value='721381'   \/><label for='answer-id-721381' id='answer-label-721381' class=' answer'><span>Session<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179034[]' id='answer-id-721382' class='answer   answerof-179034 ' value='721382'   \/><label for='answer-id-721382' id='answer-label-721382' class=' answer'><span>Bounded Staleness<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179034[]' id='answer-id-721383' class='answer   answerof-179034 ' value='721383'   \/><label for='answer-id-721383' id='answer-label-721383' class=' answer'><span>Strong<\/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-179035'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>38. <\/span>You need to design a solution that meets the business requirements of Health Insights. <br \/>\r<br>What should you include in the recommendation?<\/div><input type='hidden' name='question_id[]' id='qID_38' value='179035' \/><input type='hidden' id='answerType179035' 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-179035[]' id='answer-id-721384' class='answer   answerof-179035 ' value='721384'   \/><label for='answer-id-721384' id='answer-label-721384' class=' answer'><span>Azure Cosmos DB that uses the Gremlin<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179035[]' id='answer-id-721385' class='answer   answerof-179035 ' value='721385'   \/><label for='answer-id-721385' id='answer-label-721385' class=' answer'><span>Azure Data Factory<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179035[]' id='answer-id-721386' class='answer   answerof-179035 ' value='721386'   \/><label for='answer-id-721386' id='answer-label-721386' class=' answer'><span>Azure Cosmos DB that uses the SQL API<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179035[]' id='answer-id-721387' class='answer   answerof-179035 ' value='721387'   \/><label for='answer-id-721387' id='answer-label-721387' class=' answer'><span>Azure Databricks<\/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-179036'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>39. <\/span>You need to recommend a solution to quickly identify all the columns in Health Review that contain sensitive health data. <br \/>\r<br>What should you include in the recommendation?<\/div><input type='hidden' name='question_id[]' id='qID_39' value='179036' \/><input type='hidden' id='answerType179036' 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-179036[]' id='answer-id-721388' class='answer   answerof-179036 ' value='721388'   \/><label for='answer-id-721388' id='answer-label-721388' class=' answer'><span>classifications<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179036[]' id='answer-id-721389' class='answer   answerof-179036 ' value='721389'   \/><label for='answer-id-721389' id='answer-label-721389' class=' answer'><span>data masking<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179036[]' id='answer-id-721390' class='answer   answerof-179036 ' value='721390'   \/><label for='answer-id-721390' id='answer-label-721390' class=' answer'><span>SQL Server auditing<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179036[]' id='answer-id-721391' class='answer   answerof-179036 ' value='721391'   \/><label for='answer-id-721391' id='answer-label-721391' class=' answer'><span>Azure tags<\/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-179037'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>40. <\/span>What should you recommend as a batch processing solution for Health Interface?<\/div><input type='hidden' name='question_id[]' id='qID_40' value='179037' \/><input type='hidden' id='answerType179037' 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-179037[]' id='answer-id-721392' class='answer   answerof-179037 ' value='721392'   \/><label for='answer-id-721392' id='answer-label-721392' class=' answer'><span>Azure CycleCloud<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179037[]' id='answer-id-721393' class='answer   answerof-179037 ' value='721393'   \/><label for='answer-id-721393' id='answer-label-721393' class=' answer'><span>Azure Stream Analytics<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179037[]' id='answer-id-721394' class='answer   answerof-179037 ' value='721394'   \/><label for='answer-id-721394' id='answer-label-721394' class=' answer'><span>Azure Data Factory<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179037[]' id='answer-id-721395' class='answer   answerof-179037 ' value='721395'   \/><label for='answer-id-721395' id='answer-label-721395' class=' answer'><span>Azure Databricks<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-41' style=';'><div id='questionWrap-41'  class='   watupro-question-id-179038'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>41. <\/span>HOTSPOT <br \/>\r<br>You need to design the storage for the Health Insights data platform. <br \/>\r<br>Which types of tables should you include in the design? 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=560 height=377 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/05\/image076-10.jpg\" v:shapes=\"_x0000_i1062\"><br><\/div><input type='hidden' name='question_id[]' id='qID_41' value='179038' \/><input type='hidden' id='answerType179038' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179038[]' id='textarea_q_179038' 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-179039'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>42. <\/span>Topic 5, Data Engineer for Trey Research <br \/>\r<br><br \/>\r<br>Overview <br \/>\r<br>You are a data engineer for Trey Research. The company is close to completing a joint project with the government to build smart highways infrastructure across North America. This involves the placement of sensors and cameras to measure traffic flow, car speed, and vehicle details. <br \/>\r<br><br \/>\r<br>You have been asked to design a cloud solution that will meet the business and technical requirements of the smart highway. <br \/>\r<br><br \/>\r<br>Solution components <br \/>\r<br>Telemetry Capture <br \/>\r<br>The telemetry capture system records each time a vehicle passes in front of a sensor. <br \/>\r<br>The sensors run on a custom embedded operating system and record the following telemetry data: <br \/>\r<br>- Time <br \/>\r<br>- Location in latitude and longitude <br \/>\r<br>- Speed in kilometers per hour (kmph) <br \/>\r<br>- Length of vehicle in meters <br \/>\r<br><br \/>\r<br>Visual Monitoring <br \/>\r<br>The visual monitoring system is a network of approximately 1,000 cameras placed near highways that capture images of vehicle traffic every 2 seconds. The cameras record high resolution images. Each image is approximately 3 MB in size. <br \/>\r<br><br \/>\r<br>Requirements: Business <br \/>\r<br><br \/>\r<br>The company identifies the following business requirements: <br \/>\r<br>- External vendors must be able to perform custom analysis of data using machine learning technologies. <br \/>\r<br>- You must display a dashboard on the operations status page that displays the following metrics: telemetry, volume, and processing latency. <br \/>\r<br>- Traffic data must be made available to the Government Planning Department for the purpose of modeling changes to the highway system. The traffic data will be used in conjunction with other data such as information about events such as sporting events, weather conditions, and population statistics. External data used during the modeling is stored in on-premises SQL Server 2016 databases and CSV files stored in an Azure Data Lake Storage Gen2 storage account. <br \/>\r<br>- Information about vehicles that have been detected as going over the speed limit during the last 30 minutes must be available to law enforcement officers. Several law enforcement organizations may respond to speeding vehicles. <br \/>\r<br>- The solution must allow for searches of vehicle images by license plate to support law enforcement investigations. Searches must be able to be performed using a query language and must support fuzzy searches to compensate for license plate detection errors. <br \/>\r<br><br \/>\r<br>Requirements: Security <br \/>\r<br>The solution must meet the following security requirements: <br \/>\r<br>- External vendors must not have direct access to sensor data or images. <br \/>\r<br>- Images produced by the vehicle monitoring solution must be deleted after one month. You must minimize costs associated with deleting images from the data store. <br \/>\r<br>- Unauthorized usage of data must be detected in real time. Unauthorized usage is determined by looking for unusual usage patterns. <br \/>\r<br>- All changes to Azure resources used by the solution must be recorded and stored. Data must be provided to the security team for incident response purposes. <br \/>\r<br><br \/>\r<br>Requirements: Sensor data <br \/>\r<br>You must write all telemetry data to the closest Azure region. The sensors used for the telemetry capture system have a small amount of memory available and so must write data as quickly as possible to avoid losing telemetry data. <br \/>\r<br><br \/>\r<br>You need to design the storage for the telemetry capture system. <br \/>\r<br>What storage solution should you use in the design?<\/div><input type='hidden' name='question_id[]' id='qID_42' value='179039' \/><input type='hidden' id='answerType179039' 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-179039[]' id='answer-id-721397' class='answer   answerof-179039 ' value='721397'   \/><label for='answer-id-721397' id='answer-label-721397' class=' answer'><span>Azure SQL Data Warehouse<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179039[]' id='answer-id-721398' class='answer   answerof-179039 ' value='721398'   \/><label for='answer-id-721398' id='answer-label-721398' class=' answer'><span>Azure Databricks<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179039[]' id='answer-id-721399' class='answer   answerof-179039 ' value='721399'   \/><label for='answer-id-721399' id='answer-label-721399' class=' answer'><span>Azure Cosmos DB<\/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-179040'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>43. <\/span>You need to design the storage for the visual monitoring system. <br \/>\r<br>Which storage solution should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_43' value='179040' \/><input type='hidden' id='answerType179040' 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-179040[]' id='answer-id-721400' class='answer   answerof-179040 ' value='721400'   \/><label for='answer-id-721400' id='answer-label-721400' class=' answer'><span>Azure Blob storage<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179040[]' id='answer-id-721401' class='answer   answerof-179040 ' value='721401'   \/><label for='answer-id-721401' id='answer-label-721401' class=' answer'><span>Azure Table storage<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179040[]' id='answer-id-721402' class='answer   answerof-179040 ' value='721402'   \/><label for='answer-id-721402' id='answer-label-721402' class=' answer'><span>Azure SQL database<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179040[]' id='answer-id-721403' class='answer   answerof-179040 ' value='721403'   \/><label for='answer-id-721403' id='answer-label-721403' class=' answer'><span>Azure Media Services<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-44' style=';'><div id='questionWrap-44'  class='   watupro-question-id-179041'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>44. <\/span>You need to design the unauthorized data usage detection system. <br \/>\r<br>What Azure service should you include in the design?<\/div><input type='hidden' name='question_id[]' id='qID_44' value='179041' \/><input type='hidden' id='answerType179041' 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-179041[]' id='answer-id-721404' class='answer   answerof-179041 ' value='721404'   \/><label for='answer-id-721404' id='answer-label-721404' class=' answer'><span>Azure Databricks<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179041[]' id='answer-id-721405' class='answer   answerof-179041 ' value='721405'   \/><label for='answer-id-721405' id='answer-label-721405' class=' answer'><span>Azure SQL Data Warehouse<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179041[]' id='answer-id-721406' class='answer   answerof-179041 ' value='721406'   \/><label for='answer-id-721406' id='answer-label-721406' class=' answer'><span>Azure Analysis Services<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179041[]' id='answer-id-721407' class='answer   answerof-179041 ' value='721407'   \/><label for='answer-id-721407' id='answer-label-721407' class=' answer'><span>Azure Data Factory<\/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-179042'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>45. <\/span>DRAG DROP <br \/>\r<br>You need to design the system for notifying law enforcement officers about speeding vehicles. <br \/>\r<br>How should you design the pipeline? To answer, drag the appropriate services to the correct locations. Each service 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=649 height=150 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/05\/image080-10.jpg\" v:shapes=\"_x0000_i1064\"><br><\/div><input type='hidden' name='question_id[]' id='qID_45' value='179042' \/><input type='hidden' id='answerType179042' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179042[]' id='textarea_q_179042' 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-179043'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>46. <\/span>You need to design the solution for the government planning department. <br \/>\r<br>Which services should you include in the design?<\/div><input type='hidden' name='question_id[]' id='qID_46' value='179043' \/><input type='hidden' id='answerType179043' 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-179043[]' id='answer-id-721409' class='answer   answerof-179043 ' value='721409'   \/><label for='answer-id-721409' id='answer-label-721409' class=' answer'><span>Azure SQL Data Warehouse and Elastic Queries<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179043[]' id='answer-id-721410' class='answer   answerof-179043 ' value='721410'   \/><label for='answer-id-721410' id='answer-label-721410' class=' answer'><span>Azure SQL Database and Polybase<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179043[]' id='answer-id-721411' class='answer   answerof-179043 ' value='721411'   \/><label for='answer-id-721411' id='answer-label-721411' class=' answer'><span>Azure SQL Data Warehouse and Polybase<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179043[]' id='answer-id-721412' class='answer   answerof-179043 ' value='721412'   \/><label for='answer-id-721412' id='answer-label-721412' class=' answer'><span>Azure SQL Database and Elastic Queries<\/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-179044'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>47. <\/span>Topic 6, Litware Case <br \/>\r<br><br \/>\r<br>Case study <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. 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 questions in 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 section 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 in 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>Overview <br \/>\r<br>Litware, Inc. owns and operates 300 convenience stores across the US. The company sells a variety of packaged foods and drinks, as well as a variety of prepared foods, such as sandwiches and pizzas. <br \/>\r<br>Litware has a loyalty club whereby members can get daily discounts on specific items by providing their membership number at checkout. <br \/>\r<br>Litware employs business analysts who prefer to analyze data by using Microsoft Power BI, and data scientists who prefer analyzing data in Azure Databricks notebooks. <br \/>\r<br><br \/>\r<br>Requirements. Business Goals <br \/>\r<br>Litware wants to create a new analytics environment in Azure to meet the following requirements: <br \/>\r<br>- See inventory levels across the stores. Data must be updated as close to real time as possible. <br \/>\r<br>- Execute ad hoc analytical queries on historical data to identify whether the loyalty club discounts increase sales of the discounted products. <br \/>\r<br>- Every four hours, notify store employees about how many prepared food items to produce based on historical demand from the sales data. <br \/>\r<br><br \/>\r<br>Requirements. Technical Requirements <br \/>\r<br>Litware identifies the following technical requirements: <br \/>\r<br>- Minimize the number of different Azure services needed to achieve the business goals <br \/>\r<br>- Use platform as a service (PaaS) offerings whenever possible and avoid having to provision virtual machines that must be managed by Litware. <br \/>\r<br>- Ensure that the analytical data store is accessible only to the company\u2019s on-premises network and Azure services. <br \/>\r<br>- Use Azure Active Directory (Azure AD) authentication whenever possible. <br \/>\r<br>- Use the principle of least privilege when designing security. <br \/>\r<br>- Stage inventory data in Azure Data Lake Storage Gen2 before loading the data into the analytical data store. Litware wants to remove transient data from Data Lake Storage once the data is no longer in use. Files that have a modified date that is older than 14 days must be removed. <br \/>\r<br>- Limit the business analysts\u2019 access to customer contact information, such as phone numbers, because this type of data is not analytically relevant. <br \/>\r<br>- Ensure that you can quickly restore a copy of the analytical data store within one hour in the event of corruption or accidental deletion. <br \/>\r<br><br \/>\r<br>Requirements. Planned Environment <br \/>\r<br>Litware plans to implement the following environment: <br \/>\r<br>- The application development team will create an Azure event hub to receive real-time sales data, including store number, date, time, product ID, customer loyalty number, price, and discount amount, from the point of sale (POS) system and output the data to data storage in Azure. <br \/>\r<br>- Customer data, including name, contact information, and loyalty number, comes from Salesforce and can be imported into Azure once every eight hours. Row modified dates are not trusted in the source table. <br \/>\r<br>- Product data, including product ID, name, and category, comes from Salesforce and can be imported into Azure once every eight hours. Row modified dates are not trusted in the source table. <br \/>\r<br>- Daily inventory data comes from a Microsoft SQL server located on a private network. <br \/>\r<br>- Litware currently has 5 TB of historical sales data and 100 GB of customer data. The company expects approximately 100 GB of new data per month for the next year. <br \/>\r<br>- Litware will build a custom application named FoodPrep to provide store employees with the calculation results of how many prepared food items to produce every four hours. <br \/>\r<br>- Litware does not plan to implement Azure ExpressRoute or a VPN between the on-premises network and Azure. <br \/>\r<br><br \/>\r<br>What should you do to improve high availability of the real-time data processing solution?<\/div><input type='hidden' name='question_id[]' id='qID_47' value='179044' \/><input type='hidden' id='answerType179044' 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-179044[]' id='answer-id-721413' class='answer   answerof-179044 ' value='721413'   \/><label for='answer-id-721413' id='answer-label-721413' class=' answer'><span>Deploy identical Azure Stream Analytics jobs to paired regions in Azure.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179044[]' id='answer-id-721414' class='answer   answerof-179044 ' value='721414'   \/><label for='answer-id-721414' id='answer-label-721414' class=' answer'><span>Deploy a High Concurrency Databricks cluster.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179044[]' id='answer-id-721415' class='answer   answerof-179044 ' value='721415'   \/><label for='answer-id-721415' id='answer-label-721415' class=' answer'><span>Deploy an Azure Stream Analytics job and use an Azure Automation runbook to check the status of the job and to start the job if it stops.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179044[]' id='answer-id-721416' class='answer   answerof-179044 ' value='721416'   \/><label for='answer-id-721416' id='answer-label-721416' class=' answer'><span>Set Data Lake Storage to use geo-redundant storage (GRS).<\/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-179045'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>48. <\/span>Inventory levels must be calculated by subtracting the current day's sales from the previous day's final inventory. <br \/>\r<br>Which two options provide Litware with the ability to quickly calculate the current inventory levels by store and product? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_48' value='179045' \/><input type='hidden' id='answerType179045' 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-179045[]' id='answer-id-721417' class='answer   answerof-179045 ' value='721417'   \/><label for='answer-id-721417' id='answer-label-721417' class=' answer'><span>Consume the output of the event hub by using Azure Stream Analytics and aggregate the data by store and product. Output the resulting data directly to Azure Synapse Analytics. Use Transact-SQL to calculate the inventory levels.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179045[]' id='answer-id-721418' class='answer   answerof-179045 ' value='721418'   \/><label for='answer-id-721418' id='answer-label-721418' class=' answer'><span>Output Event Hubs Avro files to Azure Blob storage. Use Transact-SQL to calculate the inventory levels by using PolyBase in Azure Synapse Analytics.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179045[]' id='answer-id-721419' class='answer   answerof-179045 ' value='721419'   \/><label for='answer-id-721419' id='answer-label-721419' class=' answer'><span>Consume the output of the event hub by using Databricks. Use Databricks to calculate the inventory levels and output the data to Azure Synapse Analytics.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179045[]' id='answer-id-721420' class='answer   answerof-179045 ' value='721420'   \/><label for='answer-id-721420' id='answer-label-721420' class=' answer'><span>Consume the output of the event hub by using Azure Stream Analytics and aggregate the data by store and product. Output the resulting data into Databricks. Calculate the inventory levels in Databricks and output the data to Azure Blob storage.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179045[]' id='answer-id-721421' class='answer   answerof-179045 ' value='721421'   \/><label for='answer-id-721421' id='answer-label-721421' class=' answer'><span>Output Event Hubs Avro files to Azure Blob storage. Trigger an Azure Data Factory copy activity to run every 10 minutes to load the data into Azure Synapse Analytics. Use Transact-SQL to aggregate the data by store and product.<\/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-179046'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>49. <\/span>HOTSPOT <br \/>\r<br>Which Azure service and feature should you recommend using to manage the transient data for Data Lake Storage? 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=504 height=341 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/05\/image086-10.jpg\" v:shapes=\"_x0000_i1067\"><br><\/div><input type='hidden' name='question_id[]' id='qID_49' value='179046' \/><input type='hidden' id='answerType179046' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179046[]' id='textarea_q_179046' 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-179047'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>50. <\/span>Which Azure service should you recommend for the analytical data store so that the business analysts and data scientists can execute ad hoc queries as quickly as possible?<\/div><input type='hidden' name='question_id[]' id='qID_50' value='179047' \/><input type='hidden' id='answerType179047' 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-179047[]' id='answer-id-721423' class='answer   answerof-179047 ' value='721423'   \/><label for='answer-id-721423' id='answer-label-721423' class=' answer'><span>Azure Data Lake Storage Gen2<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179047[]' id='answer-id-721424' class='answer   answerof-179047 ' value='721424'   \/><label for='answer-id-721424' id='answer-label-721424' class=' answer'><span>Azure Cosmos DB<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179047[]' id='answer-id-721425' class='answer   answerof-179047 ' value='721425'   \/><label for='answer-id-721425' id='answer-label-721425' class=' answer'><span>Azure SQL Database<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179047[]' id='answer-id-721426' class='answer   answerof-179047 ' value='721426'   \/><label for='answer-id-721426' id='answer-label-721426' class=' answer'><span>Azure SQL Data Warehouse<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-51' style=';'><div id='questionWrap-51'  class='   watupro-question-id-179048'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>51. <\/span>HOTSPOT <br \/>\r<br>Which Azure Data Factory components should you recommend using together to import the customer data from Salesforce to Data Lake Storage? 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=434 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/05\/image092-10.jpg\" v:shapes=\"_x0000_i1070\"><br><\/div><input type='hidden' name='question_id[]' id='qID_51' value='179048' \/><input type='hidden' id='answerType179048' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179048[]' id='textarea_q_179048' 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-52' style=';'><div id='questionWrap-52'  class='   watupro-question-id-179049'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>52. <\/span>HOTSPOT <br \/>\r<br>Which Azure Data Factory components should you recommend using together to import the daily inventory data from SQL to Data Lake Storage? 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=457 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/05\/image096-9.jpg\" v:shapes=\"_x0000_i1072\"><br><\/div><input type='hidden' name='question_id[]' id='qID_52' value='179049' \/><input type='hidden' id='answerType179049' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179049[]' id='textarea_q_179049' 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-179050'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>53. <\/span>Topic 7, Misc. Questions <br \/>\r<br><br \/>\r<br>HOTSPOT <br \/>\r<br>You manage an on-premises server named Server1 that has a database named Database1. The company purchases a new application that can access data from Azure SQL Database. <br \/>\r<br>You recommend a solution to migrate Database1 to an Azure SQL Database instance. <br \/>\r<br>What should you recommend? 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=649 height=250 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/05\/image100-9.jpg\" v:shapes=\"_x0000_i1074\"><br><\/div><input type='hidden' name='question_id[]' id='qID_53' value='179050' \/><input type='hidden' id='answerType179050' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179050[]' id='textarea_q_179050' 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-54' style=';'><div id='questionWrap-54'  class='   watupro-question-id-179051'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>54. <\/span>You are designing a statistical analysis solution that will use custom proprietary Python functions on near real-time data from Azure Event Hubs. <br \/>\r<br>You need to recommend which Azure service to use to perform the statistical analysis. The solution must minimize latency. <br \/>\r<br>What should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_54' value='179051' \/><input type='hidden' id='answerType179051' 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-179051[]' id='answer-id-721430' class='answer   answerof-179051 ' value='721430'   \/><label for='answer-id-721430' id='answer-label-721430' class=' answer'><span>Azure Synapse Analytics<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179051[]' id='answer-id-721431' class='answer   answerof-179051 ' value='721431'   \/><label for='answer-id-721431' id='answer-label-721431' class=' answer'><span>Azure Stream Analytics<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179051[]' id='answer-id-721432' class='answer   answerof-179051 ' value='721432'   \/><label for='answer-id-721432' id='answer-label-721432' class=' answer'><span>Azure Databricks<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179051[]' id='answer-id-721433' class='answer   answerof-179051 ' value='721433'   \/><label for='answer-id-721433' id='answer-label-721433' class=' answer'><span>Azure SQL Database<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-55' style=';'><div id='questionWrap-55'  class='   watupro-question-id-179052'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>55. <\/span>You plan to create an Azure Synapse Analytics dedicated SQL pool. <br \/>\r<br>You need to minimize the time it takes to identify queries that return confidential information as defined by the company\u2019s data privacy regulations and the users who executed the queries. <br \/>\r<br>Which two components should you include in the solution? 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_55' value='179052' \/><input type='hidden' id='answerType179052' 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-179052[]' id='answer-id-721434' class='answer   answerof-179052 ' value='721434'   \/><label for='answer-id-721434' id='answer-label-721434' class=' answer'><span>dynamic data masking for columns that contain confidential information \r\nB sensitivity-classification labels applied to columns that contain confidential information<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179052[]' id='answer-id-721435' class='answer   answerof-179052 ' value='721435'   \/><label for='answer-id-721435' id='answer-label-721435' class=' answer'><span>resource tags for databases that contain confidential information<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179052[]' id='answer-id-721436' class='answer   answerof-179052 ' value='721436'   \/><label for='answer-id-721436' id='answer-label-721436' class=' answer'><span>audit logs sent to a Log Analytics workspace<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-56' style=';'><div id='questionWrap-56'  class='   watupro-question-id-179053'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>56. <\/span>HOTSPOT <br \/>\r<br>You have an Azure Data Lake Storage Gen2 account named account1 that stores logs as shown in the following table. <br \/>\r<br><br><img decoding=\"async\" width=398 height=58 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/05\/image104-8.jpg\" v:shapes=\"_x0000_i1076\"><br><br \/>\r<br>You do not expect that the logs will be accessed during the retention periods. <br \/>\r<br>You need to recommend a solution for account1 that meets the following requirements: <br \/>\r<br>&#10001; Automatically deletes the logs at the end of each retention period <br \/>\r<br>&#10001; Minimizes storage costs <br \/>\r<br>What should you include in the recommendation? 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=276 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/05\/image106-8.jpg\" v:shapes=\"_x0000_i1077\"><br><\/div><input type='hidden' name='question_id[]' id='qID_56' value='179053' \/><input type='hidden' id='answerType179053' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179053[]' id='textarea_q_179053' 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-179054'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>57. <\/span>HOTSPOT <br \/>\r<br>You are designing a solution for a company. You plan to use Azure Databricks. <br \/>\r<br>You need to recommend workloads and tiers to meet the following requirements: <br \/>\r<br>&#10001; Provide managed clusters for running production jobs. <br \/>\r<br>&#10001; Provide persistent clusters that support auto-scaling for analytics processes. <br \/>\r<br>&#10001; Provide role-based access control (RBAC) support for Notebooks. <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=650 height=293 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/05\/image110-8.jpg\" v:shapes=\"_x0000_i1079\"><br><\/div><input type='hidden' name='question_id[]' id='qID_57' value='179054' \/><input type='hidden' id='answerType179054' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179054[]' id='textarea_q_179054' 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-58' style=';'><div id='questionWrap-58'  class='   watupro-question-id-179055'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>58. <\/span>HOTSPOT <br \/>\r<br>You have an Azure subscription that contains a logical Microsoft SQL server named Server1. Server1 hosts an Azure Synapse Analytics SQL dedicated pool named Pool1. You need to recommend a Transparent Data Encryption (TDE) solution for Server1. <br \/>\r<br>The solution must meet the following requirements: <br \/>\r<br>&#8226; Track the usage of encryption keys. <br \/>\r<br>&#8226; Maintain the access of client apps to Pool1 in the event of an Azure datacenter outage <br \/>\r<br>that affects the availability of the encryption keys. <br \/>\r<br>What should you include in the recommendation? To answer, select the appropriate options in the answer area. <br \/>\r<br><br><img decoding=\"async\" width=650 height=141 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/05\/image114-8.jpg\" v:shapes=\"_x0000_i1081\"><br><\/div><input type='hidden' name='question_id[]' id='qID_58' value='179055' \/><input type='hidden' id='answerType179055' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179055[]' id='textarea_q_179055' 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-179056'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>59. <\/span>HOTSPOT <br \/>\r<br>A company stores large datasets in Azure, including sales transactions and customer account information. <br \/>\r<br>You must design a solution to analyze the data. <br \/>\r<br>You plan to create the following HDInsight clusters: <br \/>\r<br><br><img decoding=\"async\" width=609 height=73 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/05\/image118-8.jpg\" v:shapes=\"_x0000_i1083\"><br><br \/>\r<br>You need to ensure that the clusters support the query requirements. <br \/>\r<br>Which cluster types should you recocmmend? To answer, select the appropriate configuration in the answer area. NOTE: Each correct seletion is worth one point. <br \/>\r<br><br><img decoding=\"async\" width=458 height=318 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/05\/image120-7.jpg\" v:shapes=\"_x0000_i1084\"><br><\/div><input type='hidden' name='question_id[]' id='qID_59' value='179056' \/><input type='hidden' id='answerType179056' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-179056[]' id='textarea_q_179056' 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-60' style=';'><div id='questionWrap-60'  class='   watupro-question-id-179057'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>60. <\/span>A company is developing a mission-critical line of business app that uses Azure SQL Database Managed Instance. You must design a disaster recovery strategy for the solution. <br \/>\r<br>You need to ensure that the database automatically recovers when full or partial loss of the Azure SQL Database service occurs in the primary region. <br \/>\r<br>What should you recommend?<\/div><input type='hidden' name='question_id[]' id='qID_60' value='179057' \/><input type='hidden' id='answerType179057' 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-179057[]' id='answer-id-721441' class='answer   answerof-179057 ' value='721441'   \/><label for='answer-id-721441' id='answer-label-721441' class=' answer'><span>Failover-group<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179057[]' id='answer-id-721442' class='answer   answerof-179057 ' value='721442'   \/><label for='answer-id-721442' id='answer-label-721442' class=' answer'><span>Azure SQL Data Sync<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179057[]' id='answer-id-721443' class='answer   answerof-179057 ' value='721443'   \/><label for='answer-id-721443' id='answer-label-721443' class=' answer'><span>SQL Replication<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-179057[]' id='answer-id-721444' class='answer   answerof-179057 ' value='721444'   \/><label for='answer-id-721444' id='answer-label-721444' class=' answer'><span>Active geo-replication<\/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=\"watuPROButtons5431\" >\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=\"5431\" id=\"watuPROExamID\"\/>\n\t<input type=\"hidden\" name=\"start_time\" id=\"startTime\" value=\"2026-05-01 08:06:08\" \/>\n\t<input type=\"hidden\" name=\"start_timestamp\" id=\"startTimeStamp\" value=\"1777622768\" \/>\n\t<input type=\"hidden\" name=\"question_ids\" value=\"\" \/>\n\t<input type=\"hidden\" name=\"watupro_questions\" value=\"178998:721275,721276,721277,721278 | 178999:721279,721280,721281,721282 | 179000:721283 | 179001:721284 | 179002:721285 | 179003:721286,721287,721288,721289 | 179004:721290 | 179005:721291 | 179006:721292 | 179007:721293,721294,721295,721296 | 179008:721297 | 179009:721298,721299,721300,721301 | 179010:721302 | 179011:721303 | 179012:721304,721305,721306,721307 | 179013:721308,721309,721310,721311,721312 | 179014:721313,721314,721315,721316 | 179015:721317 | 179016:721318 | 179017:721319,721320,721321,721322 | 179018:721323,721324,721325,721326 | 179019:721327 | 179020:721328,721329,721330,721331,721332 | 179021:721333,721334,721335,721336,721337 | 179022:721338,721339,721340 | 179023:721341 | 179024:721342,721343,721344,721345,721346 | 179025:721347,721348,721349,721350 | 179026:721351,721352,721353,721354 | 179027:721355,721356,721357,721358 | 179028:721359 | 179029:721360,721361,721362,721363,721364 | 179030:721365,721366,721367,721368,721369,721370 | 179031:721371 | 179032:721372,721373,721374,721375 | 179033:721376,721377,721378,721379 | 179034:721380,721381,721382,721383 | 179035:721384,721385,721386,721387 | 179036:721388,721389,721390,721391 | 179037:721392,721393,721394,721395 | 179038:721396 | 179039:721397,721398,721399 | 179040:721400,721401,721402,721403 | 179041:721404,721405,721406,721407 | 179042:721408 | 179043:721409,721410,721411,721412 | 179044:721413,721414,721415,721416 | 179045:721417,721418,721419,721420,721421 | 179046:721422 | 179047:721423,721424,721425,721426 | 179048:721427 | 179049:721428 | 179050:721429 | 179051:721430,721431,721432,721433 | 179052:721434,721435,721436 | 179053:721437 | 179054:721438 | 179055:721439 | 179056:721440 | 179057:721441,721442,721443,721444\" \/>\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 = \"178998,178999,179000,179001,179002,179003,179004,179005,179006,179007,179008,179009,179010,179011,179012,179013,179014,179015,179016,179017,179018,179019,179020,179021,179022,179023,179024,179025,179026,179027,179028,179029,179030,179031,179032,179033,179034,179035,179036,179037,179038,179039,179040,179041,179042,179043,179044,179045,179046,179047,179048,179049,179050,179051,179052,179053,179054,179055,179056,179057\";\nWatuPROSettings[5431] = {};\nWatuPRO.qArr = question_ids.split(',');\nWatuPRO.exam_id = 5431;\t    \nWatuPRO.post_id = 24478;\nWatuPRO.store_progress = 0;\nWatuPRO.curCatPage = 1;\nWatuPRO.requiredIDs=\"0\".split(\",\");\nWatuPRO.hAppID = \"0.35057600 1777622768\";\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(5431);\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":[6748,6749,6750,6752,7907,7908],"class_list":["post-24478","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-data-certification","tag-dp-201","tag-dp-201-dumps","tag-dp-201-dumps-questions","tag-dp-201-exam-dumps","tag-dp-201-exam-questions","tag-dp-201-free-dumps"],"_links":{"self":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/24478","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=24478"}],"version-history":[{"count":1,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/24478\/revisions"}],"predecessor-version":[{"id":24481,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/24478\/revisions\/24481"}],"wp:attachment":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/media?parent=24478"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/categories?post=24478"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/tags?post=24478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}