Skill 3.5: Monitor SQL Server Instances

QUESTION 1

__________________can create alerts based on an event occurring and a performance object counter meeting a threshold or WMI event.

		a. Enterprise Manager
		b. SQL Server Agent
		c. Query Analyzer
		d. None of the above

4 points   

QUESTION 2

SQL server performance condition alerts are based on SQL Server’s performance object counters.

		a. True
		b. False

4 points   

QUESTION 3

____________provides a framework which enables you to evaluate a single Server Instance to see if it confirms to a standard operating environment, or violates any standards or policies that might have a place.

		a. System Security center (SSC)
		b. Resource based modeling (RBM)
		c. Policy based management (PBM)
		d. None of the above

4 points   

QUESTION 4

___________________tracks the execution of a specified query in real-time. This report can be used to view performance degradation.

		a. Regressed queries
		b. Tracked queries
		c. Top Resource Consuming Queries
		d. None of the above

4 points   

QUESTION 5

Which database mail profile, once set, enables you to send emails via the database engine?

		a. Private
		b. Public
		c. Both A and B
		d. None of the above

4 points   

QUESTION 6

The SQL Server Agent can create alerts that will fire based on an event occurring and a performance object counter meeting a threshold or WMI event.

		a. True
		b. False

4 points   

QUESTION 7

Analysis Services and Reporting Services are pre-defined policies that are automatically setup during the install of SQL Server.

True

False

4 points   

QUESTION 8

The database mail account does not allow you to store information required by the database engine for using the SMTP gateway to send email.

		a. True
		b. False

4 points   

QUESTION 9

Which of the following is a profile type for a database mail profile?

		a. Public
		b. Private
		c. Hybrid
		d. Both A and B

4 points   

QUESTION 10

When you are using the ‘Evaluation Mode’ of Policy Based Management (PBM), which feature can be automated?

		a. On demand
		b. On schedule
		c. On change: log only
		d. All of the above