DP-300 Certification Practice Question #163

Question

You have an Azure subscription that contains an Azure SQL database named DB1.

You execute the following T-SQL statements against DB1.

For each of the following statements, select Yes if the statement is true, otherwise select No.

NOTE: Each correct selection is worth one point.

Accepted Answer

1. **Statement 1 is No:** Under row compression, fixed-length Unicode columns like `NCHAR(10)` (column3) are stored in variable-length format. They do not occupy a fixed 10 bytes (or 20 bytes) on disk; instead, the storage matches the actual length of the character strings stored (0 to 20 bytes).
2. **Statement 2 is No:** Dictionary compression is a technique used in PAGE compression (which consists of row compression, prefix compression, and dictionary compression). Rebuilding the table with `ROW` compression does not enable dictionary compression.
3. **Statement 3 is Yes:** Row compression supports all the data types of `column1` (TINYINT), `column2` (VARCHAR), and `column4` (BINARY). TINYINT and BINARY benefit by being stored in variable-length formats, and VARCHAR is supported (with reduced metadata overhead), meaning the table successfully undergoes row compression without any type-compatibility limitations.

More DP-300 practice questions