PrepAway - Latest Free Exam Questions & Answers

What should Amy Walsh do?

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include implementing maintenance on a SQL Server 2005 database server named Certkiller -DB01.
At present there are certain jobs that run every Sunday whilst other jobs run at the start of every month. A Domain.com user named Amy Walsh is a member of the Finance department. You instruct her to schedule the jobs in the way that uses the minimum administrative effort.
What should Amy Walsh do?

PrepAway - Latest Free Exam Questions & Answers

A.
Amy Walsh needs to create a job schedule that runs once a day.
Then she can assign jobs to this job schedule.
Thereafter the jobs can be executed if the day is either a Sunday or the first day of the month.

B.
A job needs to be created for every task that runs daily.
Then Amy Walsh can use a Transact-SQL statement to check the date and day of the week.
Thereafter a code needs to be executed if the day is either a Sunday or the first day of the month.

C.
Amy Walsh needs to create a job schedule that runs every Sunday.
Then she can assign weekly tasks to this schedule.
She can then create a second schedule that runs on the first day of every month.
Thereafter she can assign monthly tasks to this schedule.

D.
Amy Walsh needs to create a job for every task that runs weekly on Sundays.
Thereafter she should add a second job schedule that runs the job on the first of the month.

Explanation:
You need 2 schedules or both tasks will be executed on Sundays and on the first day of the month. Creating a job schedule for every task that runs once a week instead of creating one schedule containing all the tasks would use more administrative effort than needed.


Leave a Reply