MicrosoftMicrosoft
DP-300 · Question #358
DP-300 Question #358: Real Exam Question with Answer & Explanation
Sign in or unlock DP-300 to reveal the answer and full explanation for question #358. The question stem and answer options stay visible for context.
Submitted by rania.sa· Mar 6, 2026Implement and manage an Azure SQL environment / Configure and optimize database performance including storage and index compression in Azure SQL Database
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. Answer:
Options
- taskEnable page compression on the PK_SalesOrderHeader_SalesOrderID clustered index of the SalesLT.SalesOrderHeader table in an Azure SQL database named db1.
- prerequisitesAccess to the virtual machine, SQL Server Management Studio (SSMS) installed, and credentials to connect to Azure SQL database 'db1'.
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Azure SQL Database#Index Compression#T-SQL#Performance Optimization