ExamGecko
Question list
Search
Search

Question 568 - SnowPro Core discussion

Report
Export

Which governance feature is supported by all Snowflake editions?

A.

Object tags

Answers
A.

Object tags

B.

Masking policies

Answers
B.

Masking policies

C.

Row access policies

Answers
C.

Row access policies

D.

OBJECT_DEPENDENCIES View

Answers
D.

OBJECT_DEPENDENCIES View

Suggested answer: D

Explanation:

Snowflake's governance features vary across different editions, but the OBJECT_DEPENDENCIES view is supported by all Snowflake editions. This feature is part of Snowflake's Information Schema and is designed to help users understand the dependencies between various objects in their Snowflake environment.

The OBJECT_DEPENDENCIES view provides a way to query and analyze the relationships and dependencies among different database objects, such as tables, views, and stored procedures. This is crucial for governance, as it allows administrators and data engineers to assess the impact of changes, understand object relationships, and ensure proper management of data assets.

Object tags, masking policies, and row access policies are more advanced features that offer fine-grained data governance capabilities such as tagging objects for classification, dynamically masking sensitive data based on user roles, and controlling row-level access to data. These features may have varying levels of support across different Snowflake editions, with some features being exclusive to higher-tier editions.

asked 29/10/2024
Vipulkumar Shukal
37 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first