Microsoft DP-900 Microsoft Azure Data Fundamentals Online Training
Microsoft DP-900 Online Training
The questions for DP-900 were last updated at Jul 05,2025.
- Exam Code: DP-900
- Exam Name: Microsoft Azure Data Fundamentals
- Certification Provider: Microsoft
- Latest update: Jul 05,2025
HOTSPOT
You have the following JSON document.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document. NOTE: Each correct selection is worth one point.
HOTSPOT
You are reviewing the data model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point
You need to query a table named Products in an Azure SQL database.
Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. (Choose three.)
- A . You must be assigned the Reader role for the resource group that contains the database.
- B . You must have SELECT access to the Products table.
- C . You must have a user in the database.
- D . You must be assigned the Contributor role for the resource group that contains the database.
- E . Your IP address must be allowed to connect to the database.
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?
- A . INSERT
- B . MERGE
- C . UPDATE
- D . CREATE
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.
Which Azure service should you use?
- A . Azure HDInsight
- B . Azure SQL Database
- C . Azure Cosmos DB
- D . SQL Server on Azure virtual machines