Advanced WGU C175 & D426 Data Management
Foundations Actual Exam Production. Updated 2026
(Graded A+) Instant Download PDF.
Exam Format: Objective Assessment (OA)
Target Grade: Pass / 100% Verified Answers and Explanations
Section 1: Database Concepts, Architecture & Modeling
Question 1
A database designer is mapping out business requirements for a new logistics application.
They sketch out an initial diagram that identifies core business objects such as "Shipment",
"Driver", and "Warehouse", along with lines linking how they connect. The diagram omits
any mention of data types, specific table structures, keys, or technical specifications.
Which abstraction level does this model represent?
A) Logical Design
B) Physical Design
C) Conceptual Design
D) Abstract Schema
Correct Answer: C Rationale: The conceptual model represents a high-level, business-centric
view of data that focuses purely on defining entities and their relationships. It intentionally
ignores all technological implementation details, primary/foreign keys, and data types,
which are later introduced in the logical and physical design stages.
Question 2
When creating a highly complex relational database layout, an engineer needs to ensure
that specific administrative teams have access only to certain subsets of corporate records,
preventing unauthorized personnel from scanning full raw data pools.
Which core database requirement addresses this protection strategy?
A) Authorization
B) Performance Optimization
C) Data Volatility Assessment
D) Transaction Recovery
,Correct Answer: A Rationale: Authorization is the security implementation mechanism
within a DBMS that defines user roles and limits data access permissions to authenticated
accounts based on structural compliance rules.
Question 3
A designer works with a table where a combination of three specific attributes is explicitly
designated to serve as the unique row identifier. If any one of these three columns is
omitted, the remaining columns lose their capability to uniquely identify distinct records in
the table.
What structural property describes this specific characteristic?
A) Functional Transitivity
B) Minimality
C) Referential Parity
D) Atomicity
Correct Answer: B Rationale: Minimality means that a key contains the absolute minimum
number of columns required to guarantee uniqueness. If a composite primary key is minimal,
removing even one attribute destroys its ability to uniquely identify rows.
Question 4
An entity-relationship diagram (ERD) indicates a dynamic structural connection where an
entity type references itself. For instance, an Employees table contains a relationship called
Manages where a senior employee acts as a manager to other lower-tier rows within the
same table.
What type of relationship is this?
A) Binary Relationship
B) Ternary Relationship
C) Unary (Recursive) Relationship
D) Associative Entity
Correct Answer: C Rationale: A unary, or recursive, relationship occurs when an entity type
has a relationship linking back to itself. This allows individual instances inside a single table
to form hierarchical paths with other rows in the same table.
Section 2: Data Integrity, Constraints & Keys
Question 5
,A database developer configures a table schema and intends to apply a property that
automatically generates sequential, incrementing numerical identifiers every time an
application client sends an unstructured insert command.
Which specific configuration parameter should the developer declare on this column in
MySQL?
A) DEFAULT
B) AUTO_INCREMENT
C) UNIQUE
D) SERIAL
Correct Answer: B Rationale: In MySQL, the AUTO_INCREMENT keyword is specifically
designated to generate sequential integer values automatically for newly appended rows,
removing the manual ID tracking burden from the application layer.
Question 6
A developer attempts to delete a row representing a parent account inside the Customers
table. However, the DBMS rejects the operation with an error code because multiple active
records inside the child Orders table still point to that specific customer's primary key.
What referential integrity action was enforced by the database?
A) CASCADE
B) SET NULL
C) RESTRICT
D) SET DEFAULT
Correct Answer: C Rationale: The RESTRICT (or NO ACTION) referential integrity rule
prevents any delete or update action on a parent table if there are dependent matching rows
found inside child tables, preserving valid relational linkages.
Question 7
Which property is fundamentally enforced on any column that has been successfully
designated as a relational table's primary key?
A) NULL
B) NOT NULL
C) NUMERIC
D) CASCADE
, Correct Answer: B Rationale: By definition, a primary key constraint combines the rules of
uniqueness and non-nullability. A primary key field can never contain a NULL value, ensuring
that every record can be distinctly identified.
Question 8
A database designer wants to limit entries within a Staff_Age column to values that fall
strictly between 18 and 65.
Which database constraint mechanism provides an analytical expression layer to validate
this input rule directly on the column?
A) UNIQUE
B) CHECK
C) FOREIGN KEY
D) RESTRICT
Correct Answer: B Rationale: The CHECK constraint evaluates user input against a boolean
expression before permitting structural data storage. If the expression evaluates to false, the
insert or update operation is blocked.
Section 3: Normalization Pipeline
Question 9
A database audit uncovers a legacy spreadsheet migration where a column named
Phone_Numbers contains multiple comma-separated values inside individual table cells
(e.g., "555-1234, 555-5678").
This configuration directly violates which relational normal form?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)
Correct Answer: A Rationale: First Normal Form requires that all column cell values must be
strictly atomic (meaning single, indivisible data values) and that the table has an established
primary key. Multi-valued or comma-delimited strings within a single attribute cell violate
1NF.
Question 10
A table is confirmed to be in First Normal Form (1NF). Its primary key is a composite key
consisting of (Project_ID, Employee_ID). An auditor notes that a non-key column called
Foundations Actual Exam Production. Updated 2026
(Graded A+) Instant Download PDF.
Exam Format: Objective Assessment (OA)
Target Grade: Pass / 100% Verified Answers and Explanations
Section 1: Database Concepts, Architecture & Modeling
Question 1
A database designer is mapping out business requirements for a new logistics application.
They sketch out an initial diagram that identifies core business objects such as "Shipment",
"Driver", and "Warehouse", along with lines linking how they connect. The diagram omits
any mention of data types, specific table structures, keys, or technical specifications.
Which abstraction level does this model represent?
A) Logical Design
B) Physical Design
C) Conceptual Design
D) Abstract Schema
Correct Answer: C Rationale: The conceptual model represents a high-level, business-centric
view of data that focuses purely on defining entities and their relationships. It intentionally
ignores all technological implementation details, primary/foreign keys, and data types,
which are later introduced in the logical and physical design stages.
Question 2
When creating a highly complex relational database layout, an engineer needs to ensure
that specific administrative teams have access only to certain subsets of corporate records,
preventing unauthorized personnel from scanning full raw data pools.
Which core database requirement addresses this protection strategy?
A) Authorization
B) Performance Optimization
C) Data Volatility Assessment
D) Transaction Recovery
,Correct Answer: A Rationale: Authorization is the security implementation mechanism
within a DBMS that defines user roles and limits data access permissions to authenticated
accounts based on structural compliance rules.
Question 3
A designer works with a table where a combination of three specific attributes is explicitly
designated to serve as the unique row identifier. If any one of these three columns is
omitted, the remaining columns lose their capability to uniquely identify distinct records in
the table.
What structural property describes this specific characteristic?
A) Functional Transitivity
B) Minimality
C) Referential Parity
D) Atomicity
Correct Answer: B Rationale: Minimality means that a key contains the absolute minimum
number of columns required to guarantee uniqueness. If a composite primary key is minimal,
removing even one attribute destroys its ability to uniquely identify rows.
Question 4
An entity-relationship diagram (ERD) indicates a dynamic structural connection where an
entity type references itself. For instance, an Employees table contains a relationship called
Manages where a senior employee acts as a manager to other lower-tier rows within the
same table.
What type of relationship is this?
A) Binary Relationship
B) Ternary Relationship
C) Unary (Recursive) Relationship
D) Associative Entity
Correct Answer: C Rationale: A unary, or recursive, relationship occurs when an entity type
has a relationship linking back to itself. This allows individual instances inside a single table
to form hierarchical paths with other rows in the same table.
Section 2: Data Integrity, Constraints & Keys
Question 5
,A database developer configures a table schema and intends to apply a property that
automatically generates sequential, incrementing numerical identifiers every time an
application client sends an unstructured insert command.
Which specific configuration parameter should the developer declare on this column in
MySQL?
A) DEFAULT
B) AUTO_INCREMENT
C) UNIQUE
D) SERIAL
Correct Answer: B Rationale: In MySQL, the AUTO_INCREMENT keyword is specifically
designated to generate sequential integer values automatically for newly appended rows,
removing the manual ID tracking burden from the application layer.
Question 6
A developer attempts to delete a row representing a parent account inside the Customers
table. However, the DBMS rejects the operation with an error code because multiple active
records inside the child Orders table still point to that specific customer's primary key.
What referential integrity action was enforced by the database?
A) CASCADE
B) SET NULL
C) RESTRICT
D) SET DEFAULT
Correct Answer: C Rationale: The RESTRICT (or NO ACTION) referential integrity rule
prevents any delete or update action on a parent table if there are dependent matching rows
found inside child tables, preserving valid relational linkages.
Question 7
Which property is fundamentally enforced on any column that has been successfully
designated as a relational table's primary key?
A) NULL
B) NOT NULL
C) NUMERIC
D) CASCADE
, Correct Answer: B Rationale: By definition, a primary key constraint combines the rules of
uniqueness and non-nullability. A primary key field can never contain a NULL value, ensuring
that every record can be distinctly identified.
Question 8
A database designer wants to limit entries within a Staff_Age column to values that fall
strictly between 18 and 65.
Which database constraint mechanism provides an analytical expression layer to validate
this input rule directly on the column?
A) UNIQUE
B) CHECK
C) FOREIGN KEY
D) RESTRICT
Correct Answer: B Rationale: The CHECK constraint evaluates user input against a boolean
expression before permitting structural data storage. If the expression evaluates to false, the
insert or update operation is blocked.
Section 3: Normalization Pipeline
Question 9
A database audit uncovers a legacy spreadsheet migration where a column named
Phone_Numbers contains multiple comma-separated values inside individual table cells
(e.g., "555-1234, 555-5678").
This configuration directly violates which relational normal form?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)
Correct Answer: A Rationale: First Normal Form requires that all column cell values must be
strictly atomic (meaning single, indivisible data values) and that the table has an established
primary key. Multi-valued or comma-delimited strings within a single attribute cell violate
1NF.
Question 10
A table is confirmed to be in First Normal Form (1NF). Its primary key is a composite key
consisting of (Project_ID, Employee_ID). An auditor notes that a non-key column called
