350-901 Question #43: Real Exam Question with Answer & Explanation

The correct answer is D: relational. Relational databases are the appropriate choice for applications that require storing highly structured data and absolutely depend on strong ACID (Atomicity, Consistency, Isolation, Durability) transaction guarantees for data integrity.

Software Development and Design

Question

Which database type should be used with highly structured data and provides support for ACID transactions?

Options

Atime series
Bdocument
Cgraph
Drelational

Explanation

Relational databases are the appropriate choice for applications that require storing highly structured data and absolutely depend on strong ACID (Atomicity, Consistency, Isolation, Durability) transaction guarantees for data integrity.

Common mistakes.

A. Time series databases are specialized for handling data points indexed by time, not general-purpose highly structured data with strong ACID transactional needs.
B. Document databases are schema-less or have flexible schemas, which contrasts with the requirement for 'highly structured data', and their ACID support is often limited to single documents or eventually consistent.
C. Graph databases are optimized for data with complex relationships, not primarily for general-purpose highly structured tabular data with strict ACID transaction requirements.

Concept tested. Database types and characteristics - relational

Reference. https://learn.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview#relational-databases

Topics

#Database types#Relational databases#ACID transactions#Structured data

Community Discussion

No community discussion yet for this question.

Full 350-901 Practice Browse All 350-901 Questions