CompTIA Data+ (DA0-001) — Question 264

Which of the following database types is the best to use for transactional SQL?

Answer options

• A. Snowflake schema
• B. Hierarchical
• C. Relational
• D. Star schema

Correct answer: C

Explanation

The correct answer is C, as relational databases are specifically designed to handle transactions with ACID properties, making them ideal for SQL operations. Options A and D, while useful for organizing data, are more suited for analytical queries rather than transactional processing. Option B, the Hierarchical database, lacks the flexibility and relational capabilities required for effective transaction management.