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

  1. Question 14: You have an Azure virtual machine based on a custom image named VM1. VM1 hosts an instance of Microsoft SQL Server 2019 Standard. You need to automate the main…
  2. Question 15: You need to recommend a solution to ensure that the customers can create the database objects. The solution must meet the business goals. What should you inclu…
  3. Question 16: You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool named Pool1. You plan to create a database named DB1 in Pool1. You n…
  4. Question 17: 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…
  5. Question 18: You have an Azure Databricks workspace named workspace1 in the Standard pricing tier. Workspace1 contains an all-purpose cluster named cluster1. You need to re…
  6. Question 19: You have an on-premises Microsoft SQL Server 2019 server that hosts a database named DB1. You have an Azure subscription that contains an Azure SQL managed ins…
  7. Question 21: You have an Azure SQL Database managed instance. The instance starts experiencing performance issues. You need to identify which query is causing the issue and…
  8. Question 24: You have an Azure subscription that contains two instances of SQL Server on Azure Virtual Machines named VM1 and VM2. Both instances run Microsoft SQL Server 2…
  9. Question 25: You have an Azure SQL managed instance named MI1. You need to implement automatic tuning for the databases of MI1. What should you do?
  10. Question 26: You have an Azure subscription that contains an Azure SQL database named db1. You need to implement SQL insights for db1. Which two resources should you create…