exam questions

Exam 70-465 All Questions

View all questions & answers for the 70-465 exam

Exam 70-465 topic 1 question 24 discussion

Actual exam question from Microsoft's 70-465
Question #: 24
Topic #: 1
[All 70-465 Questions]

QUESTION NO: 24 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.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Note:
* Simple recovery model
No log backups.
* Full recovery model

Requires log backups -
Reference:
Recovery Models (SQL Server)
Full Database Backups (SQL Server)
Differential Backups (SQL Server)

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...