A logistics company tracks shipments with data that varies in structure; each shipment may have different attributes such as weight, dimensions, or special handling notes. The company needs to store this data without enforcing a rigid schema and must support flexible queries. Which data storage model is most appropriate?

Relational model with a fixed schema

Columnar model with fixed columns

Key-value model with simple key-value pairs

Document model with JSON documents

Which of the following is a common technique to improve database query performance?

Storing all data in a single table

Using appropriate indexes on frequently queried columns

Adding more indexes to every column

What is the purpose of database connection pooling?

To automatically scale the database

To reduce the overhead of establishing new database connections

To encrypt all database traffic

An e-commerce application frequently queries a large product table by product ID and also needs to search for products by name and category. The database is experiencing slow query performance. Which optimization technique would most directly improve query performance for these access patterns?

Increase the database server's memory

Use a read replica for all queries

Add indexes on the product ID, name, and category columns

Denormalize the product table into a single wide table

CompTIACloud+

Domain 1Objective 6

Database Fundamentals CV0-004 Practice Questions (Page 2)

Part of the Cloud architecture domain, which accounts for 23% of the CV0-004 exam. CompTIA does not publish an official question count, but from its 90-minute exam (~35–60 total, ~8–14 in this domain), expect 1–2 from this objective — we provide 37 practice questions to prepare you well beyond it. (estimate)

37questions here

8free pages

10concepts

23%of the exam

Questions 6–10

6application · medium
A logistics company tracks shipments with data that varies in structure; each shipment may have different attributes such as weight, dimensions, or special handling notes. The company needs to store this data without enforcing a rigid schema and must support flexible queries. Which data storage model is most appropriate?
Select an answer first
7foundation · easy
Which of the following is a common technique to improve database query performance?
Select an answer first
8foundation · easy
What is the purpose of database connection pooling?
Select an answer first
9application · medium
A retail company is building a product catalog that stores product details, categories, and inventory levels. The catalog data has a clear schema with relationships between products and categories, and the company requires ACID transactions for inventory updates. The data volume is expected to grow steadily but will remain well within the limits of a single server. Which database type is most appropriate?
Select an answer first
10application · medium
An e-commerce application frequently queries a large product table by product ID and also needs to search for products by name and category. The database is experiencing slow query performance. Which optimization technique would most directly improve query performance for these access patterns?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to CV0-004

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. “CV0-004” is a trademark of its owner, used for identification only.

Database Fundamentals CV0-004 Practice Questions (Page 2)

Questions 6–10

Which of the following is a common technique to improve database query performance?

What is the purpose of database connection pooling?

An e-commerce application frequently queries a large product table by product ID and also needs to search for products by name and category. The database is experiencing slow query performance. Which optimization technique would most directly improve query performance for these access patterns?

Keep studying — Cloud architecture