nerdexam
Snowflake

COF-R02 · Question #325

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

The correct answer is B. Use the ALTER VIEW command to update the view. See the full explanation below for the reasoning.

Question

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

Options

  • AModify the columns in the underlying table
  • BUse the ALTER VIEW command to update the view
  • CRecreate the view with the required changes
  • DMaterialize the view to perform the changes

How the community answered

(31 responses)
  • A
    6% (2)
  • B
    77% (24)
  • C
    13% (4)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice