Maintaining SQL SVR Instances

Question 1

Where would you look to retrieve a list of jobs that have failed?

• The SQL Server Agent error log
• The job history in SSMS
• The SQL Server error log
• The Windows event log

Answer 1

The job history in SSMS

EXPLANATION:

The job history within SSMS lists all the jobs that have executed, along with their execution status.

Exam Objective:
Maintaining SQL Server Instances

Exam SubObjective(s):
 Manage SQL Server Agent jobs.

Question 2

Your Orders database crashed last night, and you have determined that the crash was caused by a data file running out of space. What tool do you use to send a notification to an administrator as well as expand the data file before it runs out of space?

• Network Monitor
• Event Viewer
• System Monitor
• SQL Server Agent

Answer 2

SQL Server Agent

EXPLANATION:

You can configure a SQL Server Agent alert that notifies an operator as well as execute a job that can increase the space in the data file.

Exam Objective:
Maintaining SQL Server Instances

Exam SubObjective(s):
 Manage SQL Server Agent alerts.

Question 3

You have defined several policies that you want applied to all databases within an instance. How do you ensure that a database owner is not allowed to avoid the policy check with the least amount of administrative effort?

• Create a condition that checks all databases.
• Add the policy to a user-defined policy category and set the Mandate property.
• Add the policy to the default policy category.
• Check the policies manually against the instance.

Answer 3

Add the policy to the default policy category.

EXPLANATION:

The default category is configured with the Mandate property enabled. In addition, you cannot disable the Mandate property.

Exam Objective:
Maintaining SQL Server Instances

Exam SubObjective(s):
 Implement the declarative management framework (DMF).