Which of the following is a primary difference between SQL and NoSQL databases?

SQL databases use a fixed schema, while NoSQL databases often use a flexible schema

SQL databases are always faster than NoSQL databases

NoSQL databases do not support any form of querying

SQL databases cannot handle large volumes of data

Which use case is best suited for a non-relational database?

A content management system with flexible, evolving document structures

An enterprise resource planning (ERP) system with complex reporting

A system that requires strong consistency across distributed nodes

A banking system that requires strict ACID transactions

Which scenario is best suited for a relational database?

Storing session data for a web application with high read/write rates

Storing user profiles with varying attributes for a social media platform

Managing an inventory system with complex relationships between products, orders, and suppliers

Collecting real-time sensor data from millions of IoT devices

CompTIADataSys+

Domain 1Objective 1

Database Structure Types DS0-001 Practice Questions (Page 2)

Part of the Database fundamentals domain, which accounts for 24% of the DS0-001 exam. CompTIA does not publish an official question count, but from its 90-minute exam (~35–60 total, ~8–14 in this domain), expect 2–4 from this objective — we provide 33 practice questions to prepare you well beyond it. (estimate)

33questions here

7free pages

9concepts

24%of the exam

Questions 6–10

6foundation · easy
Which of the following is a primary difference between SQL and NoSQL databases?
Select an answer first
7foundation · easy
Which use case is best suited for a non-relational database?
Select an answer first
8foundation · easy
Which scenario is best suited for a relational database?
Select an answer first
9application · medium
A real-time recommendation engine needs to store user preferences and item attributes. The data is accessed by key (user ID or item ID) and requires extremely low latency. The team expects to scale to billions of records. Which database type is most appropriate?
Select an answer first
10foundation · easy
Which non-relational database type stores data as collections of documents, typically in JSON or BSON format?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DS0-001

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by CompTIA. “DS0-001” is a trademark of its owner, used for identification only.

Database Structure Types DS0-001 Practice Questions (Page 2)

Questions 6–10

Which of the following is a primary difference between SQL and NoSQL databases?

Which use case is best suited for a non-relational database?

Which scenario is best suited for a relational database?

A real-time recommendation engine needs to store user preferences and item attributes. The data is accessed by key (user ID or item ID) and requires extremely low latency. The team expects to scale to billions of records. Which database type is most appropriate?

Which non-relational database type stores data as collections of documents, typically in JSON or BSON format?

Keep studying — Database fundamentals