{"id":127908,"date":"2026-06-01T06:55:05","date_gmt":"2026-06-01T06:55:05","guid":{"rendered":"https:\/\/www.dumpsbase.com\/freedumps\/?p=127908"},"modified":"2026-06-01T06:55:08","modified_gmt":"2026-06-01T06:55:08","slug":"microsoft-dp-300-dumps-v21-02-for-becoming-an-expert-in-azure-sql-solutions-check-dp-300-free-dumps-part-1-q1-q40-first","status":"publish","type":"post","link":"https:\/\/www.dumpsbase.com\/freedumps\/microsoft-dp-300-dumps-v21-02-for-becoming-an-expert-in-azure-sql-solutions-check-dp-300-free-dumps-part-1-q1-q40-first.html","title":{"rendered":"Microsoft DP-300 Dumps (V21.02) for Becoming an Expert in Azure SQL Solutions: Check DP-300 Free Dumps (Part 1, Q1-Q40) First"},"content":{"rendered":"\n<p>The Microsoft Certified: Azure Database Administrator Associate (DP-300) comprehensively evaluates your ability to manage both on-premises and cloud-based databases using SQL Server and advanced Azure SQL services. If you want to pass the Microsoft DP-300 exam successfully, you need to focus on the most updated dumps from DumpsBase. We have updated the DP-300 dumps to V21.02, offering 387 practice questions and answers and helping you get entirely comfortable with the DP-300 dumps formats (PDF + Software) you will encounter. On top of delivering elite content, DumpsBase provides an exclusive 28% discount, packaged alongside continuous free updates and a complimentary demo test, giving you an affordable and comprehensive way to prepare. By choosing DumpsBase, you are actively setting yourself up for success, armed with updated DP-300 dumps (V21.02) that will help you confidently earn your Microsoft Azure Database Administrator Associate Certification.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Start with our DP-300 free dumps (Part 1, Q1-Q40) of V21.02 below, check the practice questions first:<\/h2>\n\n\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=\"submittingExam12285\" 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-12285\"><\/div>\n\n<form action=\"\" method=\"post\" class=\"quiz-form\" id=\"quiz-12285\"  enctype=\"multipart\/form-data\" >\n<div class='watu-question ' id='question-1' style=';'><div id='questionWrap-1'  class='   watupro-question-id-480017'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>1. <\/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 id=\"\u56fe\u7247 206\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image058-3.jpg\"><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_1' value='480017' \/><input type='hidden' id='answerType480017' 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-480017[]' id='answer-id-1854806' class='answer   answerof-480017 ' value='1854806'   \/><label for='answer-id-1854806' id='answer-label-1854806' 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-480017[]' id='answer-id-1854807' class='answer   answerof-480017 ' value='1854807'   \/><label for='answer-id-1854807' id='answer-label-1854807' 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-480017[]' id='answer-id-1854808' class='answer   answerof-480017 ' value='1854808'   \/><label for='answer-id-1854808' id='answer-label-1854808' 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-480017[]' id='answer-id-1854809' class='answer   answerof-480017 ' value='1854809'   \/><label for='answer-id-1854809' id='answer-label-1854809' 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-480017[]' id='answer-id-1854810' class='answer   answerof-480017 ' value='1854810'   \/><label for='answer-id-1854810' id='answer-label-1854810' 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-2' style=';'><div id='questionWrap-2'  class='   watupro-question-id-480018'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>2. <\/span>HOTSPOT<br \/>\r\n<br \/>\r\nYou have SQL Server on an Azure virtual machine.<br \/>\r\n<br \/>\r\nYou review the query plan shown in the following exhibit.<br \/>\r\n<br \/>\r\n<br \/>\r\n<img loading=\"lazy\" decoding=\"async\" id=\"\u56fe\u7247 165\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image055-4.jpg\" width=\"649\" height=\"444\" \/>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\n<br \/>\r\n<br \/>\r\n<img loading=\"lazy\" decoding=\"async\" id=\"\u56fe\u7247 166\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image056-2.jpg\" width=\"650\" height=\"252\" \/><\/div><input type='hidden' name='question_id[]' id='qID_2' value='480018' \/><input type='hidden' id='answerType480018' 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-480018[]' id='answer-id-1854811' class='answer   answerof-480018 ' value='1854811'   \/><label for='answer-id-1854811' id='answer-label-1854811' class=' answer'><span><br><img decoding=\"async\" width=650 height=252 id=\"\u56fe\u7247 167\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image057-2.jpg\"><br><\/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-480019'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>3. <\/span>SIMULATION<br \/>\r\n<br \/>\r\nTask 10<br \/>\r\n<br \/>\r\nYou need to protect all the databases on sql37006S95 from SQL injection attacks.<\/div><input type='hidden' name='question_id[]' id='qID_3' value='480019' \/><input type='hidden' id='answerType480019' 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-480019[]' id='answer-id-1854812' class='answer   answerof-480019 ' value='1854812'   \/><label for='answer-id-1854812' id='answer-label-1854812' class=' answer'><span>SQL injection attacks are a type of cyberattack that exploit a vulnerability in the application code that interacts with the database. An attacker can inject malicious SQL statements into the user input, such as a form field or a URL parameter, and execute them on the database server, resulting in data theft, corruption, or unauthorized access1. \r\n<br>To protect all the databases on sql37006S95 from SQL injection attacks, you need to follow some best practices for securing your application and database layers. Here are some of the recommended steps: \r\n<br>Use parameterized queries or stored procedures to separate the SQL code from the user input. This will prevent the user input from being interpreted as part of the SQL statement and avoid SQL injection23. \r\n<br>Validate and sanitize the user input before passing it to the database. This will ensure that the input conforms to the expected format and type, and remove any potentially harmful characters or keywords4. \r\n<br>Implement least privilege access for the database users and roles. This will limit the permissions and actions that the application can perform on the database, and reduce the impact of a successful SQL injection attack5. \r\n<br>Enable Advanced Threat Protection for Azure SQL Database. This is a feature that detects and alerts you of anomalous activities and potential threats on your database, such as SQL injection, brute force attacks, or unusual access patterns. You can configure the alert settings and notifications using the Azure portal or PowerShell. \r\n<br>These are some of the steps to protect all the databases on sql37006S95 from SQL injection attacks.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-4' style=';'><div id='questionWrap-4'  class='   watupro-question-id-480020'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>4. <\/span>DRAG DROP<br \/>\r\n<br \/>\r\nYou are building an Azure virtual machine.<br \/>\r\n<br \/>\r\nYou allocate two 1-TiB, P30 premium storage disks to the virtual machine. Each disk provides 5,000 IOPS.<br \/>\r\n<br \/>\r\nYou plan to migrate an on-premises instance of Microsoft SQL Server to the virtual machine. The instance has a database that contains a 1.2-TiB data file. The database requires 10,000 IOPS.<br \/>\r\n<br \/>\r\nYou need to configure storage for the virtual machine to support the database.<br \/>\r\n<br \/>\r\nWhich three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order.<br \/>\r\n<br \/>\r\n<br \/>\r\n<img loading=\"lazy\" decoding=\"async\" id=\"\u56fe\u7247 68\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image051-5.jpg\" width=\"650\" height=\"317\" \/><\/div><input type='hidden' name='question_id[]' id='qID_4' value='480020' \/><input type='hidden' id='answerType480020' 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-480020[]' id='answer-id-1854813' class='answer   answerof-480020 ' value='1854813'   \/><label for='answer-id-1854813' id='answer-label-1854813' class=' answer'><span><br><img decoding=\"async\" width=650 height=317 id=\"\u56fe\u7247 69\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image052-5.jpg\"><br><\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-5' style=';'><div id='questionWrap-5'  class='   watupro-question-id-480021'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>5. <\/span>You receive numerous alerts from Azure Monitor for an Azure SQL database. <br \/>\r<br>You need to reduce the number of alerts. You must only receive alerts if there is a significant change in usage patterns for an extended period. <br \/>\r<br>Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_5' value='480021' \/><input type='hidden' id='answerType480021' 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-480021[]' id='answer-id-1854814' class='answer   answerof-480021 ' value='1854814'   \/><label for='answer-id-1854814' id='answer-label-1854814' class=' answer'><span>Set Threshold Sensitivity to High<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480021[]' id='answer-id-1854815' class='answer   answerof-480021 ' value='1854815'   \/><label for='answer-id-1854815' id='answer-label-1854815' class=' answer'><span>Set the Alert logic threshold to Dynamic<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480021[]' id='answer-id-1854816' class='answer   answerof-480021 ' value='1854816'   \/><label for='answer-id-1854816' id='answer-label-1854816' class=' answer'><span>Set the Alert logic threshold to Static<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480021[]' id='answer-id-1854817' class='answer   answerof-480021 ' value='1854817'   \/><label for='answer-id-1854817' id='answer-label-1854817' class=' answer'><span>Set Threshold Sensitivity to Low<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480021[]' id='answer-id-1854818' class='answer   answerof-480021 ' value='1854818'   \/><label for='answer-id-1854818' id='answer-label-1854818' class=' answer'><span>Set Force Plan to On<\/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-480022'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>6. <\/span>You have an Azure virtual machine based on a custom image named VM1. <br \/>\r<br>VM1 hosts an instance of Microsoft SQL Server 2019 Standard. <br \/>\r<br>You need to automate the maintenance of VM1 to meet the following requirements: <br \/>\r<br>&#10001; Automate the patching of SQL Server and Windows Server. <br \/>\r<br>&#10001; Automate full database backups and transaction log backups of the databases on VM1. <br \/>\r<br>&#10001; Minimize administrative effort. <br \/>\r<br>What should you do first?<\/div><input type='hidden' name='question_id[]' id='qID_6' value='480022' \/><input type='hidden' id='answerType480022' 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-480022[]' id='answer-id-1854819' class='answer   answerof-480022 ' value='1854819'   \/><label for='answer-id-1854819' id='answer-label-1854819' class=' answer'><span>Enable a system-assigned managed identity for VM1<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480022[]' id='answer-id-1854820' class='answer   answerof-480022 ' value='1854820'   \/><label for='answer-id-1854820' id='answer-label-1854820' class=' answer'><span>Register VM1 to the Microsoft.Sql resource provider<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480022[]' id='answer-id-1854821' class='answer   answerof-480022 ' value='1854821'   \/><label for='answer-id-1854821' id='answer-label-1854821' class=' answer'><span>Install an Azure virtual machine Desired State Configuration (DSC) extension on VM1<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480022[]' id='answer-id-1854822' class='answer   answerof-480022 ' value='1854822'   \/><label for='answer-id-1854822' id='answer-label-1854822' class=' answer'><span>Register VM1 to the Microsoft.SqlVirtualMachine resource provider<\/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-480023'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>7. <\/span>You have SQL Server on an Azure virtual machine that contains a database named DB1. <br \/>\r<br>You have an application that queries DB1 to generate a sales report. <br \/>\r<br>You need to see the parameter values from the last time the query was executed. <br \/>\r<br>Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_7' value='480023' \/><input type='hidden' id='answerType480023' 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-480023[]' id='answer-id-1854823' class='answer   answerof-480023 ' value='1854823'   \/><label for='answer-id-1854823' id='answer-label-1854823' class=' answer'><span>Enable Last_Query_Plan_Stats in the master database<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480023[]' id='answer-id-1854824' class='answer   answerof-480023 ' value='1854824'   \/><label for='answer-id-1854824' id='answer-label-1854824' class=' answer'><span>Enable Lightweight_Query_Profiling in DB1<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480023[]' id='answer-id-1854825' class='answer   answerof-480023 ' value='1854825'   \/><label for='answer-id-1854825' id='answer-label-1854825' class=' answer'><span>Enable Last_Query_Plan_Stats in DB1<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480023[]' id='answer-id-1854826' class='answer   answerof-480023 ' value='1854826'   \/><label for='answer-id-1854826' id='answer-label-1854826' class=' answer'><span>Enable Lightweight_Query_Profiling in the master database<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480023[]' id='answer-id-1854827' class='answer   answerof-480023 ' value='1854827'   \/><label for='answer-id-1854827' id='answer-label-1854827' class=' answer'><span>Enable PARAMETER_SNIFFING in DB1<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-8' style=';'><div id='questionWrap-8'  class='   watupro-question-id-480024'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>8. <\/span>Which audit log destination should you use to meet the monitoring requirements?<\/div><input type='hidden' name='question_id[]' id='qID_8' value='480024' \/><input type='hidden' id='answerType480024' 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-480024[]' id='answer-id-1854828' class='answer   answerof-480024 ' value='1854828'   \/><label for='answer-id-1854828' id='answer-label-1854828' class=' answer'><span>Azure Storage<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480024[]' id='answer-id-1854829' class='answer   answerof-480024 ' value='1854829'   \/><label for='answer-id-1854829' id='answer-label-1854829' class=' answer'><span>Azure Event Hubs<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480024[]' id='answer-id-1854830' class='answer   answerof-480024 ' value='1854830'   \/><label for='answer-id-1854830' id='answer-label-1854830' class=' answer'><span>Azure Log Analytics<\/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-480025'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>9. <\/span>You need to identify the event_file target for monitonng DB3 after the migration to Azure SQL Database. The solution must meet the management requirements. <br \/>\r<br>What should you use as the event_file target?<\/div><input type='hidden' name='question_id[]' id='qID_9' value='480025' \/><input type='hidden' id='answerType480025' 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-480025[]' id='answer-id-1854831' class='answer   answerof-480025 ' value='1854831'   \/><label for='answer-id-1854831' id='answer-label-1854831' class=' answer'><span>an Azure SQL database<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480025[]' id='answer-id-1854832' class='answer   answerof-480025 ' value='1854832'   \/><label for='answer-id-1854832' id='answer-label-1854832' class=' answer'><span>an Azure Blob Storage container<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480025[]' id='answer-id-1854833' class='answer   answerof-480025 ' value='1854833'   \/><label for='answer-id-1854833' id='answer-label-1854833' class=' answer'><span>a SQL Server filegroup<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480025[]' id='answer-id-1854834' class='answer   answerof-480025 ' value='1854834'   \/><label for='answer-id-1854834' id='answer-label-1854834' class=' answer'><span>an Azure Files share<\/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-480026'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>10. <\/span>You have an Azure SQL database named sqldb1. <br \/>\r<br>You need to minimize the amount of space by the data and log files of sqldb1. <br \/>\r<br>What should you run?<\/div><input type='hidden' name='question_id[]' id='qID_10' value='480026' \/><input type='hidden' id='answerType480026' 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-480026[]' id='answer-id-1854835' class='answer   answerof-480026 ' value='1854835'   \/><label for='answer-id-1854835' id='answer-label-1854835' class=' answer'><span>DBCC SHRINKDATABASE<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480026[]' id='answer-id-1854836' class='answer   answerof-480026 ' value='1854836'   \/><label for='answer-id-1854836' id='answer-label-1854836' class=' answer'><span>sp_clean_db_free_space<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480026[]' id='answer-id-1854837' class='answer   answerof-480026 ' value='1854837'   \/><label for='answer-id-1854837' id='answer-label-1854837' class=' answer'><span>sp_clean_db_file_free_space<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480026[]' id='answer-id-1854838' class='answer   answerof-480026 ' value='1854838'   \/><label for='answer-id-1854838' id='answer-label-1854838' class=' answer'><span>DBCC SHRINKFILE<\/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-480027'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>11. <\/span>You have an Always On availability group deployed to Azure virtual machines. The availability group contains a database named DB1 and has two nodes named SQL1 and SQL2. SQL1 is the primary replica. <br \/>\r<br>You need to initiate a full backup of DB1 on SQL2. <br \/>\r<br>Which statement should you run?<\/div><input type='hidden' name='question_id[]' id='qID_11' value='480027' \/><input type='hidden' id='answerType480027' 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-480027[]' id='answer-id-1854839' class='answer   answerof-480027 ' value='1854839'   \/><label for='answer-id-1854839' id='answer-label-1854839' class=' answer'><span>BACKUP DATABASE DB1 TO URL='https:\/\/mystorageaccount.blob.core.windows.net\/ mycontainer\/DB1.bak' with (Differential, STATS=5, COMPRESSION);<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480027[]' id='answer-id-1854840' class='answer   answerof-480027 ' value='1854840'   \/><label for='answer-id-1854840' id='answer-label-1854840' class=' answer'><span>BACKUP DATABASE DB1 TO URL='https:\/\/mystorageaccount.blob.core.windows.net\/ mycontainer\/DB1.bak' with (COPY_ONLY, STATS=5, COMPRESSION);<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480027[]' id='answer-id-1854841' class='answer   answerof-480027 ' value='1854841'   \/><label for='answer-id-1854841' id='answer-label-1854841' class=' answer'><span>BACKUP DATABASE DB1 TO URL='https:\/\/mystorageaccount.blob.core.windows.net\/ mycontainer\/DB1.bak' with (File_Snapshot, STATS=5, COMPRESSION);<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480027[]' id='answer-id-1854842' class='answer   answerof-480027 ' value='1854842'   \/><label for='answer-id-1854842' id='answer-label-1854842' class=' answer'><span>BACKUP DATABASE DB1 TO URL='https:\/\/mystorageaccount.blob.core.windows.net\/ mycontainer\/DB1.bak' with (NoInit, STATS=5, COMPRESSION);<\/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-480028'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>12. <\/span>DRAG DROP<br \/>\r\n<br \/>\r\nYou have SQL Server on an Azure virtual machine named SQL1.<br \/>\r\n<br \/>\r\nSQL1 has an agent job to back up all databases.<br \/>\r\n<br \/>\r\nYou add a user named dbadmin1 as a SQL Server Agent operator.<br \/>\r\n<br \/>\r\nYou need to ensure that dbadmin1 receives an email alert if a job fails.<br \/>\r\n<br \/>\r\nWhich 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\n<br \/>\r\n<br \/>\r\n<img loading=\"lazy\" decoding=\"async\" id=\"\u56fe\u7247 139\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image062-2.jpg\" width=\"650\" height=\"317\" \/><\/div><input type='hidden' name='question_id[]' id='qID_12' value='480028' \/><input type='hidden' id='answerType480028' 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-480028[]' id='answer-id-1854843' class='answer   answerof-480028 ' value='1854843'   \/><label for='answer-id-1854843' id='answer-label-1854843' class=' answer'><span><br><img decoding=\"async\" width=650 height=317 id=\"\u56fe\u7247 140\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image063-2.jpg\"><br><\/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-480029'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>13. <\/span>HOTSPOT<br \/>\r\n<br \/>\r\nYou have an Azure SQL database named DB1.<br \/>\r\n<br \/>\r\nThe automatic tuning options for DB1 are configured as shown in the following exhibit.<br \/>\r\n<br \/>\r\n<br \/>\r\n<img loading=\"lazy\" decoding=\"async\" id=\"\u56fe\u7247 65\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image079-2.jpg\" width=\"650\" height=\"430\" \/>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\n<br \/>\r\n<br \/>\r\n<img loading=\"lazy\" decoding=\"async\" id=\"\u56fe\u7247 66\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image080-2.jpg\" width=\"601\" height=\"204\" \/><\/div><input type='hidden' name='question_id[]' id='qID_13' value='480029' \/><input type='hidden' id='answerType480029' 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-480029[]' id='answer-id-1854844' class='answer   answerof-480029 ' value='1854844'   \/><label for='answer-id-1854844' id='answer-label-1854844' class=' answer'><span><br><img decoding=\"async\" width=601 height=204 id=\"\u56fe\u7247 67\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image081-2.jpg\"><br><\/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-480030'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>14. <\/span>Topic 4, Contoso Ltd Clothing Store <br \/>\r<br><br \/>\r<br>You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements. <br \/>\r<br>Which Azure Storage functionality should you include in the solution?<\/div><input type='hidden' name='question_id[]' id='qID_14' value='480030' \/><input type='hidden' id='answerType480030' 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-480030[]' id='answer-id-1854845' class='answer   answerof-480030 ' value='1854845'   \/><label for='answer-id-1854845' id='answer-label-1854845' class=' answer'><span>time-based retention<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480030[]' id='answer-id-1854846' class='answer   answerof-480030 ' value='1854846'   \/><label for='answer-id-1854846' id='answer-label-1854846' class=' answer'><span>change feed<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480030[]' id='answer-id-1854847' class='answer   answerof-480030 ' value='1854847'   \/><label for='answer-id-1854847' id='answer-label-1854847' class=' answer'><span>lifecycle management<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480030[]' id='answer-id-1854848' class='answer   answerof-480030 ' value='1854848'   \/><label for='answer-id-1854848' id='answer-label-1854848' class=' answer'><span>soft delete<\/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-480031'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>15. <\/span>You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements. <br \/>\r<br>What should you create?<\/div><input type='hidden' name='question_id[]' id='qID_15' value='480031' \/><input type='hidden' id='answerType480031' 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-480031[]' id='answer-id-1854849' class='answer   answerof-480031 ' value='1854849'   \/><label for='answer-id-1854849' id='answer-label-1854849' class=' answer'><span>a table that has a FOREIGN KEY constraint<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480031[]' id='answer-id-1854850' class='answer   answerof-480031 ' value='1854850'   \/><label for='answer-id-1854850' id='answer-label-1854850' class=' answer'><span>a table the has an IDENTITY property<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480031[]' id='answer-id-1854851' class='answer   answerof-480031 ' value='1854851'   \/><label for='answer-id-1854851' id='answer-label-1854851' class=' answer'><span>a user-defined SEQUENCE object<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480031[]' id='answer-id-1854852' class='answer   answerof-480031 ' value='1854852'   \/><label for='answer-id-1854852' id='answer-label-1854852' class=' answer'><span>a system-versioned temporal table<\/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-480032'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>16. <\/span>HOTSPOT<br \/>\r\n<br \/>\r\nYou plan to develop a dataset named Purchases by using Azure Databricks.<br \/>\r\n<br \/>\r\nPurchases will contain the following columns:<br \/>\r\n<br \/>\r\n\u2711 ProductID<br \/>\r\n<br \/>\r\n\u2711 ItemPrice<br \/>\r\n<br \/>\r\n\u2711 LineTotal<br \/>\r\n<br \/>\r\n\u2711 Quantity<br \/>\r\n<br \/>\r\n\u2711 StoreID<br \/>\r\n<br \/>\r\n\u2711 Minute<br \/>\r\n<br \/>\r\n\u2711 Month<br \/>\r\n<br \/>\r\n\u2711 Hour<br \/>\r\n<br \/>\r\n\u2711 Year<br \/>\r\n<br \/>\r\n\u2711 Day<br \/>\r\n<br \/>\r\nYou need to store the data to support hourly incremental load pipelines that will vary for each StoreID. The solution must minimize storage costs.<br \/>\r\n<br \/>\r\nHow should you complete the code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.<br \/>\r\n<br \/>\r\n<br \/>\r\n<img loading=\"lazy\" decoding=\"async\" id=\"\u56fe\u7247 84\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image085-2.jpg\" width=\"453\" height=\"263\" \/><\/div><input type='hidden' name='question_id[]' id='qID_16' value='480032' \/><input type='hidden' id='answerType480032' 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-480032[]' id='answer-id-1854853' class='answer   answerof-480032 ' value='1854853'   \/><label for='answer-id-1854853' id='answer-label-1854853' class=' answer'><span><br><img decoding=\"async\" width=453 height=263 id=\"\u56fe\u7247 85\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image086-2.jpg\"><br><\/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-480033'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>17. <\/span>SIMULATION<br \/>\r\n<br \/>\r\nTask 7<br \/>\r\n<br \/>\r\nYou plan to create an automation runbook that will create database users in db1 from Azure AD identities. You need to configure sq1370O6895 to support the creation of new database users.<\/div><input type='hidden' name='question_id[]' id='qID_17' value='480033' \/><input type='hidden' id='answerType480033' 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-480033[]' id='answer-id-1854854' class='answer   answerof-480033 ' value='1854854'   \/><label for='answer-id-1854854' id='answer-label-1854854' class=' answer'><span>To configure sq1370O6895 to support the creation of new database users from Azure AD identities, you need to do the following steps: \r\n<br>Set up a Microsoft Entra tenant and associate it with your Azure subscription. You can use the Microsoft Entra portal or the Azure portal to create and manage your Microsoft Entra users and groups12. \r\n<br>Configure a Microsoft Entra admin for sq1370O6895. You can use the Azure portal or the Azure CLI to set a Microsoft Entra user as the admin for the server34. The Microsoft Entra admin can create other database users from Microsoft Entra identities5. \r\n<br>Connect to db1 using the Microsoft Entra admin account and run the following Transact-SQL statement to create a new database user from a Microsoft Entra identity: CREATE USER [Microsoft Entra user name] FROM EXTERNAL PROVIDER;6 You can replace the Microsoft Entra user name with the name of the user or group that you want to create in the database. \r\n<br>Grant the appropriate permissions to the new database user by adding them to a database role or granting them specific privileges. For example, you can run the following Transact-SQL statement to add the new user to the db_datareader role: ALTER ROLE db_datareader ADD MEMBER [Microsoft Entra user name]; \r\n<br>These are the steps to configure sq1370O6895 to support the creation of new database users from Azure AD identities.<\/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-480034'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>18. <\/span>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_18' value='480034' \/><input type='hidden' id='answerType480034' 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-480034[]' id='answer-id-1854855' class='answer   answerof-480034 ' value='1854855'   \/><label for='answer-id-1854855' id='answer-label-1854855' class=' answer'><span>sys.dm_pdw_nodes_tran_locks<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480034[]' id='answer-id-1854856' class='answer   answerof-480034 ' value='1854856'   \/><label for='answer-id-1854856' id='answer-label-1854856' class=' answer'><span>sys.dm_exec_compute_node_errors<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480034[]' id='answer-id-1854857' class='answer   answerof-480034 ' value='1854857'   \/><label for='answer-id-1854857' id='answer-label-1854857' class=' answer'><span>sys.dm_exec_requests<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480034[]' id='answer-id-1854858' class='answer   answerof-480034 ' value='1854858'   \/><label for='answer-id-1854858' id='answer-label-1854858' class=' answer'><span>sys.dm_cdc_errors<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480034[]' id='answer-id-1854859' class='answer   answerof-480034 ' value='1854859'   \/><label for='answer-id-1854859' id='answer-label-1854859' 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-480034[]' id='answer-id-1854860' class='answer   answerof-480034 ' value='1854860'   \/><label for='answer-id-1854860' id='answer-label-1854860' class=' answer'><span>sys.dm_tran_locks<\/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-480035'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>19. <\/span>HOTSPOT<br \/>\r\n<br \/>\r\nYou need to design an analytical storage solution for the transactional data. The solution must meet the sales transaction dataset requirements.<br \/>\r\n<br \/>\r\nWhat should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.<br \/>\r\n<br \/>\r\n<br \/>\r\n<img loading=\"lazy\" decoding=\"async\" id=\"\u56fe\u7247 22\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image031-4.jpg\" width=\"392\" height=\"177\" \/><\/div><input type='hidden' name='question_id[]' id='qID_19' value='480035' \/><input type='hidden' id='answerType480035' 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-480035[]' id='answer-id-1854861' class='answer   answerof-480035 ' value='1854861'   \/><label for='answer-id-1854861' id='answer-label-1854861' class=' answer'><span><br><img decoding=\"async\" width=391 height=177 id=\"\u56fe\u7247 21\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image032-3.jpg\"><br><\/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-480036'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>20. <\/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 id=\"\u56fe\u7247 120\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image061-1.jpg\"><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_20' value='480036' \/><input type='hidden' id='answerType480036' 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-480036[]' id='answer-id-1854862' class='answer   answerof-480036 ' value='1854862'   \/><label for='answer-id-1854862' id='answer-label-1854862' class=' answer'><span>LEGACY_CARDINALITY_ESTIMATION<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480036[]' id='answer-id-1854863' class='answer   answerof-480036 ' value='1854863'   \/><label for='answer-id-1854863' id='answer-label-1854863' class=' answer'><span>QUERY_OPTIMIZER_HOTFIXES<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480036[]' id='answer-id-1854864' class='answer   answerof-480036 ' value='1854864'   \/><label for='answer-id-1854864' id='answer-label-1854864' class=' answer'><span>OPTIMIZE_FOR_AD_HOC_WORKLOADS<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480036[]' id='answer-id-1854865' class='answer   answerof-480036 ' value='1854865'   \/><label for='answer-id-1854865' id='answer-label-1854865' class=' answer'><span>ACCELERATED_PLAN_FORCING<\/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-480037'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>21. <\/span>You need to recommend a backup solution to restore DB3. The solution must meet the availability requirements. <br \/>\r<br>Which type of backup should you use?<\/div><input type='hidden' name='question_id[]' id='qID_21' value='480037' \/><input type='hidden' id='answerType480037' 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-480037[]' id='answer-id-1854866' class='answer   answerof-480037 ' value='1854866'   \/><label for='answer-id-1854866' id='answer-label-1854866' class=' answer'><span>transaction log<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480037[]' id='answer-id-1854867' class='answer   answerof-480037 ' value='1854867'   \/><label for='answer-id-1854867' id='answer-label-1854867' class=' answer'><span>point-in-time restore (PITR)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480037[]' id='answer-id-1854868' class='answer   answerof-480037 ' value='1854868'   \/><label for='answer-id-1854868' id='answer-label-1854868' class=' answer'><span>differential<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480037[]' id='answer-id-1854869' class='answer   answerof-480037 ' value='1854869'   \/><label for='answer-id-1854869' id='answer-label-1854869' class=' answer'><span>long-term retention (LTR)<\/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-480038'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>22. <\/span>You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2016 database named DB1. <br \/>\r<br>You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate instance of App1 and DB1. The separate instances of DB1 will sync by using Azure SQL Data Sync. <br \/>\r<br>You need to recommend a database service for the deployment. The solution must minimize administrative effort. <br \/>\r<br>What should you include in the recommendation?<\/div><input type='hidden' name='question_id[]' id='qID_22' value='480038' \/><input type='hidden' id='answerType480038' 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-480038[]' id='answer-id-1854870' class='answer   answerof-480038 ' value='1854870'   \/><label for='answer-id-1854870' id='answer-label-1854870' class=' answer'><span>Azure SQL Managed instance<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480038[]' id='answer-id-1854871' class='answer   answerof-480038 ' value='1854871'   \/><label for='answer-id-1854871' id='answer-label-1854871' class=' answer'><span>Azure SQL Database single database<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480038[]' id='answer-id-1854872' class='answer   answerof-480038 ' value='1854872'   \/><label for='answer-id-1854872' id='answer-label-1854872' class=' answer'><span>Azure Database for PostgreSQL<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480038[]' id='answer-id-1854873' class='answer   answerof-480038 ' value='1854873'   \/><label for='answer-id-1854873' id='answer-label-1854873' class=' answer'><span>SQL Server on Azure virtual machines<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-23' style=';'><div id='questionWrap-23'  class='   watupro-question-id-480039'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>23. <\/span>Which counter should you monitor for real-time processing to meet the technical requirements?<\/div><input type='hidden' name='question_id[]' id='qID_23' value='480039' \/><input type='hidden' id='answerType480039' 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-480039[]' id='answer-id-1854874' class='answer   answerof-480039 ' value='1854874'   \/><label for='answer-id-1854874' id='answer-label-1854874' class=' answer'><span>SU% Utilization<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480039[]' id='answer-id-1854875' class='answer   answerof-480039 ' value='1854875'   \/><label for='answer-id-1854875' id='answer-label-1854875' class=' answer'><span>CPU% utilization<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480039[]' id='answer-id-1854876' class='answer   answerof-480039 ' value='1854876'   \/><label for='answer-id-1854876' id='answer-label-1854876' class=' answer'><span>Concurrent users<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480039[]' id='answer-id-1854877' class='answer   answerof-480039 ' value='1854877'   \/><label for='answer-id-1854877' id='answer-label-1854877' class=' answer'><span>Data Conversion Errors<\/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-480040'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>24. <\/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>During normal operations, provide at least two readable copies of Sales. <br \/>\r<br>Ensure that Sales remains available if a datacenter fails. <br \/>\r<br>Solution: You deploy an Azure SQL database that uses the Business Critical service tier and Availability Zones. <br \/>\r<br>Does this meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_24' value='480040' \/><input type='hidden' id='answerType480040' 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-480040[]' id='answer-id-1854878' class='answer   answerof-480040 ' value='1854878'   \/><label for='answer-id-1854878' id='answer-label-1854878' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480040[]' id='answer-id-1854879' class='answer   answerof-480040 ' value='1854879'   \/><label for='answer-id-1854879' id='answer-label-1854879' class=' answer'><span>No<\/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-480041'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>25. <\/span>HOTSPOT<br \/>\r\n<br \/>\r\nYou need to recommend which service and target endpoint to use when migrating the databases from SVR1 to Instance1. The solution must meet the availability requirements.<br \/>\r\n<br \/>\r\nWhat should you recommend? To answer, select the appropriate options in the answer area. NOTE Each correct selection is worth one point.<br \/>\r\n<br \/>\r\n<br \/>\r\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image029-5.jpg\" width=\"337\" height=\"184\" \/><\/div><input type='hidden' name='question_id[]' id='qID_25' value='480041' \/><input type='hidden' id='answerType480041' 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-480041[]' id='answer-id-1854880' class='answer   answerof-480041 ' value='1854880'   \/><label for='answer-id-1854880' id='answer-label-1854880' class=' answer'><span><br><img decoding=\"async\" width=337 height=185 id=\"\u56fe\u7247 23\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image030-4.jpg\"><br><\/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-480042'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>26. <\/span>You deploy a database to an Azure SQL Database managed instance. <br \/>\r<br>You need to prevent read queries from blocking queries that are trying to write to the database. <br \/>\r<br>Which database option should set?<\/div><input type='hidden' name='question_id[]' id='qID_26' value='480042' \/><input type='hidden' id='answerType480042' 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-480042[]' id='answer-id-1854881' class='answer   answerof-480042 ' value='1854881'   \/><label for='answer-id-1854881' id='answer-label-1854881' class=' answer'><span>PARAMETERIZATION to FORCED<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480042[]' id='answer-id-1854882' class='answer   answerof-480042 ' value='1854882'   \/><label for='answer-id-1854882' id='answer-label-1854882' class=' answer'><span>PARAMETERIZATION to SIMPLE<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480042[]' id='answer-id-1854883' class='answer   answerof-480042 ' value='1854883'   \/><label for='answer-id-1854883' id='answer-label-1854883' class=' answer'><span>Delayed Durability to Forced<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480042[]' id='answer-id-1854884' class='answer   answerof-480042 ' value='1854884'   \/><label for='answer-id-1854884' id='answer-label-1854884' class=' answer'><span>READ_COMMITTED_SNAPSHOT to ON<\/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-480043'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>27. <\/span>You have an Azure SQL database. <br \/>\r<br>You identify a long running query. <br \/>\r<br>You need to identify which operation in the query is causing the performance issue. <br \/>\r<br>What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?<\/div><input type='hidden' name='question_id[]' id='qID_27' value='480043' \/><input type='hidden' id='answerType480043' 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-480043[]' id='answer-id-1854885' class='answer   answerof-480043 ' value='1854885'   \/><label for='answer-id-1854885' id='answer-label-1854885' class=' answer'><span>Live Query Statistics<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480043[]' id='answer-id-1854886' class='answer   answerof-480043 ' value='1854886'   \/><label for='answer-id-1854886' id='answer-label-1854886' class=' answer'><span>an estimated execution plan<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480043[]' id='answer-id-1854887' class='answer   answerof-480043 ' value='1854887'   \/><label for='answer-id-1854887' id='answer-label-1854887' class=' answer'><span>an actual execution plan<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480043[]' id='answer-id-1854888' class='answer   answerof-480043 ' value='1854888'   \/><label for='answer-id-1854888' id='answer-label-1854888' class=' answer'><span>Client Statistics<\/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-480044'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>28. <\/span>You have an Azure SQL database. The database contains a table that uses a column store index and is accessed infrequently. <br \/>\r<br>You enable column store archival compression. <br \/>\r<br>What are two possible 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_28' value='480044' \/><input type='hidden' id='answerType480044' 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-480044[]' id='answer-id-1854889' class='answer   answerof-480044 ' value='1854889'   \/><label for='answer-id-1854889' id='answer-label-1854889' class=' answer'><span>Queries that use the index will consume more disk I\/<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480044[]' id='answer-id-1854890' class='answer   answerof-480044 ' value='1854890'   \/><label for='answer-id-1854890' id='answer-label-1854890' class=' answer'><span>Queries that use the index will retrieve fewer data pages.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480044[]' id='answer-id-1854891' class='answer   answerof-480044 ' value='1854891'   \/><label for='answer-id-1854891' id='answer-label-1854891' class=' answer'><span>The index will consume more disk space.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480044[]' id='answer-id-1854892' class='answer   answerof-480044 ' value='1854892'   \/><label for='answer-id-1854892' id='answer-label-1854892' class=' answer'><span>The index will consume more memory.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480044[]' id='answer-id-1854893' class='answer   answerof-480044 ' value='1854893'   \/><label for='answer-id-1854893' id='answer-label-1854893' class=' answer'><span>Queries that use the index will consume more CPU resources.<\/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-480045'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>29. <\/span>You have 10 Azure virtual machines that have SQL Server installed. <br \/>\r<br>You need to implement a backup strategy to ensure that you can restore specific databases to other SQL Server instances. The solution must provide centralized management of the backups. <br \/>\r<br>What should you include in the backup strategy?<\/div><input type='hidden' name='question_id[]' id='qID_29' value='480045' \/><input type='hidden' id='answerType480045' 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-480045[]' id='answer-id-1854894' class='answer   answerof-480045 ' value='1854894'   \/><label for='answer-id-1854894' id='answer-label-1854894' class=' answer'><span>Automated Backup in the SQL virtual machine settings<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480045[]' id='answer-id-1854895' class='answer   answerof-480045 ' value='1854895'   \/><label for='answer-id-1854895' id='answer-label-1854895' class=' answer'><span>Azure Backup<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480045[]' id='answer-id-1854896' class='answer   answerof-480045 ' value='1854896'   \/><label for='answer-id-1854896' id='answer-label-1854896' class=' answer'><span>Azure Site Recovery<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480045[]' id='answer-id-1854897' class='answer   answerof-480045 ' value='1854897'   \/><label for='answer-id-1854897' id='answer-label-1854897' class=' answer'><span>SQL Server Agent jobs<\/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-480046'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>30. <\/span>SIMULATION<br \/>\r\n<br \/>\r\nTask 5<br \/>\r\n<br \/>\r\nYou need to configure a disaster recovery solution for db1. When a failover occurs, the connection strings to the database must remain the same. The secondary server must be in the West US 3 Azure region.<\/div><input type='hidden' name='question_id[]' id='qID_30' value='480046' \/><input type='hidden' id='answerType480046' 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-480046[]' id='answer-id-1854898' class='answer   answerof-480046 ' value='1854898'   \/><label for='answer-id-1854898' id='answer-label-1854898' class=' answer'><span>To configure a disaster recovery solution for db1, you can use the failover groups feature of Azure SQL Database. Failover groups allow you to manage the replication and failover of a group of databases across different regions with the same connection strings1. You can also use active geo-replication as an alternative, but you will need to update the connection strings manually after a failover2. \r\n<br>Here are the steps to create a failover group for db1 with the secondary server in the West US 3 region: \r\n<br>Using the Azure portal: \r\n<br>Go to the Azure portal and select your Azure SQL Database server that hosts db1. \r\n<br>Select Failover groups in the left menu and click on Add group. \r\n<br>Enter a name for the failover group and select West US 3 as the secondary region. \r\n<br>Click on Create a new server and enter the details for the secondary server, such as server name, admin login, password, and subscription. \r\n<br>Click on Select existing database(s) and choose db1 from the list of databases on the primary server. \r\n<br>Click on Configure failover policy and select the failover mode, grace period, and read-write failover endpoint mode according to your preferences. \r\n<br>Click on Create to create the failover group and start the replication of db1 to the secondary server. \r\n<br>Using PowerShell commands: \r\n<br>Install the Azure PowerShell module and log in with your Azure account. \r\n<br>Run the following command to create a new server in the West US 3 region: New-AzSqlServer - ResourceGroupName &lt;your-resource-group-name&gt; -ServerName &lt;your-secondary-server-name&gt; - Location &quot;West US 3&quot; -SqlAdministratorCredentials $(New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList &quot;&lt;your-admin-login&gt;&quot;, $(ConvertTo-SecureString -String &quot;&lt;your-password&gt;&quot; -AsPlainText -Force)) \r\n<br>Run the following command to create a new failover group with db1: New-AzSqlDatabaseFailoverGroup -ResourceGroupName &lt;your-resource-group-name&gt; -ServerName &lt;your-primary-server-name&gt; -PartnerResourceGroupName &lt;your-resource-group-name&gt; - PartnerServerName &lt;your-secondary-server-name&gt; -FailoverGroupName &lt;your-failover-group-name&gt; -Database db1 -FailoverPolicy Manual -GracePeriodWithDataLossHours 1 - ReadWriteFailoverEndpoint &quot;Enabled&quot; \r\n<br>You can modify the parameters of the command according to your preferences, such as the failover policy, grace period, and read-write failover endpoint mode. \r\n<br>These are the steps to create a failover group for db1 with the secondary server in the West US 3 region.<\/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-480047'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>31. <\/span>DRAG DROP<br \/>\r\n<br \/>\r\nYou need to configure user authentication for the SERVER1 databases. The solution must meet the security and compliance requirements.<br \/>\r\n<br \/>\r\nWhich 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\n<br \/>\r\n<br \/>\r\n<img loading=\"lazy\" decoding=\"async\" id=\"\u56fe\u7247 3\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image003-7.jpg\" width=\"650\" height=\"378\" \/><\/div><input type='hidden' name='question_id[]' id='qID_31' value='480047' \/><input type='hidden' id='answerType480047' 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-480047[]' id='answer-id-1854899' class='answer   answerof-480047 ' value='1854899'   \/><label for='answer-id-1854899' id='answer-label-1854899' class=' answer'><span><br><img decoding=\"async\" width=650 height=378 id=\"\u56fe\u7247 4\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image004-6.jpg\"><br><\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-32' style=';'><div id='questionWrap-32'  class='   watupro-question-id-480048'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>32. <\/span>You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine. <br \/>\r<br>In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs. <br \/>\r<br>Which type of storage accounts should you use for the backups?<\/div><input type='hidden' name='question_id[]' id='qID_32' value='480048' \/><input type='hidden' id='answerType480048' 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-480048[]' id='answer-id-1854900' class='answer   answerof-480048 ' value='1854900'   \/><label for='answer-id-1854900' id='answer-label-1854900' class=' answer'><span>locally-redundant storage (LRS)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480048[]' id='answer-id-1854901' class='answer   answerof-480048 ' value='1854901'   \/><label for='answer-id-1854901' id='answer-label-1854901' class=' answer'><span>read-access geo-redundant storage (RA-GRS)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480048[]' id='answer-id-1854902' class='answer   answerof-480048 ' value='1854902'   \/><label for='answer-id-1854902' id='answer-label-1854902' class=' answer'><span>zone-redundant storage (ZRS)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480048[]' id='answer-id-1854903' class='answer   answerof-480048 ' value='1854903'   \/><label for='answer-id-1854903' id='answer-label-1854903' class=' answer'><span>geo-redundant storage<\/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-480049'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>33. <\/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 failover groups. <br \/>\r<br>Does this meet the goal?<\/div><input type='hidden' name='question_id[]' id='qID_33' value='480049' \/><input type='hidden' id='answerType480049' 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-480049[]' id='answer-id-1854904' class='answer   answerof-480049 ' value='1854904'   \/><label for='answer-id-1854904' id='answer-label-1854904' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480049[]' id='answer-id-1854905' class='answer   answerof-480049 ' value='1854905'   \/><label for='answer-id-1854905' id='answer-label-1854905' class=' answer'><span>No<\/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-480050'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>34. <\/span>You have a new Azure SQL database. The database contains a column that stores confidential information. <br \/>\r<br>You need to track each time values from the column are returned in a query. The tracking information must be stored for 365 days from the date the query was executed. <br \/>\r<br>Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.<\/div><input type='hidden' name='question_id[]' id='qID_34' value='480050' \/><input type='hidden' id='answerType480050' 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-480050[]' id='answer-id-1854906' class='answer   answerof-480050 ' value='1854906'   \/><label for='answer-id-1854906' id='answer-label-1854906' class=' answer'><span>Turn on auditing and write audit logs to an Azure Storage account.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480050[]' id='answer-id-1854907' class='answer   answerof-480050 ' value='1854907'   \/><label for='answer-id-1854907' id='answer-label-1854907' class=' answer'><span>Add extended properties to the column.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480050[]' id='answer-id-1854908' class='answer   answerof-480050 ' value='1854908'   \/><label for='answer-id-1854908' id='answer-label-1854908' class=' answer'><span>Turn on Advanced Data Security for the Azure SQL server.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480050[]' id='answer-id-1854909' class='answer   answerof-480050 ' value='1854909'   \/><label for='answer-id-1854909' id='answer-label-1854909' class=' answer'><span>Apply sensitivity labels named Highly Confidential to the column.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='checkbox' name='answer-480050[]' id='answer-id-1854910' class='answer   answerof-480050 ' value='1854910'   \/><label for='answer-id-1854910' id='answer-label-1854910' class=' answer'><span>Turn on Azure Advanced Threat Protection (ATP).<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-35' style=';'><div id='questionWrap-35'  class='   watupro-question-id-480051'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>35. <\/span>You need to recommend a solution to meet the security requirements and the business requirements for DB3. <br \/>\r<br>What should you recommend as the first step of the solution?<\/div><input type='hidden' name='question_id[]' id='qID_35' value='480051' \/><input type='hidden' id='answerType480051' 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-480051[]' id='answer-id-1854911' class='answer   answerof-480051 ' value='1854911'   \/><label for='answer-id-1854911' id='answer-label-1854911' class=' answer'><span>Run the sys.5p_cdc_en&laquo;ble_db stored procedure.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480051[]' id='answer-id-1854912' class='answer   answerof-480051 ' value='1854912'   \/><label for='answer-id-1854912' id='answer-label-1854912' class=' answer'><span>Run the alter table statement and specify the enable chahgc_tracking clause.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480051[]' id='answer-id-1854913' class='answer   answerof-480051 ' value='1854913'   \/><label for='answer-id-1854913' id='answer-label-1854913' class=' answer'><span>Run the alter database statement and specify the set cmange_trackinc&gt; - on clause.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480051[]' id='answer-id-1854914' class='answer   answerof-480051 ' value='1854914'   \/><label for='answer-id-1854914' id='answer-label-1854914' class=' answer'><span>Run the sp_addarticle stored procedure.<\/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-480052'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>36. <\/span>HOTSPOT<br \/>\r\n<br \/>\r\nYou 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\n<br \/>\r\nWhat should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.<br \/>\r\n<br \/>\r\n<br \/>\r\n<img loading=\"lazy\" decoding=\"async\" id=\"\u56fe\u7247 7\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image009-7.jpg\" width=\"560\" height=\"226\" \/><\/div><input type='hidden' name='question_id[]' id='qID_36' value='480052' \/><input type='hidden' id='answerType480052' 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-480052[]' id='answer-id-1854915' class='answer   answerof-480052 ' value='1854915'   \/><label for='answer-id-1854915' id='answer-label-1854915' class=' answer'><span><br><img decoding=\"async\" width=560 height=226 id=\"\u56fe\u7247 8\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2026\/05\/image010-7.jpg\"><br><\/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-480053'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>37. <\/span>You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked. <br \/>\r<br>You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1. <br \/>\r<br>You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements: <br \/>\r<br>&#10001; Ensure that VM1 cannot connect to any Azure SQL Server other than SqlSrv1. <br \/>\r<br>&#10001; Restrict network connectivity to SqlSrv1. <br \/>\r<br>What should you create on VNet1?<\/div><input type='hidden' name='question_id[]' id='qID_37' value='480053' \/><input type='hidden' id='answerType480053' 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-480053[]' id='answer-id-1854916' class='answer   answerof-480053 ' value='1854916'   \/><label for='answer-id-1854916' id='answer-label-1854916' class=' answer'><span>a VPN gateway<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480053[]' id='answer-id-1854917' class='answer   answerof-480053 ' value='1854917'   \/><label for='answer-id-1854917' id='answer-label-1854917' class=' answer'><span>a service endpoint<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480053[]' id='answer-id-1854918' class='answer   answerof-480053 ' value='1854918'   \/><label for='answer-id-1854918' id='answer-label-1854918' class=' answer'><span>a private link<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480053[]' id='answer-id-1854919' class='answer   answerof-480053 ' value='1854919'   \/><label for='answer-id-1854919' id='answer-label-1854919' class=' answer'><span>an ExpressRoute gateway<\/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-480054'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>38. <\/span>Topic 3, ADatum Corporation <br \/>\r<br><br \/>\r<br>Overview <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>ADatum Corporation is a retailer that sells products through two sales channels: retail stores and a website. <br \/>\r<br><br \/>\r<br>Existing Environment <br \/>\r<br>ADatum has one database server that has Microsoft SQL Server 2016 installed. The server hosts three mission-critical databases named SALESDB, DOCDB, and REPORTINGDB. <br \/>\r<br>SALESDB collects data from the stores and the website. <br \/>\r<br>DOCDB stores documents that connect to the sales data in SALESDB. The documents are stored in two different JSON formats based on the sales channel. <br \/>\r<br>REPORTINGDB stores reporting data and contains several columnstore indexes. A daily process creates reporting data in REPORTINGDB from the data in SALESDB. The process is implemented as a SQL Server Integration Services (SSIS) package that runs a stored procedure from SALESDB. <br \/>\r<br><br \/>\r<br>Requirements <br \/>\r<br>Planned Changes <br \/>\r<br>ADatum plans to move the current data infrastructure to Azure. <br \/>\r<br>The new infrastructure has the following requirements: <br \/>\r<br>&#10001; Migrate SALESDB and REPORTINGDB to an Azure SQL database. <br \/>\r<br>&#10001; Migrate DOCDB to Azure Cosmos DB. <br \/>\r<br>&#10001; The sales data, including the documents in JSON format, must be gathered as it arrives and analyzed online by using Azure Stream Analytics. The analytics process will perform aggregations that must be done continuously, without gaps, and without overlapping. <br \/>\r<br>&#10001; As they arrive, all the sales documents in JSON format must be transformed into one consistent format. <br \/>\r<br>&#10001; Azure Data Factory will replace the SSIS process of copying the data from SALESDB to REPORTINGDB. <br \/>\r<br><br \/>\r<br>Technical Requirements <br \/>\r<br>The new Azure data infrastructure must meet the following technical requirements: <br \/>\r<br>&#10001; Data in SALESDB must encrypted by using Transparent Data Encryption (TDE). The encryption must use your own key. <br \/>\r<br>&#10001; SALESDB must be restorable to any given minute within the past three weeks. <br \/>\r<br>&#10001; Real-time processing must be monitored to ensure that workloads are sized properly based on actual usage patterns. <br \/>\r<br>&#10001; Missing indexes must be created automatically for REPORTINGDB. <br \/>\r<br>&#10001; Disk IO, CPU, and memory usage must be monitored for SALESDB. <br \/>\r<br><br \/>\r<br>Which windowing function should you use to perform the streaming aggregation of the sales data?<\/div><input type='hidden' name='question_id[]' id='qID_38' value='480054' \/><input type='hidden' id='answerType480054' 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-480054[]' id='answer-id-1854920' class='answer   answerof-480054 ' value='1854920'   \/><label for='answer-id-1854920' id='answer-label-1854920' class=' answer'><span>Sliding<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480054[]' id='answer-id-1854921' class='answer   answerof-480054 ' value='1854921'   \/><label for='answer-id-1854921' id='answer-label-1854921' class=' answer'><span>Hopping<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480054[]' id='answer-id-1854922' class='answer   answerof-480054 ' value='1854922'   \/><label for='answer-id-1854922' id='answer-label-1854922' class=' answer'><span>Session<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480054[]' id='answer-id-1854923' class='answer   answerof-480054 ' value='1854923'   \/><label for='answer-id-1854923' id='answer-label-1854923' class=' answer'><span>Tumbling<\/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-480055'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>39. <\/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_39' value='480055' \/><input type='hidden' id='answerType480055' 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-480055[]' id='answer-id-1854924' class='answer   answerof-480055 ' value='1854924'   \/><label for='answer-id-1854924' id='answer-label-1854924' class=' answer'><span>Yes<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480055[]' id='answer-id-1854925' class='answer   answerof-480055 ' value='1854925'   \/><label for='answer-id-1854925' id='answer-label-1854925' class=' answer'><span>No<\/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-480056'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>40. <\/span>You have a version-8.0 Azure Database for MySQL database. <br \/>\r<br>You need to identify which database queries consume the most resources. <br \/>\r<br>Which tool should you use?<\/div><input type='hidden' name='question_id[]' id='qID_40' value='480056' \/><input type='hidden' id='answerType480056' 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-480056[]' id='answer-id-1854926' class='answer   answerof-480056 ' value='1854926'   \/><label for='answer-id-1854926' id='answer-label-1854926' class=' answer'><span>Query Store<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480056[]' id='answer-id-1854927' class='answer   answerof-480056 ' value='1854927'   \/><label for='answer-id-1854927' id='answer-label-1854927' class=' answer'><span>Metrics<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480056[]' id='answer-id-1854928' class='answer   answerof-480056 ' value='1854928'   \/><label for='answer-id-1854928' id='answer-label-1854928' class=' answer'><span>Query Performance Insight<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-480056[]' id='answer-id-1854929' class='answer   answerof-480056 ' value='1854929'   \/><label for='answer-id-1854929' id='answer-label-1854929' class=' answer'><span>Alerts<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div style='display:none' id='question-41'>\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=\"watuPROButtons12285\" >\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=\"12285\" id=\"watuPROExamID\"\/>\n\t<input type=\"hidden\" name=\"start_time\" id=\"startTime\" value=\"2026-06-01 08:26:21\" \/>\n\t<input type=\"hidden\" name=\"start_timestamp\" id=\"startTimeStamp\" value=\"1780302381\" \/>\n\t<input type=\"hidden\" name=\"question_ids\" value=\"\" \/>\n\t<input type=\"hidden\" name=\"watupro_questions\" value=\"480017:1854806,1854807,1854808,1854809,1854810 | 480018:1854811 | 480019:1854812 | 480020:1854813 | 480021:1854814,1854815,1854816,1854817,1854818 | 480022:1854819,1854820,1854821,1854822 | 480023:1854823,1854824,1854825,1854826,1854827 | 480024:1854828,1854829,1854830 | 480025:1854831,1854832,1854833,1854834 | 480026:1854835,1854836,1854837,1854838 | 480027:1854839,1854840,1854841,1854842 | 480028:1854843 | 480029:1854844 | 480030:1854845,1854846,1854847,1854848 | 480031:1854849,1854850,1854851,1854852 | 480032:1854853 | 480033:1854854 | 480034:1854855,1854856,1854857,1854858,1854859,1854860 | 480035:1854861 | 480036:1854862,1854863,1854864,1854865 | 480037:1854866,1854867,1854868,1854869 | 480038:1854870,1854871,1854872,1854873 | 480039:1854874,1854875,1854876,1854877 | 480040:1854878,1854879 | 480041:1854880 | 480042:1854881,1854882,1854883,1854884 | 480043:1854885,1854886,1854887,1854888 | 480044:1854889,1854890,1854891,1854892,1854893 | 480045:1854894,1854895,1854896,1854897 | 480046:1854898 | 480047:1854899 | 480048:1854900,1854901,1854902,1854903 | 480049:1854904,1854905 | 480050:1854906,1854907,1854908,1854909,1854910 | 480051:1854911,1854912,1854913,1854914 | 480052:1854915 | 480053:1854916,1854917,1854918,1854919 | 480054:1854920,1854921,1854922,1854923 | 480055:1854924,1854925 | 480056:1854926,1854927,1854928,1854929\" \/>\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 = \"480017,480018,480019,480020,480021,480022,480023,480024,480025,480026,480027,480028,480029,480030,480031,480032,480033,480034,480035,480036,480037,480038,480039,480040,480041,480042,480043,480044,480045,480046,480047,480048,480049,480050,480051,480052,480053,480054,480055,480056\";\nWatuPROSettings[12285] = {};\nWatuPRO.qArr = question_ids.split(',');\nWatuPRO.exam_id = 12285;\t    \nWatuPRO.post_id = 127908;\nWatuPRO.store_progress = 0;\nWatuPRO.curCatPage = 1;\nWatuPRO.requiredIDs=\"0\".split(\",\");\nWatuPRO.hAppID = \"0.78809000 1780302381\";\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(12285);\nWatuPRO.inCategoryPages=1;});    \t \n<\/script>\n","protected":false},"excerpt":{"rendered":"<p>The Microsoft Certified: Azure Database Administrator Associate (DP-300) comprehensively evaluates your ability to manage both on-premises and cloud-based databases using SQL Server and advanced Azure SQL services. If you want to pass the Microsoft DP-300 exam successfully, you need to focus on the most updated dumps from DumpsBase. We have updated the DP-300 dumps to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[101,4088,21253],"tags":[9449],"class_list":["post-127908","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-azure-certification","category-microsoft-certified-azure-database-administrator-associate","tag-dp-300"],"_links":{"self":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/127908","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=127908"}],"version-history":[{"count":1,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/127908\/revisions"}],"predecessor-version":[{"id":127909,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/127908\/revisions\/127909"}],"wp:attachment":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/media?parent=127908"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/categories?post=127908"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/tags?post=127908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}