What is the primary goal of database capacity planning?

To ensure the database can handle future growth without performance degradation

To make the database run faster than its design specifications

To eliminate the need for database backups

To reduce the number of database administrators needed

What is the purpose of setting up alerts in database monitoring?

To replace the need for regular database maintenance

To automatically fix all performance issues

To increase the database's storage capacity

To notify administrators when performance metrics exceed thresholds

A database administrator is setting up monitoring for a database that experiences periodic performance degradation. The degradation is not consistent and is difficult to reproduce. The administrator wants to capture the state of the system when the issue occurs. Which monitoring technique is most appropriate?

Set up a SQL Server Agent job to run a diagnostic query every 5 minutes and log the results.

Increase the database's maximum memory setting to prevent the degradation.

Enable a lightweight tracing mechanism that captures queries that exceed a duration threshold.

Manually run sp_who2 or a similar command whenever the administrator notices the issue.

A database administrator is troubleshooting a performance issue where a specific query is slow only during certain times of the day. The administrator wants to identify the exact resource bottleneck. Which performance tuning tool should the administrator use first?

A dynamic management view that reports wait statistics.

A company's transaction database is currently 500 GB and grows at a rate of 20 GB per month. The company plans to retain data for an additional two years due to new regulatory requirements. The current storage system is at 80% capacity. What is the most important factor to consider for capacity planning?

The number of concurrent users accessing the database.

The version of the database management system in use.

The current CPU utilization of the database server.

The projected storage requirement based on the growth rate and the new retention period.

CompTIADataSys+

Domain 3Objective 2

Maintenance Processes DS0-001 Practice Questions (Page 4)

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 27 practice questions to prepare you well beyond it. (estimate)

27questions here

6free pages

8concepts

25%of the exam

Questions 16–20

16foundation · easy
What is the primary goal of database capacity planning?
Select an answer first
17foundation · easy
What is the purpose of setting up alerts in database monitoring?
Select an answer first
18expert · medium
A database administrator is setting up monitoring for a database that experiences periodic performance degradation. The degradation is not consistent and is difficult to reproduce. The administrator wants to capture the state of the system when the issue occurs. Which monitoring technique is most appropriate?
Select an answer first
19application · medium
A database administrator is troubleshooting a performance issue where a specific query is slow only during certain times of the day. The administrator wants to identify the exact resource bottleneck. Which performance tuning tool should the administrator use first?
Select an answer first
20application · medium
A company's transaction database is currently 500 GB and grows at a rate of 20 GB per month. The company plans to retain data for an additional two years due to new regulatory requirements. The current storage system is at 80% capacity. What is the most important factor to consider for capacity planning?
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.

Maintenance Processes DS0-001 Practice Questions (Page 4)

Questions 16–20

What is the primary goal of database capacity planning?

What is the purpose of setting up alerts in database monitoring?

A database administrator is troubleshooting a performance issue where a specific query is slow only during certain times of the day. The administrator wants to identify the exact resource bottleneck. Which performance tuning tool should the administrator use first?

Keep studying — Database management and maintenance