nerdexam
CompTIA

DA0-001 · Question #469

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

The correct answer is C. Relational. Relational databases are best suited for transactional SQL because they efficiently handle structured data and support ACID properties needed for transactions.

Data Concepts and Environments

Question

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

Options

  • ASnowflake schema
  • BHierarchical
  • CRelational
  • DStar schema

How the community answered

(24 responses)
  • B
    8% (2)
  • C
    88% (21)
  • D
    4% (1)

Explanation

Relational databases are best suited for transactional SQL because they efficiently handle structured data and support ACID properties needed for transactions.

Topics

#Database types#Relational databases#Transactional SQL#OLTP

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice