Free practice test · no sign-up
DP-900Free Microsoft Azure Data Fundamentals practice test
- ✓ 10 free questions
- ✓ Instant answers & explanations
- ✓ No sign-up, no email
10 real DP-900 practice questions with instant answers and explanations — no account, no credit card, no email. Score yourself, then unlock the full bank of 70 questions whenever you’re ready. The DP-900 passing score is 700 / 1000.
A retail company stores customer records in a table where every row has the same fixed set of typed columns, such as customer ID, name, and signup date. How is this kind of data best described?
Answer key
All 10 DP-900 questions & answers
Prefer to just read the answers and explanations? Here’s the full key for this free DP-900 test.
Q1. A retail company stores customer records in a table where every row has the same fixed set of typed columns, such as customer ID, name, and signup date. How is this kind of data best described?
Correct answer: A. Structured data
Data that conforms to a rigid, predefined schema of rows and columns with consistent data types is structured data, the model used by relational tables.
Q2. A developer receives records where each item may include different fields and nesting, but each field is labeled with tags or key-value pairs. Which category describes this data?
Correct answer: B. Semi-structured data
Semi-structured data does not fit a fixed relational schema but still carries self-describing markers such as keys or tags, as seen in JSON and XML documents.
Q3. Which of the following is the clearest example of unstructured data?
Correct answer: C. A collection of scanned images and video clips
Media files such as images, audio, and video have no internal field-and-record organization, making them unstructured data.
Q4. A file uses commas to separate field values and a newline to separate each record, with an optional header row. Which format is this?
Correct answer: B. CSV
CSV (comma-separated values) is a plain-text, row-based delimited format where commas separate fields and newlines separate records.
Q5. An analytics team wants a file format that stores data column by column and compresses well to speed up large analytical scans. Which format best fits this need?
Correct answer: C. Parquet
Parquet is a columnar, compressed format optimized for analytical queries that read a subset of columns across many rows.
Q6. Which statement best describes the Avro file format?
Correct answer: A. A row-based format that stores its schema alongside the data, well suited to streaming and message pipelines
Avro is a compact, row-oriented binary format that embeds its schema, making it a common choice for serializing streaming and event data.
Q7. An order-entry application constantly inserts and updates many small records, with each transaction touching only a few rows. Which workload type does this represent?
Correct answer: B. OLTP
Online transaction processing (OLTP) handles high volumes of short read/write operations against current data, typical of order-entry and point-of-sale systems.
Q8. A system aggregates years of historical sales to answer complex questions like total revenue by region over time. Which workload type is this?
Correct answer: B. OLAP
Online analytical processing (OLAP) is optimized for complex, read-heavy queries that summarize large volumes of historical data.
Q9. Which contrast between OLTP and OLAP systems is accurate?
Correct answer: B. OLTP favors many small, fast transactions while OLAP favors complex reads over large historical datasets
OLTP prioritizes rapid, concurrent transactional writes on current data, whereas OLAP prioritizes analytical reads and aggregations over large historical stores.
Q10. A payroll job runs once each night to process the entire day's timesheets in a single large operation. Which processing approach is this?
Correct answer: B. Batch processing
Batch processing collects data over a period and processes it together as a group, often on a schedule such as a nightly run.
Exam facts and objectives sourced from the official Microsoft certification page. Last reviewed June 2026.
Ready for the full DP-900 bank? Start free.
70 questions, timed mock exams, and missed-question review — 30 free questions, no card.
Start free trial