For which use case is a NoSQL database generally more suitable than a SQL database?

Handling rapidly evolving data models with high write throughput

Generating complex reports with multi-table joins

Managing financial transactions that require strict ACID compliance

Storing highly structured data with complex relationships

A financial institution is required to maintain strict data integrity for all transactions, including atomicity and rollback capabilities. They also need to generate real-time reports that aggregate data across multiple tables. The current system uses a NoSQL database, but the reporting team is struggling to produce accurate reports due to inconsistent data. What is the best course of action?

Use a graph database to model transaction relationships

Migrate to a relational database that supports ACID transactions

Use a key-value store with strong consistency

Keep the NoSQL database and implement application-level transactions

A startup is building a mobile app that needs to store user-generated content. They expect rapid growth and want to avoid database downtime during scaling. They also need to support flexible query patterns as features evolve. Which database choice best meets these needs?

A relational database with manual sharding

A NoSQL database with automatic horizontal scaling

A relational database with vertical scaling

A graph database with vertical scaling

A news website stores articles in MongoDB. Each article has a title, author, publish date, and a list of tags. The website needs to display articles that match a specific tag, sorted by publish date. What is the most appropriate way to model and query this data in MongoDB?

Store tags as an array and create a compound index on tags and publish date

Store each tag as a separate document and use joins

Store tags as a comma-separated string and use regex queries

Create a separate collection for tags and use $lookup

CompTIADataSys+

Domain 1Objective 1

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

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 11–15

11foundation · easy
Which type of non-relational database is best suited for representing highly interconnected data, such as social networks or recommendation engines?
Select an answer first
12foundation · easy
For which use case is a NoSQL database generally more suitable than a SQL database?
Select an answer first
13expert · hard
A financial institution is required to maintain strict data integrity for all transactions, including atomicity and rollback capabilities. They also need to generate real-time reports that aggregate data across multiple tables. The current system uses a NoSQL database, but the reporting team is struggling to produce accurate reports due to inconsistent data. What is the best course of action?
Select an answer first
14application · medium
A startup is building a mobile app that needs to store user-generated content. They expect rapid growth and want to avoid database downtime during scaling. They also need to support flexible query patterns as features evolve. Which database choice best meets these needs?
Select an answer first
15application · medium
A news website stores articles in MongoDB. Each article has a title, author, publish date, and a list of tags. The website needs to display articles that match a specific tag, sorted by publish date. What is the most appropriate way to model and query this data in MongoDB?
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 3)

Questions 11–15

Which type of non-relational database is best suited for representing highly interconnected data, such as social networks or recommendation engines?

For which use case is a NoSQL database generally more suitable than a SQL database?

A startup is building a mobile app that needs to store user-generated content. They expect rapid growth and want to avoid database downtime during scaling. They also need to support flexible query patterns as features evolve. Which database choice best meets these needs?

A news website stores articles in MongoDB. Each article has a title, author, publish date, and a list of tags. The website needs to display articles that match a specific tag, sorted by publish date. What is the most appropriate way to model and query this data in MongoDB?

Keep studying — Database fundamentals