Choosing the right database Flashcards
What is the primary consideration when choosing the right database for an application?
a) The popularity of the database
b) The requirements of the application being built
c) The cost of the database software
d) The programming language used for development
b) The requirements of the application being built
Which theorem is mentioned as a framework for understanding database requirements?
a) ACID theorem
b) CAP theorem
c) BASE theorem
d) PACELC theorem
b) CAP theorem
When should a relational database (RDBMS) be used according to the text?
a) When performance across a large geographic region is required
b) When a dynamic query model is required and performance is not a concern
c) When data needs to be stored in a denormalized format
d) When the application requires high write throughput
b) When a dynamic query model is required and performance is not a concern
Which type of application would benefit more from a relational database (RDBMS)?
a) Applications requiring high geographic distribution
b) Applications serving data in an OLAP system paradigm
c) Applications with high write throughput and low latency
d) Applications requiring eventual consistency
b) Applications serving data in an OLAP system paradigm
When is a NoSQL database likely a better fit?
a) When a dynamic query model is required
b) When performance across a large geographic region is required
c) When strict ACID compliance is needed
d) When the application requires complex joins
b) When performance across a large geographic region is required
What is the main focus when deciding on a database according to the text?
a) The programming language used
b) The cost of the database
c) The data and how it needs to be served
d) The popularity of the database vendor
c) The data and how it needs to be served
Which of the following is NOT a characteristic of applications that benefit from a relational database?
a) Dynamic query model
b) OLAP system paradigm
c) High geographic distribution
d) Performance is not a primary concern
c) High geographic distribution
What does OLAP stand for in the context of database systems?
a) Online Analytical Processing
b) Online Application Logic Processing
c) Object-Level Access Protocol
d) Operational Load Allocation Process
a) Online Analytical Processing
Which of the following is a key advantage of NoSQL databases mentioned in the text?
a) Support for complex joins
b) Performance across large geographic regions
c) Strict ACID compliance
d) Dynamic query models
b) Performance across large geographic regions
What is the primary trade-off when choosing a relational database over a NoSQL database?
a) Geographic distribution
b) Performance for large-scale queries
c) Support for dynamic query models
d) Write throughput and low latency
c) Support for dynamic query models
Which of the following is a characteristic of applications that benefit from NoSQL databases?
a) Need for complex joins
b) High geographic distribution and performance
c) Strict ACID compliance
d) OLAP system paradigm
b) High geographic distribution and performance
What is the ultimate deciding factor when choosing a database according to the text?
a) The cost of the database
b) The programming language used
c) The data and how it needs to be served
d) The popularity of the database
c) The data and how it needs to be served
