PrepAway - Latest Free Exam Questions & Answers

Tag: sql server drop certificate 15352

What should you do?

You work as the database administrator at Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that runs on a Windows Server 2003 computer. Certkiller -DB01 hosts a database named CK_Sales that is used to store sales information for the company. You create a maintenance job named DB_Job for Certkiller -DB01 and configure the job to run when the processor utilization on the server drops below 15%. A week later you notice that the scheduled maintenance job has not yet run. You open System Monitor on Certkiller -DB01 and notice that the processor utilization is currently at approximately 5%. You need to ensure that the maintenance job runs when the processor utilization drops below 15%.
What should you do? (Each correct answer represents part of the solution. Choose two.)