DP-900 Data Workloads and Roles Practice Questions
This topic tests whether you can tell transactional (OLTP) workloads from analytical (OLAP) workloads, and which characteristics belong to each. Transactional questions often come down to the ACID properties: atomicity, consistency, isolation and durability. Batch processing and how operational data flows into an analytical store also come up here.
The other half is people: what a database administrator, a data engineer and a data analyst are responsible for, plus basic data governance roles such as data owner and data steward.
Below are 7 free questions on this topic. Try each one before you open the answer.
Question 1
Which data professional is primarily responsible for building machine learning models to predict future outcomes from historical data?
A.Data analyst
B.Data engineer
C.Data scientist
D.Database administrator
chevron_rightShow answer and explanation
Correct answer: C. Data scientist
Data scientists use statistical analysis and machine learning to build predictive models from historical data. Data analysts focus on querying and visualizing data for business insights. Data engineers build the pipelines and infrastructure to move and transform data. Database administrators manage database health, performance, and security.
Question 2
Within a data governance framework, who is typically responsible for defining business rules for a specific data domain and ensuring that data meets quality standards within that domain?
A.Cloud administrator
B.Data engineer
C.Data steward
D.Network architect
chevron_rightShow answer and explanation
Correct answer: C. Data steward
A data steward is a governance role responsible for managing data quality, defining business rules, and ensuring compliance with data policies within a specific domain (such as customer data or financial data). Data engineers build the technical infrastructure and pipelines. Cloud administrators manage infrastructure and access. Network architects design network topology — none of these are governance-focused roles.
Question 3
Which data professional is primarily responsible for designing and maintaining the infrastructure that enables data to flow from source systems to analytical environments?
A.Data analyst
B.Data engineer
C.Data scientist
D.Database administrator
chevron_rightShow answer and explanation
Correct answer: B. Data engineer
Data engineers design, build, and maintain data pipelines, integration workflows, and the storage infrastructure (such as data lakes and data warehouses) that enable data to move from source systems to analytical platforms. Data analysts consume that data to produce reports and insights. Data scientists build predictive models. Database administrators maintain the health and security of database systems — not pipeline architecture.
Question 4
Which workload type is best described as: read-heavy queries that aggregate millions of rows across multiple years to produce business intelligence reports?
A.OLTP
B.OLAP
C.Streaming
D.Transactional
chevron_rightShow answer and explanation
Correct answer: B. OLAP
OLAP (Online Analytical Processing) is designed for complex, read-heavy analytical queries that aggregate large volumes of historical data — such as "total sales per region per quarter for the last five years." OLTP handles high-volume, low-latency transactional operations (inserts, updates, deletes). Streaming processes data in real time. Transactional and OLTP refer to the same concept of high-frequency write-oriented workloads.
Question 5
What is the difference between a data owner and a data steward in a data governance framework?
A.A data owner builds data pipelines; a data steward creates visualizations
B.A data owner has business accountability for a data asset and its appropriate use; a data steward manages the day-to-day quality, rules, and compliance of that data
C.A data owner is a technical database administrator; a data steward is a business analyst
D.A data owner and data steward are different terms for the same role
chevron_rightShow answer and explanation
Correct answer: B. A data owner has business accountability for a data asset and its appropriate use; a data steward manages the day-to-day quality, rules, and compliance of that data
In data governance, the data owner is typically a senior business stakeholder who is accountable for the data asset and decides how it should be used. The data steward is responsible for the operational governance — enforcing data quality rules, maintaining business glossary definitions, and ensuring compliance with policies. These are complementary roles: the owner sets the direction, and the steward executes it.
Question 6
Determine whether each statement about OLTP systems is correct.
1.OLTP systems are optimized for both read and write operations to support CRUD transactions.
2.The Isolation property of ACID guarantees that a committed transaction will remain committed even if the database is restarted.
3.Atomicity means that a transaction is treated as a single unit that either succeeds completely or fails completely.
chevron_rightShow answer and explanation
Statement 1: Yes
Statement 2: No
Statement 3: Yes
Statement 1 is correct: OLTP databases are optimized for both read and write operations to support high-volume transactional workloads. Statement 2 is incorrect: Durability — not Isolation — guarantees that committed transactions persist even after a system restart. Isolation ensures concurrent transactions do not interfere with each other. Statement 3 is correct: Atomicity defines that all operations in a transaction must succeed or all must be rolled back.
Question 7
The ___ property of ACID transactions ensures that concurrent transactions cannot interfere with one another and must result in a consistent database state.
A.Atomicity
B.Consistency
C.Isolation
D.Durability
chevron_rightShow answer and explanation
Correct answer: C. Isolation
Isolation ensures concurrent transactions do not interfere with each other. Atomicity ensures a transaction fully succeeds or fully fails. Consistency ensures the database moves from one valid state to another. Durability ensures committed transactions persist even after a system failure.
These are 7 of 34 Data Workloads and Roles questions in the full bank
Practice all 400 DP-900 questions in exam format, including drag-and-drop and multi-select questions, with a mock exam and progress tracking.