Microsoft DP-900 Practice Exams
Last updated on Apr 03,2025- Exam Code: DP-900
- Exam Name: Microsoft Azure Data Fundamentals
- Certification Provider: Microsoft
- Latest update: Apr 03,2025
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
DRAG DROP
Match the types of data to the appropriate Azure data services.
To answer, drag the appropriate data types from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
Your company is designing a data store tor internet-connected temperature sensors. The collected data will be used to analyze temperature trends.
Which type of data store should you use?
- A . relational
- B . columnar
- C . graph
- D . time series
A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense.
What should the developers use?
- A . Azure Data Studio
- B . sq1cmd
- C . Microsoft SQL Server Management Studio (SSMS)
- D . Azure Data Explorer
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.
When you create an Azure SQL database, which account can always connect to the database?
- A . the Azure Active director/ (Azure AO) account that created the database
- B . the Azure Active Directly Azure AD) administrator account
- C . the sa account
- D . the server admin login account of the logical server
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.
You have an Azure Cosmos DB account that uses the Core (SQL) API.
Which two settings can you configure at the container level? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. (Choose two.)
- A . the throughput
- B . the read region
- C . the partition key
- D . the API