CRISC · Question #384
If concurrent update transactions to an account are not processed properly, which of the following will MOST likely be affected?
The correct answer is D. Integrity. Improper processing of concurrent update transactions directly impacts data integrity, leading to inaccurate or inconsistent account balances.
Question
If concurrent update transactions to an account are not processed properly, which of the following will MOST likely be affected?
Options
- AConfidentiality
- BAccountability
- CAvailability
- DIntegrity
How the community answered
(31 responses)- A6% (2)
- B3% (1)
- D90% (28)
Why each option
Improper processing of concurrent update transactions directly impacts data integrity, leading to inaccurate or inconsistent account balances.
Confidentiality is about preventing unauthorized disclosure of information, which is not directly impacted by improper concurrent updates.
Accountability relates to being able to trace actions to an individual or entity, which is separate from the correctness of the data itself.
Availability refers to the system or data being accessible when needed, and while errors might lead to temporary unavailability, the primary and most likely impact of improper concurrent updates is on the data's correctness.
When concurrent update transactions are not processed properly, such as through a lack of proper concurrency control mechanisms, data integrity is compromised. This can result in lost updates, inconsistent data states, or incorrect account balances, where the data no longer accurately reflects the true state of the account. Integrity ensures that data is accurate, complete, and consistent throughout its lifecycle.
Concept tested: Data integrity in concurrent transactions
Source: https://learn.microsoft.com/en-us/sql/relational-databases/sql-server-transaction-locking-and-row-versioning-guide?view=sql-server-ver16#concurrency-control-types
Topics
Community Discussion
No community discussion yet for this question.