tailieunhanh - The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P153

The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P153: 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. | Self Test Appendix Appendix 65 recovery restore as they are not kept within your reach. What is the best way to meet these compliance requirements without interfering with the existing backup mechanism and avoiding impact on users A. Take a full backup written to the special media on Sunday at 1 00 . Give this backup to the compliance officer. B. Take a copy-only backup written to the special media on Sunday at 1 00 . Give this backup to the compliance officer. C. Take an incremental backup written to the special media on Sunday at 1 00 . Give this backup to the compliance officer. D. Take a partial backup written to the special media on Sunday at 1 00 . Give this backup to the compliance officer. Correct Answer Explanation B. The copy-only backup is similar to a full backup but does not change the last backup timestamp. This means that all differential backups will be based on the last full backup and all incremental backups will be based either on the last full or the last differential backup. This will preserve the current backup mechanism and will fall within the light user activity period on Sunday the copy backup will take the same amount of time as the full backup does . Incorrect Answers Explanations A C and D. Answer A is incorrect because all differential and Monday and Tuesday s incremental backups will be taken off the compliance-related full backup which will not be accessible if you need to perform a restore. Answer C is incorrect because the incremental backup will not provide the compliance officer with a backup that can be restored. Additionally by doing this you will invalidate Monday and Tuesday s incremental log backups. Answer D is incorrect because a partial backup will not provide the compliance officer with a backup that can be restored. Chapter 8 ETL Techniques 1. You want to export data from a SQL Server instance to a text file. This operation needs to be scheduled to run at night without human intervention. Select the best .