Last updated on July 13th, 2024 at 11:58 pm
Microsoft DP900 Exam Dumps post contains real and latest questions for Microsoft Azure Fundamentals.
Microsoft DP900 Exam Dumps – QAs 56-60
Table of Contents
Q56. 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?
- INSERT
- MERGE
- UPDATE
- CREATE
Correct Answer
3. UPDATE
Q57. Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.
Which Azure service should you use?
- Azure HDInsight
- Azure SQL Database
- Azure Cosmos DB
- SQL Server on Azure Virtual Machines
Correct Answer
2. Azure SQL Database
Reference:
https://azure.microsoft.com/en-us/services/sql-database/#features
Q58. HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:
Q59. DRAG DROP –
Match the tools to the appropriate descriptions.
To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all.
Select and Place:
Correct Answer
Reference:
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt
Q60. HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
