Data Engineering, DP-900, Microsoft Certification

Practice Questions: Describe responsibilities for data engineers (DP-900 Exam Prep)

Practice Questions

Question 1

Which task is a primary responsibility of a data engineer?

A. Creating dashboards for business users
B. Managing database user permissions
C. Building and maintaining data pipelines
D. Training machine learning models

✅ Answer: C

Explanation:
Data engineers are responsible for designing and maintaining data pipelines that move and transform data.

Question 2

A company needs to collect data from multiple systems and prepare it for reporting.

Which role is primarily responsible for this task?

A. Data Analyst
B. Database Administrator
C. Data Engineer
D. Business User

✅ Answer: C

Explanation:
Data engineers handle data ingestion, integration, and preparation for downstream analytics.

Question 3

Which process involves extracting data from sources, transforming it, and loading it into a destination system?

A. OLTP
B. ETL
C. OLAP
D. ACID

✅ Answer: B

Explanation:
ETL (Extract, Transform, Load) is a core responsibility of data engineers.

Question 4

Which Azure service is commonly used by data engineers to orchestrate data pipelines?

A. Azure SQL Database
B. Azure Data Factory
C. Azure Blob Storage
D. Azure Virtual Machines

✅ Answer: B

Explanation:
Azure Data Factory is used to build, schedule, and manage data pipelines.

Question 5

Which responsibility ensures that data used for analytics is accurate and reliable?

A. Query optimization
B. Data visualization
C. Data quality management
D. User authentication

✅ Answer: C

Explanation:
Data engineers ensure data quality through validation and cleaning processes.

Question 6

A data engineer is working with large-scale data processing using Apache Spark.

Which Azure service are they MOST likely using?

A. Azure SQL Database
B. Azure Cosmos DB
C. Azure Databricks
D. Azure Table Storage

✅ Answer: C

Explanation:
Azure Databricks is a Spark-based platform used for large-scale data processing.

Question 7

Which storage solution is commonly used by data engineers for storing large volumes of raw and processed data?

A. Azure Data Lake Storage
B. Azure Queue Storage
C. Azure SQL Database
D. Azure Cache for Redis

✅ Answer: A

Explanation:
Azure Data Lake Storage is optimized for big data storage and analytics workloads.

Question 8

Which task is LEAST likely to be performed by a data engineer?

A. Transforming raw data into structured formats
B. Monitoring data pipelines
C. Creating Power BI dashboards
D. Integrating multiple data sources

✅ Answer: C

Explanation:
Creating dashboards is typically the responsibility of a data analyst, not a data engineer.

Question 9

Which type of data processing involves handling real-time data streams?

A. Batch processing
B. Streaming processing
C. Relational processing
D. Transactional processing

✅ Answer: B

Explanation:
Data engineers often work with streaming pipelines for real-time data ingestion.

Question 10

A data engineer selects Parquet as a storage format for a dataset.

What is the primary reason for this choice?

A. It is human readable
B. It supports transactional updates
C. It is optimized for analytical performance
D. It enforces a strict schema

✅ Answer: C

Explanation:
Parquet is a columnar format that improves performance for analytical workloads.

✅ Quick Exam Takeaways

For DP-900, remember data engineers:

✔ Build and manage data pipelines
✔ Handle ETL/ELT processes
✔ Work with batch and streaming data
✔ Ensure data quality and reliability
✔ Manage data storage solutions (Data Lake, Blob)
✔ Use Azure services like:

  • Azure Data Factory
  • Azure Databricks
  • Azure Data Lake Storage
  • Azure Synapse Analytics

✔ Enable analytics and BI by preparing data

Go to the DP-900 Exam Prep Hub main page.

Leave a comment