MOC20764:M9-10

What is recommended for the SQL Server Agent service account?

• • A) Any user account

• • Windows domain account

• • C) Local System account

• • D) Network Service account

Which SQL Server Agent role allows users to view job definitions they do not own?

• • A) SQLAgentUserRole

  • D) Both B and C

• • B) SQLAgentReaderRole

• • C) SQLAgentOperatorRole

• • D) Both B and C

What do credentials in SQL Server typically contain?

• • A) Only a user name

• • B) Only a password

• • C) Both a Windows username and password

• • D) A Windows username and a SQL Server login

What is the purpose of proxy accounts in SQL Server Agent?

• • A) To extend the functionality of the SQL Server Agent

• • B) To execute job steps that require a security context other than the SQL Server Agent service account

• • C) To manage user roles within SQL Server

• • D) To encrypt the job scripts

What is required before configuring a proxy account?

• • A) Configuring a credential

• • B) Disabling all existing jobs

• • C) Restarting SQL Server Agent

• • D) Obtaining sysadmin privileges

SQL Server Agent jobs can only be managed by users with sysadmin privileges.

• true

• false

Proxy accounts in SQL Server Agent can execute job steps for any subsystem without specific configuration.

• true

• false

Only members of sysadmin can create and manage proxy accounts in SQL Server Agent.

• true

• false

What property uniquely identifies an error raised by the SQL Server Database Engine?

• • A) Error message

• • B) Error number

• • C) Severity

• • D) State

What is Database Mail primarily used for in SQL Server?

• • A) As part of a job

• • B) In response to an alert

• • C) From a stored procedure

• • D) All of the above