Question 1

It is always preferable to quantitatively measure performance rather than relying on the experience of an individual database administrator.

Accepted Answer

A) True 
 B)False

Question 2

Which range of SQL Server error message severity levels are user-generated messages that must be fixed by the user?

Accepted Answer

A) 1-10 
B) 11-16 
C) 17-10 
D) 20-25 
A) 1-10 
B) 11-16 
C) 17-10 
D) 20-25

Question 3

Match between columns
                        Premises: a message generated automatically in response to a system event or when a performance condition is met
a mechanism that enables certain server-level or database-level events to be captured and written to a target
rules defined by placing a threshold on the value of a specific performance counter monitored by SQL Server Agent
contains system events as well as certain user-defined events for the SQL Server instance
a numerical indicator that describes the type of SQL Server error; can be used to specify whether an alert should be generated
a dynamic management view or function that operates at the level of the SQL Server instance
A dynamic management view or function that allows information in an individual user database to be retrieved
a feature of the Management Data Warehouse on a SQL Server instance that is used to capture several different types of data
the process of using a baseline to compare against current system performance
an alias for an individual or group of people with their email or pager information

Accepted Answer

The Answer of SQL Server Audit and severity level and is...

Question 4

When is the ideal time to measure system performance to form a baseline?

Accepted Answer

A) before the system is put into production 
B) under normal operating loads 
C) on weekends, when there is little use 
D) after a series of complaints that the system is performing poorly 
A) before the system is put into production 
B) under normal operating loads 
C) on weekends, when there is little use 
D) after a series of complaints that the system is performing poorly

Question 5

What is the first priority of a database administrator in determining the proper functioning of a SQL Server instance?

Accepted Answer

The first priority for a database admini

Question 6

For which type of event are notifications and alerts generally NOT sent?

Accepted Answer

A) SQL Server Agent job failure 
B) High CPU or memory utilization 
C) Deadlocks 
D) SQL Server errors with severity 1-10 
A) SQL Server Agent job failure 
B) High CPU or memory utilization 
C) Deadlocks 
D) SQL Server errors with severity 1-10

Question 7

A data collector set is a collection of statistics captured and viewed in real time.

Accepted Answer

A) True 
 B)False

Question 8

What permissions must a user have in order to view data in Activity Monitor? What happens if the user runs the tool but lacks sufficient permissions?

Accepted Answer

To view data in Activity Monitor, a user

Question 9

SQL Server ____________ Monitor is a dashboard that allows you to monitor system behavior through a simple graphical user interface.

Accepted Answer

The answer of SQL Server ____________ Monitor is a dashboard...

Question 10

After establishing the current state of a SQL Server instance, databases, and network connections, what should a database administrator check next?

Accepted Answer

The database administrator sho

Question 11

Which of the following is NOT part of the process of creating a database audit?

Accepted Answer

A) create an audit user and assign the AUDIT DB permission 
B) define an audit object 
C) create the server audit specification 
D) enable the audit to begin capturing events 
A) create an audit user and assign the AUDIT DB permission 
B) define an audit object 
C) create the server audit specification 
D) enable the audit to begin capturing events

Question 12

A ______________ is a set of recorded performance results that can be used as future comparison points.

Accepted Answer

The answer of A ______________ is a set of recorded...

Question 13

Describe how a database administrator can distinguish between normal and abnormal SQL Server activity.

Accepted Answer

To distinguish between normal and abnorm

Question 14

Performance ___________ are rules defined by placing a threshold on the value of a specific performance counter monitored by SQL Server Agent.

Accepted Answer

The answer of Performance ___________ are rules defined by placing...

Question 15

How must the recipient of a notification be configured in SQL Server Agent?

Accepted Answer

A) as a mail recipient 
B) as an alert administrator 
C) as an operator 
D) as an Agent manager 
A) as a mail recipient 
B) as an alert administrator 
C) as an operator 
D) as an Agent manager

Question 16

To get an accurate view of SQL Server performance using SQL Server Activity Monitor without affecting overall system performance, how often should the server be polled?

Accepted Answer

A) 10 times/second 
B) 1 time/second 
C) 1 time/10 seconds 
D) 10 times/minute 
A) 10 times/second 
B) 1 time/second 
C) 1 time/10 seconds 
D) 10 times/minute

Question 17

Which of the following is true about the Management Data Warehouse?

Accepted Answer

A) there are no predefined data collection sets 
B) it is installed automatically with SQL Server 
C) management reports must be custom made 
D) data may be queried using SQL 
A) there are no predefined data collection sets 
B) it is installed automatically with SQL Server 
C) management reports must be custom made 
D) data may be queried using SQL

Question 18

List the main ranges of severity levels and their function.

Accepted Answer

1-10-Messages generated by a SQL Server

Question 19

A database administrator must ____________ monitor each SQL Server instance to minimize the risk of service disruption.

Accepted Answer

The answer of A database administrator must ____________ monitor each...

It is always preferable to quantitatively measure performance rather than relying on the experience of an individual database administrator.

Which range of SQL Server error message severity levels are user-generated messages that must be fixed by the user?

When is the ideal time to measure system performance to form a baseline?

What is the first priority of a database administrator in determining the proper functioning of a SQL Server instance?

For which type of event are notifications and alerts generally NOT sent?

A data collector set is a collection of statistics captured and viewed in real time.

What permissions must a user have in order to view data in Activity Monitor? What happens if the user runs the tool but lacks sufficient permissions?

SQL Server ____________ Monitor is a dashboard that allows you to monitor system behavior through a simple graphical user interface.

After establishing the current state of a SQL Server instance, databases, and network connections, what should a database administrator check next?

Which of the following is NOT part of the process of creating a database audit?

A ______________ is a set of recorded performance results that can be used as future comparison points.

Describe how a database administrator can distinguish between normal and abnormal SQL Server activity.

Performance ___________ are rules defined by placing a threshold on the value of a specific performance counter monitored by SQL Server Agent.

How must the recipient of a notification be configured in SQL Server Agent?

To get an accurate view of SQL Server performance using SQL Server Activity Monitor without affecting overall system performance, how often should the server be polled?

Which of the following is true about the Management Data Warehouse?

List the main ranges of severity levels and their function.

A database administrator must ____________ monitor each SQL Server instance to minimize the risk of service disruption.

Introduction to SQL Server 2012

Deploying SQL Server 2012

Architecture and Configuration

Creating SQL Server 2012 Databases

Transact:SQL Primer

SQL Server Security

Performance Monitoring and Optimization

Backup and Recovery

Data Integration

Filters

Exam 10: Monitoring SQL Server 2012

It is always preferable to quantitatively measure performance rather than relying on the experience of an individual database administrator.

Which range of SQL Server error message severity levels are user-generated messages that must be fixed by the user?

When is the ideal time to measure system performance to form a baseline?

What is the first priority of a database administrator in determining the proper functioning of a SQL Server instance?

For which type of event are notifications and alerts generally NOT sent?

A data collector set is a collection of statistics captured and viewed in real time.

What permissions must a user have in order to view data in Activity Monitor? What happens if the user runs the tool but lacks sufficient permissions?

SQL Server ____________ Monitor is a dashboard that allows you to monitor system behavior through a simple graphical user interface.

After establishing the current state of a SQL Server instance, databases, and network connections, what should a database administrator check next?

Which of the following is NOT part of the process of creating a database audit?

A ______________ is a set of recorded performance results that can be used as future comparison points.

Describe how a database administrator can distinguish between normal and abnormal SQL Server activity.

Performance ___________ are rules defined by placing a threshold on the value of a specific performance counter monitored by SQL Server Agent.

How must the recipient of a notification be configured in SQL Server Agent?

To get an accurate view of SQL Server performance using SQL Server Activity Monitor without affecting overall system performance, how often should the server be polled?

Which of the following is true about the Management Data Warehouse?

List the main ranges of severity levels and their function.

A database administrator must ____________ monitor each SQL Server instance to minimize the risk of service disruption.

Introduction to SQL Server 2012

Deploying SQL Server 2012

Architecture and Configuration

Creating SQL Server 2012 Databases

Transact:SQL Primer

SQL Server Security

Performance Monitoring and Optimization

Backup and Recovery

Data Integration

Filters