Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 259 discussion

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

What should be considered when deciding to use a Secure View? (Choose two.)

  • A. No details of the query execution plan will be available in the query profiler.
  • B. Once created there is no way to determine if a view is secure or not.
  • C. Secure views do not take advantage of the same internal optimizations as standard views.
  • D. It is not possible to create secure materialized views.
  • E. The view definition of a secure view is still visible to users by way of the information schema.
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
AS314
Highly Voted 1 year, 11 months ago
Selected Answer: AC
https://alexandersks.medium.com/views-in-snowflake-part-3-secure-view-8bbd8832b3af
upvoted 13 times
...
halol
Highly Voted 1 year, 11 months ago
Selected Answer: AC
A & C i think
upvoted 8 times
...
Mallikharjuna452
Most Recent 4 months ago
A and C are correct
upvoted 1 times
...
Vijay2605
8 months, 2 weeks ago
Selected Answer: AC
AC is the right ans
upvoted 1 times
...
_yyukta
8 months, 3 weeks ago
Selected Answer: AC
A and C are correct
upvoted 1 times
...
GAUURAAV
1 year ago
A and C
upvoted 1 times
...
Avi0407
1 year ago
Selected Answer: AC
https://alexandersks.medium.com/views-in-snowflake-part-3-secure-view-8bbd8832b3af
upvoted 2 times
...
Heetec
1 year, 1 month ago
Selected Answer: AC
A and C
upvoted 1 times
...
Thaiya
1 year, 2 months ago
A and C
upvoted 1 times
...
Amitsnowflake
1 year, 2 months ago
Selected Answer: AC
A and C
upvoted 1 times
...
HighBMI
1 year, 5 months ago
Selected Answer: AC
AC are the correct answers
upvoted 1 times
...
Needium
1 year, 6 months ago
Selected Answer: AC
AC is correct
upvoted 1 times
...
aroma
1 year, 7 months ago
AC is correct
upvoted 2 times
...
Raju039
1 year, 8 months ago
Selected Answer: AC
The internals of a secure view are not exposed in Query Profile (in the web interface).
upvoted 3 times
Raju039
1 year, 8 months ago
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 1 times
...
...
KarBiswa
1 year, 8 months ago
Selected Answer: AC
correct answer
upvoted 2 times
...
mayank
1 year, 8 months ago
Selected Answer: AC
a and c.
upvoted 2 times
...
markpumc
1 year, 9 months ago
A and E
upvoted 1 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 ...