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.

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

Comment: *

Name: *

Email: *

Verification: *

You have a Microsoft SQL Server database named DB1 that contains a table named Table1.
The database role membership for a user named User1 is 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.

Correct Answer:

Explanation:
Box 1: delete a row from Table1
Members of the db_datawriter fixed database role can add, delete, or change data in all user tables.
Box 2: db_datareader
Members of the db_datareader fixed database role can read all data from all user tables.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles

Comment: *

Name: *

Email: *

Verification: *

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)

Comment: *

Name: *

Email: *

Verification: *

You have SQL Server on an Azure virtual machine that contains a database named DB1.
You view a plan summary that shows the duration in milliseconds of each execution of query 1178902 as shown in the following exhibit:

What should you do to ensure that the query uses the execution plan which executes in the least amount of time?

• A.Force the query execution plan for plan 1221065.
• B.Run the DBCC FREEPROCCACHEcommand.
• C.Force the query execution plan for plan 1220917.
• D.Disable parameter sniffing.

Comment: *

Name: *

Email: *

Verification: *

You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 is 30 TB and has a 1-GB daily rate of change.
You back up the database by using a Microsoft SQL Server Agent job that runs Transact-SQL commands. You perform a weekly full backup on Sunday, daily differential backups at 01:00, and transaction log backups every five minutes.
The database fails on Wednesday at 10:00.
Which three backups should you restore in sequence? To answer, move the appropriate backups from the list of backups to the answer area and arrange them in the correct order.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *