🔥 3-day streak
Microsoft Azure Database Administrator Associate77 / 144
Question 77 of 144

You administer a SQL Server 2019 instance on-premises that uses log shipping to a secondary server in a remote datacenter for disaster recovery. Recently, users reporting on the standby secondary complain that data is unusually stale. You need to determine, using the built-in log shipping monitoring, which specific step is falling behind so you can target your investigation. Which log shipping job and its associated monitoring metric should you examine to confirm that the transaction logs are being applied to the secondary too slowly?

Reviewed for accuracy · Report an issueNext question