PrepAway - Latest Free Exam Questions & Answers

Tag: backup

You need to configure system image backups to meet the following requirements:* Automatically create a system

You have a computer that runs Windows 7. You need to configure system image backups to meet the following requirements:
* Automatically create a system image every day without user intervention
* Retain multiple copies of the system image
Which type of backup destination should you use?

In the backup application, which name should you specify?

Your Exchange Server 2007 environment is configured with cluster continuous replication (CCR). The Microsoft Windows Cluster service (MSCS) is installed on two servers named Server1 and Server2. The default cluster that runs on the MSCS cluster is named Clus1. The cluster mailbox server (CMS) is named ExchCMS1. Currently Clus1 and ExchCMS1 are running on the Server1 cluster node, and the CCR replica is running on the Server2 cluster node. You need to back up the CCR replica. In the backup application, which name should you specify?
Practice exams also include self assessment and reporting features!

What should you do to ensure that the Transaction Log option is available in the Backup type drop-down list?

You manage an instance of SQL Server 2008. The server contains a database named Corpdb . You configure theoptions for the Corpdb database as shown in the following graphic:
You are creating a transaction log backup of the Corpdb database. You open the Back Up Database – Corpdb dialog box to perform the transaction log backup. However, you discover that the Transaction Log option is notavailable in the Backup type drop-down list. You want to ensure that the Transaction Log option is available in the Backup type drop-down list.
exhibit What should you do? (Choose two. Each answer represents a complete solution.)

Which fixed server role or roles will allow you to perform this task?

You are responsible for managing a SQL Server 2008 computer. The server contains several databases thatcontain mission-critical information.
You configure daily backups for all databases. To ensure that the backupprocess takes less time, you want to configure backup compression on the server.
Which fixed server role or roles will allow you to perform this task? (Choose all that apply.)

Which statement will fulfill all the requirements in this scenario?

You are a database administrator for your company. You are required to perform a full backup of the Sales database.
When performing the backup, you must fulfill the following requirements:
? The backup should be written to the disk backup device named ‘ C:sales1a.bak ‘.
? The size of each block for the backup should be 64 KB.
? The backup should expire on the 11th day.
? The new backup sets should be appended to existing backup sets on the backup media.
? The newly created backup should be named FULL BACKUP OF SALES .
Which statement will fulfill all the requirements in this scenario?

Which backup strategy should you implement?

You are the database administrator for your company. You maintain a database named Hr1 on a SQL Server2008 instance named Sql1.
The database size is approximately 45 GB and uses the Full Recovery model. The Hr1 database consists of a primary filegroup and four secondary filegroups.
Each filegroup contains three datafiles that are located on different disks. The Hr1 database is an online transaction processing database.
You perform a full backup of the database everytwo days. The Transaction_details table in the database contains all the transaction details and is updatedfrequently.
You are required to frequently back up the data in the table to prevent loss of transaction details in theevent of a failure. Which backup strategy should you implement?


Page 1 of 41234