What is the primary purpose of eliminating data redundancy in a database?

To simplify the database schema

To improve data consistency and reduce update anomalies

To increase data storage capacity

A database has a CUSTOMERS table with sensitive columns like CreditCardNumber and SSN. A support team needs to see customer names and phone numbers but must not see sensitive data. What is the most appropriate way to provide this access?

Grant the support team SELECT permission on the CUSTOMERS table.

Create a view that includes only Name and PhoneNumber, and grant the support team SELECT permission on the view.

Create a new table with only Name and PhoneNumber and copy the data into it.

Encrypt the sensitive columns and grant the support team SELECT permission.

A business intelligence dashboard queries a large fact table to display daily sales totals. The query is complex and takes several seconds to run, causing the dashboard to load slowly. The underlying data is updated only once per day at 2:00 AM. Which solution would most improve dashboard performance?

Denormalize the fact table by adding a column for the daily total.

Add more indexes to the fact table on all columns used in the query.

Create a materialized view that pre-aggregates the daily sales totals and refresh it after the nightly data load.

Create a standard view that pre-aggregates the daily sales totals.

CompTIADataSys+

Domain 3Objective 4

Data Management Tasks DS0-001 Practice Questions (Page 2)

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

14questions here

3free pages

5concepts

25%of the exam

Questions 6–10

6foundation · easy
What is the primary purpose of eliminating data redundancy in a database?
Select an answer first
7application · medium
A database has a CUSTOMERS table with sensitive columns like CreditCardNumber and SSN. A support team needs to see customer names and phone numbers but must not see sensitive data. What is the most appropriate way to provide this access?
Select an answer first
8application · medium
A business intelligence dashboard queries a large fact table to display daily sales totals. The query is complex and takes several seconds to run, causing the dashboard to load slowly. The underlying data is updated only once per day at 2:00 AM. Which solution would most improve dashboard performance?
Select an answer first
9foundation · easy
Which constraint is used to enforce a relationship between two tables by ensuring that values in a column match values in another table's primary key?
Select an answer first
10foundation · easy
Which SQL statement is used to modify existing rows in a table?
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.

Data Management Tasks DS0-001 Practice Questions (Page 2)

Questions 6–10

What is the primary purpose of eliminating data redundancy in a database?

A database has a CUSTOMERS table with sensitive columns like CreditCardNumber and SSN. A support team needs to see customer names and phone numbers but must not see sensitive data. What is the most appropriate way to provide this access?

Which constraint is used to enforce a relationship between two tables by ensuring that values in a column match values in another table's primary key?

Which SQL statement is used to modify existing rows in a table?

Keep studying — Database management and maintenance