Microsoft 70-432 is often called the hardest of all Microsoft exams. GreatExam helps you kill the Microsoft 70-432 exam challenge and achieve the perfect passing score with its latest practice test, packed into the revolutionary interactive VCE. This is the best way to prepare and pass the 70-432 exam.
You maintain a SQL Server 2008 instance.
You use SQL Server Database Mail to distribute multiple reports that are scheduled and generated every night.
You need to enforce a mail retention policy to delete copies of automatically generated mails
after 60 days.
Which process should you use?
A. Set the Subscription retention interval to delete mails after 60 days.
B. Set the MailProfile property of a Management Policy on the Server facet to delete mails after 60 days.
C. Create a SQL Agent job to use the sysmail_delete_log_sp stored procedure to delete mails older than 60 days.
D. Create a SQL Agent job to use the sysmail_delete_mailitems_sp stored procedure to delete mails older than 60 days.