Which SQL Server component should you use?

You are a database developer for VirtuArt Corporation on an instance of SQL Server 2008. You are creating an application for the order processing department.
The application will send e-mail notifications to sales representatives when specific orders for priority customers are shipped.
When an order from a priority customer that is over $1000.00 is shipped, the application must e-mail the customer’s assigned sales representative and include details of the order as an e-mail attachment, and also meet the following requirements:
E-mail should be sent using Simple Mail Transfer Protocol (SMTP).
Impact on the SQL server should be minimized.
Which SQL Server component should you use?
A. Database Mail
B. SQL Server Mail
C. Distributed Transaction Coordinator (DTC)
D. SQL Server alerts

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.