1
WGU C175/D426 DATA MANAGEMENT FOUNDATIONS
OA EXAM 2026/2027 | Newest Actual Exam 2 Latest
Versions | Q&A with Rationales | 100% Verified | Already
Graded A+ | Pass Guaranteed
[VERSION 1 - 70 QUESTIONS - ALREADY GRADED A+]
[V1A: Database Concepts & Architecture (Q1-12)]
Question 1 A university maintains separate Excel spreadsheets for student records in
each academic department. When a student changes their major, staff must manually
update the spreadsheet in the old department and create a new entry in the new
department, often resulting in conflicting phone numbers and addresses across files.
Which database characteristic, if implemented, would MOST directly eliminate this
specific problem?
A. Data independence
B. Data redundancy control
C. Data integrity enforcement
D. Data security
Rationale: Data redundancy control eliminates duplicate storage of the same data
across multiple files by maintaining a single shared repository. In this scenario, a
centralized database would store each student's contact information once,
eliminating the need for manual updates across departmental spreadsheets and
preventing conflicting values. Data independence (A) concerns schema changes not
affecting applications. Data integrity (C) enforces rules but doesn't inherently prevent
redundant storage. Data security (D) controls access, not duplication.
Correct Answer: B
Question 2 A retail corporation uses a database system where the marketing
department sees customer names and purchase histories without viewing credit card
,2
numbers, while the accounting department sees transaction amounts and payment
methods without viewing customer names. The database administrator sees the
complete raw storage structure including file locations and index pointers. Which
three-schema architecture levels are respectively represented by the marketing view,
accounting view, and DBA view?
A. External, External, Internal
B. Conceptual, External, Internal
C. External, Conceptual, Internal
D. External, External, Conceptual
Rationale: The marketing and accounting views are both external schemas (user-
specific views of data), while the DBA's view of physical storage structures represents
the internal schema. The conceptual schema would show the complete logical
structure without physical details. Therefore, the correct mapping is External, External,
Internal. The conceptual level (C, D) represents the organization-wide logical view,
not department-specific subsets.
Correct Answer: A
Question 3 A database administrator modifies the physical storage of a table from
row-based to columnar format to improve analytical query performance. No
application code changes are required, and all SQL queries continue to execute
identically. This scenario BEST demonstrates which type of data independence?
A. Logical data independence
B. Physical data independence
C. Schema mapping independence
D. Application independence
Rationale: Physical data independence ensures that changes to the internal/physical
level (storage structures, indexing, file organization) do not affect the conceptual or
external levels. Changing from row-based to columnar storage is a physical-level
modification. Logical data independence (A) would involve conceptual schema
changes (like adding a column) not affecting external views. Schema mapping (C)
and application independence (D) are not standard ANSI SPARC architecture terms.
,3
Correct Answer: B
Question 4 Which component of the DBMS is DIRECTLY responsible for parsing a
SQL query, checking syntax against the data dictionary, and generating an optimized
execution plan before the query is executed?
A. Storage manager
B. Transaction manager
C. Query processor
D. Data catalog
Rationale: The query processor (also called query compiler/optimizer) parses SQL
statements, validates them against the data dictionary/catalog, performs semantic
analysis, and generates an optimized execution plan. The storage manager (A)
handles physical I/O. The transaction manager (B) ensures ACID properties and
concurrency control. The data catalog (D) stores metadata but does not perform
parsing or optimization.
Correct Answer: C
Question 5 A hospital database stores patient records. When a nurse queries for a
patient's allergies, the system must retrieve data from disk, translate it into a format
the application understands, and ensure that concurrent updates by the pharmacy
department do not corrupt the record. Which DBMS functions are respectively
involved in these three operations?
A. Storage manager, Query processor, Transaction manager
B. Query processor, Storage manager, Transaction manager
C. Storage manager, Data dictionary, Concurrency controller
D. Storage manager, Query processor, Concurrency controller
Rationale: Retrieving data from disk is the storage manager's responsibility.
Translating raw data into application-usable format involves the query processor
(result formatting). Ensuring concurrent updates don't corrupt data is the transaction
, 4
manager's concurrency control function. While concurrency controller (D) describes
the function, "Transaction manager" (A) is the standard DBMS component name that
encompasses this responsibility per ANSI SQL:2023 architecture.
Correct Answer: A
Question 6 Which statement accurately describes the relationship between the data
dictionary and the system catalog in a modern DBMS?
A. The data dictionary is a subset of the system catalog containing only user-defined
tables
B. The system catalog is a subset of the data dictionary containing only physical
storage metadata
C. The terms are often used interchangeably; the catalog stores all metadata
including schemas, constraints, users, and statistics
D. The data dictionary stores only integrity constraints while the catalog stores
everything else
Rationale: In modern DBMS implementations (per ANSI SQL:2023 and ISO/IEC
9075), the system catalog (or data dictionary) stores comprehensive metadata
including base table definitions, views, constraints, user accounts, privileges, indexes,
and statistical information. The terms are frequently used interchangeably, though
"system catalog" is the preferred SQL standard term. Options A, B, and D incorrectly
partition metadata between the two concepts.
Correct Answer: C
Question 7 A database system guarantees that if a funds transfer transaction debits
$500 from Account A, it MUST also credit $500 to Account B, or neither operation
occurs. Additionally, once the transaction commits, the changes persist even if the
system crashes immediately after. Which two ACID properties are demonstrated?
A. Consistency and Durability
B. Atomicity and Durability
WGU C175/D426 DATA MANAGEMENT FOUNDATIONS
OA EXAM 2026/2027 | Newest Actual Exam 2 Latest
Versions | Q&A with Rationales | 100% Verified | Already
Graded A+ | Pass Guaranteed
[VERSION 1 - 70 QUESTIONS - ALREADY GRADED A+]
[V1A: Database Concepts & Architecture (Q1-12)]
Question 1 A university maintains separate Excel spreadsheets for student records in
each academic department. When a student changes their major, staff must manually
update the spreadsheet in the old department and create a new entry in the new
department, often resulting in conflicting phone numbers and addresses across files.
Which database characteristic, if implemented, would MOST directly eliminate this
specific problem?
A. Data independence
B. Data redundancy control
C. Data integrity enforcement
D. Data security
Rationale: Data redundancy control eliminates duplicate storage of the same data
across multiple files by maintaining a single shared repository. In this scenario, a
centralized database would store each student's contact information once,
eliminating the need for manual updates across departmental spreadsheets and
preventing conflicting values. Data independence (A) concerns schema changes not
affecting applications. Data integrity (C) enforces rules but doesn't inherently prevent
redundant storage. Data security (D) controls access, not duplication.
Correct Answer: B
Question 2 A retail corporation uses a database system where the marketing
department sees customer names and purchase histories without viewing credit card
,2
numbers, while the accounting department sees transaction amounts and payment
methods without viewing customer names. The database administrator sees the
complete raw storage structure including file locations and index pointers. Which
three-schema architecture levels are respectively represented by the marketing view,
accounting view, and DBA view?
A. External, External, Internal
B. Conceptual, External, Internal
C. External, Conceptual, Internal
D. External, External, Conceptual
Rationale: The marketing and accounting views are both external schemas (user-
specific views of data), while the DBA's view of physical storage structures represents
the internal schema. The conceptual schema would show the complete logical
structure without physical details. Therefore, the correct mapping is External, External,
Internal. The conceptual level (C, D) represents the organization-wide logical view,
not department-specific subsets.
Correct Answer: A
Question 3 A database administrator modifies the physical storage of a table from
row-based to columnar format to improve analytical query performance. No
application code changes are required, and all SQL queries continue to execute
identically. This scenario BEST demonstrates which type of data independence?
A. Logical data independence
B. Physical data independence
C. Schema mapping independence
D. Application independence
Rationale: Physical data independence ensures that changes to the internal/physical
level (storage structures, indexing, file organization) do not affect the conceptual or
external levels. Changing from row-based to columnar storage is a physical-level
modification. Logical data independence (A) would involve conceptual schema
changes (like adding a column) not affecting external views. Schema mapping (C)
and application independence (D) are not standard ANSI SPARC architecture terms.
,3
Correct Answer: B
Question 4 Which component of the DBMS is DIRECTLY responsible for parsing a
SQL query, checking syntax against the data dictionary, and generating an optimized
execution plan before the query is executed?
A. Storage manager
B. Transaction manager
C. Query processor
D. Data catalog
Rationale: The query processor (also called query compiler/optimizer) parses SQL
statements, validates them against the data dictionary/catalog, performs semantic
analysis, and generates an optimized execution plan. The storage manager (A)
handles physical I/O. The transaction manager (B) ensures ACID properties and
concurrency control. The data catalog (D) stores metadata but does not perform
parsing or optimization.
Correct Answer: C
Question 5 A hospital database stores patient records. When a nurse queries for a
patient's allergies, the system must retrieve data from disk, translate it into a format
the application understands, and ensure that concurrent updates by the pharmacy
department do not corrupt the record. Which DBMS functions are respectively
involved in these three operations?
A. Storage manager, Query processor, Transaction manager
B. Query processor, Storage manager, Transaction manager
C. Storage manager, Data dictionary, Concurrency controller
D. Storage manager, Query processor, Concurrency controller
Rationale: Retrieving data from disk is the storage manager's responsibility.
Translating raw data into application-usable format involves the query processor
(result formatting). Ensuring concurrent updates don't corrupt data is the transaction
, 4
manager's concurrency control function. While concurrency controller (D) describes
the function, "Transaction manager" (A) is the standard DBMS component name that
encompasses this responsibility per ANSI SQL:2023 architecture.
Correct Answer: A
Question 6 Which statement accurately describes the relationship between the data
dictionary and the system catalog in a modern DBMS?
A. The data dictionary is a subset of the system catalog containing only user-defined
tables
B. The system catalog is a subset of the data dictionary containing only physical
storage metadata
C. The terms are often used interchangeably; the catalog stores all metadata
including schemas, constraints, users, and statistics
D. The data dictionary stores only integrity constraints while the catalog stores
everything else
Rationale: In modern DBMS implementations (per ANSI SQL:2023 and ISO/IEC
9075), the system catalog (or data dictionary) stores comprehensive metadata
including base table definitions, views, constraints, user accounts, privileges, indexes,
and statistical information. The terms are frequently used interchangeably, though
"system catalog" is the preferred SQL standard term. Options A, B, and D incorrectly
partition metadata between the two concepts.
Correct Answer: C
Question 7 A database system guarantees that if a funds transfer transaction debits
$500 from Account A, it MUST also credit $500 to Account B, or neither operation
occurs. Additionally, once the transaction commits, the changes persist even if the
system crashes immediately after. Which two ACID properties are demonstrated?
A. Consistency and Durability
B. Atomicity and Durability
