1
Microsoft Data Fundamentals (DP-
900) — Advanced Practice Exam
150 Multiple-Choice Questions
with Answers and Rationales a
well detailed one
written and graded A+
upgraded
, 2
DOMAIN 1: CORE DATA CONCEPTS (25–30%)
Question 1
A company collects IoT sensor data from thousands of devices. Each device sends temperature,
humidity, and pressure readings in different formats depending on the device model. Some
devices include additional fields like battery level or GPS coordinates, while others do not. How
should this data be classified?
A. Structured data
B. Semi-structured data
C. Unstructured data
D. Relational data
- detailed answer 100% correct :- B — Semi-structured data
Rationale: Semi-structured data contains organizational properties like tags or markers but does
not conform to a rigid schema. JSON data with variable fields is a classic example of semi-
structured data. Structured data requires a fixed schema (A), unstructured data has no
organization (C), and relational data is a specific type of structured data (D).
Question 2
Which of the following characteristics is MOST associated with an online transaction processing
(OLTP) workload?
A. Large-scale historical data aggregation
B. Complex analytical queries over millions of rows
C. High volume of short, atomic transactions
D. Batch processing of data overnight
- detailed answer 100% correct :- C — High volume of short, atomic transactions
Rationale: OLTP systems are designed for high-volume, short-duration transactions with ACID
properties. Options A, B, and D describe analytical workloads (OLAP) which focus on complex
queries and historical analysis.
Question 3
, 3
A database administrator needs to eliminate duplicate customer address data stored across
multiple tables to improve data consistency. Which process should be applied?
A. Database partitioning
B. Data normalization
C. Data replication
D. Data encryption
- detailed answer 100% correct :- B — Data normalization
Rationale: Normalization is the process of organizing data to reduce redundancy and improve
data integrity by structuring tables to minimize duplicate data. Partitioning improves scalability
(A), replication copies data (C), and encryption secures data (D).
Question 4
Which SQL statement should be used to remove all rows from a table while preserving the table
structure for future use?
A. DROP TABLE
B. DELETE FROM
C. TRUNCATE TABLE
D. REMOVE TABLE
- detailed answer 100% correct :- C — TRUNCATE TABLE
Rationale: TRUNCATE TABLE removes all rows from a table but retains the table structure. DROP
TABLE removes both the data and the table structure (A). DELETE FROM removes rows but can
be rolled back and is slower for large tables (B). REMOVE is not a standard SQL command (D).
Question 5
A data engineer is building a data pipeline that processes streaming data from social media
feeds in real-time. Which type of data processing is being implemented?
A. Batch processing
B. Stream processing
C. Transactional processing
D. Analytical processing
- detailed answer 100% correct :- B — Stream processing
, 4
Rationale: Stream processing handles data continuously as it arrives, processing events in real-
time or near-real-time. Batch processing processes data in large chunks at scheduled intervals
(A). Transactional processing handles operational database operations (C). Analytical processing
focuses on historical data analysis (D).
Question 6
Which role is primarily responsible for creating dashboards and visual reports to help business
users understand data insights?
A. Database Administrator (DBA)
B. Data Engineer
C. Data Analyst
D. Data Scientist
- detailed answer 100% correct :- C — Data Analyst
Rationale: Data analysts are primarily responsible for creating dashboards, reports, and
visualizations to communicate data insights to stakeholders. DBAs manage database
performance and security (A). Data engineers build data pipelines (B). Data scientists build
predictive models (D).
Question 7
A company stores millions of image files for a machine learning training dataset. How should
these image files be classified?
A. Structured data
B. Semi-structured data
C. Unstructured data
D. Tabular data
- detailed answer 100% correct :- C — Unstructured data
Rationale: Unstructured data has no predefined organizational structure or schema. Images,
videos, audio files, and free-form text are classic examples of unstructured data. Structured data
fits a rigid schema (A). Semi-structured data has some organizational properties (B). Tabular
data is a form of structured data (D).
Microsoft Data Fundamentals (DP-
900) — Advanced Practice Exam
150 Multiple-Choice Questions
with Answers and Rationales a
well detailed one
written and graded A+
upgraded
, 2
DOMAIN 1: CORE DATA CONCEPTS (25–30%)
Question 1
A company collects IoT sensor data from thousands of devices. Each device sends temperature,
humidity, and pressure readings in different formats depending on the device model. Some
devices include additional fields like battery level or GPS coordinates, while others do not. How
should this data be classified?
A. Structured data
B. Semi-structured data
C. Unstructured data
D. Relational data
- detailed answer 100% correct :- B — Semi-structured data
Rationale: Semi-structured data contains organizational properties like tags or markers but does
not conform to a rigid schema. JSON data with variable fields is a classic example of semi-
structured data. Structured data requires a fixed schema (A), unstructured data has no
organization (C), and relational data is a specific type of structured data (D).
Question 2
Which of the following characteristics is MOST associated with an online transaction processing
(OLTP) workload?
A. Large-scale historical data aggregation
B. Complex analytical queries over millions of rows
C. High volume of short, atomic transactions
D. Batch processing of data overnight
- detailed answer 100% correct :- C — High volume of short, atomic transactions
Rationale: OLTP systems are designed for high-volume, short-duration transactions with ACID
properties. Options A, B, and D describe analytical workloads (OLAP) which focus on complex
queries and historical analysis.
Question 3
, 3
A database administrator needs to eliminate duplicate customer address data stored across
multiple tables to improve data consistency. Which process should be applied?
A. Database partitioning
B. Data normalization
C. Data replication
D. Data encryption
- detailed answer 100% correct :- B — Data normalization
Rationale: Normalization is the process of organizing data to reduce redundancy and improve
data integrity by structuring tables to minimize duplicate data. Partitioning improves scalability
(A), replication copies data (C), and encryption secures data (D).
Question 4
Which SQL statement should be used to remove all rows from a table while preserving the table
structure for future use?
A. DROP TABLE
B. DELETE FROM
C. TRUNCATE TABLE
D. REMOVE TABLE
- detailed answer 100% correct :- C — TRUNCATE TABLE
Rationale: TRUNCATE TABLE removes all rows from a table but retains the table structure. DROP
TABLE removes both the data and the table structure (A). DELETE FROM removes rows but can
be rolled back and is slower for large tables (B). REMOVE is not a standard SQL command (D).
Question 5
A data engineer is building a data pipeline that processes streaming data from social media
feeds in real-time. Which type of data processing is being implemented?
A. Batch processing
B. Stream processing
C. Transactional processing
D. Analytical processing
- detailed answer 100% correct :- B — Stream processing
, 4
Rationale: Stream processing handles data continuously as it arrives, processing events in real-
time or near-real-time. Batch processing processes data in large chunks at scheduled intervals
(A). Transactional processing handles operational database operations (C). Analytical processing
focuses on historical data analysis (D).
Question 6
Which role is primarily responsible for creating dashboards and visual reports to help business
users understand data insights?
A. Database Administrator (DBA)
B. Data Engineer
C. Data Analyst
D. Data Scientist
- detailed answer 100% correct :- C — Data Analyst
Rationale: Data analysts are primarily responsible for creating dashboards, reports, and
visualizations to communicate data insights to stakeholders. DBAs manage database
performance and security (A). Data engineers build data pipelines (B). Data scientists build
predictive models (D).
Question 7
A company stores millions of image files for a machine learning training dataset. How should
these image files be classified?
A. Structured data
B. Semi-structured data
C. Unstructured data
D. Tabular data
- detailed answer 100% correct :- C — Unstructured data
Rationale: Unstructured data has no predefined organizational structure or schema. Images,
videos, audio files, and free-form text are classic examples of unstructured data. Structured data
fits a rigid schema (A). Semi-structured data has some organizational properties (B). Tabular
data is a form of structured data (D).
