DP-300 Certification Practice Question #236

Question

You have a SQL Server on Azure Virtual Machines instance named VM1 that hosts a database named DB1.
You run the following query.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

The Transact-SQL statement performs a transaction log backup with the `COPY_ONLY` and `NORECOVERY` options. The `COPY_ONLY` parameter ensures that the transaction log is not truncated, which makes the first statement "No". The `NORECOVERY` parameter places the database in the `RESTORING` state so that it is prepared for a subsequent restore sequence and no new transactions can be committed. Because SQL Server distinguishes between `RESTORING` and `OFFLINE` database states, the database is not in the offline state, making the second statement "No". Lastly, a log backup initiated with `NORECOVERY` to capture the remaining transaction log before a restore operation is by definition a tail-log backup, making the third statement "Yes".

More DP-300 practice questions