nerdexam
Microsoft

70-432 · Question #6

You are the administrator of a SQL Server 2008 instance. According to the company requirement the names of all user-defined stored procedures must contain the prefix usp_ on all instances. You have…

The correct answer is B. A policy should be created. See the full explanation below for the reasoning.

Question

You are the administrator of a SQL Server 2008 instance. According to the company requirement the names of all user-defined stored procedures must contain the prefix usp_ on all instances. You have to make sure that stored procedures that do not contain this prefix cannot be created by you. What should you do?

Options

  • AA policy should be created.
  • BA policy should be created.
  • CA condition should be created.
  • DA condition should be created.

How the community answered

(30 responses)
  • A
    3% (1)
  • B
    73% (22)
  • C
    7% (2)
  • D
    17% (5)

Community Discussion

No community discussion yet for this question.

Full 70-432 Practice