DP-900 Describe core data concepts: 302 practice questions

12 of the 302 Describe core data concepts questions in the Certsqill DP-900 bank, shown in full below. Each one carries an explanation for every option, not just the correct one — the wrong answers are where the marks go.

Preparing for DP-900? Take the free 5-min readiness check →

1. Database administrator: Which role is most directly responsible for restoring the database?

1. Data analyst

   Data analysts interpret information and create reports, but recovery is outside their primary responsibility.
2. Business stakeholder

   Business stakeholders define needs and interpret outcomes, not usually the technical restoration of database services.
3. Database administrator ✓

   Database administrators commonly manage availability, backups, recovery, access, performance, and configuration for databases.
4. Data engineer

   Data engineers build ingestion and transformation pipelines rather than primarily restoring operational database backups.

Database administrators are most directly associated with database availability, backup, and recovery responsibilities.

2. Delimited tabular text: What does this file represent?

1. Delimited tabular text ✓

   CSV is delimited text used to represent tabular records; applications interpret headers, delimiters, quoting, and types.
2. Database software

   Database software manages data storage, querying, integrity, and access; a CSV file is only delimited text.
3. Relational schema

   Consistent columns may resemble relational data, but CSV alone does not define relational constraints or relationships.
4. Hierarchical object storage

   Object storage is a service for holding files and objects. Comma separation describes the file representation, not its storage service.

CSV is delimited text representing tabular records.

3. OLTP: Which workload best describes this activity?

1. Streaming analytics

   Streaming analytics examines continuously arriving events, but payment account updates are operational transactions.
2. OLTP ✓

   OLTP supports concurrent short transactions that update current operational state while preserving transactional integrity.
3. Batch processing

   Batch processing handles accumulated bounded input, whereas these payments require immediate operational updates.
4. OLAP

   OLAP focuses on analysis and aggregation, usually across historical data, rather than frequent operational updates.

OLTP handles concurrent short transactions that maintain current operational state.

4. Structured data: How should this data be classified?

1. Unstructured data

   Unstructured data lacks a predefined tabular organization, unlike records with consistent columns and field definitions.
2. Structured data ✓

   Structured data follows a predefined, consistent schema, commonly expressed through typed rows and columns.
3. Semi-structured data

   Semi-structured data uses markers such as properties or tags with flexible organization, unlike fixed columns.
4. Binary data

   Binary describes encoding rather than this data's organizational classification, which is clearly predefined and tabular.

Consistent predefined columns and field definitions indicate structured data.

5. Database administrator: Which role fits best?

1. Data engineer

   Data engineers manage ingestion and transformation pipelines, not usually the primary administration of database permissions.
2. Application developer

   Application developers implement software behavior, while database access administration is a distinct database responsibility.
3. Database administrator ✓

   Database administrators commonly manage database access, permissions, availability, recovery, performance, and configuration.
4. Data analyst

   Data analysts create reports and communicate insights, rather than primarily administering database permissions.

Database administrators are the role most directly associated with administering database permissions.

6. Semi-structured data format: What does this format primarily provide?

1. An access policy

   The format describes data; it does not define permissions or authorization decisions.
2. A relational database management system

   The text is a data representation, not database software.
3. A fixed schema for every table

   Varying properties and nested arrays do not require identical predefined table columns.
4. Semi-structured data format ✓

   Nested properties and arrays provide structure while allowing profiles to vary.

Nested properties and flexible fields indicate semi-structured data.

7. OLAP: Which workload is this analysis?

1. Event ingestion

   Event ingestion collects incoming events; it does not describe grouping historical revenue for analytical insight.
2. OLTP

   OLTP manages current operational transactions, not primarily historical aggregation across several analytical dimensions.
3. OLAP ✓

   OLAP analyzes and aggregates historical data to support trends, comparisons, and business decisions.
4. Transactional processing

   Transactional processing records operational changes, whereas this activity summarizes history for analysis.

Historical aggregation across dimensions for trends is an OLAP workload.

8. Semi-structured data: How should the data be classified?

1. Semi-structured data ✓

   Property names, nested objects, and arrays provide structure while optional fields allow records to vary.
2. Relational data

   Relational data emphasizes tables and relationships; nested variable documents do not inherently establish that model.
3. Unstructured data

   Recognizable properties and nested arrays provide organization, so the records are not wholly unstructured.
4. Structured data

   Structured data normally follows a consistent predefined schema, unlike records with optional and varying properties.

Recognizable properties combined with variable nested records indicate semi-structured data.

9. Database administrator: Which role is most directly associated with this task?

1. Business sponsor

   Business sponsors provide priorities and funding, not typically hands-on database performance monitoring or configuration.
2. Data engineer

   Data engineers build and manage pipelines, although they may interact with systems during data movement.
3. Data analyst

   Data analysts investigate business information and create insights, rather than primarily tuning database performance.
4. Database administrator ✓

   Database administrators commonly monitor and improve database performance, availability, access, and configuration.

Database administrators are most directly responsible for database performance and configuration.

10. It is semi-structured data using tagged text: Which statement best describes this representation?

1. It is unstructured because the records are text.

   Named elements and attributes provide meaningful organization, so the text is not wholly unstructured.
2. It is a relational database because tags define columns.

   Tags organize text but do not automatically create relational tables, constraints, or a database system.
3. It is semi-structured data using tagged text. ✓

   Elements and attributes provide structural markers while optional content allows records to vary.
4. It is a fixed schema because every element is required.

   Optional elements and varying records contradict the claim that every record follows an identical fixed schema.

XML-style elements and attributes provide semi-structured organization within text.

11. A transaction: Which capability should the service use?

1. A batch job

   A batch job controls when accumulated work runs but does not inherently provide all-or-nothing behavior.
2. A data lake

   A data lake stores diverse data and does not coordinate these operational updates.
3. A dashboard

   A dashboard presents information after processing and does not control update consistency.
4. A transaction ✓

   A transaction can group both operations so they commit together or roll back together.

Use a transaction to apply related database changes atomically.

12. Semi-structured XML: Which data representation best describes these records?

1. Unstructured binary content

   Binary content such as images lacks the descriptive tags present in these records.
2. Delimited CSV text

   CSV represents tabular values and does not naturally express nested elements or attributes.
3. Structured relational rows

   Relational rows usually follow predefined columns and types across a consistent schema.
4. Semi-structured XML ✓

   XML tags and attributes provide structure while allowing records to contain varying nested elements.

XML is semi-structured because tags and attributes organize flexible, potentially nested records.

Other DP-900 domains

• Describe an analytics workload on Azure — 302 questions →
• Identify considerations for relational data on Azure — 260 questions →
• Describe considerations for working with non-relational data on Azure — 216 questions →
• All 1080 DP-900 questions →
• DP-900 certification: requirements, cost and exam format →