16. You receive a data file each day from a business partner. You need to import
the file each morning after it is received. Your developers have created a
package to properly import the file, and have deployed the package to your
SSIS instance. When they saved the package, they used the “Encrypt all with
Password” protection level. You need to make sure the password can’t be seen
in the scheduled job’s definition. What should you do to schedule the package?
A. Create a SQL Server Agent job and use an “Operating System (cmdExec)”
step to run the DTExec utility
B. Create a SQL Server Agent job and use a “SQL Server Integration Services
Package” step
C. Use the “Scheduled Tasks” in windows to run the DTExec utility nightly
D. Use the “Scheduled Tasks” in windows to run the DTExecUI utility
nightly
Bạn đang xem 16. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P83 POT