WGU C175/D426 Data Management Foundations
OA Actual Exam 2026/2027 | Detailed Rationales |
Complete Exam-Style Questions | Pass Guaranteed
– A+ Graded
Total Questions: 50 | Time: 90 min | Pass: 70%
TABLE OF CONTENTS
Section 1 | Database Concepts & Architecture | Q1 – Q10
Section 2 | SQL Fundamentals (DDL, DML, Queries) | Q11 – Q20
Section 3 | Database Design & Normalization | Q21 – Q30
Section 4 | Data Modeling (ERDs, Entities, Attributes) | Q31 – Q40
Section 5 | Transaction Management, Indexing & Security | Q41 – Q50
Instructions: Choose the single best answer. Pass: 70% in 90 minutes.
══════════════════════════════════════
SECTION 1: DATABASE CONCEPTS & ARCHITECTURE Q1 – Q10
══════════════════════════════════════
Question 1 of 50
A regional retail chain currently stores customer, inventory, and sales data in separate
Excel workbooks across twelve store locations. The operations director notices that the
same customer email appears with three different spellings across different files, and
consolidating quarterly reports takes three weeks. She proposes migrating to a
centralized relational database system. Which benefit of a DBMS most directly
addresses the email inconsistency problem?
A. Providing multiple user interfaces for different departments
B. Enforcing controlled redundancy and data integrity through centralized storage ✓
CORRECT
C. Eliminating the need for any backup procedures
,D. Increasing the maximum file size beyond spreadsheet limits
Correct Answer: B
Rationale: A DBMS enforces data integrity through constraints and centralized storage,
which prevents the same logical data from being stored inconsistently across separate
files. Increasing file size limits in choice D does not address the root cause of data
inconsistency caused by uncontrolled redundancy. In practice, data redundancy is the
primary reason organizations migrate from spreadsheets to databases, because even
small inconsistencies in customer records can corrupt marketing analytics and revenue
reporting.
Question 2 of 50
A hospital IT director is explaining the three-level ANSI-SPARC database architecture to
the board of trustees. He emphasizes that when the storage team replaced the old disk
arrays with solid-state drives last month, none of the billing or scheduling applications
required code changes. Which type of data independence did the hospital achieve?
A. Logical data independence from external view changes
B. External data independence from conceptual schema changes
C. Physical data independence from internal storage changes ✓ CORRECT
D. Conceptual data independence from logical restructuring
Correct Answer: C
Rationale: Physical data independence insulates the conceptual and external schemas
from changes in the physical storage layer, such as switching from disk arrays to
solid-state drives. Logical data independence in choice A refers to immunity from
changes in the conceptual schema, such as adding new tables, not from storage
hardware changes. This independence is critical because it allows database
administrators to tune performance by reorganizing storage without involving
application developers.
,Question 3 of 50
A university registrar maintains a student information system where academic advisors
see only course enrollment and GPA, financial aid officers see only tuition and payment
status, and faculty see only class rosters. All these views draw from the same
underlying tables but present different subsets. Which architecture concept makes this
selective presentation possible?
A. The internal schema controlling disk block allocation
B. The conceptual schema defining all university data relationships
C. The external schema providing user-specific views ✓ CORRECT
D. The data dictionary storing table row counts
Correct Answer: C
Rationale: The external schema defines customized views that present different
subsets of data to different user groups while hiding information they do not need to
see. The conceptual schema in choice B describes the overall logical structure of the
entire database but does not by itself create user-specific filtered perspectives. External
views are essential for security and usability because they allow a single database to
serve diverse stakeholders without exposing sensitive data such as financial records to
faculty or academic details to unauthorized staff.
Question 4 of 50
A database administrator at a financial services firm is auditing the system catalog to
verify that all tables storing personally identifiable information have encryption flags
enabled. The system catalog is part of which larger DBMS component?
A. The data dictionary ✓ CORRECT
B. The query optimizer
C. The transaction log buffer
D. The concurrency control manager
, Correct Answer: A
Rationale: The data dictionary, also called the system catalog, is the centralized
repository of metadata that stores definitions of all database objects including tables,
columns, constraints, and security attributes. The query optimizer in choice B uses the
dictionary but is not the repository itself; confusing the tool with the data store is a
common conceptual error. In production environments, the data dictionary is
indispensable for impact analysis because it allows DBAs to trace which applications
depend on specific columns before making schema changes.
Question 5 of 50
An e-commerce startup currently processes orders using a collection of CSV files
shared on a network drive. The engineering lead argues that as transaction volume
grows, this approach will cause update anomalies where two sales representatives
accidentally overwrite each other's changes to the same inventory file. Which DBMS
feature directly prevents this scenario?
A. File compression utilities that reduce storage footprint
B. Concurrency control mechanisms managing simultaneous multi-user access ✓
CORRECT
C. Spreadsheet password protection on shared workbooks
D. Automated cloud backup services with version history
Correct Answer: B
Rationale: DBMS concurrency control mechanisms, including locking and timestamp
protocols, manage simultaneous access by multiple users to ensure that concurrent
transactions do not corrupt data through lost updates. Password protection in choice C
prevents unauthorized opening but does nothing to coordinate concurrent edits by
authorized users. As transaction volume scales, the lack of concurrency control in
file-based systems becomes the primary bottleneck that forces companies to adopt
relational database systems.
OA Actual Exam 2026/2027 | Detailed Rationales |
Complete Exam-Style Questions | Pass Guaranteed
– A+ Graded
Total Questions: 50 | Time: 90 min | Pass: 70%
TABLE OF CONTENTS
Section 1 | Database Concepts & Architecture | Q1 – Q10
Section 2 | SQL Fundamentals (DDL, DML, Queries) | Q11 – Q20
Section 3 | Database Design & Normalization | Q21 – Q30
Section 4 | Data Modeling (ERDs, Entities, Attributes) | Q31 – Q40
Section 5 | Transaction Management, Indexing & Security | Q41 – Q50
Instructions: Choose the single best answer. Pass: 70% in 90 minutes.
══════════════════════════════════════
SECTION 1: DATABASE CONCEPTS & ARCHITECTURE Q1 – Q10
══════════════════════════════════════
Question 1 of 50
A regional retail chain currently stores customer, inventory, and sales data in separate
Excel workbooks across twelve store locations. The operations director notices that the
same customer email appears with three different spellings across different files, and
consolidating quarterly reports takes three weeks. She proposes migrating to a
centralized relational database system. Which benefit of a DBMS most directly
addresses the email inconsistency problem?
A. Providing multiple user interfaces for different departments
B. Enforcing controlled redundancy and data integrity through centralized storage ✓
CORRECT
C. Eliminating the need for any backup procedures
,D. Increasing the maximum file size beyond spreadsheet limits
Correct Answer: B
Rationale: A DBMS enforces data integrity through constraints and centralized storage,
which prevents the same logical data from being stored inconsistently across separate
files. Increasing file size limits in choice D does not address the root cause of data
inconsistency caused by uncontrolled redundancy. In practice, data redundancy is the
primary reason organizations migrate from spreadsheets to databases, because even
small inconsistencies in customer records can corrupt marketing analytics and revenue
reporting.
Question 2 of 50
A hospital IT director is explaining the three-level ANSI-SPARC database architecture to
the board of trustees. He emphasizes that when the storage team replaced the old disk
arrays with solid-state drives last month, none of the billing or scheduling applications
required code changes. Which type of data independence did the hospital achieve?
A. Logical data independence from external view changes
B. External data independence from conceptual schema changes
C. Physical data independence from internal storage changes ✓ CORRECT
D. Conceptual data independence from logical restructuring
Correct Answer: C
Rationale: Physical data independence insulates the conceptual and external schemas
from changes in the physical storage layer, such as switching from disk arrays to
solid-state drives. Logical data independence in choice A refers to immunity from
changes in the conceptual schema, such as adding new tables, not from storage
hardware changes. This independence is critical because it allows database
administrators to tune performance by reorganizing storage without involving
application developers.
,Question 3 of 50
A university registrar maintains a student information system where academic advisors
see only course enrollment and GPA, financial aid officers see only tuition and payment
status, and faculty see only class rosters. All these views draw from the same
underlying tables but present different subsets. Which architecture concept makes this
selective presentation possible?
A. The internal schema controlling disk block allocation
B. The conceptual schema defining all university data relationships
C. The external schema providing user-specific views ✓ CORRECT
D. The data dictionary storing table row counts
Correct Answer: C
Rationale: The external schema defines customized views that present different
subsets of data to different user groups while hiding information they do not need to
see. The conceptual schema in choice B describes the overall logical structure of the
entire database but does not by itself create user-specific filtered perspectives. External
views are essential for security and usability because they allow a single database to
serve diverse stakeholders without exposing sensitive data such as financial records to
faculty or academic details to unauthorized staff.
Question 4 of 50
A database administrator at a financial services firm is auditing the system catalog to
verify that all tables storing personally identifiable information have encryption flags
enabled. The system catalog is part of which larger DBMS component?
A. The data dictionary ✓ CORRECT
B. The query optimizer
C. The transaction log buffer
D. The concurrency control manager
, Correct Answer: A
Rationale: The data dictionary, also called the system catalog, is the centralized
repository of metadata that stores definitions of all database objects including tables,
columns, constraints, and security attributes. The query optimizer in choice B uses the
dictionary but is not the repository itself; confusing the tool with the data store is a
common conceptual error. In production environments, the data dictionary is
indispensable for impact analysis because it allows DBAs to trace which applications
depend on specific columns before making schema changes.
Question 5 of 50
An e-commerce startup currently processes orders using a collection of CSV files
shared on a network drive. The engineering lead argues that as transaction volume
grows, this approach will cause update anomalies where two sales representatives
accidentally overwrite each other's changes to the same inventory file. Which DBMS
feature directly prevents this scenario?
A. File compression utilities that reduce storage footprint
B. Concurrency control mechanisms managing simultaneous multi-user access ✓
CORRECT
C. Spreadsheet password protection on shared workbooks
D. Automated cloud backup services with version history
Correct Answer: B
Rationale: DBMS concurrency control mechanisms, including locking and timestamp
protocols, manage simultaneous access by multiple users to ensure that concurrent
transactions do not corrupt data through lost updates. Password protection in choice C
prevents unauthorized opening but does nothing to coordinate concurrent edits by
authorized users. As transaction volume scales, the lack of concurrency control in
file-based systems becomes the primary bottleneck that forces companies to adopt
relational database systems.
