Which alter command below may affect the availability of column with respect to time travel?

Which alter command below may affect the availability of column with respect to time travel?
A . ALTER TABLE…DROP COLUMN
B. ALTER TABLE…SET DATA TYPE
C. ALTER TABLE…SET DEFAULT

View Answer

Answer: B

Explanation:

If the precision of a column is decreased below the maximum precision of any column data retained in Time Travel, you will not be able to restore the table without first increasing the precision. The precision of a column data can only be altered using the ALTER TABLE …SET DATA TYPE command.

Hence, ALTER TABLE…SET DATA TYPE is the most appropriate answer https://docs.snowflake.com/en/sql-reference/sql/alter-table-column.html#alter-table-alter-column