Microsoft
70-432 · Question #141
70-432 Question #141: Real Exam Question with Answer & Explanation
The correct answer is B. BACKUP DATABASE FINANCE TO DISK = ,t:\backups\finance.bak' WITH COMPRESSION:. See the full explanation below for the reasoning.
Question
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?
Options
- ABACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak*;
- BBACKUP DATABASE FINANCE TO DISK = ,t:\backups\finance.bak' WITH COMPRESSION:
- CBACKUP DATABASE FINANCE TO DISK = ,t:\backups\finance.bak' WITH DIFFERENTIAL:
- DBACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak' WITH COMPRESSION-
Community Discussion
No community discussion yet for this question.