exam questions

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam

Exam 70-764 topic 1 question 261 discussion

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

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

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
V_karag
4 years, 11 months ago
We use full recovery model so we need also log backups to achieve the 3 rd requirement
upvoted 1 times
huzein
4 years, 7 months ago
No, see here how the simple recovery model effects the t-log: https://www.mssqltips.com/sqlservertutorial/4/sql-server-simple-recovery-model/
upvoted 1 times
...
...
TheSwedishGuy
5 years, 4 months ago
Not a big fan of the solution! This solution has no DR, so if a hardware error occurs, you're screwed!
upvoted 1 times
...
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 ...