HOTSPOT -
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
Hot Area:
98-364 Exam QuestionsBrowse all questions from this exam
98-364 Exam - Question 74
Show AnswerHide Answer
Correct Answer: 
Discussion
7 commentstgallagh
Feb 5, 2020SORRY!! My response is partially incorrect. The Correct answer sequence is as shown: Y, N, N, Y. Read the third item, it stated since "BEFORE" the last full back up, no after. Therefore I am incorrect with my answer sequence but the explanation is accurate in the explanation.
tgallagh
Feb 5, 2020Y,N,Y,Y A differential backup is based on the most recent, previous full data backup. A differential backup captures only the data that has changed since that full backup.
Jheus
Nov 16, 2019Differential backups and recovery are similar to incremental in that these backups grab only files that have been updated since the last normal backup.
Andy7622
Nov 1, 2020first of all a backup and recovery two different processes. Incremental backup is another name for a Differnential backup.
Jovial
May 24, 2020i think third answer is N because it says before full backup.. isnt it first full backup then differential backup
riti123
Jun 18, 2020the question says backs up data "before" the last full backup. The data backup after the last full backup comes as the differential backup.
riti123
Jun 18, 2020the question says "before" the last full backup. therefore it should be No. The differential backup is the data backed up AFTER the last full backup.
robertscobar
Oct 29, 2021https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/differential-backups-sql-server?view=sql-server-ver15