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 plan to move two 100-GB databases to Azure.
You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations.
What should you use?

• A.An Azure SQL Database elastic pool
• B.SQL Server on Azure virtual machines
• C.an Azure SQL Database managed instance
• D.Azure SQL databases

Comment: *

Name: *

Email: *

Verification: *

You deploy a database to an Azure SQL Database managed instance.
D18912E1457D5D1DDCBD40AB3BF70D5D
You need to prevent read queries from blocking queries that are trying to write to the database.
Which database option should set?

• A.PARAMETERIZATION to FORCED
• B.PARAMETERIZATION to SIMPLE
• C.Delayed Durability to Forced
• D.READ_COMMITTED_SNAPSHOT to ON

Comment: *

Name: *

Email: *

Verification: *

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.

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.
Reference:
https://azure.microsoft.com/pricing/details/database-migration/
https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-online

Comment: *

Name: *

Email: *

Verification: *

You plan to migrate on-premises Microsoft SQL Server databases to Azure.
You need to identify which deployment and resiliency options meet the following requirements:
Support user-initiated backups.
Support multiple automatically replicated instances across Azure regions.
Minimize administrative effort to implement and maintain business continuity.
What should you identify? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation
Box 1: SQL Server on Azure VMs
SQL Server on Azure Virtual Machines can take advantage of Automated Backup, which regularly creates backups of your database to blob storage. You can also manually use this technique.
Box 2: Active geo-replication
Geo-replication for services such as Azure SQL Database and Cosmos DB will create secondary replicas of your data across multiple regions. While both services will automatically replicate data within the same region, geo-replication protects you against a regional outage by enabling you to fail over to a secondary region.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-on-azure-vm-iaas-what-is
https://docs.microsoft.com/en-us/dotnet/architecture/cloud-native/infrastructure-resiliency-azure

Comment: *

Name: *

Email: *

Verification: *