DP-900 Sample Questions & Answers
Analytics workloads and visualizing them in Power BI tie with core data concepts for the top weight, alongside relational concepts and Azure's relational services, and working with non-relational data like Cosmos DB.
Launch the full DP-900 simulator →Free DP-900 Sample Questions with Answers
Real questions from the Azure Data Fundamentals practice test — answers and explanations included. Showing 10 of 20 free samples.
- Question 1Beginner
Describe core data concepts · Identify roles and responsibilities for data workloads
A data professional is responsible for designing, building, and maintaining data pipelines that move data from various sources into a central data warehouse. This role involves data cleaning, transformation, and ensuring data quality. Which data professional role best describes these responsibilities?
Show answer & explanation
Correct answer: C
The responsibilities described—building and maintaining data pipelines, performing ETL/ELT operations, and ensuring data quality—are core functions of a Data Engineer. Data Engineers focus on the infrastructure and processes for moving and transforming data to make it available for analysis.
- Question 2Intermediate
Describe considerations for working with non-relational data on Azure · Describe Azure File storage
A company has several on-premises file servers hosting departmental data. They plan to migrate this data to Azure to provide a centralized, cloud-based file share that can be mounted by both Windows and Linux virtual machines using the standard SMB 3.0 protocol. Which Azure Storage service is designed for this 'lift and shift' file server scenario?
Show answer & explanation
Correct answer: D
Azure Files is the service specifically designed to provide fully managed cloud file shares accessible via the industry-standard Server Message Block (SMB) and Network File System (NFS) protocols. This makes it ideal for migrating existing applications and workloads that rely on on-premises file servers, as it allows mounting the share just like a local network drive.
- Question 3IntermediateSelect 2
Identify considerations for relational data on Azure · Identify common structured query language (SQL) statements
An administrator needs to grant a new user the ability to read data from all tables in a specific database but NOT the ability to modify any data. Which TWO types of SQL statements should the administrator use? (Select TWO)
Show answer & explanation
Correct answers: A, C
The
GRANTstatement is part of Data Control Language (DCL) and is used to give specific permissions, such as SELECT (read), to a user or role.The
SELECTstatement is part of Data Manipulation Language (DML) and is the permission that allows a user to read or query data from a table. The administrator would useGRANT SELECTto achieve the goal. - Question 4Beginner
Describe an analytics workload on Azure · Describe considerations for data ingestion and processing
A data architect is comparing Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) processes for a new analytics solution. In which process is the data transformation performed by the target data store, such as a modern data warehouse?
Show answer & explanation
Correct answer: B
In an ELT (Extract, Load, Transform) process, raw data is first extracted from the source and loaded directly into the target data store (like Azure Synapse Analytics). The powerful processing capabilities of the target system are then used to perform the transformations in place. This contrasts with ETL, where transformation happens in a separate staging area before the data is loaded into the target.
flowchart TD subgraph ETL [ETL Process] A[Source] --> B(Extract) B --> C{Transform in Staging} C --> D[Load] D --> E((Data Warehouse)) end subgraph ELT [ELT Process] F[Source] --> G(Extract) G --> H[Load] H --> I((Data Warehouse)) I --> J{Transform in Warehouse} end - Question 5Advanced
Identify considerations for relational data on Azure · Describe the Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines
A company wants to migrate its on-premises SQL Server databases to Azure. They require an Azure service that provides the highest level of compatibility with their existing SQL Server applications, including support for SQL Server Agent and cross-database queries, while still being a fully managed Platform as a Service (PaaS) offering. Which Azure SQL service should they choose?
Show answer & explanation
Correct answer: C
Azure SQL Managed Instance is specifically designed for this scenario. It is a fully managed PaaS offering that provides near-100% compatibility with the latest on-premises SQL Server Enterprise Edition database engine. It supports instance-level features like SQL Server Agent, Service Broker, and cross-database queries, making it the ideal choice for migrating existing SQL Server applications with minimal changes.
- Question 6Advanced
Describe an analytics workload on Azure · Describe common elements of large-scale analytics
Case Study:
Company Background:
Contoso Pharmaceuticals is a global research company that conducts large-scale clinical trials. Each trial generates massive amounts of data from various sources, including IoT sensors monitoring patient vitals, structured case report forms (CRFs) from clinics, and unstructured notes from researchers. The data volume can reach several terabytes per day during active trials.Current Situation:
The company's on-premises infrastructure is struggling to keep up with the data ingestion and processing demands. Analysts report that it takes days to prepare data for analysis, significantly delaying insights. They need a cloud solution that can handle both real-time data streams from sensors and large batches of files uploaded daily from clinics.Requirements:
- The solution must support both streaming and batch data ingestion.
- A centralized repository is needed to store all raw data, regardless of structure, for long-term archival and future analysis.
- A powerful analytics platform is required to process and transform the raw data into a structured format suitable for querying and reporting by data scientists and analysts.
- The solution must be scalable and cost-effective.
Which Azure architecture best meets Contoso's requirements?
Show answer & explanation
Correct answer: C
This architecture correctly addresses all requirements. Azure Event Hubs is designed for high-throughput streaming data ingestion (IoT sensors). Azure Data Factory is ideal for orchestrating batch data movement (CRF files). Azure Data Lake Storage Gen2 serves as the scalable, cost-effective centralized repository for raw data of all types. Azure Databricks or Synapse Analytics provide the powerful, massively parallel processing engines needed for large-scale data transformation.
- Question 7Beginner
Describe an analytics workload on Azure · Identify appropriate visualizations for data
A data analyst needs to create a visualization in Power BI to show the relationship between two numerical variables: product price and units sold. The goal is to identify patterns, trends, and outliers in the data. Which type of visualization is most suitable for this purpose?
Show answer & explanation
Correct answer: B
A scatter chart is the ideal visualization for showing the relationship between two numerical values. It plots data points on a horizontal (X) and a vertical (Y) axis, making it easy to see correlations, clusters, and outliers between variables like price and units sold.
- Question 8Intermediate
Identify considerations for relational data on Azure · Identify common database objects
The primary purpose of a clustered index in a relational database table is to ______.
Show answer & explanation
Correct answer: C
A clustered index determines the physical order of data in a table. Because the data rows themselves can only be sorted in one way, there can be only one clustered index per table. This is different from a non-clustered index, which has a structure separate from the data rows.
- Question 9Beginner
Describe an analytics workload on Azure · Describe the difference between batch and streaming data
Which type of data processing deals with data as it is generated, typically with very low latency requirements?
Show answer & explanation
Correct answer: B
Stream processing, also known as real-time processing, is designed to ingest, analyze, and act on data as it is created. It is used in scenarios like fraud detection, IoT sensor monitoring, and live analytics where immediate insights are critical. This contrasts with batch processing, which collects and processes data in large chunks over a period of time.
- Question 10Intermediate
Describe an analytics workload on Azure · Describe Microsoft cloud services for large-scale analytics, including Azure Databricks and Microsoft Fabric
Microsoft Fabric is a unified analytics platform that combines multiple data services into a single, integrated environment. Which of the following is the foundational, tenant-wide data lake solution within Microsoft Fabric that is based on an open architecture?
Show answer & explanation
Correct answer: C
OneLake is the central, unified data lake for the entire Microsoft Fabric tenant. It is often described as the 'OneDrive for data' because it provides a single, logical data lake for the whole organization without requiring any upfront provisioning. It is built on top of Azure Data Lake Storage Gen2 but provides an enhanced, integrated experience across all Fabric workloads like Data Engineering, Data Science, and Power BI.
Ready for the real thing?
The full DP-900 simulator has every exam-style question, timed mode, and instant scoring.