DP-900 domain - 30% of the exam

Describe Core Data Concepts

Describe Core Data Concepts is 30% of the DP-900 exam. These are the objectives it covers, each with practice questions, with every answer explained.

The domain in numbers

77
Practice questions
4
Objectives
27
Easy
50
Medium

Where people go wrong

  • Giving pipeline work to the wrong role

    The wrong answers hand ingestion, cleansing and transformation pipelines to the database administrator, the data analyst or the AI engineer because each works near data. The database administrator secures and maintains the database, the analyst explores data for insights, and the AI engineer builds features on large language models and machine learning pipelines. The data engineer designs the ingestion and transformation workloads, applies data cleaning routines, and owns the management and monitoring of pipelines so that loads perform as expected.

    See it in a sample question
  • Giving security, backup and tuning to the wrong role

    The wrong answers give access control, backups and runtime tuning to the data engineer, the data analyst or the AI engineer. Engineers build pipelines and analysts consume data, so neither grants or denies user access. The database administrator manages security by granting privileges and denying access, stores backup copies, restores data after a failure or disaster, and owns the overall availability and consistent performance of the database systems.

    See it in a sample question
  • Swapping one ACID property for another

    Every ACID option is a real property, so the wrong answers pick a neighbour. Consistency, isolation and durability are offered where all-or-nothing completion is asked. Atomicity treats a transaction as one unit that succeeds completely or fails completely, such as a debit and a credit that both apply or neither does. Isolation stops concurrent transactions interfering, durability keeps a committed result after a restart, and consistency moves data from one valid state to another.

    See it in a sample question
  • Reading analytical work as transactional

    The wrong answers swap the two workload types on the strength of the data source or the daily volume. A warehouse fed from a transactional source is still analytical, since it holds historical snapshots in a relational schema optimised for reading and reporting. Live transfers or payment events, recorded as small discrete units of work with create, retrieve, update and delete operations, are OLTP. High volume does not make a workload analytical, because analytical systems are read-only or read-mostly over historical data.

    See it in a sample question
  • Mixing up the Parquet and Avro layouts

    The wrong answers swap the layouts of the two optimised binary formats. Parquet is columnar: a file holds row groups in which the data for each column is stored together, and its metadata helps locate the right chunk of rows. Avro is row-based, storing records as binary blocks behind a JSON header that an application uses to parse the data and extract its fields. Neither is human-readable text such as CSV or XML.

    See it in a sample question

Objectives in this domain

Sample questions from this domain

Free sampleDescribe Core Data Conceptseasy

Which data role is responsible for building and managing the pipelines that ingest, cleanse, and transform data as it moves between systems?

  • ADatabase administrator, who maintains availability and grants access to a database
  • BData analyst, who builds analytical models and reports to identify business trends
  • CData engineer, who designs ingestion, cleansing, and transformation data workloads Correct
  • DAI engineer, who builds intelligent features using large language models and data
The data engineer builds and monitors the pipelines that ingest, cleanse, and transform data across systems. Data engineers design and implement data-related workloads including ingestion pipelines, cleansing and transformation activities, and they own the management and monitoring of those pipelines.

Why A is wrong: Tempting because both work close to data stores, but the DBA secures and maintains the database rather than building ingestion and transformation pipelines across systems.

Why B is wrong: Tempting since analysts consume processed data, but they explore data for insights rather than constructing the ingestion and transformation pipelines.

Why C is correct: Correct. Data engineers design and implement data-related workloads including ingestion pipelines, cleansing and transformation activities, and they own the management and monitoring of those pipelines.

Why D is wrong: Tempting as a technical role working with data, but AI engineers enable intelligent scenarios rather than owning the cleansing and transformation pipelines.

Free sampleDescribe Core Data Conceptseasy

An organisation needs someone to grant or deny access to data, store backup copies, and restore data after a failure. Which data role owns these responsibilities?

  • AData engineer, who builds pipelines to move and transform data between systems
  • BDatabase administrator, who manages permissions, backups, and recovery of data Correct
  • CData analyst, who explores data to produce charts and visualisations for decisions
  • DAI engineer, who integrates AI-powered features into applications and workflows
The DBA secures the database, controls who can access data, and owns backup and recovery. The database administrator is responsible for managing database security, granting or denying access to users, storing backup copies, and restoring data in the event of a failure.

Why A is wrong: Tempting because engineers handle the data platform, but pipeline construction and transformation are their focus, not assigning permissions, taking backups, or restoring after failure.

Why B is correct: Correct. The database administrator is responsible for managing database security, granting or denying access to users, storing backup copies, and restoring data in the event of a failure.

Why C is wrong: Tempting as a common data role, but analysts surface insights through reports and visualisations and do not manage user access or backup and recovery.

Why D is wrong: Tempting as a modern data role, but AI engineers build intelligent features with models and pipelines rather than granting access or restoring backups.

Free sampleDescribe Core Data Conceptseasy

In an OLTP system that enforces ACID semantics, which property guarantees that a transaction either succeeds completely or fails completely as a single unit?

  • AConsistency, which moves the data from one valid state to another after the work completes
  • BIsolation, which stops concurrent transactions from interfering with one another
  • CAtomicity, which treats the transaction as one indivisible unit of work Correct
  • DDurability, which keeps a committed transaction persisted even after a restart
Atomicity makes a transaction all-or-nothing: it commits as one unit or it fails entirely. Atomicity treats each transaction as a single unit that succeeds completely or fails completely, so a debit and its matching credit either both apply or neither does.

Why A is wrong: Tempting because consistency is also part of ACID, but it governs valid state transitions, not the all-or-nothing completion of the unit of work.

Why B is wrong: Isolation is a genuine ACID property, but it concerns concurrency between transactions rather than whether one transaction completes wholly or not at all.

Why C is correct: Correct. Atomicity treats each transaction as a single unit that succeeds completely or fails completely, so a debit and its matching credit either both apply or neither does.

Why D is wrong: Durability is a real ACID property, but it ensures committed results survive a shutdown rather than guaranteeing all-or-nothing completion.

Free sampleDescribe Core Data Conceptseasy

A retail banking application records each transfer of money between customer accounts the moment it happens, handling millions of small create, retrieve, update, and delete operations every day. Which type of data workload does this application represent?

  • AAn analytical workload, because it processes a high daily volume of customer records and business metrics
  • BA transactional workload, because it records discrete events as they occur with read and write operations Correct
  • CA reporting workload, because it summarises account activity into dashboards for business users
  • DA data-lake workload, because it collects a large volume of file-based account data for later analysis
Recording live, discrete events through high-volume create, retrieve, update and delete operations is a transactional (OLTP) workload. A transactional system records transactions - small, discrete units of work such as a money transfer - as they happen, using a database optimised for both read and write (CRUD) operations, which is the defining characteristic of OLTP.

Why A is wrong: High volume is tempting, but analytical workloads are read-only or read-mostly over historical snapshots; they do not record live debits and credits as they occur.

Why B is correct: Correct. A transactional system records transactions - small, discrete units of work such as a money transfer - as they happen, using a database optimised for both read and write (CRUD) operations, which is the defining characteristic of OLTP.

Why C is wrong: Reporting and dashboards belong to the analytical side; this system is creating and updating individual account records, not summarising them for consumption.

Why D is wrong: Data lakes store file-based data for large-scale analysis; this scenario performs live CRUD on account records, which is the transactional pattern.

Free sampleDescribe Core Data Conceptsmedium

Why is Parquet described as a columnar data format?

  • AData for each column is stored together within a row group Correct
  • BEach complete record is stored together as one row of binary blocks
  • CEach value is wrapped in angle-bracket tags inside a document
  • DFields are written as comma-separated text with a header line
Parquet is columnar: within each row group the data for a column is stored together. The grounding states a Parquet file contains row groups in which the data for each column is stored together, which is what makes it a columnar format.

Why A is correct: Correct. The grounding states a Parquet file contains row groups in which the data for each column is stored together, which is what makes it a columnar format.

Why B is wrong: Storing each whole record together in blocks is the row-based approach used by Avro, the opposite of Parquet's columnar layout.

Why C is wrong: Angle-bracket tags are XML markup, not how Parquet organises columns into row groups.

Why D is wrong: Comma-separated text with a header line is CSV, a human-readable format that is not optimised or columnar like Parquet.

Other domains in this exam

See also the DP-900 cert hub, the study guide, and the cheat sheet.

Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.