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?
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;