Hotspot 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…

Question

Exhibit

Answer Area

• The log file will be truncated.
• DB1 will be placed in an offline state.
• You are performing a tail-log backup.

Explanation

This hotspot question tests knowledge of SQL Server's DBCC CHECKDB command and its behavior when run against a database on an Azure Virtual Machine. Without seeing the specific query and statements, the core concept revolves around database consistency checks and their outputs/side effects.

Approach. DBCC CHECKDB checks the logical and physical integrity of all objects in a SQL Server database. When run on a SQL Server on Azure VM, it behaves identically to on-premises SQL Server - it checks allocation structures, system table integrity, and user table integrity. Key behaviors include: it acquires a database snapshot for consistency (if not in single-user mode), it reports errors via messages/output, it can be run with NO_INFOMSGS to suppress informational messages, and REPAIR options require single-user mode. Evaluating each statement requires understanding these specific behaviors, such as whether the command runs successfully, whether it requires exclusive access, and what the output contains.

Concept tested. SQL Server DBCC CHECKDB command behavior, including its ability to run on Azure VM-hosted databases, snapshot creation for consistency checks, repair options requiring single-user mode, and interpretation of the command's output and side effects.

Reference. https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql

No community discussion yet for this question.