Microsoft Azure Data Fundamentals
(DP-900) Exam (AGACNP-C) 2026–2027
| Comprehensive Question Practice Test
with Answers & Rationales| Free Pdf
Access
1. What is the main purpose of data?
A. Support decision-making and provide insights
B. Replace operating systems
C. Manage computer hardware
D. Create network cables
Correct Answer: A
Rationale: Data is collected and analyzed to support decisions and generate insights.
2. What is structured data?
A. Data organized in a predefined format
B. Data with no organization
C. Only image files
D. Only video files
,Correct Answer: A
Rationale: Structured data follows a fixed schema, such as tables in databases.
3. Which is an example of structured data?
A. SQL database table
B. Video recording
C. Audio file
D. Social media post
Correct Answer: A
Rationale: SQL tables store structured rows and columns.
4. What is semi-structured data?
A. Data with some organization but no fixed schema
B. Data stored only in spreadsheets
C. Data with no information
D. Data stored only in databases
Correct Answer: A
Rationale: Semi-structured data includes formats like JSON and XML.
5. Which is an example of semi-structured data?
A. JSON document
B. Relational table
C. Printed document
,D. Binary application file
Correct Answer: A
Rationale: JSON contains structured elements but flexible schemas.
6. What is unstructured data?
A. Data without a predefined structure
B. Data stored in SQL tables
C. Data with fixed columns
D. Data stored only in databases
Correct Answer: A
Rationale: Unstructured data includes images, videos, and documents.
7. Which is an example of unstructured data?
A. Image files
B. SQL records
C. Spreadsheet tables
D. Database rows
Correct Answer: A
Rationale: Images do not follow a tabular structure.
8. What is a database?
A. Organized collection of data
B. Computer hardware
, C. Network device
D. Operating system
Correct Answer: A
Rationale: Databases store and manage organized information.
9. What is a relational database?
A. Database that stores data in tables with relationships
B. Database without structure
C. File storage system
D. Image repository
Correct Answer: A
Rationale: Relational databases use tables and relationships.
10. What language is commonly used to query relational databases?
A. SQL
B. HTML
C. CSS
D. XML only
Correct Answer: A
Rationale: SQL is used to retrieve and manage relational data.
11. What is descriptive analytics?
A. Explains what happened in the past
(DP-900) Exam (AGACNP-C) 2026–2027
| Comprehensive Question Practice Test
with Answers & Rationales| Free Pdf
Access
1. What is the main purpose of data?
A. Support decision-making and provide insights
B. Replace operating systems
C. Manage computer hardware
D. Create network cables
Correct Answer: A
Rationale: Data is collected and analyzed to support decisions and generate insights.
2. What is structured data?
A. Data organized in a predefined format
B. Data with no organization
C. Only image files
D. Only video files
,Correct Answer: A
Rationale: Structured data follows a fixed schema, such as tables in databases.
3. Which is an example of structured data?
A. SQL database table
B. Video recording
C. Audio file
D. Social media post
Correct Answer: A
Rationale: SQL tables store structured rows and columns.
4. What is semi-structured data?
A. Data with some organization but no fixed schema
B. Data stored only in spreadsheets
C. Data with no information
D. Data stored only in databases
Correct Answer: A
Rationale: Semi-structured data includes formats like JSON and XML.
5. Which is an example of semi-structured data?
A. JSON document
B. Relational table
C. Printed document
,D. Binary application file
Correct Answer: A
Rationale: JSON contains structured elements but flexible schemas.
6. What is unstructured data?
A. Data without a predefined structure
B. Data stored in SQL tables
C. Data with fixed columns
D. Data stored only in databases
Correct Answer: A
Rationale: Unstructured data includes images, videos, and documents.
7. Which is an example of unstructured data?
A. Image files
B. SQL records
C. Spreadsheet tables
D. Database rows
Correct Answer: A
Rationale: Images do not follow a tabular structure.
8. What is a database?
A. Organized collection of data
B. Computer hardware
, C. Network device
D. Operating system
Correct Answer: A
Rationale: Databases store and manage organized information.
9. What is a relational database?
A. Database that stores data in tables with relationships
B. Database without structure
C. File storage system
D. Image repository
Correct Answer: A
Rationale: Relational databases use tables and relationships.
10. What language is commonly used to query relational databases?
A. SQL
B. HTML
C. CSS
D. XML only
Correct Answer: A
Rationale: SQL is used to retrieve and manage relational data.
11. What is descriptive analytics?
A. Explains what happened in the past
