70-764

Review 342 70-764 practice questions with answer explanations and community insights.

Question 1

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. 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. You need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail. Solution: You add the DatabaseMailUserRole to Mail1 in the tempdb database. Does the solution meet the goal?

  1. Yes
  2. No

Question 2

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. 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. You need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail. Solution: You add the DatabaseMailUserRole to Mail1 in the msdb database. Does the solution meet the goal?

  1. Yes
  2. No

Question 3

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. 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. You need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail. Solution: You add the DatabaseMailUserRole to Mail1 in the master database. Does the solution meet the goal?

  1. Yes
  2. No

Question 4

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. 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. 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. You need to ensure that you can perform auditing at the database level for DB1. Solution: You migrate DB1 to the default instance on a server that runs Microsoft SQL Server 2016 Standard edition. Does the solution meet the goal?

  1. Yes
  2. No

Question 5

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. 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. 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. You need to ensure that you can perform auditing at the database level for DB1. Solution: You migrate DB1 to a named instance on a server that runs Microsoft SQL Server 2016 Enterprise edition. Does the solution meet the goal?

  1. Yes
  2. No
We are moving to a new platform

CertificationTest is being migrated. Some pages may be slow or briefly unavailable; everything will be back to normal within a few hours. If you run into any issue, email support@certificationtest.net.