If a transaction fails partway through in an OLTP system, what should happen to the work that already started?

AIt should remain partially committed for later repair

BIt should be rolled back as a single unit

CIt should be converted to a report

DIt should be archived to cold storage

More Describe core data concepts Questions

61 questions

Full Microsoft Certified: Azure Data Fundamentals Practice Test

All topics covered

All Microsoft Certified: Azure Data Fundamentals Questions

Browse by topic

Related Questions

Which description best matches structured data?...

easy

A team stores device events as JSON documents where fields can vary between records. How should this...

easy

A media company is archiving product photos and training videos. Which type of data is it primarily ...

easy

A new order management application requires joins, strong consistency, and a fixed schema. Which typ...

medium

A finance team exports daily sales data as comma-delimited text files with one row per transaction. ...

medium

View all Describe core data concepts questions

Educational Content — CertQnA practice questions are written against official exam objectives, covering the same domains tested on the real exam. All content is original and independent — not actual exam questions, not affiliated with any certification vendor. Learn more about our content policy

Discussion

Be the first to share your understanding of this concept

⚠️ Discussion is for concept clarification only. Do not share or request actual exam questions or answers.