exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 57 discussion

Actual exam question from Microsoft's DP-900
Question #: 57
Topic #: 1
[All DP-900 Questions]

Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?

  • A. atomicity
  • B. isolation
  • C. durability
  • D. consistency
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
PatYeo
Highly Voted 2 years, 1 month ago
A is correct. https://www.databricks.com/glossary/acid-transactions A.C.I.D. properties: Atomicity, Consistency, Isolation, and Durability Atomicity - each statement in a transaction (to read, write, update or delete data) is treated as a single unit. Either the entire statement is executed, or none of it is executed. This property prevents data loss and corruption from occurring if, for example, if your streaming data source fails mid-stream.
upvoted 23 times
...
vizwiz
Highly Voted 1 year, 8 months ago
On exam March 9, 2023.
upvoted 5 times
...
heobanten04
Most Recent 7 months, 2 weeks ago
I took the exam on 30.03.2024 and got 936; this question appeared, correct answer: Atomicity
upvoted 1 times
...
AGTraining
8 months, 2 weeks ago
Selected Answer: A
option A
upvoted 1 times
...
trashbox
1 year ago
A. Appeared on 2023-11-05.
upvoted 1 times
...
AZFabio
1 year, 2 months ago
Selected Answer: A
correct
upvoted 1 times
...
rohirag
1 year, 4 months ago
Selected Answer: A
Atomicity
upvoted 1 times
...
VNR25
1 year, 4 months ago
This question appeared in the 07/07/23 exam and the answer is correct.
upvoted 1 times
...
mamahani
1 year, 7 months ago
I took the exam 12.04.2023 and got 1000, 100% score; this question appeared, correct answer: atomicity
upvoted 4 times
...
PhyoPluto
1 year, 8 months ago
the exam on 07/03/2023
upvoted 2 times
...
chiiiweiii
1 year, 8 months ago
Selected Answer: A
Correct Answer
upvoted 1 times
...
sreekan2
1 year, 10 months ago
Selected Answer: A
A is correct.
upvoted 1 times
...
Mannie_001
1 year, 12 months ago
Answer is correct
upvoted 1 times
...
edurakhan
2 years ago
Selected Answer: A
Atomicity is the correct answer
upvoted 2 times
...
JA2018
2 years, 1 month ago
Selected Answer: A
all operations must be successfully completed for the transaction to complete.
upvoted 3 times
...
raydel92
2 years, 1 month ago
Selected Answer: A
Correct answer is A. atomicity https://learn.microsoft.com/en-us/training/modules/explore-core-data-concepts/5-transactional-data-processing?ns-enrollment-type=learningpath&ns-enrollment-id=learn.wwl.azure-data-fundamentals-explore-core-data-concepts
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago