ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-464 All Questions

View all questions & answers for the 70-464 exam
Go to Exam

Exam 70-464 topic 1 question 66 discussion

Actual exam question from Microsoft's 70-464
Question #: 66
Topic #: 1
[All 70-464 Questions]

You plan to migrate an instance of SQL Server 2008 to a new installation of SQL Server 2012.
You need to migrate alerts and e-mail notifications.
Which system stored procedures should you use? (Each correct answer presents part of the solution. Choose all that apply.)

  • A. sp_syspolicy_create_job
  • B. sp_add_operator
  • C. sp_audit_write
  • D. sp_add_alert
Show Suggested Answer Hide Answer
Suggested Answer: BC 🗳️
B: sp_add_operator creates an operator (notification recipient) for use with alerts and jobs.
C: sp_audit_write adds a user-defined audit event to the USER_DEFINED_AUDIT_GROUP. If USER_DEFINED_AUDIT_GROUP is not enabled, sp_audit_write is ignored.
by Dolous at Jan. 13, 2021, 12:44 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Dolous
4 years, 5 months ago
sp_add_alert - https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-add-alert-transact-sql?view=sql-server-ver15
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel