SnowPro Core Certification Exam Questions and Answers
Question 5
When an object is created in Snowflake. who owns the object?
Options:
A.
The public role
B.
The user's default role
C.
The current active primary role
D.
The owner of the parent schema
Answer:
C
Explanation:
In Snowflake, when an object is created, it is owned by the role that is currently active. This active role is the one that is being used to execute the creation command. Ownership implies full control over the object, including the ability to grant and revoke access privileges. This is specified in Snowflake's documentation under the topic of Access Control, which states that "the role in use at the time of object creation becomes the owner of the object."
References:
Snowflake Documentation: Object Ownership
Question 6
What is a characteristic of a tag associated with a masking policy?
Options:
A.
A tag can be dropped after a masking policy is assigned
B.
A tag can have only one masking policy for each data type.
C.
A tag can have multiple masking policies for each data type.
D.
A tag can have multiple masking policies with varying data types
Answer:
B
Explanation:
In Snowflake, a tag can be associated with only one masking policy for each data type. This means that for a given data type, you can define a single masking policy to be applied when a tag is used. Tags and masking policies are part of Snowflake's data classification and governance features, allowing for data masking based on the context defined by the tags.
In Snowflake, the authorization to execute CREATE <object> statements, such as creating tables, views, databases, etc., is determined by the role currently set as the user's primary role. The primary role of a user or session specifies the set of privileges (including creation privileges) that the user has. While users can have multiple roles, only the primary role is used to determine what objects the user can create unless explicitly specified in the session.
[Reference: This is based on the principle of Role-Based Access Control (RBAC) in Snowflake, where roles are used to manage access permissions. The official Snowflake documentation on Understanding and Using Roles would be the best resource to verify this information: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html#roles, , ]
Question 8
What does the Activity area of Snowsight allow users to do? (Select TWO).
Options:
A.
Schedule automated data backups.
B.
Explore each step of an executed query.
C.
Monitor queries executed by users in an account.
D.
Create and manage user roles and permissions.
E.
Access Snowflake Marketplace to find and integrate datasets.
Answer:
B, C
Explanation:
The Activity area of Snowsight, Snowflake's web interface, allows users to perform several important tasks related to query management and performance analysis. Among the options provided, the correct ones are:
B. Explore each step of an executed query: Snowsight provides detailed insights into query execution, including the ability to explore the execution plan of a query. This helps users understand how a query was processed, identify performance bottlenecks, and optimize query performance.
C. Monitor queries executed by users in an account: The Activity area enables users to monitor the queries that have been executed by users within the Snowflake account. This includes viewing the history of queries, their execution times, resources consumed, and other relevant metrics.
These features are crucial for effective query performance tuning and ensuring efficient use of Snowflake's resources.
References:
Snowflake Documentation on Snowsight: Using Snowsight