Practice Questions
Question 1
Which statement best describes structured data?
A. Data stored as images and videos
B. Data organized in key-value pairs without a schema
C. Data organized in rows and columns with a predefined schema
D. Data that can only be stored in files
✅ Answer: C
Explanation:
Structured data uses a fixed schema and is typically organized into tables with rows and columns, making it easy to query and analyze.
Question 2
Which of the following is a defining characteristic of structured data?
A. Schema-on-read
B. Schema-on-write
C. No enforced data types
D. Free-form text storage
✅ Answer: B
Explanation:
Structured data uses schema-on-write, meaning the structure (tables, columns, data types) must be defined before data is stored.
Question 3
You have a table with columns CustomerID, Name, and JoinDate. Each column has a defined data type. What feature of structured data does this demonstrate?
A. Indexing
B. Semi-structured storage
C. Strong data typing
D. Unstructured formatting
✅ Answer: C
Explanation:
Structured data enforces strong data typing, ensuring each column only accepts valid values (e.g., dates in date columns).
Question 4
Which language is most commonly used to query structured data?
A. Python
B. JSON
C. SQL
D. XML
✅ Answer: C
Explanation:
Structured data is designed to be queried using SQL (Structured Query Language).
Question 5
Which Azure service is primarily designed to store structured relational data?
A. Azure Blob Storage
B. Azure Data Lake Storage
C. Azure SQL Database
D. Azure File Storage
✅ Answer: C
Explanation:
Azure SQL Database is a managed relational database service optimized for structured data.
Question 6
What does a row represent in structured data?
A. A column definition
B. A schema
C. A single record or entity instance
D. A data type
✅ Answer: C
Explanation:
Each row represents one complete record (for example, one customer or one order).
Question 7
Which feature helps ensure that every record in a table can be uniquely identified?
A. Foreign key
B. Primary key
C. Index
D. View
✅ Answer: B
Explanation:
A primary key uniquely identifies each row and is a core integrity feature of structured data systems.
Question 8
Why is structured data well suited for reporting and dashboards?
A. It allows free-form documents
B. It does not require validation
C. It supports predictable schemas and efficient queries
D. It stores multimedia content
✅ Answer: C
Explanation:
Fixed schemas and SQL support make structured data ideal for analytics, reporting, and BI workloads.
Question 9
Which of the following best illustrates structured data?
A. A collection of photos
B. JSON log files
C. A spreadsheet with defined columns
D. Audio recordings
✅ Answer: C
Explanation:
Spreadsheets with consistent columns and rows are classic examples of structured data.
Question 10
What is a major benefit of enforcing constraints such as NOT NULL and UNIQUE?
A. Faster internet connections
B. Reduced storage costs
C. Improved data integrity
D. Automatic encryption
✅ Answer: C
Explanation:
Constraints help maintain accuracy and consistency, which is a key strength of structured data systems.
✅ Quick Exam Takeaway
For DP-900, remember:
- Structured data uses tables (rows + columns)
- Requires a predefined schema
- Enforces data types and constraints
- Is queried with SQL
- Commonly lives in relational databases like Azure SQL Database
Go to the DP-900 Exam Prep Hub main page.
The Data Community 