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

  1. Question 1: 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?
  2. Question 2: Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the…
  3. Question 4: Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the…
  4. Question 5: You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs on SQLMI1. You need to ensure that an automatic email notif…
  5. Question 6: You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2019 database named DB1. You plan to deploy additional instances…
  6. Question 7: You have several Azure SQL databases on the same Azure SQL Database server in a resource group named ResourceGroup1. You must be alerted when CPU usage exceeds…
  7. Question 8: Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the…
  8. Question 9: You have an Azure SQL database named DB1. You run a query while connected to DB1. You review the actual execution plan for the query, and you add an index to a…
  9. Question 10: 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 dur…
  10. Question 11: You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email. You need to prevent nonadministrative u…