Snowpro Advanced Architect · Free Practice Question Easy
Question 34
How can you convert an existing view to a secure view in Snowflake?
- A A. By recreating the view from scratch using the SECURE keyword
- B B. By using the ALTER VIEW command with the SECURE keyword
- C C. By granting additional privileges to the view
- D D. By modifying the data retention settings
Reveal correct answer
Correct answer: B
Explanation
The ALTER VIEW command with the SECURE keyword can be used to convert an existing view to a secure view.A. Incorrect, you do not need to recreate the view.
B. Correct, the ALTER VIEW command with the SECURE keyword can convert an existing view to a secure view.
C. Incorrect, privileges do not make a view secure.
D. Incorrect, data retention settings do not affect view security.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
