SnowPro Core Certification — Question 301

How can a user change which columns are referenced in a view?

Answer options

• A. Modify the columns in the underlying table
• B. Use the ALTER VIEW command to update the view
• C. Recreate the view with the required changes
• D. Materialize the view to perform the changes

Correct answer: C

Explanation

The correct method to change the columns in a view is to recreate it with the necessary alterations, which is option C. Option A is incorrect because modifying the underlying table does not directly update the view's column references. Option B is also wrong as ALTER VIEW typically allows modification of the view's structure but not its columns directly. Option D is not valid since materializing a view does not change its definition.