Question 1

Where are server-scoped dynamic management views stored?

Accepted Answer

A) master system database 
B) model system database 
C) resource system database 
D) msdb system database 
A) master system database 
B) model system database 
C) resource system database 
D) msdb system database A

Question 2

What are data collectors and data collections?

Accepted Answer

The data collector is a feature of the SQL Server Management Data Warehouse that overcomes the limitations of traces and data collector sets as it can be used to capture several different types of data. A data collection is a specific instance of a data collector that specifies the method for collecting the data, the source of the data to collect, and the method for storing the collected data, including when to purge the data.

Question 3

Which section of Activity Monitor should you inspect if you want to see the average speeds for read and write transfers of data to the physical disk?

Accepted Answer

A) Overview 
B) Processes 
C) Resource Waits 
D) Data File I/O 
A) Overview 
B) Processes 
C) Resource Waits 
D) Data File I/O D

Question 4

What is the first priority in checking the status of a SQL Server instance?

Accepted Answer

A) check database status using Object Explorer 
B) verify remote client/server connectivity 
C) ensure that all services are running normally 
D) check for recent errors of scheduled jobs 
A) check database status using Object Explorer 
B) verify remote client/server connectivity 
C) ensure that all services are running normally 
D) check for recent errors of scheduled jobs

Question 5

Each data collector type stores the results of the data collection in the Management Data ___________.

Accepted Answer

The answer of Each data collector type stores the results...

Question 6

Activity Monitor can help you assess CPU and memory utilization.

Accepted Answer

A) True 
 B)False

Question 7

Where should you look for events related to a maintenance and backup plan scheduled using SQL Server Agent?

Accepted Answer

A) Windows application log 
B) SQL Server Agent error log 
C) SQL Server log 
D) Windows system and security logs 
A) Windows application log 
B) SQL Server Agent error log 
C) SQL Server log 
D) Windows system and security logs

Question 8

Which of the following is NOT a standard collector type installed on SQL Server?

Accepted Answer

A) Transact-SQL Query 
B) SQL Alert 
C) SQL Trace 
D) Query Activity 
A) Transact-SQL Query 
B) SQL Alert 
C) SQL Trace 
D) Query Activity

Question 9

Each SQL Server error message is assigned a numerical _________ level that describes the type of error.

Accepted Answer

The answer of Each SQL Server error message is assigned...

Question 10

List two events in which the SQL Server Agent should be used to send notifications and alerts?

Accepted Answer

SQL Server Agent job failure n

Question 11

Describe the steps involved in capturing a set of baseline values.

Accepted Answer

Analyze and translate business requireme

Question 12

A data collector set is a collection of ____________ captured at predetermined time intervals.

Accepted Answer

The answer of A data collector set is a collection...

Question 13

Which type of message is generated automatically when a performance condition is met?

Accepted Answer

A) Alerts 
B) WMI events 
C) Counters 
D) Performance alarm 
A) Alerts 
B) WMI events 
C) Counters 
D) Performance alarm

Question 14

Activity Monitor uses _________ management views to retrieve several of its result sets.

Accepted Answer

The answer of Activity Monitor uses _________ management views to...

Question 15

To check whether system or resource errors have occurred, you should check the events in the Windows application log and SQL Server log.

Accepted Answer

A) True 
 B)False

Question 16

What are performance conditions and how do they work? Provide an example.

Accepted Answer

Performance conditions are rules defined

Question 17

What permission must a user have to be able to view data in Activity Monitor?

Accepted Answer

A) VIEW ANY DATABASE 
B) VIEW SERVER STATE 
C) ALTER SETTINGS 
D) CONTROL SERVER 
A) VIEW ANY DATABASE 
B) VIEW SERVER STATE 
C) ALTER SETTINGS 
D) CONTROL SERVER

Question 18

What tool do you use to record a SQL Server trace?

Accepted Answer

A) Task Manager 
B) Performance Monitor 
C) SQL Server Profiler 
D) Management Data Warehouse 
A) Task Manager 
B) Performance Monitor 
C) SQL Server Profiler 
D) Management Data Warehouse

Question 19

Ideally, database administrators will monitor SQL Server reactively, and solve problems as they occur.

Accepted Answer

A) True 
 B)False

Question 20

What are dynamic management views and dynamic management functions?

Accepted Answer

A dynamic management view (DMV)is a syst

Where are server-scoped dynamic management views stored?

What are data collectors and data collections?

Which section of Activity Monitor should you inspect if you want to see the average speeds for read and write transfers of data to the physical disk?

What is the first priority in checking the status of a SQL Server instance?

Each data collector type stores the results of the data collection in the Management Data ___________.

Activity Monitor can help you assess CPU and memory utilization.

Where should you look for events related to a maintenance and backup plan scheduled using SQL Server Agent?

Which of the following is NOT a standard collector type installed on SQL Server?

Each SQL Server error message is assigned a numerical _________ level that describes the type of error.

List two events in which the SQL Server Agent should be used to send notifications and alerts?

Describe the steps involved in capturing a set of baseline values.

A data collector set is a collection of ____________ captured at predetermined time intervals.

Which type of message is generated automatically when a performance condition is met?

Activity Monitor uses _________ management views to retrieve several of its result sets.

To check whether system or resource errors have occurred, you should check the events in the Windows application log and SQL Server log.

What are performance conditions and how do they work? Provide an example.

What permission must a user have to be able to view data in Activity Monitor?

What tool do you use to record a SQL Server trace?

Ideally, database administrators will monitor SQL Server reactively, and solve problems as they occur.

What are dynamic management views and dynamic management functions?

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

Where are server-scoped dynamic management views stored?

What are data collectors and data collections?

Which section of Activity Monitor should you inspect if you want to see the average speeds for read and write transfers of data to the physical disk?

What is the first priority in checking the status of a SQL Server instance?

Each data collector type stores the results of the data collection in the Management Data ___________.

Activity Monitor can help you assess CPU and memory utilization.

Where should you look for events related to a maintenance and backup plan scheduled using SQL Server Agent?

Which of the following is NOT a standard collector type installed on SQL Server?

Each SQL Server error message is assigned a numerical _________ level that describes the type of error.

List two events in which the SQL Server Agent should be used to send notifications and alerts?

Describe the steps involved in capturing a set of baseline values.

A data collector set is a collection of ____________ captured at predetermined time intervals.

Which type of message is generated automatically when a performance condition is met?

Activity Monitor uses _________ management views to retrieve several of its result sets.

To check whether system or resource errors have occurred, you should check the events in the Windows application log and SQL Server log.

What are performance conditions and how do they work? Provide an example.

What permission must a user have to be able to view data in Activity Monitor?

What tool do you use to record a SQL Server trace?

Ideally, database administrators will monitor SQL Server reactively, and solve problems as they occur.

What are dynamic management views and dynamic management functions?

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