Microsoft
70-465 · Question #133
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 wit
Sign in or unlock 70-465 to reveal the answer and full explanation for question #133. The question stem and answer options stay visible for context.
Submitted by carter_n· Mar 5, 2026Design and implement a data warehousing solution
Question
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:
Exhibit
Answer Area
Drag items
Perform a weekly full backup of the database.Ship the logs to a secondary server.Set the database to the simple recovery model.Set the database to the full recovery model.Create a database snapshot.Perform a backup of the transaction log every hour.Perform a differential backup of the database every night.
Unlock 70-465 to see the answer
You've previewed enough free 70-465 questions. Unlock 70-465 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#SQL Server Backup#Recovery Models#Transaction Log Management#Data Warehouse Strategy