DRAG DROP
You need to recommend a backup process for data warehouse database.
The solution must meet the following requirements:
• Ensure that if a hardware failure occurs, you can bring the database online without
losing more than 24 hours of transactions.
• Minimize the amount of administrative effort required to restore any lost data.
• Minimize the space used by transaction logs.
What should you include in the recommendation?To answer, move the appropriate actions
from the list of actions to the answer area and arrange them in the correct order.
Answer: See the explanation.
Explanation:
Box 1: Set the database to the simple recovery model.
Box 2: Perform a weekly full backup of the database.
Box 3: Perform a differential backup of the database every night.
Note:
* Simple recovery model
No log backups.
* Full recovery model
Requires log backups