PrepAway - Latest Free Exam Questions & Answers

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB. You have received instructions from
management to cut the content of the entire database backup files of CK_DB.

What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
You should consider using the following Transact-SQL statement:
BACKUP DATABASE CK_DB TO DISK = ‘t:backupsfinance.bak’

B.
You should consider using the following Transact-SQL statement:
BACKUP DATABASE CK_DB TO DISK = ‘t:backupsfinance.bak’ WITH DIFFERENTIAL;

C.
You should consider using the following Transact-SQL statement:
BACKUP DATABASE CK_DB TO DISK = ‘t:backups TT_DB.bak’ WITH COMPRESSION;

D.
You should consider using the following Transact-SQL statement:
BACKUP DATABASE CK_DB TO DISK = ‘t:backupsfinance.bak’ WITH COMPRESSION, DIFFERENTIAL;


Leave a Reply