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 3 of 5.

  1. Question 29: You have an instance of SQL Server on Azure Virtual Machines named VM1. You plan to schedule a SQL Server Agent job that will rebuild indexes of the databases…
  2. Question 31: 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…
  3. Question 32: You have a SQL Server on Azure Virtual Machines instance named SQLVM1 that was deployed by using an Azure Marketplace SQL Server 2019 Enterprise image. You nee…
  4. Question 34: You have an Azure SQL database named DB1 that contains a nonclustered index named index1. End users report slow queries when they use index1. You need to ident…
  5. Question 35: You need to recommend a disaster recovery solution for an on-premises Microsoft SQL Server database. The solution must meet the following requirements: • Suppo…
  6. Question 36: You have an Azure subscription. You need to deploy an Azure SQL database. The solution must meet the following requirements: • Dynamically scale CPU resources.…
  7. Question 38: You have an Azure AD tenant and a logical Microsoft SQL server named SQL1 that hosts several Azure SQL databases. You plan to assign Azure AD users permissions…
  8. Question 39: You have an Azure subscription. You need to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an A…
  9. Question 40: 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 ensur…
  10. Question 41: You have an on-premises datacenter that contains a 2-TB Microsoft SQL Server 2019 database named DB1. You need to recommend a solution to migrate DB1 to an Azu…