WGU Data Management - Foundations Exam - Topic 4 Question 10 Discussion

Actual exam question for WGU's WGU Data Management - Foundations exam

Question #: 10
Topic #: 4

[All WGU Data Management - Foundations Questions]

What is the role of the transaction manager within the database system architecture?

AThe transaction manager uses information from the catalog to perform query optimization.

BThe transaction manager is composed of a query processor, storage manager, transaction manager, log, and catalog.

CThe transaction manager logs insert, update, and delete queries, and the result is sent back to the application.

DThe transaction manager translates the query processor instructions into filesystem commands and uses an index to quickly locate the requested data.

Show Suggested Answer

Suggested Answer: C

A Transaction Manager ensures ACID (Atomicity, Consistency, Isolation, Durability) properties in database transactions. It manages concurrent transactions, ensuring no conflicts occur and logs modifications to support recovery mechanisms.

Option A (Incorrect): Query optimization is managed by the query processor, not the transaction manager.

Option B (Incorrect): The transaction manager is a component of the database architecture but is not composed of the entire system (query processor, storage manager, etc.).

Option C (Correct): The transaction manager logs transactions like INSERT, UPDATE, and DELETE, ensuring consistency and recoverability.

Option D (Incorrect): The storage manager is responsible for translating queries into file system commands.

by Graciela at May 04, 2026, 05:39 PM

Limited Time Offer

25%

Off

Get Premium WGU Data Management - Foundations Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Carole

17 days ago

I feel like I've seen a question similar to this before, and I think the transaction manager does more than just logging. Maybe it's option B?

upvoted 0 times

...

Louisa

22 days ago

I think option C sounds familiar because we discussed how transaction managers log operations, but I can't recall if that's the complete picture.

upvoted 0 times

...

Ellen

27 days ago

I remember the transaction manager is crucial for ensuring data integrity, but I'm not sure which option really captures its role.

upvoted 0 times

...