O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Review Questions

  1. You've been tasked with writing a standard for package security. You were able to gather the following background information: packages will be deployed to the file system, only sensitive data within the packages needs to be secured, and packages might be executed by multiple users. Which security option would you select from the following?
    1. Do Not Save Sensitive
    2. Encrypt All with Password
    3. Encrypt All with User Key
    4. Encrypt Sensitive with Password
    5. Encrypt Sensitive with User Key
    6. Rely on Server Storage for Encryption
  2. Your packages need to be able to resume at the point they failed. Select all of the options that need to be enabled.
    1. Set the CheckPointFileName to any folder and filename.
    2. Set CheckPointShouldBeUsed to True.
    3. Set ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required