How can a user change which columns are referenced in a view?
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
The Answer Is:
C
This question includes an explanation.
Explanation:
In Snowflake, to change the columns referenced in a view, the view must be recreated with the required changes. The ALTER VIEW command does not allow changing the definition of a view; it can only be used to rename a view, convert it to or from a secure view, or add, overwrite, or remove a comment for a view. Therefore, the correct approach is to drop the existing view and create a new one with the desired column references.
COF-C02 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"