You have an Azure SQL database named sqldb1.
You need to minimize the possibility of Query Store transitioning to a read-only state.
What should you do?

• A.Double the value of Data Flush interval
• B.Decrease by half the value of Data Flush Interval
• C.Double the value of Statistics Collection Interval
• D.Decrease by half the value of Statistics Collection interval

Comment: *

Name: *

Email: *

Verification: *

HOTSPOT
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.
Hot Area:

Correct Answer:

Explanation:
Azure Database Migration service
Box 1: Premium 4-VCore
Scenario: Migrate the SERVER1 databases to the Azure SQL Database platform.
* Minimize downtime during the migration of the SERVER1 databases.
Premimum 4-vCore is for large or business critical workloads. It supports online migrations, offline migrations, and faster migration speeds.
Incorrect Answers:
The Standard pricing tier suits most small- to medium- business workloads, but it supports offline migration only.
Box 2: A VPN gateway
You need to create a Microsoft Azure Virtual Network for the Azure Database Migration Service by using the Azure Resource Manager deployment model, which provides site-to-site connectivity to your on-premises source servers by using either ExpressRoute or VPN.
Reference:
https://azure.microsoft.com/pricing/details/database-migration/
https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-online Plan and Implement Data Platform Resources Question Set 2

Comment: *

Name: *

Email: *

Verification: *

You need to implement authentication for ResearchDB1. The solution must meet the security and compliance requirements.
What should you run as part of the implementation?

• A.CREATE LOGIN and the FROM WINDOWS clause
• B.CREATE USER and the FROM CERTIFICATE clause
• C.CREATE USER and the FROM LOGIN clause
• D.CREATE USER and the ASYMMETRIC KEY clause
• E.CREATE USER and the FROM EXTERNAL PROVIDER clause

Comment: *

Name: *

Email: *

Verification: *

You have an Always On availability group deployed to Azure virtual machines. The availability group contains a database named DB1 and has two nodes named SQL1 and SQL2. SQL1 is the primary replica.
You need to initiate a full backup of DB1 on SQL2.
Which statement should you run?
BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/

• A.mycontainer/DB1.bak' with (Differential, STATS=5, COMPRESSION);
  BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/
• B.mycontainer/DB1.bak' with (COPY_ONLY, STATS=5, COMPRESSION);
  BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/
• C.mycontainer/DB1.bak' with (File_Snapshot, STATS=5, COMPRESSION);
  BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/
• D.mycontainer/DB1.bak' with (NoInit, STATS=5, COMPRESSION);

Comment: *

Name: *

Email: *

Verification: *

You need to configure user authentication for the SERVER1 databases. The solution must meet the security and compliance 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.

Correct Answer:

1 - Create an Azure Active Directory administrator for the logical server
2 - Create contained database users
3 - Connect to your database by using Azure AD account
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview

Comment: *

Name: *

Email: *

Verification: *