The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P83: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 392 Chapter 8 ETL Techniques 12. You need to transfer a database to another server for testing purposes. You want to ensure that you get the entire database as well as any logins and SQL Server Agent Jobs related to the database. You want to perform the transfer as easily as possible. Which one of the following tools best meets your needs A. Import and Export Wizard B. Copy Database Wizard C. Business Intelligence Development Studio D. BCP 13. You need to import data from an Access database into a database in SQL Server. You want to perform the import as simply as possible. Which one of the following options best meets the requirements A. Import and Export Wizard B. Copy Database Wizard C. Business Intelligence Development Studio D. BCP 14. You need to deploy an SSIS package to a production server. You want to use package roles to control access to the packages. When the developer creates the package which protection level should they use A. Encrypt sensitive with password B. Encrypt all with user key C. Rely on server storage and roles for access control D. Encrypt all with password 15. Your company implements formal development test and production environments. Packages are using servers in the development environment tested on servers in the test environment and finally run in the production environment. You need to point the packages to the correct servers depending on the environment without having to edit the packages themselves. Which of the following options best supports changing the properties of a package at runtime A. Package Configurations B. DTExec command line options C. SQL Server Integrations Services Packages step in a job. D. DTExecUI options ETL Techniques Chapter 8 393 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 .
