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

, 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) Notransitive dependencies
• B) Nopartial dependencies
• C) All non-keyattributes depend on thewhole
primarykey
• D) Every determinant is acandidatekey
✅ Correct Answer: A
*Rationale: 3NF requires thatthetable is in 2NF (no
partial dependencies) and that thereareno
transitivedependencies (non-key attributes
shouldnotdepend on othernon-keyattributes).
Option B describes 2NF. Option D describes BCNF.
Option C is 2NF.*



3. Atable has attributes: EmployeeID,
EmployeeName, DepartmentID,
DepartmentName, and Salary. Functional
dependencies: EmployeeID → EmployeeName,
DepartmentID, Salary; DepartmentID →