SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 259


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

Show Answer
Correct Answer: AC

When considering the use of a Secure View, it is important to note that no details of the query execution plan will be available in the query profiler, which maintains the security of the view. Additionally, secure views do not take advantage of the same internal optimizations as standard views because these optimizations often require access to the underlying data, which secure views are designed to protect.

Discussion

17 comments
Sign in to comment
AS314Options: AC
Dec 25, 2022

https://alexandersks.medium.com/views-in-snowflake-part-3-secure-view-8bbd8832b3af

halolOptions: AC
Dec 8, 2022

A & C i think

Raju039Options: AC
Mar 17, 2023

The internals of a secure view are not exposed in Query Profile (in the web interface).

Raju039
Mar 17, 2023

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.

mayankOptions: AC
Feb 28, 2023

a and c.

KarBiswaOptions: AC
Mar 10, 2023

correct answer

aromaOptions: AC
Apr 14, 2023

AC is correct

Avi0407Options: AC
Nov 6, 2023

https://alexandersks.medium.com/views-in-snowflake-part-3-secure-view-8bbd8832b3af

markpumcOptions: AE
Feb 13, 2023

A and E

NeediumOptions: AC
May 9, 2023

AC is correct

HighBMIOptions: AC
May 28, 2023

AC are the correct answers

AmitsnowflakeOptions: AC
Aug 30, 2023

A and C

ThaiyaOptions: AC
Sep 11, 2023

A and C

HeetecOptions: AC
Sep 30, 2023

A and C

GAUURAAVOptions: AC
Nov 16, 2023

A and C

_yyuktaOptions: AC
Feb 26, 2024

A and C are correct

Vijay2605Options: AC
Mar 7, 2024

AC is the right ans

Mallikharjuna452Options: AC
Jul 22, 2024

A and C are correct