You have an Azure SOI database named SQLDb1 that contains the resources shown in the following table. Column1 contains JSON data. You need to compress Column1. The solution must minimize the amount of

The correct answer is A. the COMPRESS() function. https://learn.microsoft.com/es-es/sql/t-sql/functions/compress-transact-sql?view=sql-server-ver16

Submitted by jian89· Mar 6, 2026Monitor, configure, and optimize database resources

Question

You have an Azure SOI database named SQLDb1 that contains the resources shown in the following table. Column1 contains JSON data. You need to compress Column1. The solution must minimize the amount of storage used. What should you use?

Options

Athe COMPRESS() function
Bcolumnstore archive compression
Crow compression
Dcolumnstore compression

How the community answered

(26 responses)

A
81% (21)
B
4% (1)
C
4% (1)
D
12% (3)

Explanation

https://learn.microsoft.com/es-es/sql/t-sql/functions/compress-transact-sql?view=sql-server-ver16

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice