WGU D027 ADVANCED DATA
MANAGEMENT PROFESSIONAL
ASSESSMENT QUESTIONS AND
ANSWERS
1. Which normal form specifically addresses the issue of overlapping candidate keys where a
determinant is not a candidate key?
A. Second Normal Form (2NF)
B. Boyce-Codd Normal Form (BCNF)
C. Third Normal Form (3NF)
D. Fourth Normal Form (4NF)
Answer: B
Conceptual Explanation: BCNF is a stronger version of 3NF that handles cases where a
table has multiple overlapping candidate keys, requiring every determinant to be a
candidate key.
,2. In the context of ACID properties, which property ensures that a transaction is treated as a
single unit, which either succeeds completely or fails completely?
A. Consistency
B. Durability
C. Isolation
D. Atomicity
Answer: D
Conceptual Explanation: Atomicity ensures that all operations within a transaction are
completed; if any part fails, the entire transaction is rolled back.
3. Which type of index is most efficient for queries involving range comparisons (e.g.,
BETWEEN, >, <)?
A. Hash Index
B. Bitmap Index
C. B-Tree Index
D. Function-based Index
Answer: C
Conceptual Explanation: B-Tree indexes maintain data in a sorted order, making them
highly efficient for range-based queries compared to Hash indexes which are better for
equality.
, 4. What is the primary purpose of the ‘Transform’ step in the ETL (Extract, Transform, Load)
process?
A. To extract data from various source systems.
B. To back up original source data for audit purposes.
C. To physically move data into the production environment.
D. To ensure data conforms to the schema of the target data warehouse.
Answer: D
Conceptual Explanation: Transformation involves cleaning, filtering, and reformatting
data to ensure it aligns with the target database’s business rules and structure.
5. Which concurrency control problem occurs when a transaction reads data that has been
modified by another transaction but not yet committed?
A. Lost Update
B. Non-repeatable Read
C. Phantom Read
D. Dirty Read
Answer: D
Conceptual Explanation: A dirty read happens when a transaction accesses uncommitted
changes made by another transaction, which might eventually be rolled back.
MANAGEMENT PROFESSIONAL
ASSESSMENT QUESTIONS AND
ANSWERS
1. Which normal form specifically addresses the issue of overlapping candidate keys where a
determinant is not a candidate key?
A. Second Normal Form (2NF)
B. Boyce-Codd Normal Form (BCNF)
C. Third Normal Form (3NF)
D. Fourth Normal Form (4NF)
Answer: B
Conceptual Explanation: BCNF is a stronger version of 3NF that handles cases where a
table has multiple overlapping candidate keys, requiring every determinant to be a
candidate key.
,2. In the context of ACID properties, which property ensures that a transaction is treated as a
single unit, which either succeeds completely or fails completely?
A. Consistency
B. Durability
C. Isolation
D. Atomicity
Answer: D
Conceptual Explanation: Atomicity ensures that all operations within a transaction are
completed; if any part fails, the entire transaction is rolled back.
3. Which type of index is most efficient for queries involving range comparisons (e.g.,
BETWEEN, >, <)?
A. Hash Index
B. Bitmap Index
C. B-Tree Index
D. Function-based Index
Answer: C
Conceptual Explanation: B-Tree indexes maintain data in a sorted order, making them
highly efficient for range-based queries compared to Hash indexes which are better for
equality.
, 4. What is the primary purpose of the ‘Transform’ step in the ETL (Extract, Transform, Load)
process?
A. To extract data from various source systems.
B. To back up original source data for audit purposes.
C. To physically move data into the production environment.
D. To ensure data conforms to the schema of the target data warehouse.
Answer: D
Conceptual Explanation: Transformation involves cleaning, filtering, and reformatting
data to ensure it aligns with the target database’s business rules and structure.
5. Which concurrency control problem occurs when a transaction reads data that has been
modified by another transaction but not yet committed?
A. Lost Update
B. Non-repeatable Read
C. Phantom Read
D. Dirty Read
Answer: D
Conceptual Explanation: A dirty read happens when a transaction accesses uncommitted
changes made by another transaction, which might eventually be rolled back.
