70-432 Sample Question: 21

Question: 21

You maintain a SQL Server 2008 instance.
The SQL Server instance is configured to use the T1222 and T1204 trace flags during startup.
You need to ensure that your failure recovery plan backs up the use of the trace flags.
What should you do?

A. Backup the default.trc file.
B. Backup the master database.
C. Backup the resource database.
D. Backup the SQL Server registry hive.

Answer: D

70-432 Sample Question: 20

Question: 20

You maintain a SQL Server 2008 Enterprise Edition instance that contains a database named Finance. You need to reduce the size of the full database backup files of the Finance database. Which Transact-SQL statement should you use

A. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak';
B. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak' WITH COMPRESSION;
C. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak' WITH DIFFERENTIAL;
D. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak' WITH COMPRESSION, DIFFERENTIAL;

Answer: B