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

 

"Get Help With Your Essay
. If you need assistance with writing your essay, our professional essay writing service is here to help!

Order Now