Administering Relational Databases on Microsoft Azure Free Practice Exam Questions

44 real Administering Relational Databases on Microsoft Azure exam questions with answers and AI explanations. Microsoft certification prep — page 4 of 5.

  1. Question 43: 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…
  2. Question 44: You have an on-premises datacenter that contains a 14-TB Microsoft SQL Server database. You plan to create an Azure SQL managed instance and migrate the on-pre…
  3. Question 45: You have an Azure SQL managed instance named SQLMI1 that has the following settings: • vCores: 4 • Service tier: General Purpose • Hardware generation: Standar…
  4. Question 47: You are modifying an existing disaster recovery solution for an Azure SQL managed instance that contains a failover group named FG1. You need to ensure the max…
  5. Question 48: You have five instances of SQL Server on Azure Virtual Machines. You need to monitor Microsoft SQL Server performance for all the instances by consolidating me…
  6. Question 50: You manage 100 Azure SQL managed instances located across 10 Azure regions. You need to receive voice message notifications when a maintenance event affects an…
  7. Question 59: You have an on-premises Microsoft SQL Server 2022 instance that hosts a 60-TB production database named DB1. You plan to migrate DB1 to Azure. You need to reco…
  8. Question 60: You have an Azure subscription that contains an Azure SQL database named DB1. You need to host elastic jobs by using DB1. DB1 will also be configured as a job…
  9. Question 61: You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVM1. SQLVM1 has the following configurations: • Automated…
  10. Question 62: You have an Azure subscription. You plan to provision a single Azure SQL database. You need to ensure that the database supports the autoscaling of compute res…