exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 586 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 586
Topic #: 1
[All SnowPro Core Questions]

Why would a Snowflake user create a secure view instead of a standard view?

  • A. The secure view is only available to end users with the corresponding SECURE_ACCESS property.
  • B. End users are unable to see the view definition, and internal optimizations differ with a secure view.
  • C. With a secure view, the underlying data is replicated to a separate storage layer with enhanced encryption.
  • D. Secure views support additional functionality that is not supported for standard views, such as column masking and row level access policies.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
muks86
Highly Voted 4 months ago
Answer should be B Why Should I Use Secure Views? For a non-secure view, internal optimizations can indirectly expose data. Some of the internal optimizations for views require access to the underlying data in the base tables for the view. This access might allow data that is hidden from users of the view to be exposed through user code, such as user-defined functions, or other programmatic methods. Secure views do not utilize these optimizations, ensuring that users have no access to the underlying data.
upvoted 5 times
...
magarrr
Most Recent 3 weeks, 1 day ago
Selected Answer: B
https://docs.snowflake.com/en/user-guide/views-secure
upvoted 2 times
...
MultiCloudIronMan
2 months ago
Selected Answer: B
B is correct
upvoted 1 times
...
learner2023
2 months, 1 week ago
Selected Answer: B
B is correct answer. https://docs.snowflake.com/en/user-guide/views-secure
upvoted 1 times
...
dementor
3 months, 4 weeks ago
Selected Answer: B
B is the correct answer
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago