WGU D426 Data Management Foundations OA Actual Exam Questions and Answer Latest Update

1. A hospital monitors patient heart rates over time, generating billions of readings. Which data
characteristic does this illustrate?

 A) Format of data

 B) Access of data

 C) Scope of data

 D) Analog encoding of data
Correct answer: C Scope refers to the volume of data, which can be massive in continuous
monitoring scenarios.

2. A scientist records temperature changes on a vinyl record as continuous grooves. This
represents what type of data encoding?

 A) Digital data

 B) Analog data

 C) Operational data

 D) Analytic data
Correct answer: B Analog data uses physical continuous variations, unlike digital which
uses discrete binary values.

3. An online retailer stores active shopping cart data in RAM for millisecond response times. Which
database type is being used?

 A) Embedded database

 B) Federated database

 C) In-memory database

 D) Relational database
Correct answer: C In-memory databases prioritize speed by keeping data in volatile main
memory.

,4. A smart thermostat runs a small database inside its firmware without a separate server. This
describes which database type?

 A) In-memory database

 B) Embedded database

 C) Federated database

 D) Autonomous database
Correct answer: B An embedded database is tightly integrated into an application rather
than running independently.

5. A corporation links its Oracle sales database and MySQL inventory database under a single
query interface. What type of database is this?

 A) In-memory database

 B) Embedded database

 C) Federated database

 D) Relational database
Correct answer: C A federated database coordinates multiple participating databases
under a single software layer.

6. In a federated system, each participating database operates independently without requiring
coordination from others. This describes which property?

 A) Heterogeneous

 B) Autonomous

 C) Middleware

 D) Global catalog
Correct answer: B Autonomous databases in a federated system operate independently of
other participating databases.

7. A federated system connects an Oracle database and a MySQL database that have completely
different internal structures. This is called:

 A) Homogeneous databases

 B) Autonomous databases

,  C) Heterogeneous databases

 D) Replicated databases
Correct answer: C Heterogeneous databases either run under different database systems
or have incompatible schemas.

8. Which component in a federated database sits between application programs and the database
software to coordinate communication?

 A) Global catalog

 B) Database wrapper

 C) Middleware

 D) Nickname
Correct answer: C Middleware is software that lies between application programs and
database software.

9. A federated system maintains a directory of all participating tables, columns, and indexes. What
is this directory called?

 A) Middleware

 B) Global catalog

 C) Database wrapper

 D) User mapping
Correct answer: B The global catalog is a directory of participating database objects such
as tables, columns, and indexes.

10. In a federated database, which component breaks down a federated query into separate
queries for each participating database?

 A) Global query processor

 B) Database wrapper

 C) Middleware

 D) Global catalog
Correct answer: A The global query processor decomposes a federated query into queries
for each participating database.

, 11. Which federated component converts decomposed queries into the appropriate syntax for
each specific participating database?

 A) Global query processor

 B) Database wrapper

 C) Global catalog

 D) Nickname
Correct answer: B The database wrapper converts decomposed queries to the appropriate
syntax for each participating database.

12. A federated database uses a local name "prod_table" to refer to a remote table called
"product_inventory". This local name is a:

 A) Nickname

 B) User mapping

 C) Global catalog

 D) Middleware
Correct answer: A A nickname is the federated database name for a participating database
object like tables and columns.

13. A federated database associates user "bob" locally with user "admin" on a remote Oracle
database. This association is called:

 A) Nickname

 B) User mapping

 C) Global catalog

 D) Middleware
Correct answer: B User mapping associates a federated database user with a participating
database user.

14. A database administrator requests to retrieve all customer records from the database. This
request is formally called a:

 A) Transaction

 B) Query