This question is part of a series of questions that present the same scenario. Each question in the series contains aunique solution that might meet the stated goals. Some question sets might have more than one correct solution, whileothers might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear inthe review screen.You have two Azure SQL Database servers named Server1 and Server2. Each server contains

You have an on-premises Microsoft SQL Server 2019 database named SQL1 that uses merge replication. You need to migrate SQL1 to Azure. Which service should you use?

You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1. You have an Azure subscription that contains an Azure SQL database named SQLDB1. You need to replicate DB1 to SQlDC1. Which type of replication should you use?

You need to recommend an availability strategy for an Azure SQL database. The strategy must meet the following requirements: Support failovers that do not require client applications to change their connection strings. Replicate the database to a secondary Azure region. Support failover to the secondary region. What should you include in the recommendation?

This question is part of a series of questions that present the same scenario. Each question in the series contains aunique solution that might meet the stated goals. Some question sets might have more than one correct solution, whileothers might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear inthe review screen.You have an Azure SQL database named Sales.You need to implement disaster recovery for S

You have an Azure SQL database named DB1. You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs. Which deployment option and pricing tier should you configure?

You have a new Azure subscription.You create an Azure SQL Database instance named DB1 on an Azure SQL Database server named Server1.You need to ensure that users can connect to DB1 in the event of an Azure regional outage. In the event of an outage,applications that connect to DB1 must be able to connect without having to update the connection strings.Which two actions should you perform? Each correct answer presents part of the solution. Each correct selection is worth one point.

You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1. You plan to migrate DB1 to an Azure SQL Database managed instance. What should you use to minimize downtime and data loss during the migration?

This question is part of a series of questions that present the same scenario. Each question in the series contains aunique solution that might meet the stated goals. Some question sets might have more than one correct solution, whileothers might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear inthe review screen.You have an Azure SQL database named Sales.You need to implement disaster recovery for S

You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2019 database namedDB1.You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate instance ofApp1 and DB1. The separate instances of DB1 will sync by using Azure SQL Data Sync.You need to recommend a database service for the deployment. The solution must minimize administrative effort.What should you include in the recommendation?

You have an Azure SQL database that contains a table named factSales. FactSales contains the columns shown in the following table. FactSales has 6 billion rows and is loaded nightly by using a batch process. Which type of compression provides the greatest space reduction for the database?

You Save an Azure SCX database named DB1. You need to query the fragmentation information of data and indexes for the tables in D61. Which command should you run? A. B. C. D.

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?

You have an Azure subscription that uses a domain named contoso.com.You have two Azure VMs named DBServer1 and DBServer2. Each of them hosts a default SQL Server instance. DBServer1

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?

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 duringscaling operations.What should you use?

You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases. Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution. Each correct selection is worth one point.

You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQLServer tier. All the tiers run on Hyper-V virtual machines.Your new disaster recovery plan requires that all business-critical applications can be recovered to Azure.You need to recommend a solution to fail over the database tier of App1 to Azure. The solution must provide the ability totest failover to Azure without affecting the current environment.What should you include in the reco

You have an Azure subscription. You create a logical SQL server that hosts four databases Each database will be used by a separate customer. You need to ensure that each customer can access only its own database. The solution must minimize administrative effort Which two actions should you perform? Each correct answer presents part of the solution Each correct selection is worth one point.

You have a single availability set that contains two SQL Server on Azure Virtual Machines instances. The instances were deployed by using an Azure Marketplace SQL Server 2019 Enterprise image that has the latest cumulative updates applied. The instances are configured as the nodes of a failover cluster instance (FCI) named FCI1. You need to ensure that client applications can connect to FCI1. The solution must meet the following requirements: * Provide an availability SLA * Minimize costs. What should y