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 (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
AS314
Highly Voted 2 years, 4 months ago
Selected Answer: AC
https://alexandersks.medium.com/views-in-snowflake-part-3-secure-view-8bbd8832b3af
upvoted 13 times
...
halol
Highly Voted 2 years, 5 months ago
Selected Answer: AC
A & C i think
upvoted 8 times
...
Mallikharjuna452
Most Recent 9 months, 3 weeks ago
A and C are correct
upvoted 1 times
...
Vijay2605
1 year, 2 months ago
Selected Answer: AC
AC is the right ans
upvoted 1 times
...
_yyukta
1 year, 2 months ago
Selected Answer: AC
A and C are correct
upvoted 1 times
...
GAUURAAV
1 year, 5 months ago
A and C
upvoted 1 times
...
Avi0407
1 year, 6 months ago
Selected Answer: AC
https://alexandersks.medium.com/views-in-snowflake-part-3-secure-view-8bbd8832b3af
upvoted 2 times
...
Heetec
1 year, 7 months ago
Selected Answer: AC
A and C
upvoted 1 times
...
Thaiya
1 year, 8 months ago
A and C
upvoted 1 times
...
Amitsnowflake
1 year, 8 months ago
Selected Answer: AC
A and C
upvoted 1 times
...
HighBMI
1 year, 11 months ago
Selected Answer: AC
AC are the correct answers
upvoted 1 times
...
Needium
2 years ago
Selected Answer: AC
AC is correct
upvoted 1 times
...
aroma
2 years ago
AC is correct
upvoted 2 times
...
Raju039
2 years, 1 month ago
Selected Answer: AC
The internals of a secure view are not exposed in Query Profile (in the web interface).
upvoted 4 times
Raju039
2 years, 1 month 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
2 years, 2 months ago
Selected Answer: AC
correct answer
upvoted 2 times
...
mayank
2 years, 2 months ago
Selected Answer: AC
a and c.
upvoted 2 times
...
markpumc
2 years, 2 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago