Microsoft
70-451 · Question #76
You need to design a database solution that meets the following capabilities: - Executes SQL Server Integration Services (SSIS) packages - Executes Transact-SQL - Schedules tasks - Sends alerts…
The correct answer is D. SQL Server Agent. See the full explanation below for the reasoning.
Question
You need to design a database solution that meets the following capabilities:
- Executes SQL Server Integration Services (SSIS) packages
- Executes Transact-SQL
- Schedules tasks
- Sends alerts
Which SQL Server component should you use?
Options
- ANotification Services
- BService Broker
- CSQL Mail
- DSQL Server Agent
How the community answered
(34 responses)- A9% (3)
- B15% (5)
- C3% (1)
- D74% (25)
Community Discussion
No community discussion yet for this question.