DP-900 Practice Test

DP-900 Practice Test practice questions, page 13 of 13, with answer review and explanations.

Question 61

Select the answer that correctly completes the sentence.

Question 62

You have an inventory management database that contains the following table. Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

  1. INSERT
  2. MERGE
  3. UPDATE
  4. CREATE

Question 63

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?

  1. Azure HDInsight
  2. Azure SQL Database
  3. Azure Cosmos DB
  4. SQL Server on Azure Virtual Machines

Question 64

You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database. You need to embed documents and query results into a SQL notebook. What should you use?

  1. Microsoft SQL Server Management Studio (SSMS)
  2. Azure Data Studio
  3. Azure CLI
  4. Azure PowerShell