問題文
An energy utility team enabled liquid clustering on a 30 TB table with ALTER TABLE two weeks ago. Queries filtering on the clustering key are still slow, and the team confirmed the keys are set correctly. Which two things should they check? (Select two.)
選択肢
- Whether the table has more than 4 clustering keys, since additional keys are silently ignored.
- Whether OPTIMIZE has been run, since the default behavior does not apply clustering to previously written data.
- Whether Photon is enabled, since clustering requires Photon to skip files.
- Whether the clustering columns have statistics collected, since clustering keys must be columns for which statistics are collected.
- Whether the table is partitioned, since clustering only works on partitioned tables.