Maintenance Processes DS0-001 Practice Questions (Page 2)

Questions 6–10

1. 6application · medium

   A database administrator notices that a frequently run reporting query is taking 30 seconds to complete. The query joins three large tables and filters on a non-indexed date column. The administrator examines the query execution plan and sees a table scan on the largest table. Which action should the administrator take first to improve query performance?

   • AIncrease the memory allocated to the database server.
   • BCreate a nonclustered index on the date column used in the WHERE clause.
   • CCreate a clustered index on the date column of the largest table.
   • DRewrite the query to use a subquery instead of a join.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   What is a primary drawback of creating too many indexes on a table?

   • AThey slow down SELECT queries
   • BThey prevent the database from using the query optimizer
   • CThey consume storage and slow down data modification operations
   • DThey automatically cause table fragmentation
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A database administrator needs to set up proactive monitoring for a new production database. The goal is to be alerted before a disk space shortage causes an outage. Which monitoring approach is most effective?

   • AMonitor CPU utilization of the database server.
   • BSet up an alert that triggers when the database file size reaches 90% of the maximum allocated size.
   • CManually check disk space once a week.
   • DMonitor the database error log for disk-related errors.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which of the following is a common database monitoring technique?

   • ADeleting old backup files
   • BChanging the database's default character set
   • CRenaming database tables
   • DTracking query response times
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which of the following is a best practice before applying a database patch to a production environment?

   • AApply the patch directly to production to save time
   • BTest the patch in a non-production environment
   • CSkip the patch if the database is running fine
   • DDisable all database monitoring during the patch
   Reveal Solution Discussion Select an answer first