WGU D668 Advanced Data Management – Newest 2026 OA Exam Test Bank | 200+ Questions & Answers with Detailed Rationales | Complete A+ Study Guide

, WGU D668 Advanced Data Management –
Newest 2026 OA Exam Test Bank

200+ Questions & Answers with Detailed
Rationales

Complete A+ Guide for Objective
Assessment




Section 1: Database Design & Normalization
(Questions 1-30)



1. A database designer has a table with the
following functional dependencies:
• StudentID → StudentName, Major
• CourseID → CourseName, Credits
• StudentID, CourseID → Grade

, Which normal form is this relation in?
• A) First normal form (1NF)
• B) Second normal form (2NF)
• C) Third normal form (3NF)
• D) Boyce-Codd normal form (BCNF)
✅ Correct Answer: B
Rationale: The table has composite primary key
(StudentID, CourseID). Grade is fully functionally
dependent on the whole key, but StudentName
and Major depend only on StudentID (partial
dependency), and CourseName and Credits
depend only on CourseID (partial dependency).
Partial dependencies violate 2NF, so the table is
in 1NF but not 2NF. To reach 2NF, we would
decompose into three tables: Student, Course,
and Enrollment.



2. Which of the following is a characteristic of
Third Normal Form (3NF)?

, • A) No transitive dependencies
k k k




• B) No partial dependencies
k k k




• C) All non-key attributes depend on the whole
k k k k k k k




primary key
k k




• D) Every determinant is a candidate key
k k k k k k




✅ Correct Answer: A
k k k




*Rationale: 3NF requires that the table is in 2NF (no k k k k k k k k k




partial dependencies) and that there are no
k k k k k k k




transitive dependencies (non-key attributes
k k k k




should not depend on other non-key attributes).
k k k k k k k




Option B describes 2NF. Option D describes BCNF.
k k k k k k k k




Option C is 2NF.*
k k k k




3. A table has attributes: EmployeeID,
k k k k k




EmployeeName, DepartmentID,
k k




DepartmentName, and Salary. Functional
k k k k




dependencies: EmployeeID → EmployeeName,
k k k k




DepartmentID, Salary; DepartmentID →
k k k k