WGU C182 Objective Assessment Exam 2026
\\C182 Data Management for Organizations –
Practice Exam (Part 1 of 5) Complete Practice
Exam with Answers and Detailed Rationales (2026
Edition]
Q1. Which of the following best describes structured data?
A) Unformatted text files stored in a directory
B) Data organized in rows and columns with a predefined schema
C) Social media posts containing hashtags and images
D) Sensor logs with inconsistent timestamp formats
AnswerB
Rationale:
• A) Incorrect. Unformatted text files lack a fixed schema and are unstructured.
• B) Correct. Structured data adheres to a defined schema, typically stored in relational tables.
• C) Incorrect. Social media content mixes text, media, and metadata, making it semi-structured
or unstructured.
• D) Incorrect. Inconsistent formatting violates schema requirements, classifying it as
unstructured.
Q2. In a relational database, which constraint ensures that a foreign key value must either match a
primary key value in the referenced table or be NULL?
A) UNIQUE constraint
B) CHECK constraint
C) Referential integrity constraint
D) DEFAULT constraint
AnswerC
Rationale:
• A) Incorrect. UNIQUE prevents duplicate values within a column but doesn’t enforce cross-table
relationships.
• B) Incorrect. CHECK validates data against a condition within the same table.
, • C) Correct. Referential integrity enforces valid relationships between tables via foreign keys.
• D) Incorrect. DEFAULT supplies a value when none is provided; it doesn’t validate relationships.
Q3. Which normal form requires that every non-key attribute be fully functionally dependent on the
primary key?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)
AnswerB
Rationale:
• A) Incorrect. 1NF only requires atomic values and no repeating groups.
• B) Correct. 2NF eliminates partial dependencies by ensuring non-key attributes depend on the
entire primary key.
• C) Incorrect. 3NF removes transitive dependencies, building upon 2NF.
• D) Incorrect. BCNF addresses cases where a non-key attribute determines a key attribute.
Q4. Which SQL clause is used to filter groups after an aggregate function has been applied?
A) WHERE
B) HAVING
C) GROUP BY
D) ORDER BY
AnswerB
Rationale:
• A) Incorrect. WHERE filters rows before aggregation occurs.
• B) Correct. HAVING filters grouped results after aggregation, typically used with GROUP BY.
• C) Incorrect. GROUP BY organizes rows into groups but does not filter them.
• D) Incorrect. ORDER BY sorts the final result set; it does not filter.
Q5. In data warehousing, what is the primary purpose of a fact table?
A) Store descriptive attributes like customer names
B) Hold measurable, quantitative data for analysis
C) Manage database user permissions
D) Track metadata about source systems
AnswerB
Rationale:
• A) Incorrect. Descriptive attributes belong in dimension tables.
• B) Correct. Fact tables store metrics/measures (e.g., sales amount, quantity) linked to dimension
keys.
, • C) Incorrect. Permissions are managed at the database security layer.
• D) Incorrect. Metadata is stored in data dictionaries or catalogs, not fact tables.
Q6. Which ACID property ensures that a transaction is either fully completed or not applied at all?
A) Atomicity
B) Consistency
C) Isolation
D) Durability
AnswerA
Rationale:
• A) Correct. Atomicity guarantees all-or-nothing execution of transactions.
• B) Incorrect. Consistency ensures data meets predefined rules before and after the transaction.
• C) Incorrect. Isolation prevents concurrent transactions from interfering with each other.
• D) Incorrect. Durability ensures committed transactions survive system failures.
Q7. Which data model uses a tree-like structure with parent-child relationships?
A) Relational model
B) Hierarchical model
C) Network model
D) Object-oriented model
AnswerB
Rationale:
• A) Incorrect. Relational uses tables, keys, and set-based operations.
• B) Correct. Hierarchical databases organize data in a strict parent-child tree structure.
• C) Incorrect. Network models allow multiple parents per child using pointer-based graphs.
• D) Incorrect. Object-oriented models use classes, inheritance, and encapsulation.
Q8. What is the main advantage of denormalization in a read-heavy database environment?
A) Reduces data redundancy
B) Improves write performance
C) Decreases query response time by reducing joins
D) Enhances data consistency
AnswerC
Rationale:
• A) Incorrect. Denormalization intentionally increases redundancy.
• B) Incorrect. It typically degrades write performance due to update anomalies.
• C) Correct. Fewer joins mean faster read queries, ideal for reporting and analytics.
• D) Incorrect. It increases the risk of inconsistency due to duplicated data.
, Q9. Which NoSQL database type is best suited for storing social media posts with varying fields and
nested structures?
A) Key-value store
B) Column-family store
C) Document database
D) Graph database
AnswerC
Rationale:
• A) Incorrect. Key-value stores handle simple pairs, not complex or nested data.
• B) Incorrect. Column-family optimizes for wide tables and analytics, not flexible schemas.
• C) Correct. Document databases (e.g., MongoDB) store semi-structured JSON/BSON, ideal for
variable fields.
• D) Incorrect. Graph databases excel at relationship-heavy data, not document flexibility.
Q10. In an ERD, what does a crow’s foot notation on a relationship line indicate?
A) One-to-one relationship
B) One-to-many relationship
C) Many-to-many relationship
D) Weak entity dependency
AnswerB
Rationale:
• A) Incorrect. 1:1 relationships use single lines on both ends.
• B) Correct. A crow’s foot denotes “many,” paired with a single line on the opposite end for one-
to-many.
• C) Incorrect. Many-to-many requires a junction table; notation shows crow’s feet on both ends.
• D) Incorrect. Weak entities are shown with double rectangles, not crow’s foot notation.
Q11. Which SQL command is classified as Data Definition Language (DDL)?
A) SELECT
B) UPDATE
C) CREATE
D) GRANT
AnswerC
Rationale:
• A) Incorrect. SELECT is DML (Data Manipulation Language).
• B) Incorrect. UPDATE modifies existing data and is DML.
• C) Correct. CREATE defines database objects (tables, indexes, schemas), making it DDL.
• D) Incorrect. GRANT manages permissions and is DCL (Data Control Language).
\\C182 Data Management for Organizations –
Practice Exam (Part 1 of 5) Complete Practice
Exam with Answers and Detailed Rationales (2026
Edition]
Q1. Which of the following best describes structured data?
A) Unformatted text files stored in a directory
B) Data organized in rows and columns with a predefined schema
C) Social media posts containing hashtags and images
D) Sensor logs with inconsistent timestamp formats
AnswerB
Rationale:
• A) Incorrect. Unformatted text files lack a fixed schema and are unstructured.
• B) Correct. Structured data adheres to a defined schema, typically stored in relational tables.
• C) Incorrect. Social media content mixes text, media, and metadata, making it semi-structured
or unstructured.
• D) Incorrect. Inconsistent formatting violates schema requirements, classifying it as
unstructured.
Q2. In a relational database, which constraint ensures that a foreign key value must either match a
primary key value in the referenced table or be NULL?
A) UNIQUE constraint
B) CHECK constraint
C) Referential integrity constraint
D) DEFAULT constraint
AnswerC
Rationale:
• A) Incorrect. UNIQUE prevents duplicate values within a column but doesn’t enforce cross-table
relationships.
• B) Incorrect. CHECK validates data against a condition within the same table.
, • C) Correct. Referential integrity enforces valid relationships between tables via foreign keys.
• D) Incorrect. DEFAULT supplies a value when none is provided; it doesn’t validate relationships.
Q3. Which normal form requires that every non-key attribute be fully functionally dependent on the
primary key?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)
AnswerB
Rationale:
• A) Incorrect. 1NF only requires atomic values and no repeating groups.
• B) Correct. 2NF eliminates partial dependencies by ensuring non-key attributes depend on the
entire primary key.
• C) Incorrect. 3NF removes transitive dependencies, building upon 2NF.
• D) Incorrect. BCNF addresses cases where a non-key attribute determines a key attribute.
Q4. Which SQL clause is used to filter groups after an aggregate function has been applied?
A) WHERE
B) HAVING
C) GROUP BY
D) ORDER BY
AnswerB
Rationale:
• A) Incorrect. WHERE filters rows before aggregation occurs.
• B) Correct. HAVING filters grouped results after aggregation, typically used with GROUP BY.
• C) Incorrect. GROUP BY organizes rows into groups but does not filter them.
• D) Incorrect. ORDER BY sorts the final result set; it does not filter.
Q5. In data warehousing, what is the primary purpose of a fact table?
A) Store descriptive attributes like customer names
B) Hold measurable, quantitative data for analysis
C) Manage database user permissions
D) Track metadata about source systems
AnswerB
Rationale:
• A) Incorrect. Descriptive attributes belong in dimension tables.
• B) Correct. Fact tables store metrics/measures (e.g., sales amount, quantity) linked to dimension
keys.
, • C) Incorrect. Permissions are managed at the database security layer.
• D) Incorrect. Metadata is stored in data dictionaries or catalogs, not fact tables.
Q6. Which ACID property ensures that a transaction is either fully completed or not applied at all?
A) Atomicity
B) Consistency
C) Isolation
D) Durability
AnswerA
Rationale:
• A) Correct. Atomicity guarantees all-or-nothing execution of transactions.
• B) Incorrect. Consistency ensures data meets predefined rules before and after the transaction.
• C) Incorrect. Isolation prevents concurrent transactions from interfering with each other.
• D) Incorrect. Durability ensures committed transactions survive system failures.
Q7. Which data model uses a tree-like structure with parent-child relationships?
A) Relational model
B) Hierarchical model
C) Network model
D) Object-oriented model
AnswerB
Rationale:
• A) Incorrect. Relational uses tables, keys, and set-based operations.
• B) Correct. Hierarchical databases organize data in a strict parent-child tree structure.
• C) Incorrect. Network models allow multiple parents per child using pointer-based graphs.
• D) Incorrect. Object-oriented models use classes, inheritance, and encapsulation.
Q8. What is the main advantage of denormalization in a read-heavy database environment?
A) Reduces data redundancy
B) Improves write performance
C) Decreases query response time by reducing joins
D) Enhances data consistency
AnswerC
Rationale:
• A) Incorrect. Denormalization intentionally increases redundancy.
• B) Incorrect. It typically degrades write performance due to update anomalies.
• C) Correct. Fewer joins mean faster read queries, ideal for reporting and analytics.
• D) Incorrect. It increases the risk of inconsistency due to duplicated data.
, Q9. Which NoSQL database type is best suited for storing social media posts with varying fields and
nested structures?
A) Key-value store
B) Column-family store
C) Document database
D) Graph database
AnswerC
Rationale:
• A) Incorrect. Key-value stores handle simple pairs, not complex or nested data.
• B) Incorrect. Column-family optimizes for wide tables and analytics, not flexible schemas.
• C) Correct. Document databases (e.g., MongoDB) store semi-structured JSON/BSON, ideal for
variable fields.
• D) Incorrect. Graph databases excel at relationship-heavy data, not document flexibility.
Q10. In an ERD, what does a crow’s foot notation on a relationship line indicate?
A) One-to-one relationship
B) One-to-many relationship
C) Many-to-many relationship
D) Weak entity dependency
AnswerB
Rationale:
• A) Incorrect. 1:1 relationships use single lines on both ends.
• B) Correct. A crow’s foot denotes “many,” paired with a single line on the opposite end for one-
to-many.
• C) Incorrect. Many-to-many requires a junction table; notation shows crow’s feet on both ends.
• D) Incorrect. Weak entities are shown with double rectangles, not crow’s foot notation.
Q11. Which SQL command is classified as Data Definition Language (DDL)?
A) SELECT
B) UPDATE
C) CREATE
D) GRANT
AnswerC
Rationale:
• A) Incorrect. SELECT is DML (Data Manipulation Language).
• B) Incorrect. UPDATE modifies existing data and is DML.
• C) Correct. CREATE defines database objects (tables, indexes, schemas), making it DDL.
• D) Incorrect. GRANT manages permissions and is DCL (Data Control Language).
