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
box1: Set the database to the FULL recovery model.
no, full RM required for log backup, not for differential (like in our case)
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.
Option A right
May answer is also the same as below:
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.
yeah A.
[email protected]
Box 1: Set the database to the simple recovery model -> meet “Minimize the space used by transaction logs” requirement.
Box 2: Perform a weekly full backup of the database.
Box 3: Perform a differential backup of the database every night -> together with a weekly full backup, meet “without losing more than 24 hours of transactions” requirement.