CompTIADataSys+
Domain 3Objective 1
Monitoring and Reporting 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 15 practice questions to prepare you well beyond it. (estimate)
15questions here
3free pages
4concepts
25%of the exam
Questions 6–10
- 6
A database administrator is troubleshooting a database that is running out of disk space. The administrator suspects that the transaction log is growing excessively. Which metric should the administrator check to confirm this?
Select an answer first - 7
A database administrator wants to identify which queries are consuming the most CPU time. Which performance metric should be analyzed?
Select an answer first - 8
What is the primary purpose of a database transaction log?
Select an answer first - 9
A database administrator is monitoring a database that is experiencing intermittent performance issues. The administrator notices that the buffer pool hit ratio is high, but the page life expectancy (PLE) is low. The administrator also notices that the database has a large number of logical reads. Which action should the administrator take to improve performance?
Select an answer first - 10
A database administrator is monitoring a database that is experiencing slow response times. The administrator notices that the buffer pool hit ratio is 95%, but the average disk read latency is high. Which action should the administrator take to improve performance?
Select an answer first
Finished these 5 questions?
Review the revealed explanations, or continue through the curriculum.
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.