Pre-Summer Sale Special - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

You are planning the migration of the SERVER1 databases. The solution must meet the business requirements.

What should you include in the migration plan? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to identify t he cause of the performance issues on SalesSQLDb1.

Which two dynamic management views should you use? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A.

sys.dm_pdw_nodes_tran_locks

B.

sys.dm_exec_compute_ node_errors

C.

sys.dm_exec_requests

D.

sys.dm_cdc_errors

E.

sys.dm_pdw_nodes_os_wait_stats

F.

sys.dm_tran_locks

You need to recommend a solution to ensure that the customers can create the database objects. The solution must meet the business goals.

What should you include in the recommendation?

A.

For each customer, grant the customer ddl_admin to the existing schema.

B.

For each customer, create an additional schema and grant the customer ddl_admin to the new schema.

C.

For each customer, create an additional schema and grant the customer db_writerto the new schema.

D.

For each customer, g rant the customer db_writerto the existing schema.

You need to implement the monitoring of SalesSQLDb1. The solution must meet the technical requir ements.

How should you collect and stream metrics? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You are evaluating the business goals.

Which feature should you use to provide customers with the required level of access based on their service agreement?

A.

dynamic data masking

B.

Conditional Access in Azure

C.

service principals

D.

row-level security (RLS)

You need to configure user authentication for the SERVER1 databases. The solution must meet the security and compl iance requirements.

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.

You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the technical requirements.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

You have an Azure SQL database named DB1 that contains two tables named Table1 and Table2. Both tables contai n a column named a Column1. Column1 is used for joins by an application named App1.

You need to protect the contents of Column1 at rest, in transit, and in use.

How should you protect the contents of Column1? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have an Azure SQL database that contains a table named Customers Customers contains the following columns.

The data in the PhoneNumber and Email columns is encrypted.

You need to recommend a data classification strategy for Customers. The solution must meet the following requirements:

• Support data security and privacy requirements.

• Support the auditing of access to sensitive data

• Minimize administrative effort.

What should you recommend?

A.

Apply a sensitivity label to each column.

B.

Enable Transparent Data Encryption (TDE) for the database.

C.

Implement dynamic data masking for the PhoneNumber and Email columns.

D.

Apply a sensitivity label to Customers

You configure backups for an Azure SQL database as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.