Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than

one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

A company has a Microsoft SQL Server environment that has multiple databases. A dat

abase named DB1 has multiple online file groups. It is configured to use the full recovery model. A full backup is preformed nightly and transaction logs are performed on the hour. A large number of records are accidentally deleted at 17:20.

You need to

perform a point-in-time recovery. Which option should you use first?

A. backup compression

B. backup encryption

C. file snapshot backup

D. mirrored backup media sets

E. SQL Server backup to URL

F. SQL Server Managed Backup to Azure

G. tail-log backup

H

. back up and truncate the transaction log

To back up the tail of the log (that is, the active log), check Back up the tail of the log, and leave database in the restoring state.

A tail-log backup is taken after a failure to back up the tail of

the log in order to prevent work loss. Back up the active log (a tail-log backup) both after a failure, before beginning to restore the database, or when failing over to a secondary database. Selecting this option is equivalent to specifying the NORECOVER

Y option in the BACKUP LOG statement of Transact-SQL.

References: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-a-transaction-log-sql-server?view=sql-server-2017