| Exam Code | DP-900 |
| Exam Name | Microsoft Azure Data Fundamentals |
| Questions | 319 Questions Answers With Explanation |
| Update Date | July 16,2026 |
| Price |
Was : |
Welcome to Certsleader, your ultimate source for top-quality DP-900 dumps tailored for Microsoft DP-900 exam. Our comprehensive resources are designed to help you excel in your exam preparations and achieve your certification goals. Whether you are a beginner looking to start a career in Microsoft or an experienced professional seeking to advance your skills, Certsleader has the right tools to support your journey.
At Certsleader, we are committed to your success. Our practice questions answers are designed to improve your knowledge and help you pass your exams on the first attempt with high scores. In the rare event that you do not succeed, we offer a full refund, taking responsibility for your satisfaction.
Join thousands of satisfied learners who have successfully passed their certification exams with Certsleader. Explore our study materials, download your PDF files, and take the first step towards a rewarding IT career today.
Which statement is an example of Data Manipulation Language (DML)?
A. REVOKE
B. DISABLE
C. CREATE
D. UPDATE
Which three actions are used when performing diagnostic analytics?
A. • Identify data anomalies • Collect anomaly-related data • Discover relationships and trends that explain anomalies.
B. • Identify data anomalies • Predict when anomalies are likely to recur
• Use analytical tools such as decision trees and regression.
C. • Apply serf-learning loops to draw inferences from anomalies. • Predict when anomalies are likely to recur • Use analytical tools such as decision trees and regression.
D. • Identify data anomalies • Use machine learning to find patterns in large datasets. • Discover relationships and trends that explain anomalies.
You plan to deploy an app. The app requires a nonrelational data service that will provide latency guarantees of less than 10-ms for reads and writes. What should you include in the solution?
A. Azure Cosmos
B. Azure Table storage
C. Azure Files
D. Azure Blob storage
You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse. What should you use to query the files?
A. Azure Functions
B. Microsoft SQL Server Integration Services (SSIS)
C. PolyBase
D. Azure Data Factory
Which statement is an example of Data Definition Language (DDL)?
A. SELECT
B. JOIN
C. MERGE
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
Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart. Which type of data store will provide the lowest latency to retrieve the data?
A. key/value
B. graph
C. columnar
D. document
You need to design and model a database by using a graphical tool that supports project oriented offline database development. What should you use?
A. Microsoft SQL Server Data Tools (SSDT)
B. Microsoft SQL Server Management Studio (SSMS)
C. Azure Databricks
D. Azure Data Studio
Which Azure Data Factory component provides the compute environment for activities?
A. a linked service
B. an integration runtime
C. a control flow
D. a pipeline
What are two characteristics of real-time data processing? Each correct answer present a complete solution. NOTE: Each correct selection is worth one point.
A. Data is processed as it is created.
B. Low latency is expected
C. High latency acceptable
D. Data is processed periodically
You manage an application that stores data in a shared folder on a Windows server. You need to move the shared folder to Azure Storage. Which type of Azure Storage should you use?
A. queue
B. blob
C. file
D. table
Your company needs to ensure that in Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet. What should you use?
A. Azure DNS
B. Azure Application Gateway
C. Azure Private link
D. Azure Traffic Manager
Which setting can only be configured during the creation of an Azure Cosmos DB account?
A. geo-redundancy
B. multi-region writes
C. production or non-reduction account type
D. API
Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point.
A. Azure Time Series Insights
B. Azure HDInsight
C. Azure Databricks
D. Azure Log Analytics
Which Azure Data Factory component initiates the execution of a pipeline?
A. a control flow
B. a trigger
C. a parameter
D. an activity
What are two uses of data visualization? Each correct answer present a complete solution. NOTE: Each correct selection is worth one point.
A. Represent trends and patterns over time.
B. Communicate the significance of data.
C. implement machine learning to predict future values.
D. Consistently implement business logic across reports
You need to modify a view in a relational database by adding a new column. Which statement should you use?
A. MERGE
B. ALTER
C. INSERT
D. UPDATE
Which type of database contains nodes and edges?
A. graph
B. columnar
C. key/value
D. time series
Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution. (Choose three.) NOTE: Each correct selection is worth one point.
A. a report page
B. a Microsoft PowerPoint slide
C. a visualization from a report
D. a dataflow
E. a text box
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?
A. supports partitioning
B. provides resiliency if art Azure region fads
C. provides a higher storage capacity
D. supports a multi-master model
