A database administrator is monitoring a database that is experiencing performance issues. The administrator notices that the disk I/O is consistently at 90% utilization, but the CPU utilization is only 30%. Which action should the administrator take to improve performance?

Increase the number of CPU cores to balance the load.

Disable the database's automatic checkpointing to reduce disk writes.

Increase the database's memory allocation to improve the buffer pool hit ratio.

Move the database files to a faster storage tier, such as SSD.

A database administrator is troubleshooting a database that is experiencing unexpected data loss. The administrator suspects that a specific user may have deleted data. The database has both transaction logs and audit logs enabled. Which source of information should the administrator use to identify the user and the exact data deleted?

Review the transaction logs to find the DELETE operations.

Review the error logs to find any errors related to data deletion.

Review the performance metrics to identify unusual activity.

Review the audit logs to find DELETE operations by the suspected user.

A database administrator is investigating a data integrity issue. The administrator suspects that an unauthorized user may have modified data. Which source of information should the administrator review first to identify the user and the exact changes made?

The database's transaction logs

The database's performance metrics

CompTIADataSys+

Domain 3Objective 1

Monitoring and Reporting DS0-001 Practice Questions (Page 1)

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

15questions here

3free pages

4concepts

25%of the exam

Questions 1–5

1application · medium
A database administrator is monitoring a database that is experiencing performance issues. The administrator notices that the disk I/O is consistently at 90% utilization, but the CPU utilization is only 30%. Which action should the administrator take to improve performance?
Select an answer first
2expert · medium
A database administrator is troubleshooting a database that is experiencing unexpected data loss. The administrator suspects that a specific user may have deleted data. The database has both transaction logs and audit logs enabled. Which source of information should the administrator use to identify the user and the exact data deleted?
Select an answer first
3foundation · easy
Which resource utilization metric indicates the percentage of time the database server's processor is busy?
Select an answer first
4application · easy
A database administrator is investigating a data integrity issue. The administrator suspects that an unauthorized user may have modified data. Which source of information should the administrator review first to identify the user and the exact changes made?
Select an answer first
5foundation · easy
A database administrator wants to determine if the database server has sufficient memory for its workload. Which resource utilization metric should be reviewed?
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.

Monitoring and Reporting DS0-001 Practice Questions (Page 1)

Questions 1–5

A database administrator is monitoring a database that is experiencing performance issues. The administrator notices that the disk I/O is consistently at 90% utilization, but the CPU utilization is only 30%. Which action should the administrator take to improve performance?

Which resource utilization metric indicates the percentage of time the database server's processor is busy?

A database administrator is investigating a data integrity issue. The administrator suspects that an unauthorized user may have modified data. Which source of information should the administrator review first to identify the user and the exact changes made?

A database administrator wants to determine if the database server has sufficient memory for its workload. Which resource utilization metric should be reviewed?

Keep studying — Database management and maintenance