Search Header Logo

MOC20764:M9-10

Authored by mohsin murtaza

Computers

University

Used 1+ times

MOC20764:M9-10
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

true

false

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

true

false

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?