Term
Which of the following types of administration is a programmed response to a predictable administrative task?
A) Master Administration
B) Automated Administration
C) Performance Administration
D) Target Administration |
|
Definition
| B) Automated administration |
|
|
Term
Which of the following would be considered administrative tasks that are defined once and executed as many times as necessary?
A) Operations
B) Steps
C) Jobs
D) None Of The Above |
|
Definition
|
|
Term
Which of the following type of servers houses a complete list of the various operations that must be performed on various target servers when using multi-server automation?
A) Operation Servers
B) Master Servers
C) Performance Servers
D) Step Servers |
|
Definition
|
|
Term
Which of the following listens for messages sent across a network, receives messages addressed to a computer or user on the computer, and displays them in the form of pop-up message boxes?
A) Messenger Service
B) Net Send Service
C) Performance Service
D) Target Service |
|
Definition
|
|
Term
Which of the following is a command line application in Windows 2000 and Windows NT which automatically forces a message box to pop up on a computer screen when a user is connected to the network?
A) Message Send
B) Target Send
C) Net Send
D) All Of The Above |
|
Definition
|
|
Term
Which of the following are users who are configured within an instance of SQL Server 2000 to receive notification regarding jobs and alerts?
A) Performers
B) Messengers
C) Targeters
D) Operators |
|
Definition
|
|
Term
Which of the following are individual metrics that are measured by SQL Server 2000?
A) Performance Object
B) Performance Operators
C) Performance Counters
D) Performance Servers |
|
Definition
|
|
Term
Which of the following would be considered a grouping option or mechanism used to categorize related performance counters?
A) Performance Objects
B) Target Objects
C) Messenger Objects
D) Master Objects |
|
Definition
|
|
Term
Which of the following is a separate program that executes administrative tasks and generates alerts defined by database administrators?
A) Target Server Agent
B) SQL Server Agent
C) Step Server Agent
D) Master Server Agent |
|
Definition
|
|
Term
Which of the following can be in the form of T-SQL statements executable files or ActiveX scripts?
A) Messages
B) Operations
C) Steps
D) None Of The Above |
|
Definition
|
|
Term
Which of the following is an instance of SQL Server 2000 that connects to the master server and receives jobs scheduled to be run locally when using multi-server automation?
A) Job Server
B) Performance Server
C) Net Server
D) Target Server |
|
Definition
|
|
Term
Which of the following is NOT an operation performed by the SQL Server Agent?
A) Automatic system backups
B) Execution of administrative tasks
C) Detect system conditions and automatically initiate measures to solve problems
D) Alerting people |
|
Definition
| A) Automatic system backups |
|
|
Term
The figure shown above depicts which of the following? (Figure of diamonds and rectangles)
A) Windows 2000 Server architecture
B) SQL Server Agent architecture
C) Windows NT Server architecture
D) None of the above |
|
Definition
| B) SQL Server Agent architecture |
|
|
Term
A step in a job can be which of the following?
A) T-SQL Statements
B) Windows executable Programs
C) ActiveX Scripts
D) All The Above |
|
Definition
|
|
Term
Which of the following are commonly used to trigger notification of a problem to administrative users of a database?
A) Alerts
B) Schemas
C) Templates
D) All Of the above |
|
Definition
|
|
Term
Which of the following is NOT a method that is used to notify operators of alerts in jobs?
A) Pager
B) Net Send Command
C) E-Mail
D) None Of the Above |
|
Definition
|
|
Term
Which of the following notification methods is NOT the most quick and efficient way to communicate with users?
A) Pager
B) Email
C) Net Send Command
D) None Of the Above |
|
Definition
|
|
Term
Which of the following notification methods is an extension of standard e-mail notification?
A) Net Send notification
B) Pager
C) Net Send Command
D) None Of The Above |
|
Definition
|
|
Term
The figure shown above is an example of which type of automation architecture? (1 top pc and 4 lower pcs)
A) Multi Server
B) Multi Domain
C) Single Server
D) Single Domain |
|
Definition
|
|
Term
Which of the following tabs of the SQL Server Agent properties window allows someone to configure SQL Server Agent to monitor and restart the SQL Server and SQL Server Agent services?
A) The Connection Tab
B) The Advanced Tab
C) The Alerts Tab
D) The General Tab |
|
Definition
|
|
