{"id":20517,"date":"2021-03-13T02:16:01","date_gmt":"2021-03-13T02:16:01","guid":{"rendered":"https:\/\/www.dumpsbase.com\/freedumps\/?p=20517"},"modified":"2021-03-13T02:16:04","modified_gmt":"2021-03-13T02:16:04","slug":"updated-dp-300-dumps-questions-for-administering-relational-databases-on-microsoft-azure","status":"publish","type":"post","link":"https:\/\/www.dumpsbase.com\/freedumps\/updated-dp-300-dumps-questions-for-administering-relational-databases-on-microsoft-azure.html","title":{"rendered":"Updated DP-300 Dumps Questions For Administering Relational Databases on Microsoft Azure"},"content":{"rendered":"\n<p>On Mar 10th, 2021, the exam content of DP-300 Administering Relational Databases on Microsoft Azure exam has been updated. According to the update, we have released the most updated DP-300 dumps questions to help you prepare for Microsoft Azure Database Administrator Associate certification exam well. The current DP-300 dumps is V9.02, with 80 practice exam questions, additionally, all the answers have been verified by the professional team. We ensure that you can pass DP-300 Microsoft exam in one go with the great DP-300 dumps.<\/p>\n<h1>Read <span style=\"color: #ff6600;\">DP-300 Free Dumps<\/span> Online For Checking<\/h1>\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=\"submittingExam5197\" 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-5197\"><\/div>\n\n<form action=\"\" method=\"post\" class=\"quiz-form\" id=\"quiz-5197\"  enctype=\"multipart\/form-data\" >\n<div class='watu-question ' id='question-1' style=';'><div id='questionWrap-1'  class='   watupro-question-id-169182'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>1. <\/span>Topic 1, Litware <br \/>\r<br><br \/>\r<br>Existing Environment <br \/>\r<br>Network Environment <br \/>\r<br>The manufacturing and research datacenters connect to the primary datacenter by using a VPN. <br \/>\r<br>The primary datacenter has an ExpressRoute connection that uses both Microsoft peering and private peering. The private peering connects to an Azure virtual network named HubVNet. <br \/>\r<br><br \/>\r<br>Identity Environment <br \/>\r<br>Litware has a hybrid Azure Active Directory (Azure AD) deployment that uses a domain named litwareinc.com. All Azure subscriptions are associated to the litwareinc.com Azure AD tenant. <br \/>\r<br><br \/>\r<br>Database Environment <br \/>\r<br>The sales department has the following database workload: <br \/>\r<br>- An on-premises named SERVER1 hosts an instance of Microsoft SQL Server 2012 and two 1-TB databases. <br \/>\r<br>- A logical server named SalesSrv01A contains a geo-replicated Azure SQL database named SalesSQLDb1. SalesSQLDb1 is in an elastic pool named SalesSQLDb1Pool. SalesSQLDb1 uses database firewall rules and contained database users. <br \/>\r<br>- An application named SalesSQLDb1App1 uses SalesSQLDb1. <br \/>\r<br><br \/>\r<br>The manufacturing office contains two on-premises SQL Server 2016 servers named SERVER2 and SERVER3. The servers are nodes in the same Always On availability group. The availability group contains a database named ManufacturingSQLDb1 <br \/>\r<br><br \/>\r<br>Database administrators have two Azure virtual machines in HubVnet named VM1 and VM2 that run Windows Server 2019 and are used to manage all the Azure databases. <br \/>\r<br><br \/>\r<br>Licensing Agreement <br \/>\r<br>Litware is a Microsoft Volume Licensing customer that has License Mobility through Software Assurance. <br \/>\r<br><br \/>\r<br>Current Problems <br \/>\r<br>SalesSQLDb1 experiences performance issues that are likely due to out-of-date statistics and frequent blocking queries. <br \/>\r<br><br \/>\r<br>Requirements <br \/>\r<br>Planned Changes <br \/>\r<br>Litware plans to implement the following changes: <br \/>\r<br>- Implement 30 new databases in Azure, which will be used by time-sensitive manufacturing apps that have varying usage patterns. Each database will be approximately 20 GB. <br \/>\r<br>- Create a new Azure SQL database named ResearchDB1 on a logical server named ResearchSrv01. ResearchDB1 will contain Personally Identifiable Information (PII) data. <br \/>\r<br>- Develop an app named ResearchApp1 that will be used by the research department to populate and access ResearchDB1. <br \/>\r<br>- Migrate ManufacturingSQLDb1 to the Azure virtual machine platform. <br \/>\r<br>- Migrate the SERVER1 databases to the Azure SQL Database platform. <br \/>\r<br><br \/>\r<br>Technical Requirements <br \/>\r<br>Litware identifies the following technical requirements: <br \/>\r<br>- Maintenance tasks must be automated. <br \/>\r<br>- The 30 new databases must scale automatically. <br \/>\r<br>- The use of an on-premises infrastructure must be minimized. <br \/>\r<br>- Azure Hybrid Use Benefits must be leveraged for Azure SQL Database deployments. <br \/>\r<br>- All SQL Server and Azure SQL Database metrics related to CPU and storage usage and limits must be analyzed by using Azure built-in functionality. <br \/>\r<br><br \/>\r<br>Security and Compliance Requirements <br \/>\r<br>Litware identifies the following security and compliance requirements: <br \/>\r<br>- Store encryption keys in Azure Key Vault. <br \/>\r<br>- Retain backups of the PII data for two months. <br \/>\r<br>- Encrypt the PII data at rest, in transit, and in use. <br \/>\r<br>- Use the principle of least privilege whenever possible. <br \/>\r<br>- Authenticate database users by using Active Directory credentials. <br \/>\r<br>- Protect Azure SQL Database instances by using database-level firewall rules. <br \/>\r<br>- Ensure that all databases hosted in Azure are accessible from VM1 and VM2 without relying on public endpoints. <br \/>\r<br><br \/>\r<br>Business Requirements <br \/>\r<br>Litware identifies the following business requirements: <br \/>\r<br>- Meet an SLA of 99.99% availability for all Azure deployments. <br \/>\r<br>- Minimize downtime during the migration of the SERVER1 databases. <br \/>\r<br>- Use the Azure Hybrid Use Benefits when migrating workloads to Azure. <br \/>\r<br>- Once all requirements are met, minimize costs whenever possible. <br \/>\r<br><br \/>\r<br>DRAG DROP <br \/>\r<br>You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the technical requirements. <br \/>\r<br>Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. <br \/>\r<br><br><img decoding=\"async\" width=479 height=498 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/03\/image002-23.jpg\" v:shapes=\"_x0000_i1025\"><br><\/div><input type='hidden' name='question_id[]' id='qID_1' value='169182' \/><input type='hidden' id='answerType169182' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-169182[]' id='textarea_q_169182' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-2' style=';'><div id='questionWrap-2'  class='   watupro-question-id-169183'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>2. <\/span>HOTSPOT <br \/>\r<br>You need to recommend a configuration for ManufacturingSQLDb1 after the migration to Azure. The solution must meet the business requirements. <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=647 height=281 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/03\/image006-20.jpg\" v:shapes=\"_x0000_i1027\"><br><\/div><input type='hidden' name='question_id[]' id='qID_2' value='169183' \/><input type='hidden' id='answerType169183' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-169183[]' id='textarea_q_169183' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-3' style=';'><div id='questionWrap-3'  class='   watupro-question-id-169184'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>3. <\/span>HOTSPOT <br \/>\r<br>You are planning the migration of the SERVER1 databases. The solution must meet the business requirements. <br \/>\r<br>What should you include in the migration plan? 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=269 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/03\/image010-18.jpg\" v:shapes=\"_x0000_i1029\"><br><\/div><input type='hidden' name='question_id[]' id='qID_3' value='169184' \/><input type='hidden' id='answerType169184' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-169184[]' id='textarea_q_169184' 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-169185'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>4. <\/span>HOTSPOT <br \/>\r<br>You need to recommend the appropriate purchasing model and deployment option for the 30 new databases. The solution must meet the technical requirements and the business requirements. <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=560 height=226 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/03\/image014-14.jpg\" v:shapes=\"_x0000_i1031\"><br><\/div><input type='hidden' name='question_id[]' id='qID_4' value='169185' \/><input type='hidden' id='answerType169185' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-169185[]' id='textarea_q_169185' 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-169186'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>5. <\/span>D18912E1457D5D1DDCBD40AB3BF70D5D <br \/>\r<br>You need to identify the cause of the performance issues on SalesSQLDb1. <br \/>\r<br>Which two dynamic management views should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_5' value='169186' \/><input type='hidden' id='answerType169186' 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-169186[]' id='answer-id-684621' class='answer   answerof-169186 ' value='684621'   \/><label for='answer-id-684621' id='answer-label-684621' class=' answer'><span>sys.dm_pdw_nodes_tran_locks<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169186[]' id='answer-id-684622' class='answer   answerof-169186 ' value='684622'   \/><label for='answer-id-684622' id='answer-label-684622' class=' answer'><span>sys.dm_exec_compute_node_errors<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169186[]' id='answer-id-684623' class='answer   answerof-169186 ' value='684623'   \/><label for='answer-id-684623' id='answer-label-684623' class=' answer'><span>sys.dm_exec_requests<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169186[]' id='answer-id-684624' class='answer   answerof-169186 ' value='684624'   \/><label for='answer-id-684624' id='answer-label-684624' class=' answer'><span>sys.dm_cdc_errors<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169186[]' id='answer-id-684625' class='answer   answerof-169186 ' value='684625'   \/><label for='answer-id-684625' id='answer-label-684625' class=' answer'><span>sys.dm_pdw_nodes_os_wait_stats<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169186[]' id='answer-id-684626' class='answer   answerof-169186 ' value='684626'   \/><label for='answer-id-684626' id='answer-label-684626' class=' answer'><span>sys.dm_tran_locks<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-6' style=';'><div id='questionWrap-6'  class='   watupro-question-id-169187'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>6. <\/span>HOTSPOT <br \/>\r<br>You need to implement the monitoring of SalesSQLDb1. The solution must meet the technical requirements. <br \/>\r<br>How should you collect and stream metrics? 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=298 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/03\/image018-11.jpg\" v:shapes=\"_x0000_i1033\"><br><\/div><input type='hidden' name='question_id[]' id='qID_6' value='169187' \/><input type='hidden' id='answerType169187' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-169187[]' id='textarea_q_169187' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-7' style=';'><div id='questionWrap-7'  class='   watupro-question-id-169188'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>7. <\/span>DRAG DROP <br \/>\r<br>You need to configure user authentication for the SERVER1 databases. The solution must meet the security and compliance requirements. <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=378 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/03\/image022-9.jpg\" v:shapes=\"_x0000_i1035\"><br><\/div><input type='hidden' name='question_id[]' id='qID_7' value='169188' \/><input type='hidden' id='answerType169188' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-169188[]' id='textarea_q_169188' 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-169189'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>8. <\/span>What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?<\/div><input type='hidden' name='question_id[]' id='qID_8' value='169189' \/><input type='hidden' id='answerType169189' 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-169189[]' id='answer-id-684629' class='answer   answerof-169189 ' value='684629'   \/><label for='answer-id-684629' id='answer-label-684629' class=' answer'><span>Configure SalesSQLDb1 as writable.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169189[]' id='answer-id-684630' class='answer   answerof-169189 ' value='684630'   \/><label for='answer-id-684630' id='answer-label-684630' class=' answer'><span>Update the connection strings of SalesSQLDb1App1.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169189[]' id='answer-id-684631' class='answer   answerof-169189 ' value='684631'   \/><label for='answer-id-684631' id='answer-label-684631' class=' answer'><span>Update the firewall rules of SalesSQLDb1.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169189[]' id='answer-id-684632' class='answer   answerof-169189 ' value='684632'   \/><label for='answer-id-684632' id='answer-label-684632' class=' answer'><span>Update the users in SalesSQLDb1.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-9' style=';'><div id='questionWrap-9'  class='   watupro-question-id-169190'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>9. <\/span>You need to implement authentication for ResearchDB1. The solution must meet the security and compliance requirements. <br \/>\r<br>What should you run as part of the implementation?<\/div><input type='hidden' name='question_id[]' id='qID_9' value='169190' \/><input type='hidden' id='answerType169190' 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-169190[]' id='answer-id-684633' class='answer   answerof-169190 ' value='684633'   \/><label for='answer-id-684633' id='answer-label-684633' class=' answer'><span>CREATE LOGIN and the FROM WINDOWS clause<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169190[]' id='answer-id-684634' class='answer   answerof-169190 ' value='684634'   \/><label for='answer-id-684634' id='answer-label-684634' class=' answer'><span>CREATE USER and the FROM CERTIFICATE clause<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169190[]' id='answer-id-684635' class='answer   answerof-169190 ' value='684635'   \/><label for='answer-id-684635' id='answer-label-684635' class=' answer'><span>CREATE USER and the FROM LOGIN clause<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169190[]' id='answer-id-684636' class='answer   answerof-169190 ' value='684636'   \/><label for='answer-id-684636' id='answer-label-684636' class=' answer'><span>CREATE USER and the ASYMMETRIC KEY clause<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169190[]' id='answer-id-684637' class='answer   answerof-169190 ' value='684637'   \/><label for='answer-id-684637' id='answer-label-684637' class=' answer'><span>CREATE USER and the FROM EXTERNAL PROVIDER clause<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-10' style=';'><div id='questionWrap-10'  class='   watupro-question-id-169191'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>10. <\/span>Which audit log destination should you use to meet the monitoring requirements?<\/div><input type='hidden' name='question_id[]' id='qID_10' value='169191' \/><input type='hidden' id='answerType169191' 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-169191[]' id='answer-id-684638' class='answer   answerof-169191 ' value='684638'   \/><label for='answer-id-684638' id='answer-label-684638' class=' answer'><span>Azure Storage<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169191[]' id='answer-id-684639' class='answer   answerof-169191 ' value='684639'   \/><label for='answer-id-684639' id='answer-label-684639' class=' answer'><span>Azure Event Hubs<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169191[]' id='answer-id-684640' class='answer   answerof-169191 ' value='684640'   \/><label for='answer-id-684640' id='answer-label-684640' class=' answer'><span>Azure Log Analytics<\/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-169192'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>11. <\/span>What should you implement to meet the disaster recovery requirements for the PaaS solution?<\/div><input type='hidden' name='question_id[]' id='qID_11' value='169192' \/><input type='hidden' id='answerType169192' 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-169192[]' id='answer-id-684641' class='answer   answerof-169192 ' value='684641'   \/><label for='answer-id-684641' id='answer-label-684641' class=' answer'><span>Availability Zones<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169192[]' id='answer-id-684642' class='answer   answerof-169192 ' value='684642'   \/><label for='answer-id-684642' id='answer-label-684642' class=' answer'><span>failover groups<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169192[]' id='answer-id-684643' class='answer   answerof-169192 ' value='684643'   \/><label for='answer-id-684643' id='answer-label-684643' class=' answer'><span>Always On availability groups<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169192[]' id='answer-id-684644' class='answer   answerof-169192 ' value='684644'   \/><label for='answer-id-684644' id='answer-label-684644' class=' answer'><span>geo-replication<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-12' style=';'><div id='questionWrap-12'  class='   watupro-question-id-169193'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>12. <\/span>HOTSPOT <br \/>\r<br>You are evaluating the role assignments. <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=649 height=209 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/03\/image032-7.jpg\" v:shapes=\"_x0000_i1040\"><br><\/div><input type='hidden' name='question_id[]' id='qID_12' value='169193' \/><input type='hidden' id='answerType169193' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-169193[]' id='textarea_q_169193' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-13' style=';'><div id='questionWrap-13'  class='   watupro-question-id-169194'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>13. <\/span>Based on the PaaS prototype, which Azure SQL Database compute tier should you use?<\/div><input type='hidden' name='question_id[]' id='qID_13' value='169194' \/><input type='hidden' id='answerType169194' 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-169194[]' id='answer-id-684646' class='answer   answerof-169194 ' value='684646'   \/><label for='answer-id-684646' id='answer-label-684646' class=' answer'><span>Business Critical 4-vCore<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169194[]' id='answer-id-684647' class='answer   answerof-169194 ' value='684647'   \/><label for='answer-id-684647' id='answer-label-684647' class=' answer'><span>Hyperscale<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169194[]' id='answer-id-684648' class='answer   answerof-169194 ' value='684648'   \/><label for='answer-id-684648' id='answer-label-684648' class=' answer'><span>General Purpose v-vCore<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169194[]' id='answer-id-684649' class='answer   answerof-169194 ' value='684649'   \/><label for='answer-id-684649' id='answer-label-684649' class=' answer'><span>Serverless<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-14' style=';'><div id='questionWrap-14'  class='   watupro-question-id-169195'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>14. <\/span>Topic 3, Misc. Questions <br \/>\r<br><br \/>\r<br>You have an Azure SQL database named sqldb1. <br \/>\r<br>You need to minimize the possibility of Query Store transitioning to a read-only state. <br \/>\r<br>What should you do?<\/div><input type='hidden' name='question_id[]' id='qID_14' value='169195' \/><input type='hidden' id='answerType169195' 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-169195[]' id='answer-id-684650' class='answer   answerof-169195 ' value='684650'   \/><label for='answer-id-684650' id='answer-label-684650' class=' answer'><span>Double the value of Data Flush interval<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169195[]' id='answer-id-684651' class='answer   answerof-169195 ' value='684651'   \/><label for='answer-id-684651' id='answer-label-684651' class=' answer'><span>Decrease by half the value of Data Flush Interval<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169195[]' id='answer-id-684652' class='answer   answerof-169195 ' value='684652'   \/><label for='answer-id-684652' id='answer-label-684652' class=' answer'><span>Double the value of Statistics Collection Interval<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169195[]' id='answer-id-684653' class='answer   answerof-169195 ' value='684653'   \/><label for='answer-id-684653' id='answer-label-684653' class=' answer'><span>Decrease by half the value of Statistics Collection interval<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-15' style=';'><div id='questionWrap-15'  class='   watupro-question-id-169196'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>15. <\/span>A data engineer creates a table to store employee information for a new application. All employee names are in the US English alphabet. All addresses are locations in the United States. <br \/>\r<br>The data engineer uses the following statement to create the table. <br \/>\r<br><br><img decoding=\"async\" width=609 height=295 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/03\/image036-7.jpg\" v:shapes=\"_x0000_i1042\"><br><br \/>\r<br>You need to recommend changes to the data types to reduce storage and improve performance. <br \/>\r<br>Which two 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_15' value='169196' \/><input type='hidden' id='answerType169196' 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-169196[]' id='answer-id-684654' class='answer   answerof-169196 ' value='684654'   \/><label for='answer-id-684654' id='answer-label-684654' class=' answer'><span>Change Salary to the money data type.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169196[]' id='answer-id-684655' class='answer   answerof-169196 ' value='684655'   \/><label for='answer-id-684655' id='answer-label-684655' class=' answer'><span>Change PhoneNumber to the float data type.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169196[]' id='answer-id-684656' class='answer   answerof-169196 ' value='684656'   \/><label for='answer-id-684656' id='answer-label-684656' class=' answer'><span>Change LastHireDate to the datetime2(7) data type.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169196[]' id='answer-id-684657' class='answer   answerof-169196 ' value='684657'   \/><label for='answer-id-684657' id='answer-label-684657' class=' answer'><span>Change PhoneNumber to the bigint data type.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169196[]' id='answer-id-684658' class='answer   answerof-169196 ' value='684658'   \/><label for='answer-id-684658' id='answer-label-684658' class=' answer'><span>Change LastHireDate to the date data type.<\/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-169197'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>16. <\/span>You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a table named CustomerPII. <br \/>\r<br>You need to record whenever users query the CustomerPII table. <br \/>\r<br>Which two options should you enable? 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_16' value='169197' \/><input type='hidden' id='answerType169197' 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-169197[]' id='answer-id-684659' class='answer   answerof-169197 ' value='684659'   \/><label for='answer-id-684659' id='answer-label-684659' class=' answer'><span>server audit specification<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169197[]' id='answer-id-684660' class='answer   answerof-169197 ' value='684660'   \/><label for='answer-id-684660' id='answer-label-684660' class=' answer'><span>SQL Server audit<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169197[]' id='answer-id-684661' class='answer   answerof-169197 ' value='684661'   \/><label for='answer-id-684661' id='answer-label-684661' class=' answer'><span>database audit specification<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169197[]' id='answer-id-684662' class='answer   answerof-169197 ' value='684662'   \/><label for='answer-id-684662' id='answer-label-684662' class=' answer'><span>a server principal<\/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-169198'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>17. <\/span>HOTSPOT <br \/>\r<br>You have an Azure SQL database named db1. <br \/>\r<br>You need to retrieve the resource usage of db1 from the last week. <br \/>\r<br>How should you complete the statement? 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=410 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/03\/image038-7.jpg\" v:shapes=\"_x0000_i1043\"><br><\/div><input type='hidden' name='question_id[]' id='qID_17' value='169198' \/><input type='hidden' id='answerType169198' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-169198[]' id='textarea_q_169198' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-18' style=';'><div id='questionWrap-18'  class='   watupro-question-id-169199'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>18. <\/span>You have 50 Azure SQL databases. <br \/>\r<br>You need to notify the database owner when the database settings, such as the database size and pricing tier, are modified in Azure. <br \/>\r<br>What should you do?<\/div><input type='hidden' name='question_id[]' id='qID_18' value='169199' \/><input type='hidden' id='answerType169199' 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-169199[]' id='answer-id-684664' class='answer   answerof-169199 ' value='684664'   \/><label for='answer-id-684664' id='answer-label-684664' class=' answer'><span>Create a diagnostic setting for the activity log that has the Security log enabled.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169199[]' id='answer-id-684665' class='answer   answerof-169199 ' value='684665'   \/><label for='answer-id-684665' id='answer-label-684665' class=' answer'><span>For the database, create a diagnostic setting that has the InstanceAndAppAdvanced metric enabled.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169199[]' id='answer-id-684666' class='answer   answerof-169199 ' value='684666'   \/><label for='answer-id-684666' id='answer-label-684666' class=' answer'><span>Create an alert rule that uses a Metric signal type.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169199[]' id='answer-id-684667' class='answer   answerof-169199 ' value='684667'   \/><label for='answer-id-684667' id='answer-label-684667' class=' answer'><span>Create an alert rule that uses an Activity Log signal type.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-19' style=';'><div id='questionWrap-19'  class='   watupro-question-id-169200'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>19. <\/span>Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. <br \/>\r<br>After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. <br \/>\r<br>You have two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database named Database1. <br \/>\r<br>You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2. <br \/>\r<br>Solution: You run the Remove-AzSqlDatabase PowerShell cmdlet for Database1 on Server2. You run the Restore-AzSqlDatabase PowerShell cmdlet for Database1 on Server2. <br \/>\r<br>Does this meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_19' value='169200' \/><input type='hidden' id='answerType169200' 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-169200[]' id='answer-id-684668' class='answer   answerof-169200 ' value='684668'   \/><label for='answer-id-684668' id='answer-label-684668' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169200[]' id='answer-id-684669' class='answer   answerof-169200 ' value='684669'   \/><label for='answer-id-684669' id='answer-label-684669' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-20' style=';'><div id='questionWrap-20'  class='   watupro-question-id-169201'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>20. <\/span>HOTSPOT <br \/>\r<br>You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1. <br \/>\r<br>You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service. <br \/>\r<br>How should you configure the backup of DB1? 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=637 height=308 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/03\/image042-7.jpg\" v:shapes=\"_x0000_i1045\"><br><\/div><input type='hidden' name='question_id[]' id='qID_20' value='169201' \/><input type='hidden' id='answerType169201' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-169201[]' id='textarea_q_169201' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-21' style=';'><div id='questionWrap-21'  class='   watupro-question-id-169202'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>21. <\/span>HOTSPOT <br \/>\r<br>You have SQL Server on an Azure virtual machine that contains a database named DB1. <br \/>\r<br>The database reports a CHECKSUM error. <br \/>\r<br>You need to recover the database. <br \/>\r<br>How should you complete the statements? 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=413 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/03\/image046-7.jpg\" v:shapes=\"_x0000_i1047\"><br><\/div><input type='hidden' name='question_id[]' id='qID_21' value='169202' \/><input type='hidden' id='answerType169202' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-169202[]' id='textarea_q_169202' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-22' style=';'><div id='questionWrap-22'  class='   watupro-question-id-169203'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>22. <\/span>HOTSPOT <br \/>\r<br>You have SQL Server on an Azure virtual machine. <br \/>\r<br>You review the query plan shown in the following exhibit. <br \/>\r<br><br><img decoding=\"async\" width=650 height=444 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/03\/image050-5.jpg\" v:shapes=\"_x0000_i1049\"><br><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=650 height=252 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/03\/image052-5.jpg\" v:shapes=\"_x0000_i1050\"><br><\/div><input type='hidden' name='question_id[]' id='qID_22' value='169203' \/><input type='hidden' id='answerType169203' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-169203[]' id='textarea_q_169203' 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-169204'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>23. <\/span>You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1. <br \/>\r<br>You plan to migrate DB1 to an Azure SQL Database managed instance. <br \/>\r<br>What should you use to minimize downtime and data loss during the migration?<\/div><input type='hidden' name='question_id[]' id='qID_23' value='169204' \/><input type='hidden' id='answerType169204' 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-169204[]' id='answer-id-684673' class='answer   answerof-169204 ' value='684673'   \/><label for='answer-id-684673' id='answer-label-684673' class=' answer'><span>distributed availability groups<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169204[]' id='answer-id-684674' class='answer   answerof-169204 ' value='684674'   \/><label for='answer-id-684674' id='answer-label-684674' class=' answer'><span>database mirroring<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169204[]' id='answer-id-684675' class='answer   answerof-169204 ' value='684675'   \/><label for='answer-id-684675' id='answer-label-684675' class=' answer'><span>log shipping<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169204[]' id='answer-id-684676' class='answer   answerof-169204 ' value='684676'   \/><label for='answer-id-684676' id='answer-label-684676' class=' answer'><span>Database Migration Assistant<\/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-169205'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>24. <\/span>DRAG DROP <br \/>\r<br>You have SQL Server on an Azure virtual machine named SQL1. <br \/>\r<br>SQL1 has an agent job to back up all databases. <br \/>\r<br>You add a user named dbadmin1 as a SQL Server Agent operator. <br \/>\r<br>You need to ensure that dbadmin1 receives an email alert if a job fails. <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=317 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/03\/image056-5.jpg\" v:shapes=\"_x0000_i1052\"><br><\/div><input type='hidden' name='question_id[]' id='qID_24' value='169205' \/><input type='hidden' id='answerType169205' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-169205[]' id='textarea_q_169205' 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-25' style=';'><div id='questionWrap-25'  class='   watupro-question-id-169206'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>25. <\/span>Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. <br \/>\r<br>After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. <br \/>\r<br>You have an Azure SQL database named Sales. <br \/>\r<br>You need to implement disaster recovery for Sales to meet the following requirements: <br \/>\r<br>&#10001; During normal operations, provide at least two readable copies of Sales. <br \/>\r<br>&#10001; Ensure that Sales remains available if a datacenter fails. <br \/>\r<br>Solution: You deploy an Azure SQL database that uses the General Purpose service tier and geo-replication. <br \/>\r<br>Does this meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_25' value='169206' \/><input type='hidden' id='answerType169206' 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-169206[]' id='answer-id-684678' class='answer   answerof-169206 ' value='684678'   \/><label for='answer-id-684678' id='answer-label-684678' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169206[]' id='answer-id-684679' class='answer   answerof-169206 ' value='684679'   \/><label for='answer-id-684679' id='answer-label-684679' class=' answer'><span>No<\/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-169207'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>26. <\/span>Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. <br \/>\r<br>After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. <br \/>\r<br>You have two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database named Database1. <br \/>\r<br>You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2. <br \/>\r<br>Solution: You restore Database1 from Server1 to the Server2 by using the RESTORE Transact-SQL command and the REPLACE option. <br \/>\r<br>Does this meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_26' value='169207' \/><input type='hidden' id='answerType169207' 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-169207[]' id='answer-id-684680' class='answer   answerof-169207 ' value='684680'   \/><label for='answer-id-684680' id='answer-label-684680' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169207[]' id='answer-id-684681' class='answer   answerof-169207 ' value='684681'   \/><label for='answer-id-684681' id='answer-label-684681' class=' answer'><span>No<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-27' style=';'><div id='questionWrap-27'  class='   watupro-question-id-169208'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>27. <\/span>You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs on SQLMI1. <br \/>\r<br>You need to ensure that an automatic email notification is sent once the job completes. <br \/>\r<br>What should you include in the solution?<\/div><input type='hidden' name='question_id[]' id='qID_27' value='169208' \/><input type='hidden' id='answerType169208' 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-169208[]' id='answer-id-684682' class='answer   answerof-169208 ' value='684682'   \/><label for='answer-id-684682' id='answer-label-684682' class=' answer'><span>From SQL Server Configuration Manager (SSMS), enable SQL Server Agent<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169208[]' id='answer-id-684683' class='answer   answerof-169208 ' value='684683'   \/><label for='answer-id-684683' id='answer-label-684683' class=' answer'><span>From SQL Server Management Studio (SSMS), run sp_set_sqlagent_properties<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169208[]' id='answer-id-684684' class='answer   answerof-169208 ' value='684684'   \/><label for='answer-id-684684' id='answer-label-684684' class=' answer'><span>From SQL Server Management Studio (SSMS), create a Database Mail profile<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169208[]' id='answer-id-684685' class='answer   answerof-169208 ' value='684685'   \/><label for='answer-id-684685' id='answer-label-684685' class=' answer'><span>From the Azure portal, create an Azure Monitor action group that has an Email\/SMS\/Push\/Voice action<\/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-169209'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>28. <\/span>HOTSPOT <br \/>\r<br>You have an Azure SQL Database managed instance named sqldbmi1 that contains a database name Sales. You need to initiate a backup of Sales. <br \/>\r<br>How should you complete the Transact-SQL statement? 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=644 height=358 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/03\/image060-5.jpg\" v:shapes=\"_x0000_i1054\"><br><\/div><input type='hidden' name='question_id[]' id='qID_28' value='169209' \/><input type='hidden' id='answerType169209' value='textarea'><!-- end question-content--><\/div><div class='question-choices '><p><textarea name='answer-169209[]' id='textarea_q_169209' class='watupro-textarea-medium' rows='5' cols='80'><\/textarea>\n<\/p><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-29' style=';'><div id='questionWrap-29'  class='   watupro-question-id-169210'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>29. <\/span>You have an Azure SQL database. <br \/>\r<br>You discover that the plan cache is full of compiled plans that were used only once. <br \/>\r<br>You run the select * from sys.database_scoped_configurations Transact-SQL command and receive the results shown in the following table. <br \/>\r<br><br><img decoding=\"async\" width=612 height=103 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2021\/03\/image064-5.jpg\" v:shapes=\"_x0000_i1056\"><br><br \/>\r<br>You need relieve the memory pressure. <br \/>\r<br>What should you configure?<\/div><input type='hidden' name='question_id[]' id='qID_29' value='169210' \/><input type='hidden' id='answerType169210' 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-169210[]' id='answer-id-684687' class='answer   answerof-169210 ' value='684687'   \/><label for='answer-id-684687' id='answer-label-684687' class=' answer'><span>LEGACY_CARDINALITY_ESTIMATION<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169210[]' id='answer-id-684688' class='answer   answerof-169210 ' value='684688'   \/><label for='answer-id-684688' id='answer-label-684688' class=' answer'><span>QUERY_OPTIMIZER_HOTFIXES<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169210[]' id='answer-id-684689' class='answer   answerof-169210 ' value='684689'   \/><label for='answer-id-684689' id='answer-label-684689' class=' answer'><span>OPTIMIZE_FOR_AD_HOC_WORKLOADS<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169210[]' id='answer-id-684690' class='answer   answerof-169210 ' value='684690'   \/><label for='answer-id-684690' id='answer-label-684690' class=' answer'><span>ACCELERATED_PLAN_FORCING<\/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-169211'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>30. <\/span>You are planning disaster recovery for the failover group of an Azure SQL Database managed instance. <br \/>\r<br>Your company\u2019s SLA requires that the database in the failover group become available as <br \/>\r<br>quickly as possible if a major outage occurs. <br \/>\r<br>You set the Read\/Write failover policy to Automatic. <br \/>\r<br>What are two results of the configuration? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_30' value='169211' \/><input type='hidden' id='answerType169211' 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-169211[]' id='answer-id-684691' class='answer   answerof-169211 ' value='684691'   \/><label for='answer-id-684691' id='answer-label-684691' class=' answer'><span>In the event of a datacenter or Azure regional outage, the databases will fail over automatically.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169211[]' id='answer-id-684692' class='answer   answerof-169211 ' value='684692'   \/><label for='answer-id-684692' id='answer-label-684692' class=' answer'><span>In the event of an outage, the databases in the primary instance will fail over immediately.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169211[]' id='answer-id-684693' class='answer   answerof-169211 ' value='684693'   \/><label for='answer-id-684693' id='answer-label-684693' class=' answer'><span>In the event of an outage, you can selectively fail over individual databases.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169211[]' id='answer-id-684694' class='answer   answerof-169211 ' value='684694'   \/><label for='answer-id-684694' id='answer-label-684694' class=' answer'><span>In the event of an outage, you can set a different grace period to fail over each database.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-169211[]' id='answer-id-684695' class='answer   answerof-169211 ' value='684695'   \/><label for='answer-id-684695' id='answer-label-684695' class=' answer'><span>In the event of an outage, the minimum delay for the databases to fail over in the primary instance will be one hour.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div style='display:none' id='question-31'>\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=\"watuPROButtons5197\" >\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=\"5197\" id=\"watuPROExamID\"\/>\n\t<input type=\"hidden\" name=\"start_time\" id=\"startTime\" value=\"2026-05-01 06:28:55\" \/>\n\t<input type=\"hidden\" name=\"start_timestamp\" id=\"startTimeStamp\" value=\"1777616935\" \/>\n\t<input type=\"hidden\" name=\"question_ids\" value=\"\" \/>\n\t<input type=\"hidden\" name=\"watupro_questions\" value=\"169182:684617 | 169183:684618 | 169184:684619 | 169185:684620 | 169186:684621,684622,684623,684624,684625,684626 | 169187:684627 | 169188:684628 | 169189:684629,684630,684631,684632 | 169190:684633,684634,684635,684636,684637 | 169191:684638,684639,684640 | 169192:684641,684642,684643,684644 | 169193:684645 | 169194:684646,684647,684648,684649 | 169195:684650,684651,684652,684653 | 169196:684654,684655,684656,684657,684658 | 169197:684659,684660,684661,684662 | 169198:684663 | 169199:684664,684665,684666,684667 | 169200:684668,684669 | 169201:684670 | 169202:684671 | 169203:684672 | 169204:684673,684674,684675,684676 | 169205:684677 | 169206:684678,684679 | 169207:684680,684681 | 169208:684682,684683,684684,684685 | 169209:684686 | 169210:684687,684688,684689,684690 | 169211:684691,684692,684693,684694,684695\" \/>\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 = \"169182,169183,169184,169185,169186,169187,169188,169189,169190,169191,169192,169193,169194,169195,169196,169197,169198,169199,169200,169201,169202,169203,169204,169205,169206,169207,169208,169209,169210,169211\";\nWatuPROSettings[5197] = {};\nWatuPRO.qArr = question_ids.split(',');\nWatuPRO.exam_id = 5197;\t    \nWatuPRO.post_id = 20517;\nWatuPRO.store_progress = 0;\nWatuPRO.curCatPage = 1;\nWatuPRO.requiredIDs=\"0\".split(\",\");\nWatuPRO.hAppID = \"0.00104000 1777616935\";\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(5197);\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,4088],"tags":[9449,9450,9454,9451,9455,9453],"class_list":["post-20517","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-azure-certification","tag-dp-300","tag-dp-300-dumps","tag-dp-300-dumps-questions","tag-dp-300-exam-dumps","tag-dp-300-exam-questions","tag-dp-300-free-dumps"],"_links":{"self":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/20517","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=20517"}],"version-history":[{"count":1,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/20517\/revisions"}],"predecessor-version":[{"id":20519,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/20517\/revisions\/20519"}],"wp:attachment":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/media?parent=20517"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/categories?post=20517"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/tags?post=20517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}