DP-300 – Administering Relational Databases on Microsoft Azure (beta)

Loading demo links...

Showing 7–9 of 15 questions

Question 7 (Mixed Questions)

You are planning disaster recovery for the failover group of an Azure SQL Database managed instance.

Your company’s SLA requires that the database in the failover group become available as quickly as possible if a major outage occurs.

You set the Read/Write failover policy to Automatic.

What are two results of the configuration? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

○
In the event of a datacenter or Azure regional outage, the databases will fail over automatically.
○
In the event of an outage, the databases in the primary instance will fail over immediately.
○
In the event of an outage, you can selectively fail over individual databases.
○
In the event of an outage, you can set a different grace period to fail over each database.
○
In the event of an outage, the minimum delay for the databases to fail over in the primary instance will be one hour.

Question 8 (New Update)

You are designing a security model for an Azure Synapse Analytics dedicated SQL pool that will support multiple companies.

You need to ensure that users from each company can view only the data of their respective company.

Which two objects should you include in the solution? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

Question 9 (New Update)

You have an Azure SQL database named DB1. DB1 has a table named Table1 that contains the following columns.

You plan to enable Always Encrypted for Table1.

Which two columns support encryption? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point

Select all that apply, then click Submit answer.

← Prev 1 2 3 4 5 Next →

Page 3 of 5

Sale Ends In

2h 0m 0s