Note: This ques

tion 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 corre

ct 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?

A. Yes

B. No

Explanation:

Database Mail is guarded by the database role DatabaseMailUserRole in th

e msdb database, not the master database, in order to prevent anyone from sending arbitrary emails. Database users or roles must be created in the msdb database and must also be a member of DatabaseMailUserRole in order to send emails with the exception of

sysadmin who has all privileges.

Note: Database Mail was first introduced as a new feature in SQL Server 2005 and replaces the SQL Mail feature found in previous versions.

References:

http://www.idevelopment.info/data/SQLServer/DBA_tips/Database_Administration/DBA_20.shtml

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?

A. Yes

B. No

Explanation:

All editions of SQL Server support server level audits. All editions support database level audits beginning with SQL Server 201

6 SP1. Prior to that, database level auditing was limited to Enterprise, Developer, and Evaluation editions.

References: https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine

Note: T

his 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 than runs Microsoft SQL Server 2016 Standard edition.

Does

the solution meet the goal?

A. Yes

B. No

Explanation:

All editions of SQL Server support server level audits. All editions support database level audits beginning with SQL Server 2016 SP1. Prior to that, database level auditing was limited to E

nterprise, Developer, and Evaluation editions.

References: https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine

Note: This question i

s 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 sol

ution.

After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a data warehouse that stored sales data. One fact table has 100 million rows.

You must

reduce storage needs for the data warehouse.

You need to implement a solution that uses column-based storage and provides real-time analytics for the operational workload.

Solution: You remove all clustered indexes, sort the transactions in the table, a

nd create a clustered index on the table, so that the table is not a heap.

Does the solution meet the goal?

A. Yes

B. No

Columnstore indexes are the standard for storing and querying large data warehousing fact tables. It uses column-based dat

a storage and query processing to achieve up to 10x query performance gains in your data warehouse over traditional row-oriented storage, and up to 10x data compression over the uncompressed data size.

In SQL Server, rowstore refers to table where the und

erlying data storage format is a heap, a clustered index, or a memory-optimized table.

References: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview

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 hav

e a correct solution.

After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You attempt to restore a database on a new SQL Server instance and receive the fo

llowing error message:

-Msg 33111, Level 16, State 3, Line 2

Cannot find server certificate with thumbprint -0x7315277C70764B1F252DC7A5101F6F66EFB1069D.-

You need to ensure that you can restore the database successfully.

Solution: You add the backup set

password to the restore command.

Does this meet the goal?

A. Yes

B. No

The error is related to the certificate.

References: https://dba.stackexchange.com/questions/3388/restore-encrypted-database-to-another-server?rq=1

No

te: 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 sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You attempt to restore a database on a new SQL Server instance and receive

the following error message:

-Msg 33111, Level 16, State 3, Line 2

Cannot find server certificate with thumbprint -0x7315277C70764B1F252DC7A5101F6F66EFB1069D.-

You need to ensure that you can restore the database successfully.

Solution: You restore the

certificate on the new instance.

Does this meet the goal?

A. Yes

B. No

The error is related to the certificate.

References: https://dba.stackexchange.com/questions/3388/restore-encrypted-database-to-another-server?rq=1