MongoDB MongoDB Transactions and ACID Compliance 3

Question 1

What is the 'snapshot' isolation level provided by MongoDB transactions?

Accepted Answer

All reads within the transaction see a consistent snapshot of data as it existed at the transaction's start time

Answer

Snapshot isolation ensures all read operations within a transaction see a consistent view of the data as it existed at the logical transaction start time. This means the transaction is isolated from any committed or uncommitted changes made by concurrent transactions during its execution.

Question 2

In MongoDB 4.2+, what was extended regarding multi-document transactions?

Accepted Answer

Support for multi-document transactions on sharded clusters

Answer

MongoDB 4.2 extended multi-document ACID transactions to sharded clusters, which were previously only available for replica sets (introduced in 4.0). This allows atomic operations spanning multiple documents across multiple shards with full ACID guarantees.

Question 3

What does the ErrorLabel 'UnknownTransactionCommitResult' indicate?

Accepted Answer

The commit result is unknown due to network error; the application should retry the commitTransaction() call

Answer

'UnknownTransactionCommitResult' means a network error occurred during the commitTransaction() call and it is unknown whether the commit succeeded. The application should retry only the commit (not the entire transaction) — MongoDB's commit is idempotent, so retrying is safe.

Question 4

Which MongoDB feature allows you to perform read and write operations atomically within a single pipeline stage?

Accepted Answer

findAndModify / findOneAndUpdate

Answer

findAndModify (and its driver equivalents findOneAndUpdate, findOneAndReplace, findOneAndDelete) atomically find and modify a single document without needing an explicit multi-document transaction. These are atomic at the single-document level and are preferred for simple atomic operations.

Question 5

What is the purpose of the retryWrites connection string option in MongoDB?

Accepted Answer

Automatically retrying certain idempotent write operations once after transient network failures

Answer

retryWrites=true (the default in modern drivers) enables automatic retry of certain idempotent write operations (insert, update, delete, findAndModify) exactly once if they fail due to transient network errors or replica set elections. It does not apply to multi-statement transactions.

MongoDB Practice Test

MongoDB Practice Test

MongoDB MongoDB Transactions and ACID Compliance 3