DP-300 Certification Practice Question #156

Question

SIMULATION
 -

In an Azure SQL database named db1, you need to enable page compression on the PK_SalesOrderHeader_SalesOrderID clustered index of the SalesLT.SalesOrderHeader table.

To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.

Accepted Answer

To enable page compression on a specific clustered index, the standard Transact-SQL command is `ALTER INDEX ON REBUILD WITH (DATA_COMPRESSION = PAGE);`. Applying this to `PK_SalesOrderHeader_SalesOrderID` on `SalesLT.SalesOrderHeader` ensures the data pages of the index are compressed. Alternatively, this can be done in SSMS by right-clicking the index, selecting Properties, navigating to Storage, and setting Compression Type to Page, followed by generating and executing the script.

More DP-300 practice questions