{"id":4634,"date":"2019-11-18T02:43:58","date_gmt":"2019-11-18T02:43:58","guid":{"rendered":"https:\/\/www.dumpsbase.com\/freedumps\/?p=4634"},"modified":"2019-11-18T02:44:02","modified_gmt":"2019-11-18T02:44:02","slug":"sql-2016-database-administration-exam-70-764-dumps-updated","status":"publish","type":"post","link":"https:\/\/www.dumpsbase.com\/freedumps\/sql-2016-database-administration-exam-70-764-dumps-updated.html","title":{"rendered":"SQL 2016 Database Administration Exam 70-764 Dumps Updated"},"content":{"rendered":"\n<p>Database professionals who are preparing for Administering a SQL Database Infrastructure exam need to choose great 70-764 study materials for good preparation. So come to get SQL 2016 Database Administration Exam 70-764 Dumps now, we have updated Microsoft MCSA: SQL 2016 Database Administration 70-764 dumps questions. We provide your proper 70-764 exam dumps for preparing and passing the 70-764 exam with confidence at first attempt by obtaining a good grade.<\/p>\n<h2><span style=\"color: #993300;\">Free Microsoft MCSA 70-764 Exam Dumps Online<\/span><\/h2>\n<script>\n  window.fbAsyncInit = function() {\n    FB.init({\n      appId            : '622169541470367',\n      autoLogAppEvents : true,\n      xfbml            : true,\n      version          : 'v3.1'\n    });\n  };\n\n  (function(d, s, id){\n     var js, fjs = d.getElementsByTagName(s)[0];\n     if (d.getElementById(id)) {return;}\n     js = d.createElement(s); js.id = id;\n     js.src = \"https:\/\/connect.facebook.net\/en_US\/sdk.js\";\n     fjs.parentNode.insertBefore(js, fjs);\n   }(document, 'script', 'facebook-jssdk'));\n<\/script><div id=\"watu_quiz\" class=\"quiz-area single-page-quiz\">\n<p><\/p><form action=\"\" method=\"post\" class=\"quiz-form \" id=\"quiz-2018\" >\n<div class='watu-question' id='question-1'><div class='question-content'><p><span class='watu_num'>1. <\/span>Topic 1, Exam Pool A <\/p>\n<p>Note: This question is part of a series of question that present the same scenario. Each question in the series contains I 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 \/>\n<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 screAen. Your company has several Microsoft SQL Saver instance. Each instance hosts many database. You observe I\/O corruption on some of the instance.<br \/>\n<br \/>You need to perform the following actions:<br \/>\n<br \/>&#8211; identify databases where the PAGE verity option is not set.<br \/>\n<br \/>&#8211; Configure full page protection for the identified databases.<br \/>\n<br \/>Solution: You run the following Transact-SQL statement: <\/p>\n<p><img decoding=\"async\" width=536 height=113 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image002.jpg\" v:shapes=\"_x0000_i1025\"><\/p>\n<p>For each database that you identify, you run the following Transact-SQL statement: <\/p>\n<p><img decoding=\"async\" width=357 height=49 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image004.jpg\" v:shapes=\"_x0000_i1026\"><\/p>\n<p>Does the solution meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115886' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478011' \/><div class='watu-question-choice'><input type='radio' name='answer-115886[]' id='answer-id-478011' class='answer answer-1  answerof-115886' value='478011' \/>&nbsp;<label for='answer-id-478011' id='answer-label-478011' class=' answer label-1'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478012' \/><div class='watu-question-choice'><input type='radio' name='answer-115886[]' id='answer-id-478012' class='answer answer-1  answerof-115886' value='478012' \/>&nbsp;<label for='answer-id-478012' id='answer-label-478012' class=' answer label-1'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType1' value='radio' class=''><\/div><div class='watu-question' id='question-2'><div class='question-content'><p><span class='watu_num'>2. <\/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 \/>\n<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. Your company has several Microsoft SOI Server instances. Each instance hosts many databases. You observe I\/O corruption on some of the instances.<br \/>\n<br \/>You need to perform the following actions:<br \/>\n<br \/>&#8211; Identify databases where the PAGE VERIFY option is not set.<br \/>\n<br \/>&#8211; Configure full page protection for the identified databases.<br \/>\n<br \/>Solution: You run the following Transact-SQL statement: <\/p>\n<p><img decoding=\"async\" width=609 height=106 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image006.jpg\" v:shapes=\"_x0000_i1027\"><\/p>\n<p>For each database that you identify, you run the following Transact-SQL statement: <\/p>\n<p><img decoding=\"async\" width=467 height=62 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image008.jpg\" v:shapes=\"_x0000_i1028\"><\/p>\n<p>Does the solution meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115887' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478013' \/><div class='watu-question-choice'><input type='radio' name='answer-115887[]' id='answer-id-478013' class='answer answer-2  answerof-115887' value='478013' \/>&nbsp;<label for='answer-id-478013' id='answer-label-478013' class=' answer label-2'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478014' \/><div class='watu-question-choice'><input type='radio' name='answer-115887[]' id='answer-id-478014' class='answer answer-2  answerof-115887' value='478014' \/>&nbsp;<label for='answer-id-478014' id='answer-label-478014' class=' answer label-2'><span class='answer'>NO<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType2' value='radio' class=''><\/div><div class='watu-question' id='question-3'><div class='question-content'><p><span class='watu_num'>3. <\/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 goals. Some question sets might have more than one correct solution, while others might not have a correct solution.<br \/>\n<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. Your company has several Microsoft SQL Server instances, Each instance hosts many databases. You observe I\/O corruption on some of the instances<br \/>\n<br \/>You need to perform the following actions:<br \/>\n<br \/>&#8211; Identify databases where the PAGE VERIFY option is not set<br \/>\n<br \/>&#8211; Configure full page protection for the identified databases.<br \/>\n<br \/>Solution: You run the following Transact-SQL statement: <\/p>\n<p><img decoding=\"async\" width=534 height=112 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image010.jpg\" v:shapes=\"_x0000_i1029\"><\/p>\n<p>For each database that you identify, you run the following Transact-SQL statement: <\/p>\n<p><img decoding=\"async\" width=467 height=62 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image008.jpg\" v:shapes=\"_x0000_i1030\"><\/p>\n<p>Does the solution meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115888' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478015' \/><div class='watu-question-choice'><input type='radio' name='answer-115888[]' id='answer-id-478015' class='answer answer-3  answerof-115888' value='478015' \/>&nbsp;<label for='answer-id-478015' id='answer-label-478015' class=' answer label-3'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478016' \/><div class='watu-question-choice'><input type='radio' name='answer-115888[]' id='answer-id-478016' class='answer answer-3  answerof-115888' value='478016' \/>&nbsp;<label for='answer-id-478016' id='answer-label-478016' class=' answer label-3'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType3' value='radio' class=''><\/div><div class='watu-question' id='question-4'><div class='question-content'><p><span class='watu_num'>4. <\/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 goals. Some question sets might have more than one correct solution, while others might not have a correct solution.<br \/>\n<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 \/>\n<br \/>You have a database named DB1 that is 640 GB and is updated frequently. You enabled log shipping for DB1 and configure backup and restore to occur every 30 minutes. You discover that the disks on the data server are almost full. You need to reduce the amount of disk space used by the log shipping process.<br \/>\n<br \/>Solution: You configure log shipping to backup and restore by using shared folder.<br \/>\n<br \/>Does this meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115889' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478017' \/><div class='watu-question-choice'><input type='radio' name='answer-115889[]' id='answer-id-478017' class='answer answer-4  answerof-115889' value='478017' \/>&nbsp;<label for='answer-id-478017' id='answer-label-478017' class=' answer label-4'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478018' \/><div class='watu-question-choice'><input type='radio' name='answer-115889[]' id='answer-id-478018' class='answer answer-4  answerof-115889' value='478018' \/>&nbsp;<label for='answer-id-478018' id='answer-label-478018' class=' answer label-4'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType4' value='radio' class=''><\/div><div class='watu-question' id='question-5'><div class='question-content'><p><span class='watu_num'>5. <\/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 goals. Some question sets might have more than one correct solution, while others might not have a correct solution.<br \/>\n<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 \/>\n<br \/>You have a database named DB1 that is 640 GB and is updated frequently. You enabled log shipping for DB1 and configure backup and restore to occur every 30 minutes. You discover that the disks on the data server are almost full. You need to reduce the amount of disk space used by the log shipping process.<br \/>\n<br \/>Solution: You enable compression for the transaction log backups:<br \/>\n<br \/>Does this meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115890' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478019' \/><div class='watu-question-choice'><input type='radio' name='answer-115890[]' id='answer-id-478019' class='answer answer-5  answerof-115890' value='478019' \/>&nbsp;<label for='answer-id-478019' id='answer-label-478019' class=' answer label-5'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478020' \/><div class='watu-question-choice'><input type='radio' name='answer-115890[]' id='answer-id-478020' class='answer answer-5  answerof-115890' value='478020' \/>&nbsp;<label for='answer-id-478020' id='answer-label-478020' class=' answer label-5'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType5' value='radio' class=''><\/div><div class='watu-question' id='question-6'><div class='question-content'><p><span class='watu_num'>6. <\/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 goals. Some question sets might have more than one correct solution, while others might not have a correct solution.<br \/>\n<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 \/>\n<br \/>You have a database named DB1 that is 640 GB and is updated frequently. You enabled log shipping for DB1 and configure backup and restore to occur every 30 minutes. You discover that the disks on the data server are almost full. You need to reduce the amount of disk space used by the log shipping process.<br \/>\n<br \/>Solution: You increase the frequency of the transaction log backups to every 10 minutes.<br \/>\n<br \/>Does this meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115891' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478021' \/><div class='watu-question-choice'><input type='radio' name='answer-115891[]' id='answer-id-478021' class='answer answer-6  answerof-115891' value='478021' \/>&nbsp;<label for='answer-id-478021' id='answer-label-478021' class=' answer label-6'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478022' \/><div class='watu-question-choice'><input type='radio' name='answer-115891[]' id='answer-id-478022' class='answer answer-6  answerof-115891' value='478022' \/>&nbsp;<label for='answer-id-478022' id='answer-label-478022' class=' answer label-6'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType6' value='radio' class=''><\/div><div class='watu-question' id='question-7'><div class='question-content'><p><span class='watu_num'>7. <\/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 \/>\n<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 \/>\n<br \/>You need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail.<br \/>\n<br \/>Solution: You add the DatabaseMailUserRole to Mail1 in the tempdb database.<br \/>\n<br \/>Does the solution meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115892' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478023' \/><div class='watu-question-choice'><input type='radio' name='answer-115892[]' id='answer-id-478023' class='answer answer-7  answerof-115892' value='478023' \/>&nbsp;<label for='answer-id-478023' id='answer-label-478023' class=' answer label-7'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478024' \/><div class='watu-question-choice'><input type='radio' name='answer-115892[]' id='answer-id-478024' class='answer answer-7  answerof-115892' value='478024' \/>&nbsp;<label for='answer-id-478024' id='answer-label-478024' class=' answer label-7'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType7' value='radio' class=''><\/div><div class='watu-question' id='question-8'><div class='question-content'><p><span class='watu_num'>8. <\/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 \/>\n<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 \/>\n<br \/>You need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail.<br \/>\n<br \/>Solution: You add the DatabaseMailUserRole to Mail1 in the msdb database.<br \/>\n<br \/>Does the solution meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115893' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478025' \/><div class='watu-question-choice'><input type='radio' name='answer-115893[]' id='answer-id-478025' class='answer answer-8  answerof-115893' value='478025' \/>&nbsp;<label for='answer-id-478025' id='answer-label-478025' class=' answer label-8'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478026' \/><div class='watu-question-choice'><input type='radio' name='answer-115893[]' id='answer-id-478026' class='answer answer-8  answerof-115893' value='478026' \/>&nbsp;<label for='answer-id-478026' id='answer-label-478026' class=' answer label-8'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType8' value='radio' class=''><\/div><div class='watu-question' id='question-9'><div class='question-content'><p><span class='watu_num'>9. <\/span>Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.<br \/>\n<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 \/>\n<br \/>You need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail.<br \/>\n<br \/>Solution: You add the DatabaseMailUserRole to Mail1 in the master database.<br \/>\n<br \/>Does the solution meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115894' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478027' \/><div class='watu-question-choice'><input type='radio' name='answer-115894[]' id='answer-id-478027' class='answer answer-9  answerof-115894' value='478027' \/>&nbsp;<label for='answer-id-478027' id='answer-label-478027' class=' answer label-9'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478028' \/><div class='watu-question-choice'><input type='radio' name='answer-115894[]' id='answer-id-478028' class='answer answer-9  answerof-115894' value='478028' \/>&nbsp;<label for='answer-id-478028' id='answer-label-478028' class=' answer label-9'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType9' value='radio' class=''><\/div><div class='watu-question' id='question-10'><div class='question-content'><p><span class='watu_num'>10. <\/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 \/>\n<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 \/>\n<br \/>A company has a server that runs Microsoft SQL Server 2016 Web edition. The server has a default instance that hosts a database named DB1.<br \/>\n<br \/>You need to ensure that you can perform auditing at the database level for DB1.<br \/>\n<br \/>Solution: You migrate DB1 to the default instance on a server that runs Microsoft SQL Server 2016 Standard edition.<br \/>\n<br \/>Does the solution meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115895' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478029' \/><div class='watu-question-choice'><input type='radio' name='answer-115895[]' id='answer-id-478029' class='answer answer-10  answerof-115895' value='478029' \/>&nbsp;<label for='answer-id-478029' id='answer-label-478029' class=' answer label-10'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478030' \/><div class='watu-question-choice'><input type='radio' name='answer-115895[]' id='answer-id-478030' class='answer answer-10  answerof-115895' value='478030' \/>&nbsp;<label for='answer-id-478030' id='answer-label-478030' class=' answer label-10'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType10' value='radio' class=''><\/div><div class='watu-question' id='question-11'><div class='question-content'><p><span class='watu_num'>11. <\/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 \/>\n<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 \/>\n<br \/>A company has a server that runs Microsoft SQL Server 2016 Web edition. The server has a default instance that hosts a database named DB1.<br \/>\n<br \/>You need to ensure that you can perform auditing at the database level for DB1.<br \/>\n<br \/>Solution: You migrate DB1 to a named instance on a server that runs Microsoft SQL Server 2016 Enterprise edition.<br \/>\n<br \/>Does the solution meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115897' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478032' \/><div class='watu-question-choice'><input type='radio' name='answer-115897[]' id='answer-id-478032' class='answer answer-11  answerof-115897' value='478032' \/>&nbsp;<label for='answer-id-478032' id='answer-label-478032' class=' answer label-11'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478034' \/><div class='watu-question-choice'><input type='radio' name='answer-115897[]' id='answer-id-478034' class='answer answer-11  answerof-115897' value='478034' \/>&nbsp;<label for='answer-id-478034' id='answer-label-478034' class=' answer label-11'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType11' value='radio' class=''><\/div><div class='watu-question' id='question-12'><div class='question-content'><p><span class='watu_num'>12. <\/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 \/>\n<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 \/>\n<br \/>A company has a server that runs Microsoft SQL Server 2016 Web edition. The server has a default instance that hosts a database named DB1.<br \/>\n<br \/>You need to ensure that you can perform auditing at the database level for DB1.<br \/>\n<br \/>Solution: You migrate DB1 to a named instance on a server than runs Microsoft SQL Server 2016 Standard edition.<br \/>\n<br \/>Does the solution meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115898' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478037' \/><div class='watu-question-choice'><input type='radio' name='answer-115898[]' id='answer-id-478037' class='answer answer-12  answerof-115898' value='478037' \/>&nbsp;<label for='answer-id-478037' id='answer-label-478037' class=' answer label-12'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478038' \/><div class='watu-question-choice'><input type='radio' name='answer-115898[]' id='answer-id-478038' class='answer answer-12  answerof-115898' value='478038' \/>&nbsp;<label for='answer-id-478038' id='answer-label-478038' class=' answer label-12'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType12' value='radio' class=''><\/div><div class='watu-question' id='question-13'><div class='question-content'><p><span class='watu_num'>13. <\/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 \/>\n<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 \/>\n<br \/>A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases. One customer reports that their database is not responding as quickly as the service level<br \/>\n<br \/>agreements dictate. You observe that the database is fragmented. You need to optimize query performance.<br \/>\n<br \/>Solution: You reorganize all indexes.<br \/>\n<br \/>Does the solution meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115900' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478040' \/><div class='watu-question-choice'><input type='radio' name='answer-115900[]' id='answer-id-478040' class='answer answer-13  answerof-115900' value='478040' \/>&nbsp;<label for='answer-id-478040' id='answer-label-478040' class=' answer label-13'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478042' \/><div class='watu-question-choice'><input type='radio' name='answer-115900[]' id='answer-id-478042' class='answer answer-13  answerof-115900' value='478042' \/>&nbsp;<label for='answer-id-478042' id='answer-label-478042' class=' answer label-13'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType13' value='radio' class=''><\/div><div class='watu-question' id='question-14'><div class='question-content'><p><span class='watu_num'>14. <\/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 \/>\n<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 \/>\n<br \/>A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases.<br \/>\n<br \/>One customer reports that their database is not responding as quickly as the service level agreements dictate. You observe that the database is fragmented. You need to optimize query performance.<br \/>\n<br \/>Solution: You rebuild all indexes.<br \/>\n<br \/>Does the solution meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115901' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478045' \/><div class='watu-question-choice'><input type='radio' name='answer-115901[]' id='answer-id-478045' class='answer answer-14  answerof-115901' value='478045' \/>&nbsp;<label for='answer-id-478045' id='answer-label-478045' class=' answer label-14'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478046' \/><div class='watu-question-choice'><input type='radio' name='answer-115901[]' id='answer-id-478046' class='answer answer-14  answerof-115901' value='478046' \/>&nbsp;<label for='answer-id-478046' id='answer-label-478046' class=' answer label-14'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType14' value='radio' class=''><\/div><div class='watu-question' id='question-15'><div class='question-content'><p><span class='watu_num'>15. <\/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 \/>\n<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 \/>\n<br \/>A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases.<br \/>\n<br \/>One customer reports that their database is not responding as quickly as the service level agreements dictate. You observe that the database is fragmented.<br \/>\n<br \/>You need to optimize query performance.<br \/>\n<br \/>Solution: You run the DBCC CHECKDB command.<br \/>\n<br \/>Does the solution meet the goal?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115903' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478049' \/><div class='watu-question-choice'><input type='radio' name='answer-115903[]' id='answer-id-478049' class='answer answer-15  answerof-115903' value='478049' \/>&nbsp;<label for='answer-id-478049' id='answer-label-478049' class=' answer label-15'><span class='answer'>Yes<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478051' \/><div class='watu-question-choice'><input type='radio' name='answer-115903[]' id='answer-id-478051' class='answer answer-15  answerof-115903' value='478051' \/>&nbsp;<label for='answer-id-478051' id='answer-label-478051' class=' answer label-15'><span class='answer'>No<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType15' value='radio' class=''><\/div><div class='watu-question' id='question-16'><div class='question-content'><p><span class='watu_num'>16. <\/span>Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.<br \/>\n<br \/>You are the database administrator for a company that hosts Microsoft SQL Server. You manage both on-premises and Microsoft Azure SQL Database environments.<br \/>\n<br \/>One instance hosts a user database named HRDB. The database contains sensitive human resources data.<br \/>\n<br \/>You need to grant an auditor permission to view the SQL Server audit logs while following the principle of least privilege.<br \/>\n<br \/>Which permission should you grant?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115904' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478053' \/><div class='watu-question-choice'><input type='radio' name='answer-115904[]' id='answer-id-478053' class='answer answer-16  answerof-115904' value='478053' \/>&nbsp;<label for='answer-id-478053' id='answer-label-478053' class=' answer label-16'><span class='answer'>DDLAdmin<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478055' \/><div class='watu-question-choice'><input type='radio' name='answer-115904[]' id='answer-id-478055' class='answer answer-16  answerof-115904' value='478055' \/>&nbsp;<label for='answer-id-478055' id='answer-label-478055' class=' answer label-16'><span class='answer'>db_datawriter<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478057' \/><div class='watu-question-choice'><input type='radio' name='answer-115904[]' id='answer-id-478057' class='answer answer-16  answerof-115904' value='478057' \/>&nbsp;<label for='answer-id-478057' id='answer-label-478057' class=' answer label-16'><span class='answer'>dbcreator<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478059' \/><div class='watu-question-choice'><input type='radio' name='answer-115904[]' id='answer-id-478059' class='answer answer-16  answerof-115904' value='478059' \/>&nbsp;<label for='answer-id-478059' id='answer-label-478059' class=' answer label-16'><span class='answer'>dbo<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478061' \/><div class='watu-question-choice'><input type='radio' name='answer-115904[]' id='answer-id-478061' class='answer answer-16  answerof-115904' value='478061' \/>&nbsp;<label for='answer-id-478061' id='answer-label-478061' class=' answer label-16'><span class='answer'>View Database State<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478062' \/><div class='watu-question-choice'><input type='radio' name='answer-115904[]' id='answer-id-478062' class='answer answer-16  answerof-115904' value='478062' \/>&nbsp;<label for='answer-id-478062' id='answer-label-478062' class=' answer label-16'><span class='answer'>View Server State<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478064' \/><div class='watu-question-choice'><input type='radio' name='answer-115904[]' id='answer-id-478064' class='answer answer-16  answerof-115904' value='478064' \/>&nbsp;<label for='answer-id-478064' id='answer-label-478064' class=' answer label-16'><span class='answer'>View Definition<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478066' \/><div class='watu-question-choice'><input type='radio' name='answer-115904[]' id='answer-id-478066' class='answer answer-16  answerof-115904' value='478066' \/>&nbsp;<label for='answer-id-478066' id='answer-label-478066' class=' answer label-16'><span class='answer'>sysadmin<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType16' value='radio' class=''><\/div><div class='watu-question' id='question-17'><div class='question-content'><p><span class='watu_num'>17. <\/span>Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.<br \/>\n<br \/>You manage a Microsoft SQL Server environment. You implement Transparent Data Encryption (TDE).<br \/>\n<br \/>A user will assist in managing TDE.<br \/>\n<br \/>You need to ensure that the user can view the TDE metadata while following the principle of lease privilege.<br \/>\n<br \/>Which permission should you grant?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115907' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478069' \/><div class='watu-question-choice'><input type='radio' name='answer-115907[]' id='answer-id-478069' class='answer answer-17  answerof-115907' value='478069' \/>&nbsp;<label for='answer-id-478069' id='answer-label-478069' class=' answer label-17'><span class='answer'>DDLAdmin<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478070' \/><div class='watu-question-choice'><input type='radio' name='answer-115907[]' id='answer-id-478070' class='answer answer-17  answerof-115907' value='478070' \/>&nbsp;<label for='answer-id-478070' id='answer-label-478070' class=' answer label-17'><span class='answer'>db_datawriter<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478072' \/><div class='watu-question-choice'><input type='radio' name='answer-115907[]' id='answer-id-478072' class='answer answer-17  answerof-115907' value='478072' \/>&nbsp;<label for='answer-id-478072' id='answer-label-478072' class=' answer label-17'><span class='answer'>dbcreator<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478074' \/><div class='watu-question-choice'><input type='radio' name='answer-115907[]' id='answer-id-478074' class='answer answer-17  answerof-115907' value='478074' \/>&nbsp;<label for='answer-id-478074' id='answer-label-478074' class=' answer label-17'><span class='answer'>dbo<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478076' \/><div class='watu-question-choice'><input type='radio' name='answer-115907[]' id='answer-id-478076' class='answer answer-17  answerof-115907' value='478076' \/>&nbsp;<label for='answer-id-478076' id='answer-label-478076' class=' answer label-17'><span class='answer'>View Database State<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478078' \/><div class='watu-question-choice'><input type='radio' name='answer-115907[]' id='answer-id-478078' class='answer answer-17  answerof-115907' value='478078' \/>&nbsp;<label for='answer-id-478078' id='answer-label-478078' class=' answer label-17'><span class='answer'>View Server State<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478079' \/><div class='watu-question-choice'><input type='radio' name='answer-115907[]' id='answer-id-478079' class='answer answer-17  answerof-115907' value='478079' \/>&nbsp;<label for='answer-id-478079' id='answer-label-478079' class=' answer label-17'><span class='answer'>View Definition<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478081' \/><div class='watu-question-choice'><input type='radio' name='answer-115907[]' id='answer-id-478081' class='answer answer-17  answerof-115907' value='478081' \/>&nbsp;<label for='answer-id-478081' id='answer-label-478081' class=' answer label-17'><span class='answer'>sysadmin<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType17' value='radio' class=''><\/div><div class='watu-question' id='question-18'><div class='question-content'><p><span class='watu_num'>18. <\/span>Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.<br \/>\n<br \/>You are the database administrator for a company that hosts Microsoft SQL Server. You manage both on-premises and Microsoft Azure SQL Database environments.<br \/>\n<br \/>You have a user database named HRDB that contains sensitive human resources data. The HRDB backup files must be encrypted.<br \/>\n<br \/>You need to grant the correct permission to the service account that backs up the HRDB database.<br \/>\n<br \/>Which permission should you grant?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115910' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478084' \/><div class='watu-question-choice'><input type='radio' name='answer-115910[]' id='answer-id-478084' class='answer answer-18  answerof-115910' value='478084' \/>&nbsp;<label for='answer-id-478084' id='answer-label-478084' class=' answer label-18'><span class='answer'>DDLAdmin<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478086' \/><div class='watu-question-choice'><input type='radio' name='answer-115910[]' id='answer-id-478086' class='answer answer-18  answerof-115910' value='478086' \/>&nbsp;<label for='answer-id-478086' id='answer-label-478086' class=' answer label-18'><span class='answer'>db_datawriter<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478087' \/><div class='watu-question-choice'><input type='radio' name='answer-115910[]' id='answer-id-478087' class='answer answer-18  answerof-115910' value='478087' \/>&nbsp;<label for='answer-id-478087' id='answer-label-478087' class=' answer label-18'><span class='answer'>dbcreator<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478089' \/><div class='watu-question-choice'><input type='radio' name='answer-115910[]' id='answer-id-478089' class='answer answer-18  answerof-115910' value='478089' \/>&nbsp;<label for='answer-id-478089' id='answer-label-478089' class=' answer label-18'><span class='answer'>dbo<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478091' \/><div class='watu-question-choice'><input type='radio' name='answer-115910[]' id='answer-id-478091' class='answer answer-18  answerof-115910' value='478091' \/>&nbsp;<label for='answer-id-478091' id='answer-label-478091' class=' answer label-18'><span class='answer'>View Database State<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478093' \/><div class='watu-question-choice'><input type='radio' name='answer-115910[]' id='answer-id-478093' class='answer answer-18  answerof-115910' value='478093' \/>&nbsp;<label for='answer-id-478093' id='answer-label-478093' class=' answer label-18'><span class='answer'>View Server State<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478095' \/><div class='watu-question-choice'><input type='radio' name='answer-115910[]' id='answer-id-478095' class='answer answer-18  answerof-115910' value='478095' \/>&nbsp;<label for='answer-id-478095' id='answer-label-478095' class=' answer label-18'><span class='answer'>View Definition<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478096' \/><div class='watu-question-choice'><input type='radio' name='answer-115910[]' id='answer-id-478096' class='answer answer-18  answerof-115910' value='478096' \/>&nbsp;<label for='answer-id-478096' id='answer-label-478096' class=' answer label-18'><span class='answer'>sysadmin<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType18' value='radio' class=''><\/div><div class='watu-question' id='question-19'><div class='question-content'><p><span class='watu_num'>19. <\/span>Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.<br \/>\n<br \/>You are the database administrator for a company that hosts Microsoft SQL Server. You manage both on-premises and Microsoft Azure SQL Database environments.<br \/>\n<br \/>You plan to delegate encryption operations to a user.<br \/>\n<br \/>You need to grant the user permission to implement cell-level encryption while following the principle of least privilege.<br \/>\n<br \/>Which permission should you grant?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115913' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478099' \/><div class='watu-question-choice'><input type='radio' name='answer-115913[]' id='answer-id-478099' class='answer answer-19  answerof-115913' value='478099' \/>&nbsp;<label for='answer-id-478099' id='answer-label-478099' class=' answer label-19'><span class='answer'>DDLAdmin<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478101' \/><div class='watu-question-choice'><input type='radio' name='answer-115913[]' id='answer-id-478101' class='answer answer-19  answerof-115913' value='478101' \/>&nbsp;<label for='answer-id-478101' id='answer-label-478101' class=' answer label-19'><span class='answer'>db_datawriter<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478103' \/><div class='watu-question-choice'><input type='radio' name='answer-115913[]' id='answer-id-478103' class='answer answer-19  answerof-115913' value='478103' \/>&nbsp;<label for='answer-id-478103' id='answer-label-478103' class=' answer label-19'><span class='answer'>dbcreator<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478104' \/><div class='watu-question-choice'><input type='radio' name='answer-115913[]' id='answer-id-478104' class='answer answer-19  answerof-115913' value='478104' \/>&nbsp;<label for='answer-id-478104' id='answer-label-478104' class=' answer label-19'><span class='answer'>dbo<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478105' \/><div class='watu-question-choice'><input type='radio' name='answer-115913[]' id='answer-id-478105' class='answer answer-19  answerof-115913' value='478105' \/>&nbsp;<label for='answer-id-478105' id='answer-label-478105' class=' answer label-19'><span class='answer'>View Database State<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478107' \/><div class='watu-question-choice'><input type='radio' name='answer-115913[]' id='answer-id-478107' class='answer answer-19  answerof-115913' value='478107' \/>&nbsp;<label for='answer-id-478107' id='answer-label-478107' class=' answer label-19'><span class='answer'>View ServerState<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478109' \/><div class='watu-question-choice'><input type='radio' name='answer-115913[]' id='answer-id-478109' class='answer answer-19  answerof-115913' value='478109' \/>&nbsp;<label for='answer-id-478109' id='answer-label-478109' class=' answer label-19'><span class='answer'>View Definition<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478111' \/><div class='watu-question-choice'><input type='radio' name='answer-115913[]' id='answer-id-478111' class='answer answer-19  answerof-115913' value='478111' \/>&nbsp;<label for='answer-id-478111' id='answer-label-478111' class=' answer label-19'><span class='answer'>sysadmin<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType19' value='radio' class=''><\/div><div class='watu-question' id='question-20'><div class='question-content'><p><span class='watu_num'>20. <\/span>Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.<br \/>\n<br \/>A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts a customer database named DB1.<br \/>\n<br \/>Customers connect to hosted database instances by using line-of-business applications. Developers connect by using SQL Server Management Studio (SSMS).<br \/>\n<br \/>You need to grant the developers permission to alter views for DB1 while following the principle of least privilege.<br \/>\n<br \/>Which permission should you grant?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115915' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478113' \/><div class='watu-question-choice'><input type='radio' name='answer-115915[]' id='answer-id-478113' class='answer answer-20  answerof-115915' value='478113' \/>&nbsp;<label for='answer-id-478113' id='answer-label-478113' class=' answer label-20'><span class='answer'>DDLAdmin<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478115' \/><div class='watu-question-choice'><input type='radio' name='answer-115915[]' id='answer-id-478115' class='answer answer-20  answerof-115915' value='478115' \/>&nbsp;<label for='answer-id-478115' id='answer-label-478115' class=' answer label-20'><span class='answer'>db_datawriter<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478117' \/><div class='watu-question-choice'><input type='radio' name='answer-115915[]' id='answer-id-478117' class='answer answer-20  answerof-115915' value='478117' \/>&nbsp;<label for='answer-id-478117' id='answer-label-478117' class=' answer label-20'><span class='answer'>dbcreator<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478119' \/><div class='watu-question-choice'><input type='radio' name='answer-115915[]' id='answer-id-478119' class='answer answer-20  answerof-115915' value='478119' \/>&nbsp;<label for='answer-id-478119' id='answer-label-478119' class=' answer label-20'><span class='answer'>dbo<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478121' \/><div class='watu-question-choice'><input type='radio' name='answer-115915[]' id='answer-id-478121' class='answer answer-20  answerof-115915' value='478121' \/>&nbsp;<label for='answer-id-478121' id='answer-label-478121' class=' answer label-20'><span class='answer'>View Database State<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478122' \/><div class='watu-question-choice'><input type='radio' name='answer-115915[]' id='answer-id-478122' class='answer answer-20  answerof-115915' value='478122' \/>&nbsp;<label for='answer-id-478122' id='answer-label-478122' class=' answer label-20'><span class='answer'>View Server State<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478124' \/><div class='watu-question-choice'><input type='radio' name='answer-115915[]' id='answer-id-478124' class='answer answer-20  answerof-115915' value='478124' \/>&nbsp;<label for='answer-id-478124' id='answer-label-478124' class=' answer label-20'><span class='answer'>View Definition<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478126' \/><div class='watu-question-choice'><input type='radio' name='answer-115915[]' id='answer-id-478126' class='answer answer-20  answerof-115915' value='478126' \/>&nbsp;<label for='answer-id-478126' id='answer-label-478126' class=' answer label-20'><span class='answer'>sysadmin<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType20' value='radio' class=''><\/div><div class='watu-question' id='question-21'><div class='question-content'><p><span class='watu_num'>21. <\/span>Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.<br \/>\n<br \/>You are the database administrator for a company that hosts Microsoft SQL Server. You manage both on-premises and Microsoft Azure SQL Database environments.<br \/>\n<br \/>Clients connect to databases by using line-of-business applications. Developers connect by using SQL Server Management Studio (SSMS).<br \/>\n<br \/>You need to provide permissions to a service account that will be used to provision a new database for a client.<br \/>\n<br \/>Which permission should you grant?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115918' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478129' \/><div class='watu-question-choice'><input type='radio' name='answer-115918[]' id='answer-id-478129' class='answer answer-21  answerof-115918' value='478129' \/>&nbsp;<label for='answer-id-478129' id='answer-label-478129' class=' answer label-21'><span class='answer'>DDLAdmin<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478130' \/><div class='watu-question-choice'><input type='radio' name='answer-115918[]' id='answer-id-478130' class='answer answer-21  answerof-115918' value='478130' \/>&nbsp;<label for='answer-id-478130' id='answer-label-478130' class=' answer label-21'><span class='answer'>db_datawriter<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478132' \/><div class='watu-question-choice'><input type='radio' name='answer-115918[]' id='answer-id-478132' class='answer answer-21  answerof-115918' value='478132' \/>&nbsp;<label for='answer-id-478132' id='answer-label-478132' class=' answer label-21'><span class='answer'>dbcreator<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478134' \/><div class='watu-question-choice'><input type='radio' name='answer-115918[]' id='answer-id-478134' class='answer answer-21  answerof-115918' value='478134' \/>&nbsp;<label for='answer-id-478134' id='answer-label-478134' class=' answer label-21'><span class='answer'>dbo<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478136' \/><div class='watu-question-choice'><input type='radio' name='answer-115918[]' id='answer-id-478136' class='answer answer-21  answerof-115918' value='478136' \/>&nbsp;<label for='answer-id-478136' id='answer-label-478136' class=' answer label-21'><span class='answer'>View Database State<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478138' \/><div class='watu-question-choice'><input type='radio' name='answer-115918[]' id='answer-id-478138' class='answer answer-21  answerof-115918' value='478138' \/>&nbsp;<label for='answer-id-478138' id='answer-label-478138' class=' answer label-21'><span class='answer'>View Server State<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478139' \/><div class='watu-question-choice'><input type='radio' name='answer-115918[]' id='answer-id-478139' class='answer answer-21  answerof-115918' value='478139' \/>&nbsp;<label for='answer-id-478139' id='answer-label-478139' class=' answer label-21'><span class='answer'>View Definition<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478141' \/><div class='watu-question-choice'><input type='radio' name='answer-115918[]' id='answer-id-478141' class='answer answer-21  answerof-115918' value='478141' \/>&nbsp;<label for='answer-id-478141' id='answer-label-478141' class=' answer label-21'><span class='answer'>sysadmin<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType21' value='radio' class=''><\/div><div class='watu-question' id='question-22'><div class='question-content'><p><span class='watu_num'>22. <\/span>Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.<br \/>\n<br \/>You are examining information about users, sessions, and processed in an on-premises Microsoft SQL Server Database Engine instance.<br \/>\n<br \/>You need to return information about processes that are not idle, that belong to a specific user, or that belong to a specific session.<br \/>\n<br \/>What should you use?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115921' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478145' \/><div class='watu-question-choice'><input type='radio' name='answer-115921[]' id='answer-id-478145' class='answer answer-22  answerof-115921' value='478145' \/>&nbsp;<label for='answer-id-478145' id='answer-label-478145' class=' answer label-22'><span class='answer'>Activity Monitor<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478147' \/><div class='watu-question-choice'><input type='radio' name='answer-115921[]' id='answer-id-478147' class='answer answer-22  answerof-115921' value='478147' \/>&nbsp;<label for='answer-id-478147' id='answer-label-478147' class=' answer label-22'><span class='answer'>sp_who3<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478149' \/><div class='watu-question-choice'><input type='radio' name='answer-115921[]' id='answer-id-478149' class='answer answer-22  answerof-115921' value='478149' \/>&nbsp;<label for='answer-id-478149' id='answer-label-478149' class=' answer label-22'><span class='answer'>SQL Server Management Studio (SSMS) Object Explorer<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478150' \/><div class='watu-question-choice'><input type='radio' name='answer-115921[]' id='answer-id-478150' class='answer answer-22  answerof-115921' value='478150' \/>&nbsp;<label for='answer-id-478150' id='answer-label-478150' class=' answer label-22'><span class='answer'>SQL Server Data Collector<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478151' \/><div class='watu-question-choice'><input type='radio' name='answer-115921[]' id='answer-id-478151' class='answer answer-22  answerof-115921' value='478151' \/>&nbsp;<label for='answer-id-478151' id='answer-label-478151' class=' answer label-22'><span class='answer'>SQL Server Data Tools (SSDT)<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478153' \/><div class='watu-question-choice'><input type='radio' name='answer-115921[]' id='answer-id-478153' class='answer answer-22  answerof-115921' value='478153' \/>&nbsp;<label for='answer-id-478153' id='answer-label-478153' class=' answer label-22'><span class='answer'>SQL Server Configuration Manager<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType22' value='radio' class=''><\/div><div class='watu-question' id='question-23'><div class='question-content'><p><span class='watu_num'>23. <\/span>Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.<br \/>\n<br \/>You observe that several indexes are fragmented.<br \/>\n<br \/>You need to rebuild the indexes.<br \/>\n<br \/>What should you use?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115923' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478156' \/><div class='watu-question-choice'><input type='radio' name='answer-115923[]' id='answer-id-478156' class='answer answer-23  answerof-115923' value='478156' \/>&nbsp;<label for='answer-id-478156' id='answer-label-478156' class=' answer label-23'><span class='answer'>Activity Monitor<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478158' \/><div class='watu-question-choice'><input type='radio' name='answer-115923[]' id='answer-id-478158' class='answer answer-23  answerof-115923' value='478158' \/>&nbsp;<label for='answer-id-478158' id='answer-label-478158' class=' answer label-23'><span class='answer'>Sp_who3 stored procedure<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478159' \/><div class='watu-question-choice'><input type='radio' name='answer-115923[]' id='answer-id-478159' class='answer answer-23  answerof-115923' value='478159' \/>&nbsp;<label for='answer-id-478159' id='answer-label-478159' class=' answer label-23'><span class='answer'>Object Explorer in the SQL Server Management Studio (SSMS)<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478161' \/><div class='watu-question-choice'><input type='radio' name='answer-115923[]' id='answer-id-478161' class='answer answer-23  answerof-115923' value='478161' \/>&nbsp;<label for='answer-id-478161' id='answer-label-478161' class=' answer label-23'><span class='answer'>SQL Server Data Collector<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478163' \/><div class='watu-question-choice'><input type='radio' name='answer-115923[]' id='answer-id-478163' class='answer answer-23  answerof-115923' value='478163' \/>&nbsp;<label for='answer-id-478163' id='answer-label-478163' class=' answer label-23'><span class='answer'>SQL Server Data Tools (SSDT)<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478165' \/><div class='watu-question-choice'><input type='radio' name='answer-115923[]' id='answer-id-478165' class='answer answer-23  answerof-115923' value='478165' \/>&nbsp;<label for='answer-id-478165' id='answer-label-478165' class=' answer label-23'><span class='answer'>SQL Server Configuration Manager<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType23' value='radio' class=''><\/div><div class='watu-question' id='question-24'><div class='question-content'><p><span class='watu_num'>24. <\/span>Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is<br \/>\n<br \/>independent of the other questions in this series. Information and details provided in a question apply only to that question.<br \/>\n<br \/>You need to examine information about logins, CPU times, and Disk I\/O on a particular database in Microsoft Azure.<br \/>\n<br \/>What should you use?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115925' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478167' \/><div class='watu-question-choice'><input type='radio' name='answer-115925[]' id='answer-id-478167' class='answer answer-24  answerof-115925' value='478167' \/>&nbsp;<label for='answer-id-478167' id='answer-label-478167' class=' answer label-24'><span class='answer'>Activity Monitor<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478168' \/><div class='watu-question-choice'><input type='radio' name='answer-115925[]' id='answer-id-478168' class='answer answer-24  answerof-115925' value='478168' \/>&nbsp;<label for='answer-id-478168' id='answer-label-478168' class=' answer label-24'><span class='answer'>Sp_who3<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478170' \/><div class='watu-question-choice'><input type='radio' name='answer-115925[]' id='answer-id-478170' class='answer answer-24  answerof-115925' value='478170' \/>&nbsp;<label for='answer-id-478170' id='answer-label-478170' class=' answer label-24'><span class='answer'>SQL Server Management Studio (SSMS) Object Explorer<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478172' \/><div class='watu-question-choice'><input type='radio' name='answer-115925[]' id='answer-id-478172' class='answer answer-24  answerof-115925' value='478172' \/>&nbsp;<label for='answer-id-478172' id='answer-label-478172' class=' answer label-24'><span class='answer'>SQL Server Data Collector<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478174' \/><div class='watu-question-choice'><input type='radio' name='answer-115925[]' id='answer-id-478174' class='answer answer-24  answerof-115925' value='478174' \/>&nbsp;<label for='answer-id-478174' id='answer-label-478174' class=' answer label-24'><span class='answer'>SQL Server Data Tools (SSDT)<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478176' \/><div class='watu-question-choice'><input type='radio' name='answer-115925[]' id='answer-id-478176' class='answer answer-24  answerof-115925' value='478176' \/>&nbsp;<label for='answer-id-478176' id='answer-label-478176' class=' answer label-24'><span class='answer'>SQL Server Configuration Manager<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType24' value='radio' class=''><\/div><div class='watu-question' id='question-25'><div class='question-content'><p><span class='watu_num'>25. <\/span>Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.<br \/>\n<br \/>You collect performance metrics on multiple Microsoft SQL Server instances and store the data in a single repository.<br \/>\n<br \/>You need to examine disk usage, query statistics, and server activity without building custom counters.<br \/>\n<br \/>What should you use?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115928' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478178' \/><div class='watu-question-choice'><input type='radio' name='answer-115928[]' id='answer-id-478178' class='answer answer-25  answerof-115928' value='478178' \/>&nbsp;<label for='answer-id-478178' id='answer-label-478178' class=' answer label-25'><span class='answer'>Activity Monitor<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478180' \/><div class='watu-question-choice'><input type='radio' name='answer-115928[]' id='answer-id-478180' class='answer answer-25  answerof-115928' value='478180' \/>&nbsp;<label for='answer-id-478180' id='answer-label-478180' class=' answer label-25'><span class='answer'>Sp_who3 stored procedure<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478182' \/><div class='watu-question-choice'><input type='radio' name='answer-115928[]' id='answer-id-478182' class='answer answer-25  answerof-115928' value='478182' \/>&nbsp;<label for='answer-id-478182' id='answer-label-478182' class=' answer label-25'><span class='answer'>Object Explorer in the Microsoft SQL Server Management Studio (SSMS)<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478184' \/><div class='watu-question-choice'><input type='radio' name='answer-115928[]' id='answer-id-478184' class='answer answer-25  answerof-115928' value='478184' \/>&nbsp;<label for='answer-id-478184' id='answer-label-478184' class=' answer label-25'><span class='answer'>SQL Server Data Collector<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478185' \/><div class='watu-question-choice'><input type='radio' name='answer-115928[]' id='answer-id-478185' class='answer answer-25  answerof-115928' value='478185' \/>&nbsp;<label for='answer-id-478185' id='answer-label-478185' class=' answer label-25'><span class='answer'>SQL Server Data Tools (SSDT)<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478187' \/><div class='watu-question-choice'><input type='radio' name='answer-115928[]' id='answer-id-478187' class='answer answer-25  answerof-115928' value='478187' \/>&nbsp;<label for='answer-id-478187' id='answer-label-478187' class=' answer label-25'><span class='answer'>SQL Server Configuration Manager<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType25' value='radio' class=''><\/div><div class='watu-question' id='question-26'><div class='question-content'><p><span class='watu_num'>26. <\/span>Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.<br \/>\n<br \/>You are examining information about users, sessions, and processes in an on-premises Microsoft SQL Server 2016 Standard Edition server.<br \/>\n<br \/>You need to identify waits for resources and return only the following information:<br \/>\n<br \/>&#8211; a list of all databases on the SQL Server instance, along with information about the database files, their paths, and names<br \/>\n<br \/>&#8211; a list of the queries recently executed that use most of memory, disk, and network resources<br \/>\n<br \/>What should you use?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115930' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478190' \/><div class='watu-question-choice'><input type='radio' name='answer-115930[]' id='answer-id-478190' class='answer answer-26  answerof-115930' value='478190' \/>&nbsp;<label for='answer-id-478190' id='answer-label-478190' class=' answer label-26'><span class='answer'>Activity Monitor<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478192' \/><div class='watu-question-choice'><input type='radio' name='answer-115930[]' id='answer-id-478192' class='answer answer-26  answerof-115930' value='478192' \/>&nbsp;<label for='answer-id-478192' id='answer-label-478192' class=' answer label-26'><span class='answer'>Sp_who3<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478193' \/><div class='watu-question-choice'><input type='radio' name='answer-115930[]' id='answer-id-478193' class='answer answer-26  answerof-115930' value='478193' \/>&nbsp;<label for='answer-id-478193' id='answer-label-478193' class=' answer label-26'><span class='answer'>SQL Server Management Studio (SSMS) Object Explorer<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478195' \/><div class='watu-question-choice'><input type='radio' name='answer-115930[]' id='answer-id-478195' class='answer answer-26  answerof-115930' value='478195' \/>&nbsp;<label for='answer-id-478195' id='answer-label-478195' class=' answer label-26'><span class='answer'>SQL Server Data Collector<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478197' \/><div class='watu-question-choice'><input type='radio' name='answer-115930[]' id='answer-id-478197' class='answer answer-26  answerof-115930' value='478197' \/>&nbsp;<label for='answer-id-478197' id='answer-label-478197' class=' answer label-26'><span class='answer'>SQL Server Data Tools (SSDT)<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478199' \/><div class='watu-question-choice'><input type='radio' name='answer-115930[]' id='answer-id-478199' class='answer answer-26  answerof-115930' value='478199' \/>&nbsp;<label for='answer-id-478199' id='answer-label-478199' class=' answer label-26'><span class='answer'>SQL Server Configuration Manager<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType26' value='radio' class=''><\/div><div class='watu-question' id='question-27'><div class='question-content'><p><span class='watu_num'>27. <\/span>Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.<br \/>\n<br \/>You have an on-premises server that runs Microsoft SQL Server 2016 Standard Edition.<br \/>\n<br \/>You need to identify missing indexes.<br \/>\n<br \/>What should you use?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115932' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478201' \/><div class='watu-question-choice'><input type='radio' name='answer-115932[]' id='answer-id-478201' class='answer answer-27  answerof-115932' value='478201' \/>&nbsp;<label for='answer-id-478201' id='answer-label-478201' class=' answer label-27'><span class='answer'>Activity Monitor<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478203' \/><div class='watu-question-choice'><input type='radio' name='answer-115932[]' id='answer-id-478203' class='answer answer-27  answerof-115932' value='478203' \/>&nbsp;<label for='answer-id-478203' id='answer-label-478203' class=' answer label-27'><span class='answer'>Sp_who3<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478205' \/><div class='watu-question-choice'><input type='radio' name='answer-115932[]' id='answer-id-478205' class='answer answer-27  answerof-115932' value='478205' \/>&nbsp;<label for='answer-id-478205' id='answer-label-478205' class=' answer label-27'><span class='answer'>SQL Server Management Studio (SSMS) Object Explorer<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478207' \/><div class='watu-question-choice'><input type='radio' name='answer-115932[]' id='answer-id-478207' class='answer answer-27  answerof-115932' value='478207' \/>&nbsp;<label for='answer-id-478207' id='answer-label-478207' class=' answer label-27'><span class='answer'>SQL Server Data Collector<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478209' \/><div class='watu-question-choice'><input type='radio' name='answer-115932[]' id='answer-id-478209' class='answer answer-27  answerof-115932' value='478209' \/>&nbsp;<label for='answer-id-478209' id='answer-label-478209' class=' answer label-27'><span class='answer'>SQL Server Data Tools (SSDT)<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478210' \/><div class='watu-question-choice'><input type='radio' name='answer-115932[]' id='answer-id-478210' class='answer answer-27  answerof-115932' value='478210' \/>&nbsp;<label for='answer-id-478210' id='answer-label-478210' class=' answer label-27'><span class='answer'>SQL Server Configuration Manager<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType27' value='radio' class=''><\/div><div class='watu-question' id='question-28'><div class='question-content'><p><span class='watu_num'>28. <\/span>HOTSPOT<br \/>\n<br \/>Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.<br \/>\n<br \/>You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance.<br \/>\n<br \/>The environments that you manage are shown in the following table. <\/p>\n<p><img decoding=\"async\" width=624 height=688 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image012.jpg\" v:shapes=\"_x0000_i1031\"><\/p>\n<p>You need to configure monitoring for Tailspin Toys. In the table below, identify the monitoring tool that you must use for each activity. NOTE: Make only one selection in each column. <\/p>\n<p><img decoding=\"async\" width=637 height=240 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image013.gif\" v:shapes=\"_x0000_i1032\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115935' \/><textarea name='answer-115935[]' rows='5' cols='40' id='textarea_q_115935' class='watu-textarea watu-textarea-28'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478213' \/><\/div><input type='hidden' id='questionType28' value='textarea' class=''><\/div><div class='watu-question' id='question-29'><div class='question-content'><p><span class='watu_num'>29. <\/span>DRAG DROP<br \/>\n<br \/>Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.<br \/>\n<br \/>You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance.<br \/>\n<br \/>The environments that you manage are shown in the following table. <\/p>\n<p><img decoding=\"async\" width=624 height=688 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image012.jpg\" v:shapes=\"_x0000_i1034\"><\/p>\n<p>You need to implement a process for importing data into WingDB.<br \/>\n<br \/>Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. <\/p>\n<p><img decoding=\"async\" width=573 height=451 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image017.jpg\" v:shapes=\"_x0000_i1035\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115936' \/><textarea name='answer-115936[]' rows='5' cols='40' id='textarea_q_115936' class='watu-textarea watu-textarea-29'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478216' \/><\/div><input type='hidden' id='questionType29' value='textarea' class=''><\/div><div class='watu-question' id='question-30'><div class='question-content'><p><span class='watu_num'>30. <\/span>HOTSPOT<br \/>\n<br \/>Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.<br \/>\n<br \/>You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance.<br \/>\n<br \/>The environments that you manage are shown in the following table. <\/p>\n<p><img decoding=\"async\" width=624 height=688 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image012.jpg\" v:shapes=\"_x0000_i1037\"><\/p>\n<p>You need to configure auditing for the Adventure Works environment.<br \/>\n<br \/>How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. <\/p>\n<p><img decoding=\"async\" width=632 height=715 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image021.jpg\" v:shapes=\"_x0000_i1038\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115937' \/><textarea name='answer-115937[]' rows='5' cols='40' id='textarea_q_115937' class='watu-textarea watu-textarea-30'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478218' \/><\/div><input type='hidden' id='questionType30' value='textarea' class=''><\/div><div class='watu-question' id='question-31'><div class='question-content'><p><span class='watu_num'>31. <\/span>HOTSPOT<br \/>\n<br \/>Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.<br \/>\n<br \/>You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance.<br \/>\n<br \/>The environments that you manage are shown in the following table. <\/p>\n<p><img decoding=\"async\" width=624 height=688 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image012.jpg\" v:shapes=\"_x0000_i1040\"><\/p>\n<p>You need to configure the Contoso instance.<br \/>\n<br \/>How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segments in the answer area. <\/p>\n<p><img decoding=\"async\" width=464 height=379 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image025.jpg\" v:shapes=\"_x0000_i1041\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115939' \/><textarea name='answer-115939[]' rows='5' cols='40' id='textarea_q_115939' class='watu-textarea watu-textarea-31'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478221' \/><\/div><input type='hidden' id='questionType31' value='textarea' class=''><\/div><div class='watu-question' id='question-32'><div class='question-content'><p><span class='watu_num'>32. <\/span>Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.<br \/>\n<br \/>You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance.<br \/>\n<br \/>The environments that you manage are shown in the following table. <\/p>\n<p><img decoding=\"async\" width=624 height=688 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image012.jpg\" v:shapes=\"_x0000_i1043\"><\/p>\n<p>You need to monitor WingDB and gather information for troubleshooting issues.<br \/>\n<br \/>What should you use?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115940' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478224' \/><div class='watu-question-choice'><input type='radio' name='answer-115940[]' id='answer-id-478224' class='answer answer-32  answerof-115940' value='478224' \/>&nbsp;<label for='answer-id-478224' id='answer-label-478224' class=' answer label-32'><span class='answer'>sp_updatestats<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478225' \/><div class='watu-question-choice'><input type='radio' name='answer-115940[]' id='answer-id-478225' class='answer answer-32  answerof-115940' value='478225' \/>&nbsp;<label for='answer-id-478225' id='answer-label-478225' class=' answer label-32'><span class='answer'>sp_lock<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478227' \/><div class='watu-question-choice'><input type='radio' name='answer-115940[]' id='answer-id-478227' class='answer answer-32  answerof-115940' value='478227' \/>&nbsp;<label for='answer-id-478227' id='answer-label-478227' class=' answer label-32'><span class='answer'>sys.dm_os_waiting_tasks<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478229' \/><div class='watu-question-choice'><input type='radio' name='answer-115940[]' id='answer-id-478229' class='answer answer-32  answerof-115940' value='478229' \/>&nbsp;<label for='answer-id-478229' id='answer-label-478229' class=' answer label-32'><span class='answer'>sys.dm_tran_active_snapshot_database_transactions<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478231' \/><div class='watu-question-choice'><input type='radio' name='answer-115940[]' id='answer-id-478231' class='answer answer-32  answerof-115940' value='478231' \/>&nbsp;<label for='answer-id-478231' id='answer-label-478231' class=' answer label-32'><span class='answer'>Activity Monitor<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType32' value='radio' class=''><\/div><div class='watu-question' id='question-33'><div class='question-content'><p><span class='watu_num'>33. <\/span>HOTSPOT<br \/>\n<br \/>Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.<br \/>\n<br \/>You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance.<br \/>\n<br \/>The environments that you manage are shown in the following table. <\/p>\n<p><img decoding=\"async\" width=624 height=688 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image012.jpg\" v:shapes=\"_x0000_i1044\"><\/p>\n<p>You need to configure auditing for WDWDB. In the table below, identify the event type that you must audit for each activity. <\/p>\n<p><img decoding=\"async\" width=549 height=232 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image028.gif\" v:shapes=\"_x0000_i1045\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115942' \/><textarea name='answer-115942[]' rows='5' cols='40' id='textarea_q_115942' class='watu-textarea watu-textarea-33'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478233' \/><\/div><input type='hidden' id='questionType33' value='textarea' class=''><\/div><div class='watu-question' id='question-34'><div class='question-content'><p><span class='watu_num'>34. <\/span>HOTSPOT<br \/>\n<br \/>Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.<br \/>\n<br \/>You have five servers that run Microsoft Windows 2012 R2. Each server hosts a Microsoft SQL Server instance. The topology for the environment is shown in the following diagram. <\/p>\n<p><img decoding=\"async\" width=649 height=362 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image032.jpg\" v:shapes=\"_x0000_i1047\"><\/p>\n<p>You have an Always On Availability group named AG1.<br \/>\n<br \/>The details for AG1 are shown in the following table. <\/p>\n<p><img decoding=\"async\" width=361 height=81 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image034.jpg\" v:shapes=\"_x0000_i1048\"><\/p>\n<p>Instance1 experiences heavy read-write traffic. The instance hosts a database named OperationsMain that is four terabytes (TB) in size. The database has multiple data files and filegroups. One of the filegroups is read_only and is half of the total database size.<br \/>\n<br \/>Instance4 and Instance5 are not part of AG1. Instance4 is engaged in heavy read-write I\/O.<br \/>\n<br \/>Instance5 hosts a database named StagedExternal. A nightly BULK INSERT process loads data into an empty table that has a rowstore clustered index and two nonclustered rowstore indexes.<br \/>\n<br \/>You must minimize the growth of the StagedExternal database log file during the BULK INSERT operations and perform point-in-time recovery after the BULK INSERT transaction. Changes made must not interrupt the log backup chain.<br \/>\n<br \/>You plan to add a new instance named Instance6 to a datacenter that is geographically distant from Site1 and Site2. You must minimize latency between the nodes in AG1.<br \/>\n<br \/>All databases use the full recovery model. All backups are written to the network location \\SQLBackup. A separate process copies backups to an offsite location. You should minimize both the time required to restore the databases and the space required to store backups.<br \/>\n<br \/>The recovery point objective (RPO) for each instance is shown in the following table. <\/p>\n<p><img decoding=\"async\" width=295 height=122 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image036.jpg\" v:shapes=\"_x0000_i1049\"><\/p>\n<p>Full backups of OperationsMain take longer than six hours to complete. All SQL Server backups use the keyword COMPRESSION.<br \/>\n<br \/>You plan to deploy the following solutions to the environment. The solutions will access a database named DB1 that is part of AG1.<br \/>\n<br \/>-Reporting system: This solution accesses data inDB1with a login that is mapped to a database user that is a member of the db_datareader role. The user has EXECUTE permissions on the database. Queries make no changes to the data. The queries must be load balanced over variable read-only replicas.<br \/>\n<br \/>-Operations system: This solution accesses data inDB1with a login that is mapped to a database user that is a member of the db_datareader and db_datawriter roles. The user has EXECUTE permissions on the database. Queries from the operations system will perform both DDL and DML operations.<br \/>\n<br \/>The wait statistics monitoring requirements for the instances are described in the following table. <\/p>\n<p><img decoding=\"async\" width=624 height=101 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image038.jpg\" v:shapes=\"_x0000_i1050\"><\/p>\n<p>You need to create the connection strings for the operations and reporting systems.<br \/>\n<br \/>In the table below, identify the option that must be specified in each connection string. NOTE: Make only one selection in each column. <\/p>\n<p><img decoding=\"async\" width=639 height=269 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image040.jpg\" v:shapes=\"_x0000_i1051\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115944' \/><textarea name='answer-115944[]' rows='5' cols='40' id='textarea_q_115944' class='watu-textarea watu-textarea-34'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478236' \/><\/div><input type='hidden' id='questionType34' value='textarea' class=''><\/div><div class='watu-question' id='question-35'><div class='question-content'><p><span class='watu_num'>35. <\/span>DRAG DROP<br \/>\n<br \/>Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.<br \/>\n<br \/>You have five servers that run Microsoft Windows 2012 R2. Each server hosts a Microsoft SQL Server instance. The topology for the environment is shown in the following diagram. <\/p>\n<p><img decoding=\"async\" width=650 height=362 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image044.jpg\" v:shapes=\"\u56fe\u7247_x0020_505\"><\/p>\n<p>You have an Always On Availability group named AG1.<br \/>\n<br \/>The details for AG1 are shown in the following table. <\/p>\n<p><img decoding=\"async\" width=361 height=81 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image034.jpg\" v:shapes=\"_x0000_i1054\"><\/p>\n<p>Instance1 experiences heavy read-write traffic. The instance hosts a database named OperationsMain that is four terabytes (TB) in size. The database has multiple data files and filegroups. One of the filegroups is read_only and is half of the total database size.<br \/>\n<br \/>Instance4 and Instance5 are not part of AG1. Instance4 is engaged in heavy read-write I\/O.<br \/>\n<br \/>Instance5 hosts a database named StagedExternal. A nightly BULK INSERT process loads data into an empty table that has a rowstore clustered index and two nonclustered rowstore indexes.<br \/>\n<br \/>You must minimize the growth of the StagedExternal database log file during the BULK INSERT operations and perform point-in-time recovery after the BULK INSERT transaction. Changes made must not interrupt the log backup chain.<br \/>\n<br \/>You plan to add a new instance named Instance6 to a datacenter that is geographically distant from Site1 and Site2. You must minimize latency between the nodes in AG1.<br \/>\n<br \/>All databases use the full recovery model. All backups are written to the network location \\SQLBackup. A separate process copies backups to an offsite location. You should minimize both the time required to restore the databases and the space required to store backups.<br \/>\n<br \/>The recovery point objective (RPO) for each instance is shown in the following table. <\/p>\n<p><img decoding=\"async\" width=295 height=122 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image036.jpg\" v:shapes=\"_x0000_i1055\"><\/p>\n<p>Full backups of OperationsMain take longer than six hours to complete. All SQL Server backups use the keyword COMPRESSION.<br \/>\n<br \/>You plan to deploy the following solutions to the environment. The solutions will access a database named DB1 that is part of AG1.<br \/>\n<br \/>-Reporting system: This solution accesses data inDB1with a login that is mapped to a database user that is a member of the db_datareader role. The user has EXECUTE permissions on the database. Queries make no changes to the data. The queries must be load balanced over variable read-only replicas.<br \/>\n<br \/>-Operations system: This solution accesses data inDB1with a login that is mapped to a database user that is a member of the db_datareader and db_datawriter roles. The user has EXECUTE permissions on the database. Queries from the operations system will perform both DDL and DML operations.<br \/>\n<br \/>The wait statistics monitoring requirements for the instances are described in the following table. <\/p>\n<p><img decoding=\"async\" width=624 height=101 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image038.jpg\" v:shapes=\"_x0000_i1056\"><\/p>\n<p>You need to propose a new process for the StagedExternal database.<br \/>\n<br \/>Which five actions should you recommended be performed in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. <\/p>\n<p><img decoding=\"async\" width=569 height=548 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image046.jpg\" v:shapes=\"_x0000_i1057\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115945' \/><textarea name='answer-115945[]' rows='5' cols='40' id='textarea_q_115945' class='watu-textarea watu-textarea-35'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478239' \/><\/div><input type='hidden' id='questionType35' value='textarea' class=''><\/div><div class='watu-question' id='question-36'><div class='question-content'><p><span class='watu_num'>36. <\/span>DRAG DROP<br \/>\n<br \/>Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.<br \/>\n<br \/>You have five servers that run Microsoft Windows 2012 R2. Each server hosts a Microsoft SQL Server instance. The topology for the environment is shown in the following diagram. <\/p>\n<p><img decoding=\"async\" width=650 height=363 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image049.jpg\" v:shapes=\"\u56fe\u7247_x0020_499\"><\/p>\n<p>You have an Always On Availability group named AG1.<br \/>\n<br \/>The details for AG1 are shown in the following table. <\/p>\n<p><img decoding=\"async\" width=361 height=81 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image034.jpg\" v:shapes=\"_x0000_i1060\"><\/p>\n<p>Instance1 experiences heavy read-write traffic. The instance hosts a database named OperationsMain that is four terabytes (TB) in size. The database has multiple data files and filegroups. One of the filegroups is read_only and is half of the total database size.<br \/>\n<br \/>Instance4 and Instance5 are not part of AG1. Instance4 is engaged in heavy read-write I\/O.<br \/>\n<br \/>Instance5 hosts a database named StagedExternal. A nightly BULK INSERT process loads data into an empty table that has a rowstore clustered index and two nonclustered rowstore indexes.<br \/>\n<br \/>You must minimize the growth of the StagedExternal database log file during the BULK INSERT operations and perform point-in-time recovery after the BULK INSERT transaction. Changes made must not interrupt the log backup chain.<br \/>\n<br \/>You plan to add a new instance named Instance6 to a datacenter that is geographically distant from Site1 and Site2. You must minimize latency between the nodes in AG1.<br \/>\n<br \/>All databases use the full recovery model. All backups are written to the network location \\SQLBackup. A separate process copies backups to an offsite location. You should minimize both the time required to restore the databases and the space required to store backups.<br \/>\n<br \/>The recovery point objective (RPO) for each instance is shown in the following table. <\/p>\n<p><img decoding=\"async\" width=295 height=122 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image036.jpg\" v:shapes=\"_x0000_i1061\"><\/p>\n<p>Full backups of OperationsMain take longer than six hours to complete. All SQL Server backups use the keyword COMPRESSION.<br \/>\n<br \/>You plan to deploy the following solutions to the environment. The solutions will access a database named DB1 that is part of AG1.<br \/>\n<br \/>Reporting system: This solution accesses data inDB1with a login that is mapped to a database user that is a member of the db_datareader role. The user has EXECUTE permissions on the database. Queries make no changes to the data. The queries must be load balanced over variable read-only replicas. Operations system: This solution accesses data inDB1with a login that is mapped to a database user that is a member of the db_datareader and db_datawriter roles. The user has EXECUTE permissions on the database. Queries from the operations system will perform both DDL and DML operations.<br \/>\n<br \/>The wait statistics monitoring requirements for the instances are described in the following table. <\/p>\n<p><img decoding=\"async\" width=624 height=101 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image038.jpg\" v:shapes=\"_x0000_i1062\"><\/p>\n<p>You need to analyze the wait type and statistics for specific instanced in the environment.<br \/>\n<br \/>Which object should you use to gather information about each instance? To answer, drag the appropriate objects to the correct instances. Each object may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. <\/p>\n<p><img decoding=\"async\" width=596 height=431 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image051.jpg\" v:shapes=\"_x0000_i1063\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115947' \/><textarea name='answer-115947[]' rows='5' cols='40' id='textarea_q_115947' class='watu-textarea watu-textarea-36'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478241' \/><\/div><input type='hidden' id='questionType36' value='textarea' class=''><\/div><div class='watu-question' id='question-37'><div class='question-content'><p><span class='watu_num'>37. <\/span>DRAG DROP<br \/>\n<br \/>Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.<br \/>\n<br \/>You have five servers that run Microsoft Windows 2012 R2. Each server hosts a Microsoft SQL Server instance. The topology for the environment is shown in the following diagram. <\/p>\n<p><img decoding=\"async\" width=628 height=395 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image057.jpg\" v:shapes=\"_x0000_i1066\"><\/p>\n<p>You have an Always On Availability group named AG1.<br \/>\n<br \/>The details for AG1 are shown in the following table. <\/p>\n<p><img decoding=\"async\" width=361 height=81 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image034.jpg\" v:shapes=\"_x0000_i1067\"><\/p>\n<p>Instance1 experiences heavy read-write traffic. The instance hosts a database named OperationsMain that is four terabytes (TB) in size. The database has multiple data files and filegroups. One of the filegroups is read_only and is half of the total database size.<br \/>\n<br \/>Instance4 and Instance5 are not part of AG1. Instance4 is engaged in heavy read-write I\/O.<br \/>\n<br \/>Instance5 hosts a database named StagedExternal. A nightly BULK INSERT process loads data into an empty table that has a rowstore clustered index and two nonclustered rowstore indexes.<br \/>\n<br \/>You must minimize the growth of the StagedExternal database log file during the BULK INSERT operations and perform point-in-time recovery after the BULK INSERT transaction. Changes made must not interrupt the log backup chain.<br \/>\n<br \/>You plan to add a new instance named Instance6 to a datacenter that is geographically distant from Site1 and Site2. You must minimize latency between the nodes in AG1.<br \/>\n<br \/>All databases use the full recovery model. All backups are written to the network location \\SQLBackup. A separate process copies backups to an offsite location. You should minimize both the time required to restore the databases and the space required to store backups.<br \/>\n<br \/>The recovery point objective (RPO) for each instance is shown in the following table. <\/p>\n<p><img decoding=\"async\" width=295 height=122 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image036.jpg\" v:shapes=\"_x0000_i1068\"><\/p>\n<p>Full backups of OperationsMain take longer than six hours to complete. All SQL Server backups<br \/>\n<br \/>use the keyword COMPRESSION.<br \/>\n<br \/>You plan to deploy the following solutions to the environment. The solutions will access a database named DB1 that is part of AG1.<br \/>\n<br \/>-Reporting system: This solution accesses data inDB1with a login that is mapped to a database user that is a member of the db_datareader role. The user has EXECUTE permissions on the database. Queries make no changes to the data. The queries must be load balanced over variable read-only replicas.<br \/>\n<br \/>-Operations system: This solution accesses data inDB1with a login that is mapped to a database user that is a member of the db_datareader and db_datawriter roles. The user has EXECUTE permissions on the database. Queries from the operations system will perform both DDL and DML operations.<br \/>\n<br \/>The wait statistics monitoring requirements for the instances are described in the following table. <\/p>\n<p><img decoding=\"async\" width=624 height=101 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image038.jpg\" v:shapes=\"_x0000_i1069\"><\/p>\n<p>You need to configure a new replica of AG1 on Instance6.<br \/>\n<br \/>How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQL statements to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. <\/p>\n<p><img decoding=\"async\" width=650 height=671 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image059.jpg\" v:shapes=\"_x0000_i1070\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115948' \/><textarea name='answer-115948[]' rows='5' cols='40' id='textarea_q_115948' class='watu-textarea watu-textarea-37'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478245' \/><\/div><input type='hidden' id='questionType37' value='textarea' class=''><\/div><div class='watu-question' id='question-38'><div class='question-content'><p><span class='watu_num'>38. <\/span>Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.<br \/>\n<br \/>You have five servers that run Microsoft Windows 2012 R2. Each server hosts a Microsoft SQL Server instance. The topology for the environment is shown in the following diagram. <\/p>\n<p><img decoding=\"async\" width=628 height=395 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image057.jpg\" v:shapes=\"_x0000_i1072\"><\/p>\n<p>You have an Always On Availability group named AG1.<br \/>\n<br \/>The details for AG1 are shown in the following table. <\/p>\n<p><img decoding=\"async\" width=361 height=81 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image034.jpg\" v:shapes=\"_x0000_i1073\"><\/p>\n<p>Instance1 experiences heavy read-write traffic. The instance hosts a database named OperationsMain that is four terabytes (TB) in size. The database has multiple data files and filegroups. One of the filegroups is read_only and is half of the total database size.<br \/>\n<br \/>Instance4 and Instance5 are not part of AG1. Instance4 is engaged in heavy read-write I\/O.<br \/>\n<br \/>Instance5 hosts a database named StagedExternal. A nightly BULK INSERT process loads data into an empty table that has a rowstore clustered index and two nonclustered rowstore indexes.<br \/>\n<br \/>You must minimize the growth of the StagedExternal database log file during the BULK INSERT operations and perform point-in-time recovery after the BULK INSERT transaction. Changes made must not interrupt the log backup chain.<br \/>\n<br \/>You plan to add a new instance named Instance6 to a datacenter that is geographically distant from Site1 and Site2. You must minimize latency between the nodes in AG1.<br \/>\n<br \/>All databases use the full recovery model. All backups are written to the network location \\SQLBackup. A separate process copies backups to an offsite location. You should minimize both the time required to restore the databases and the space required to store backups.<br \/>\n<br \/>The recovery point objective (RPO) for each instance is shown in the following table. <\/p>\n<p><img decoding=\"async\" width=295 height=122 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image036.jpg\" v:shapes=\"_x0000_i1074\"><\/p>\n<p>Full backups of OperationsMain take longer than six hours to complete. All SQL Server backups use the keyword COMPRESSION.<br \/>\n<br \/>You plan to deploy the following solutions to the environment. The solutions will access a database named DB1 that is part of AG1.<br \/>\n<br \/>-Reporting system: This solution accesses data inDB1with a login that is mapped to a database user that is a member of the db_datareader role. The user has EXECUTE permissions on the database. Queries make no changes to the data. The queries must be load balanced over variable read-only replicas.<br \/>\n<br \/>-Operations system: This solution accesses data inDB1with a login that is mapped to a database user that is a member of the db_datareader and db_datawriter roles. The user has EXECUTE permissions on the database. Queries from the operations system will perform both DDL and DML operations.<br \/>\n<br \/>The wait statistics monitoring requirements for the instances are described in the following table. <\/p>\n<p><img decoding=\"async\" width=624 height=101 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image062.jpg\" v:shapes=\"_x0000_i1075\"><\/p>\n<p>You need to create a backup plan for Instance4.<br \/>\n<br \/>Which backup plan should you create?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115950' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478247' \/><div class='watu-question-choice'><input type='radio' name='answer-115950[]' id='answer-id-478247' class='answer answer-38  answerof-115950' value='478247' \/>&nbsp;<label for='answer-id-478247' id='answer-label-478247' class=' answer label-38'><span class='answer'>Weekly full backups, nightly differential. No transaction log backups are necessary.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478249' \/><div class='watu-question-choice'><input type='radio' name='answer-115950[]' id='answer-id-478249' class='answer answer-38  answerof-115950' value='478249' \/>&nbsp;<label for='answer-id-478249' id='answer-label-478249' class=' answer label-38'><span class='answer'>Weekly full backups, nightly differential backups, transaction log backups every 5 minutes.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478251' \/><div class='watu-question-choice'><input type='radio' name='answer-115950[]' id='answer-id-478251' class='answer answer-38  answerof-115950' value='478251' \/>&nbsp;<label for='answer-id-478251' id='answer-label-478251' class=' answer label-38'><span class='answer'>Weekly full backups, nightly differential backups, transaction log backups every 12 hours.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478253' \/><div class='watu-question-choice'><input type='radio' name='answer-115950[]' id='answer-id-478253' class='answer answer-38  answerof-115950' value='478253' \/>&nbsp;<label for='answer-id-478253' id='answer-label-478253' class=' answer label-38'><span class='answer'>Full backups every 60 minutes, transaction log backups every 30 minutes.<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType38' value='radio' class=''><\/div><div class='watu-question' id='question-39'><div class='question-content'><p><span class='watu_num'>39. <\/span>Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.<br \/>\n<br \/>You have five servers that run Microsoft Windows 2012 R2. Each server hosts a Microsoft SQL Server instance. The topology for the environment is shown in the following diagram. <\/p>\n<p><img decoding=\"async\" width=628 height=395 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image057.jpg\" v:shapes=\"_x0000_i1076\"><\/p>\n<p>You have an Always On Availability group named AG1.<br \/>\n<br \/>The details for AG1 are shown in the following table. <\/p>\n<p><img decoding=\"async\" width=361 height=81 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image063.jpg\" v:shapes=\"_x0000_i1077\"><\/p>\n<p>Instance1 experiences heavy read-write traffic. The instance hosts a database named OperationsMain that is four terabytes (TB) in size. The database has multiple data files and filegroups. One of the filegroups is read_only and is half of the total database size.<br \/>\n<br \/>Instance4 and Instance5 are not part of AG1. Instance4 is engaged in heavy read-write I\/O.<br \/>\n<br \/>Instance5 hosts a database named StagedExternal. A nightly BULK INSERT process loads data into an empty table that has a rowstore clustered index and two nonclustered rowstore indexes.<br \/>\n<br \/>You must minimize the growth of the StagedExternal database log file during the BULK INSERT operations and perform point-in-time recovery after the BULK INSERT transaction. Changes made must not interrupt the log backup chain.<br \/>\n<br \/>You plan to add a new instance named Instance6 to a datacenter that is geographically distant from Site1 and Site2. You must minimize latency between the nodes in AG1.<br \/>\n<br \/>All databases use the full recovery model. All backups are written to the network location \\SQLBackup. A separate process copies backups to an offsite location. You should minimize both the time required to restore the databases and the space required to store backups.<br \/>\n<br \/>The recovery point objective (RPO) for each instance is shown in the following table. <\/p>\n<p><img decoding=\"async\" width=295 height=122 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image036.jpg\" v:shapes=\"_x0000_i1078\"><\/p>\n<p>Full backups of OperationsMain take longer than six hours to complete. All SQL Server backups use the keyword COMPRESSION.<br \/>\n<br \/>You plan to deploy the following solutions to the environment. The solutions will access a database named DB1 that is part of AG1.<br \/>\n<br \/>-Reporting system: This solution accesses data inDB1with a login that is mapped to a database user that is a member of the db_datareader role. The user has EXECUTE permissions on the database. Queries make no changes to the data. The queries must be load balanced over variable read-only replicas.<br \/>\n<br \/>-Operations system: This solution accesses data inDB1with a login that is mapped to a database user that is a member of the db_datareader and db_datawriter roles. The user has EXECUTE permissions on the database. Queries from the operations system will perform both DDL and DML operations.<br \/>\n<br \/>The wait statistics monitoring requirements for the instances are described in the following table. <\/p>\n<p><img decoding=\"async\" width=624 height=101 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image062.jpg\" v:shapes=\"_x0000_i1079\"><\/p>\n<p>You need to reduce the amount of time it takes to backup OperationsMain.<br \/>\n<br \/>What should you do?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115952' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478255' \/><div class='watu-question-choice'><input type='radio' name='answer-115952[]' id='answer-id-478255' class='answer answer-39  answerof-115952' value='478255' \/>&nbsp;<label for='answer-id-478255' id='answer-label-478255' class=' answer label-39'><span class='answer'>Modify the backup script to use the keyword SKIP in the FILE_SNAPSHOT statement.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478257' \/><div class='watu-question-choice'><input type='radio' name='answer-115952[]' id='answer-id-478257' class='answer answer-39  answerof-115952' value='478257' \/>&nbsp;<label for='answer-id-478257' id='answer-label-478257' class=' answer label-39'><span class='answer'>Modify the backup script to use the keyword SKIP in the WITH statement<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478259' \/><div class='watu-question-choice'><input type='radio' name='answer-115952[]' id='answer-id-478259' class='answer answer-39  answerof-115952' value='478259' \/>&nbsp;<label for='answer-id-478259' id='answer-label-478259' class=' answer label-39'><span class='answer'>Modify the backup script to use the keyword NO_COMPRESSION in the WITH statement.<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478261' \/><div class='watu-question-choice'><input type='radio' name='answer-115952[]' id='answer-id-478261' class='answer answer-39  answerof-115952' value='478261' \/>&nbsp;<label for='answer-id-478261' id='answer-label-478261' class=' answer label-39'><span class='answer'>Modify the full database backups script to stripe the backup across multiple backup files.<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType39' value='radio' class=''><\/div><div class='watu-question' id='question-40'><div class='question-content'><p><span class='watu_num'>40. <\/span>DRAG DROP<br \/>\n<br \/>You have a database.<br \/>\n<br \/>The existing backups for the database and their corresponding files are listed in the following table. <\/p>\n<p><img decoding=\"async\" width=553 height=162 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image065.jpg\" v:shapes=\"_x0000_i1080\"><\/p>\n<p>You purchase a new server. You must restore the database to the new server.<br \/>\n<br \/>You need to restore the data to the most recent time possible.<br \/>\n<br \/>Which three files should you restore in sequence? To answer, move the appropriate files from the list of files to the answer area and arrange them in the correct order. <\/p>\n<p><img decoding=\"async\" width=438 height=386 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image067.jpg\" v:shapes=\"_x0000_i1081\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115954' \/><textarea name='answer-115954[]' rows='5' cols='40' id='textarea_q_115954' class='watu-textarea watu-textarea-40'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478263' \/><\/div><input type='hidden' id='questionType40' value='textarea' class=''><\/div><div class='watu-question' id='question-41'><div class='question-content'><p><span class='watu_num'>41. <\/span>A Microsoft SQL Server database named DB1 has two filegroups named FG1 and FG2. You implement a backup strategy that creates backups for the filegroups.<br \/>\n<br \/>DB1 experiences a failure. You must restore FG1 and then FG2.<br \/>\n<br \/>You need to ensure that the database remains in the RECOVERING state until the restoration of FG2 completes. After the restoration of FG2 completes, the database must be online.<br \/>\n<br \/>What should you specify when you run the recovery command?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115955' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478266' \/><div class='watu-question-choice'><input type='radio' name='answer-115955[]' id='answer-id-478266' class='answer answer-41  answerof-115955' value='478266' \/>&nbsp;<label for='answer-id-478266' id='answer-label-478266' class=' answer label-41'><span class='answer'>the WITH NORECOVERY clause for FG1 and the WITH RECOVERY clause for FG2<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478268' \/><div class='watu-question-choice'><input type='radio' name='answer-115955[]' id='answer-id-478268' class='answer answer-41  answerof-115955' value='478268' \/>&nbsp;<label for='answer-id-478268' id='answer-label-478268' class=' answer label-41'><span class='answer'>the WITH RECOVERY clause for FG1 and the WITH RECOVERY clause for FG2<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478269' \/><div class='watu-question-choice'><input type='radio' name='answer-115955[]' id='answer-id-478269' class='answer answer-41  answerof-115955' value='478269' \/>&nbsp;<label for='answer-id-478269' id='answer-label-478269' class=' answer label-41'><span class='answer'>the WITH RECOVERY clause for both FG1 and FG2<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478270' \/><div class='watu-question-choice'><input type='radio' name='answer-115955[]' id='answer-id-478270' class='answer answer-41  answerof-115955' value='478270' \/>&nbsp;<label for='answer-id-478270' id='answer-label-478270' class=' answer label-41'><span class='answer'>the WITH NORECOVERY clause for both FG1 and FG2<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType41' value='radio' class=''><\/div><div class='watu-question' id='question-42'><div class='question-content'><p><span class='watu_num'>42. <\/span>DRAG DROP<br \/>\n<br \/>You have a test server that contains a database named DB1. Backups of the database are written to a single backup device. The backup device has a full, differential, and transaction log backup.<br \/>\n<br \/>You discover that the database is damaged. You restore the database to the point at which the differential backup was taken.<br \/>\n<br \/>You need to rebuild the database with data stored in the latest transaction logs.<br \/>\n<br \/>How should you complete the Transact-SQL statement? To answer. drag the appropriate Transact-SQL segments to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. <\/p>\n<p><img decoding=\"async\" width=624 height=346 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image071.jpg\" v:shapes=\"_x0000_i1083\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115957' \/><textarea name='answer-115957[]' rows='5' cols='40' id='textarea_q_115957' class='watu-textarea watu-textarea-42'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478274' \/><\/div><input type='hidden' id='questionType42' value='textarea' class=''><\/div><div class='watu-question' id='question-43'><div class='question-content'><p><span class='watu_num'>43. <\/span>You have a database named DB1 that is configured to use the full recovery model. You have a full daily backup job that runs at 02:00. The job backs up data from DB1 to the file B:DB1.bak.<br \/>\n<br \/>You need to restore the DB1 database to the point in time of May 25, 2016 at 02:23 and ensure<br \/>\n<br \/>that the database is functional and starts to accept connections.<br \/>\n<br \/>Which Transact-SQL statement should you run? <\/p>\n<p><img decoding=\"async\" width=556 height=337 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image075.jpg\" v:shapes=\"_x0000_i1085\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115958' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478276' \/><div class='watu-question-choice'><input type='radio' name='answer-115958[]' id='answer-id-478276' class='answer answer-43  answerof-115958' value='478276' \/>&nbsp;<label for='answer-id-478276' id='answer-label-478276' class=' answer label-43'><span class='answer'>Option A<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478278' \/><div class='watu-question-choice'><input type='radio' name='answer-115958[]' id='answer-id-478278' class='answer answer-43  answerof-115958' value='478278' \/>&nbsp;<label for='answer-id-478278' id='answer-label-478278' class=' answer label-43'><span class='answer'>Option B<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478280' \/><div class='watu-question-choice'><input type='radio' name='answer-115958[]' id='answer-id-478280' class='answer answer-43  answerof-115958' value='478280' \/>&nbsp;<label for='answer-id-478280' id='answer-label-478280' class=' answer label-43'><span class='answer'>Option C<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478282' \/><div class='watu-question-choice'><input type='radio' name='answer-115958[]' id='answer-id-478282' class='answer answer-43  answerof-115958' value='478282' \/>&nbsp;<label for='answer-id-478282' id='answer-label-478282' class=' answer label-43'><span class='answer'>Option D<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType43' value='radio' class=''><\/div><div class='watu-question' id='question-44'><div class='question-content'><p><span class='watu_num'>44. <\/span>HOTSPOT<br \/>\n<br \/>You manage a Microsoft-SQL Server database named sales Orders.<br \/>\n<br \/>You need to verify the integrity of the database and attempt to repair any errors that are found. Repair must not cause any data to be lost in the database.<br \/>\n<br \/>How should you complete the DBCC command? To answer, select the appropriate options in the answer area. <\/p>\n<p><img decoding=\"async\" width=498 height=126 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image077.jpg\" v:shapes=\"_x0000_i1086\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115960' \/><textarea name='answer-115960[]' rows='5' cols='40' id='textarea_q_115960' class='watu-textarea watu-textarea-44'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478284' \/><\/div><input type='hidden' id='questionType44' value='textarea' class=''><\/div><div class='watu-question' id='question-45'><div class='question-content'><p><span class='watu_num'>45. <\/span>HOTSPOT<br \/>\n<br \/>You manage a Microsoft SQL Server environment. You have a database named salesOrders that includes a table named Table1. Table1 becomes corrupt. You repair the table.<br \/>\n<br \/>You need to verify that all the data in Table1 complies with the schema.<br \/>\n<br \/>How should you complete the Transact-SQL code statement? To answer, select the appropriate Transact-SQL code segments in the dialog box in the answer area. <\/p>\n<p><img decoding=\"async\" width=462 height=119 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image081.jpg\" v:shapes=\"_x0000_i1088\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115962' \/><textarea name='answer-115962[]' rows='5' cols='40' id='textarea_q_115962' class='watu-textarea watu-textarea-45'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478287' \/><\/div><input type='hidden' id='questionType45' value='textarea' class=''><\/div><div class='watu-question' id='question-46'><div class='question-content'><p><span class='watu_num'>46. <\/span>DRAG DROP<br \/>\n<br \/>You are configuring a new Microsoft SQL Server Always On Availability Group. You plan to configure a shared network location at \\DATA-CI1SQL.<br \/>\n<br \/>You need to create an availability group listener named AGL1 on port 1433.<br \/>\n<br \/>In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order. <\/p>\n<p><img decoding=\"async\" width=580 height=400 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image085.jpg\" v:shapes=\"_x0000_i1090\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115963' \/><textarea name='answer-115963[]' rows='5' cols='40' id='textarea_q_115963' class='watu-textarea watu-textarea-46'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478290' \/><\/div><input type='hidden' id='questionType46' value='textarea' class=''><\/div><div class='watu-question' id='question-47'><div class='question-content'><p><span class='watu_num'>47. <\/span>HOTSPOT<br \/>\n<br \/>You are configuring log shipping for a Microsoft SQL Server database named salesOrders.<br \/>\n<br \/>You run the following Transact-SQL script: <\/p>\n<p><img decoding=\"async\" width=505 height=603 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image089.jpg\" v:shapes=\"_x0000_i1092\"><\/p>\n<p>You need to determine the changes that the script has on the environment.<br \/>\n<br \/>How does the script affect the environment? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. <\/p>\n<p><img decoding=\"async\" width=629 height=386 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image091.jpg\" v:shapes=\"_x0000_i1093\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115965' \/><textarea name='answer-115965[]' rows='5' cols='40' id='textarea_q_115965' class='watu-textarea watu-textarea-47'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478292' \/><\/div><input type='hidden' id='questionType47' value='textarea' class=''><\/div><div class='watu-question' id='question-48'><div class='question-content'><p><span class='watu_num'>48. <\/span>HOTSPOT<br \/>\n<br \/>You are planning the deployment of two new Always On Failover Cluster Instances (FCIs) of Microsoft SQL Server to a single Windows Server Cluster with three nodes.<br \/>\n<br \/>The planned configuration for the cluster is shown in the Server Layout exhibit. (Click the Exhibit button.) <\/p>\n<p><img decoding=\"async\" width=584 height=301 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image095.jpg\" v:shapes=\"_x0000_i1095\"><\/p>\n<p>The SAN team has configured storage for the cluster and sent the configuration to you in the email shown in the SAN Team Email exhibit. (Click the Exhibit button.) <\/p>\n<p><img decoding=\"async\" width=584 height=237 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image097.jpg\" v:shapes=\"_x0000_i1096\"><\/p>\n<p>Each node of the cluster has identical local storage available as shown in the Local Storage exhibit. (Click the Exhibit button.) <\/p>\n<p><img decoding=\"async\" width=649 height=167 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image099.jpg\" v:shapes=\"_x0000_i1097\"><\/p>\n<p>All local storage is on SSD. You need to plan specific configurations for the new cluster. For each of the following statement, select Yes if the statement is true. Otherwise, select No. <\/p>\n<p><img decoding=\"async\" width=650 height=256 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image100.gif\" v:shapes=\"_x0000_i1098\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115966' \/><textarea name='answer-115966[]' rows='5' cols='40' id='textarea_q_115966' class='watu-textarea watu-textarea-48'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478296' \/><\/div><input type='hidden' id='questionType48' value='textarea' class=''><\/div><div class='watu-question' id='question-49'><div class='question-content'><p><span class='watu_num'>49. <\/span>HOTSPOT<br \/>\n<br \/>You are planning to deploy log shipping for Microsoft SQL Server and store all backups on a dedicated fileshare.<br \/>\n<br \/>You need to configure the servers to perform each log shipping step.<br \/>\n<br \/>Which server instance should you configure to perform each action? To answer, select the appropriate server instances in the dialog box in the answer area. <\/p>\n<p><img decoding=\"async\" width=644 height=495 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image106.jpg\" v:shapes=\"_x0000_i1101\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115968' \/><textarea name='answer-115968[]' rows='5' cols='40' id='textarea_q_115968' class='watu-textarea watu-textarea-49'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478298' \/><\/div><input type='hidden' id='questionType49' value='textarea' class=''><\/div><div class='watu-question' id='question-50'><div class='question-content'><p><span class='watu_num'>50. <\/span>HOTSPOT<br \/>\n<br \/>You manage a Microsoft SQL Server instance. You have a user named User1. You need to grant the minimum permissions necessary to allow User1 to review audit logs.<br \/>\n<br \/>For each action, which option should you use? To answer, select the appropriate options in the answer area. <\/p>\n<p><img decoding=\"async\" width=649 height=354 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image110.jpg\" v:shapes=\"_x0000_i1103\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115969' \/><textarea name='answer-115969[]' rows='5' cols='40' id='textarea_q_115969' class='watu-textarea watu-textarea-50'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478302' \/><\/div><input type='hidden' id='questionType50' value='textarea' class=''><\/div><div class='watu-question' id='question-51'><div class='question-content'><p><span class='watu_num'>51. <\/span>DRAG DROP<br \/>\n<br \/>You administer a Microsoft SQL Server database named Contoso.<br \/>\n<br \/>You create a stored procedure named Sales.ReviewInvoice by running the following Transact-SQL statement: <\/p>\n<p><img decoding=\"async\" width=625 height=84 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image114.jpg\" v:shapes=\"_x0000_i1105\"><\/p>\n<p>You need to create a Windows-authenticated login named ContosoSearch and ensure that ContosoSearch can run the Sales.ReviewInvoices stored procedure.<br \/>\n<br \/>Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order. <\/p>\n<p><img decoding=\"async\" width=650 height=698 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image116.jpg\" v:shapes=\"_x0000_i1106\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115971' \/><textarea name='answer-115971[]' rows='5' cols='40' id='textarea_q_115971' class='watu-textarea watu-textarea-51'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478304' \/><\/div><input type='hidden' id='questionType51' value='textarea' class=''><\/div><div class='watu-question' id='question-52'><div class='question-content'><p><span class='watu_num'>52. <\/span>You have a database that stores information for a shipping company.<br \/>\n<br \/>You create a table named Customers by running the following Transact-SQL statement. (Line numbers are included for reference only.) <\/p>\n<p><img decoding=\"async\" width=619 height=182 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image120.jpg\" v:shapes=\"_x0000_i1108\"><\/p>\n<p>You need to ensure that salespeople can view data only for the customers that are assigned to them.<br \/>\n<br \/>Which Transact-SQL segment should you insert at line 07?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115972' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478307' \/><div class='watu-question-choice'><input type='radio' name='answer-115972[]' id='answer-id-478307' class='answer answer-52  answerof-115972' value='478307' \/>&nbsp;<label for='answer-id-478307' id='answer-label-478307' class=' answer label-52'><span class='answer'>RETURNS varchar(20)WITH Schemabinding<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478309' \/><div class='watu-question-choice'><input type='radio' name='answer-115972[]' id='answer-id-478309' class='answer answer-52  answerof-115972' value='478309' \/>&nbsp;<label for='answer-id-478309' id='answer-label-478309' class=' answer label-52'><span class='answer'>RETURNS dbo.CustomersORDER BY @salesPerson<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478310' \/><div class='watu-question-choice'><input type='radio' name='answer-115972[]' id='answer-id-478310' class='answer answer-52  answerof-115972' value='478310' \/>&nbsp;<label for='answer-id-478310' id='answer-label-478310' class=' answer label-52'><span class='answer'>RETURNS tableORDER BY @salesPerson<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478312' \/><div class='watu-question-choice'><input type='radio' name='answer-115972[]' id='answer-id-478312' class='answer answer-52  answerof-115972' value='478312' \/>&nbsp;<label for='answer-id-478312' id='answer-label-478312' class=' answer label-52'><span class='answer'>RETURNS tableWITH Schemabinding<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType52' value='radio' class=''><\/div><div class='watu-question' id='question-53'><div class='question-content'><p><span class='watu_num'>53. <\/span>You manage a Microsoft SQL Server environment.<br \/>\n<br \/>You plan to encrypt data when you create backups.<br \/>\n<br \/>You need to configure the encryption options for backups.<br \/>\n<br \/>What should you configure?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115974' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478315' \/><div class='watu-question-choice'><input type='radio' name='answer-115974[]' id='answer-id-478315' class='answer answer-53  answerof-115974' value='478315' \/>&nbsp;<label for='answer-id-478315' id='answer-label-478315' class=' answer label-53'><span class='answer'>a certificate<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478317' \/><div class='watu-question-choice'><input type='radio' name='answer-115974[]' id='answer-id-478317' class='answer answer-53  answerof-115974' value='478317' \/>&nbsp;<label for='answer-id-478317' id='answer-label-478317' class=' answer label-53'><span class='answer'>an MD5 hash<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478318' \/><div class='watu-question-choice'><input type='radio' name='answer-115974[]' id='answer-id-478318' class='answer answer-53  answerof-115974' value='478318' \/>&nbsp;<label for='answer-id-478318' id='answer-label-478318' class=' answer label-53'><span class='answer'>a DES key<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478320' \/><div class='watu-question-choice'><input type='radio' name='answer-115974[]' id='answer-id-478320' class='answer answer-53  answerof-115974' value='478320' \/>&nbsp;<label for='answer-id-478320' id='answer-label-478320' class=' answer label-53'><span class='answer'>an AES 256-bit key<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType53' value='radio' class=''><\/div><div class='watu-question' id='question-54'><div class='question-content'><p><span class='watu_num'>54. <\/span>You have a database named DB1 that stores more than 700 gigabyte (GB) of data and serves millions of requests per hour.<br \/>\n<br \/>Queries on DB1 are taking longer than normal to complete.<br \/>\n<br \/>You run the following Transact-SQL statement:<br \/>\n<br \/>SELECT * FROM sys.database_query_store_options<br \/>\n<br \/>You determine that the Query Store is in Read-Only mode.<br \/>\n<br \/>You need to maximize the time that the Query Store is in Read-Write mode.<br \/>\n<br \/>Which Transact-SQL statement should you run?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='115976' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478323' \/><div class='watu-question-choice'><input type='radio' name='answer-115976[]' id='answer-id-478323' class='answer answer-54  answerof-115976' value='478323' \/>&nbsp;<label for='answer-id-478323' id='answer-label-478323' class=' answer label-54'><span class='answer'>ALTER DATABASE DB1SET QUERY_STORE (QUERY_CAPTURE_MODE = ALL)<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478325' \/><div class='watu-question-choice'><input type='radio' name='answer-115976[]' id='answer-id-478325' class='answer answer-54  answerof-115976' value='478325' \/>&nbsp;<label for='answer-id-478325' id='answer-label-478325' class=' answer label-54'><span class='answer'>ALTER DATABASE DB1SET QUERY_STORE (MAX_STORAGE_SIZE_MB = 50)<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478326' \/><div class='watu-question-choice'><input type='radio' name='answer-115976[]' id='answer-id-478326' class='answer answer-54  answerof-115976' value='478326' \/>&nbsp;<label for='answer-id-478326' id='answer-label-478326' class=' answer label-54'><span class='answer'>ALTER DATABASE DB1SET QUERY_STORE (CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 14));<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478328' \/><div class='watu-question-choice'><input type='radio' name='answer-115976[]' id='answer-id-478328' class='answer answer-54  answerof-115976' value='478328' \/>&nbsp;<label for='answer-id-478328' id='answer-label-478328' class=' answer label-54'><span class='answer'>ALTER DATABASE DB1SET QUERY_STORE (QUERY_CAPTURE_MODE = NONE)<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType54' value='radio' class=''><\/div><div class='watu-question' id='question-55'><div class='question-content'><p><span class='watu_num'>55. <\/span>HOTSPOT<br \/>\n<br \/>You deploy a Microsoft SQL Server instance to support a global sales application. The instance includes the following tables: TableA and TableB.<br \/>\n<br \/>TableA is a partitioned table that uses an incrementing integer number for partitioning. The table has millions of rows in each partition. Most changes to the data in TableA affect recently added<br \/>\n<br \/>data. The UPDATE STATISTICS for TableA takes longer to complete than the allotted maintenance window.<br \/>\n<br \/>Thousands of operations are performed against TableB each minute. You observe a large number of Auto Update Statistics events for TableB.<br \/>\n<br \/>You need to address the performance issues with each table.<br \/>\n<br \/>In the table below, identify the action that will resolve the issues for each table. NOTE: Make only one selection in each column. <\/p>\n<p><img decoding=\"async\" width=645 height=373 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image121.gif\" v:shapes=\"_x0000_i1109\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115978' \/><textarea name='answer-115978[]' rows='5' cols='40' id='textarea_q_115978' class='watu-textarea watu-textarea-55'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478331' \/><\/div><input type='hidden' id='questionType55' value='textarea' class=''><\/div><div class='watu-question' id='question-56'><div class='question-content'><p><span class='watu_num'>56. <\/span>DRAG DROP<br \/>\n<br \/>You administer a database that is used for reporting purposes. The database has a large fact table that contains three hundred million rows. The table includes a clustered columnstore index and a nonclustered index on the Product ID column. New rows are inserted into the table every day.<br \/>\n<br \/>Performance of queries that filter the Product ID column have degraded significantly.<br \/>\n<br \/>You need to improve the performance of the queries.<br \/>\n<br \/>Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. <\/p>\n<p><img decoding=\"async\" width=570 height=440 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image125.jpg\" v:shapes=\"_x0000_i1111\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115979' \/><textarea name='answer-115979[]' rows='5' cols='40' id='textarea_q_115979' class='watu-textarea watu-textarea-56'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478333' \/><\/div><input type='hidden' id='questionType56' value='textarea' class=''><\/div><div class='watu-question' id='question-57'><div class='question-content'><p><span class='watu_num'>57. <\/span>HOTSPOT<br \/>\n<br \/>You are the database administrator of a Microsoft SQL Server instance. Developers are writing stored procedures to send emails using sp_send_dbmail. Database Mail is enabled.<br \/>\n<br \/>You need to configure each account\u2019s profile security and meet the following requirements:<br \/>\n<br \/>&#8211; Account SMTP1_Account must only be usable by logins that have been given explicit permissions to use the SMTP1_profile.<br \/>\n<br \/>&#8211; Account SMTP2_Account must only be usable by logins who are a member of the [DatabaseMailUserRole] role in msdb.<br \/>\n<br \/>In the table below. identify the profile type that must be used for each account.<br \/>\n<br \/>NOTE: Make only one selection in each column. <\/p>\n<p><img decoding=\"async\" width=630 height=206 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image128.gif\" v:shapes=\"_x0000_i1113\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115981' \/><textarea name='answer-115981[]' rows='5' cols='40' id='textarea_q_115981' class='watu-textarea watu-textarea-57'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478336' \/><\/div><input type='hidden' id='questionType57' value='textarea' class=''><\/div><div class='watu-question' id='question-58'><div class='question-content'><p><span class='watu_num'>58. <\/span>HOTSPOT<br \/>\n<br \/>You have a Microsoft SQL Server instance that hosts a database named DB1 that contains 800 gigabyte (GB) of data. The database is used 24 hours each day. You implement indexes and set the value of the Auto Update Statistics option set to True.<br \/>\n<br \/>Users report that queries take a long time to complete.<br \/>\n<br \/>You need to identify statistics that have not been updated for a week for tables where more than 1,000 rows changed.<br \/>\n<br \/>How should you complete the Transact-SQL statement? To answer, configure the appropriate Transact-SQL segments in the answer area. <\/p>\n<p><img decoding=\"async\" width=617 height=409 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image132.jpg\" v:shapes=\"_x0000_i1115\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115982' \/><textarea name='answer-115982[]' rows='5' cols='40' id='textarea_q_115982' class='watu-textarea watu-textarea-58'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478339' \/><\/div><input type='hidden' id='questionType58' value='textarea' class=''><\/div><div class='watu-question' id='question-59'><div class='question-content'><p><span class='watu_num'>59. <\/span>DRAG DROP<br \/>\n<br \/>You are the database administrator for a Microsoft SQL Server instance. You develop an Extended Events package to look for events related to application performance.<br \/>\n<br \/>You need to change the event session to include SQL Server errors that are greater than error severity 15.<br \/>\n<br \/>Which five Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order. <\/p>\n<p><img decoding=\"async\" width=600 height=405 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image136.jpg\" v:shapes=\"_x0000_i1117\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115984' \/><textarea name='answer-115984[]' rows='5' cols='40' id='textarea_q_115984' class='watu-textarea watu-textarea-59'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478341' \/><\/div><input type='hidden' id='questionType59' value='textarea' class=''><\/div><div class='watu-question' id='question-60'><div class='question-content'><p><span class='watu_num'>60. <\/span>HOTSPOT<br \/>\n<br \/>You manage a Microsoft SQL Server environment. A server fails and writes the following event to the application event log: MSG_AUDIT_FORCED_SHUTDOWN<br \/>\n<br \/>You configure the SQL Server startup parameters as shown in the following graphic: <\/p>\n<p><img decoding=\"async\" width=428 height=500 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image140.jpg\" v:shapes=\"_x0000_i1119\"><\/p>\n<p>Use the drop-down menus to select the answer choice that answers each question. NOTE: Each correct selection is worth one point. <\/p>\n<p><img decoding=\"async\" width=566 height=267 src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2018\/exams\/70-764%20V13.files\/image142.jpg\" v:shapes=\"_x0000_i1120\"><\/p>\n<\/div><input type='hidden' name='question_id[]' value='115985' \/><textarea name='answer-115985[]' rows='5' cols='40' id='textarea_q_115985' class='watu-textarea watu-textarea-60'><\/textarea><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='478344' \/><\/div><input type='hidden' id='questionType60' value='textarea' class=''><\/div><div style='display:none' id='question-61'><br \/><div class='question-content'><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watu\/loading.gif\" width=\"16\" height=\"16\" alt=\"Loading ...\" title=\"Loading ...\" \/>&nbsp;Loading &#8230;<\/div><\/div><br \/>\n<input type=\"button\" name=\"action\" onclick=\"Watu.submitResult()\" id=\"action-button\" value=\"Submit\"  class=\"watu-submit-button\" \/>\n<input type=\"hidden\" name=\"no_ajax\" value=\"0\"><input type=\"hidden\" name=\"quiz_id\" value=\"2018\" \/>\n<input type=\"hidden\" id=\"watuStartTime\" name=\"start_time\" value=\"2026-05-11 19:51:53\" \/>\n<\/form>\n<\/div>\n<div id=\"watu-loading-result\" style=\"display:none;\">\n\t<p align=\"center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watu\/loading.gif\" width=\"16\" height=\"16\" alt=\"Loading\" title=\"Loading\" \/><\/p>\n<\/div>\t\n<script type=\"text\/javascript\">\nvar exam_id=0;\nvar question_ids='';\nvar watuURL='';\njQuery(function($){\nquestion_ids = \"115886,115887,115888,115889,115890,115891,115892,115893,115894,115895,115897,115898,115900,115901,115903,115904,115907,115910,115913,115915,115918,115921,115923,115925,115928,115930,115932,115935,115936,115937,115939,115940,115942,115944,115945,115947,115948,115950,115952,115954,115955,115957,115958,115960,115962,115963,115965,115966,115968,115969,115971,115972,115974,115976,115978,115979,115981,115982,115984,115985\";\nexam_id = 2018;\nWatu.exam_id = exam_id;\nWatu.qArr = question_ids.split(',');\nWatu.post_id = 4634;\nWatu.singlePage = '1';\nWatu.hAppID = \"0.33421200 1778529113\";\nwatuURL = \"https:\/\/www.dumpsbase.com\/freedumps\/wp-admin\/admin-ajax.php\";\nWatu.noAlertUnanswered = 0;\n});\n<\/script>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[160,101],"tags":[5291,1059,5292,7842],"class_list":["post-4634","post","type-post","status-publish","format-standard","hentry","category-mcsa","category-microsoft","tag-70-764","tag-70-764-dumps","tag-70-764-exam-questions","tag-70-764-free-dumps"],"_links":{"self":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/4634","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=4634"}],"version-history":[{"count":1,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/4634\/revisions"}],"predecessor-version":[{"id":4635,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/4634\/revisions\/4635"}],"wp:attachment":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/media?parent=4634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/categories?post=4634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/tags?post=4634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}