nerdexam
Microsoft

DP-900 · Question #286

Drag and Drop Question Match the job roles to the appropriate tasks. To answer, drag the appropriate job role from the column on the left to its task on the right. Each role may be used once, more…

The correct answer is Data engineer: Create a pipeline to transfer data from a database to a data warehouse.; Database administrator: Create a transactional database.; Data analyst: Create a chart that shows sales transactions by week. A Data Engineer is responsible for building and maintaining data pipelines that move and transform data between systems (e.g., database to data warehouse). A Database Administrator (DBA) manages and creates transactional databases, handling tasks like setup, security, and…

Submitted by yuriko_h· Mar 30, 2026Core Data Concepts - Identify roles and responsibilities in the data profession (Microsoft DP-900 / Azure Data Fundamentals)

Question

Drag and Drop Question Match the job roles to the appropriate tasks. To answer, drag the appropriate job role from the column on the left to its task on the right. Each role may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Answer:

Exhibit

DP-900 question #286 exhibit

Answer Area

Drag items

Data analystData architectData engineerDatabase administrator

Correct arrangement

  • Data engineer: Create a pipeline to transfer data from a database to a data warehouse.
  • Database administrator: Create a transactional database.
  • Data analyst: Create a chart that shows sales transactions by week.

Explanation

A Data Engineer is responsible for building and maintaining data pipelines that move and transform data between systems (e.g., database to data warehouse). A Database Administrator (DBA) manages and creates transactional databases, handling tasks like setup, security, and maintenance of operational databases. A Data Analyst consumes prepared data to generate insights and visualizations, such as charts showing sales trends by week. The Data Architect role (designing overall data strategy and blueprints) was not needed for any of these specific tasks.

Topics

#Data Roles#Data Engineering#Database Administration#Data Analytics

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice