Exam 70-462 topic 2 question 190 discussion

DRAG DROP -
You administer a Microsoft SQL Server database.
Every Sunday afternoon, a process inserts a large volume of data. Users generate reports and modify additional data throughout the week.
You need to create a backup strategy that:
✑ minimizes the size of the transaction log,
✑ minimizes the size of the backups, and
✑ ensures a 24-hour recovery point objective (RPO).
Which strategy or strategies should you use? (To answer, drag the appropriate strategy or strategies to their corresponding task or tasks in the answer area.
Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)
Select and Place:

Suggested Answer:
Recovery Model: Full recovery model
Only the Full recovery model provides a 24-hour recovery point objective.

Sunday backup: Full backup -
Nightly backup: Transactional log backup
References:
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models-sql-server