DP-900 - Describe Core Data Concepts (30% of the exam) - Section 1.4
Identify roles and responsibilities for data workloads including data engineers, analysts, and scientists.
Define the responsibilities of a data engineer, data analyst, data scientist, database administrator, and data steward in a modern data team. Identify which role is accountable for pipeline construction, insight delivery, model building, operational database health, or governance respectively.
data engineerdata analystdata scientistdatabase administratordata steward
Practice question for this objective
lock_openFree sampleDescribe Core Data Conceptsmedium
The data engineer is the role responsible for ensuring that the privacy of data is maintained from on-premises systems to the cloud data stores. Is this statement correct?
AYescheck_circle Correct
BNo
Data engineers own data privacy and governance rules spanning on-premises to cloud data stores. The grounding states the data engineer is responsible for ensuring that the privacy of data is maintained within the cloud and spanning from on-premises to the cloud data stores.
Why A is correct: Correct. The grounding states the data engineer is responsible for ensuring that the privacy of data is maintained within the cloud and spanning from on-premises to the cloud data stores.
Why B is wrong: Answering No would wrongly assign this to the database administrator, but the grounding ties database-level security and access control to the administrator, while data privacy spanning on-premises and cloud data stores belongs to the data engineer.
Answers that look right on this material and are not. Each one is a distractor from a different question in the DP-900 bank for this domain.
Yes
Why it is wrong: Answering Yes is incorrect because ingestion pipelines are owned by the data engineer, while the analyst works with the resulting data for insights.
Yes
Why it is wrong: It is the AI engineer, not the data engineer, who builds and integrates AI-powered features using large language models and machine learning pipelines; data engineers build data integration pipelines and manage data stores.
Granting or denying user access to a database
Why it is wrong: Granting privileges and granting or denying access to users is a database administrator responsibility, not the engineer's.
Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.
