WGU D467 Exploring Data
Western Governors University
Academic Year 2026/2027
Objective Assessment Comprehensive Practice Examination
Questions 1–200
Data Structures, Types, Formats, and Integrity
1. Which statement best describes structured data?
A. Data stored only as images
B. Data with no consistent organization
C. Data organized according to a defined schema or structure
D. Data that cannot be queried
2. Which is an example of structured data?
A. A handwritten note
B. A photograph
,C. A relational database table
D. An audio recording
3. What is a data type?
A. A database password
B. A classification that defines the kind of value a field can contain
C. A spreadsheet worksheet
D. A SQL server
4. Which data type is most appropriate for a person's age?
A. Boolean
B. Date
C. Integer
D. Image
5. Which data type is most appropriate for a customer's name?
A. Boolean
B. Text/string
C. Integer
D. Date
6. Which value is an example of Boolean data?
,A. 125
B. "January"
C. 2026-09-17
D. TRUE
7. Which data type is best suited for a transaction date?
A. String
B. Integer
C. Date
D. Boolean
8. What is a schema?
A. A backup copy of data
B. A defined structure describing how data is organized
C. A spreadsheet formula
D. A data-cleaning error
9. What does data integrity refer to?
A. The amount of storage available
B. The visual appearance of a report
C. The accuracy, consistency, and reliability of data
D. The number of database users
10. Which situation represents poor data integrity?
, A. Every customer has a unique ID
B. Dates use the same format
C. The same customer has conflicting addresses in different records
D. Required fields are validated
11. What is metadata?
A. Deleted information
B. Information that describes data
C. A type of malware
D. A SQL password
12. Which is an example of metadata?
A. Customer's purchase amount
B. Customer's name
C. The date a dataset was created
D. Product quantity
13. What is a primary key used for?
A. Formatting a spreadsheet
B. Calculating an average
C. Uniquely identifying records in a table
D. Encrypting a database
14. Which characteristic should a primary key have?
Western Governors University
Academic Year 2026/2027
Objective Assessment Comprehensive Practice Examination
Questions 1–200
Data Structures, Types, Formats, and Integrity
1. Which statement best describes structured data?
A. Data stored only as images
B. Data with no consistent organization
C. Data organized according to a defined schema or structure
D. Data that cannot be queried
2. Which is an example of structured data?
A. A handwritten note
B. A photograph
,C. A relational database table
D. An audio recording
3. What is a data type?
A. A database password
B. A classification that defines the kind of value a field can contain
C. A spreadsheet worksheet
D. A SQL server
4. Which data type is most appropriate for a person's age?
A. Boolean
B. Date
C. Integer
D. Image
5. Which data type is most appropriate for a customer's name?
A. Boolean
B. Text/string
C. Integer
D. Date
6. Which value is an example of Boolean data?
,A. 125
B. "January"
C. 2026-09-17
D. TRUE
7. Which data type is best suited for a transaction date?
A. String
B. Integer
C. Date
D. Boolean
8. What is a schema?
A. A backup copy of data
B. A defined structure describing how data is organized
C. A spreadsheet formula
D. A data-cleaning error
9. What does data integrity refer to?
A. The amount of storage available
B. The visual appearance of a report
C. The accuracy, consistency, and reliability of data
D. The number of database users
10. Which situation represents poor data integrity?
, A. Every customer has a unique ID
B. Dates use the same format
C. The same customer has conflicting addresses in different records
D. Required fields are validated
11. What is metadata?
A. Deleted information
B. Information that describes data
C. A type of malware
D. A SQL password
12. Which is an example of metadata?
A. Customer's purchase amount
B. Customer's name
C. The date a dataset was created
D. Product quantity
13. What is a primary key used for?
A. Formatting a spreadsheet
B. Calculating an average
C. Uniquely identifying records in a table
D. Encrypting a database
14. Which characteristic should a primary key have?
