- (Topic 6)
Which role is responsible for managing the billing and credit data within Snowflake?
Correct Answer:
A
The ORGADMIN role in Snowflake is responsible for managing organization-level administrative functions, which include managing billing and credit data. This role has the highest level of administrative privileges and can oversee multiple Snowflake accounts within an organization.
References:
✑ Snowflake Documentation: Account and Organization Roles
- (Topic 6)
When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).
Correct Answer:
AD
When sharing data in Snowflake, the provider needs to grant the following privileges along with a share:
✑ A. USAGE on the specific tables in the database:This privilege allows the
consumers of the share to access the specific tables included in the share.
✑ D. USAGE on the database and the schema containing the tables to share:This privilege is necessary for the consumers to access the database and schema levels, enabling them to access the tables within those schemas.
These privileges are crucial for setting up secure and controlled access to the shared data, ensuring that only authorized users can access the specified resources.
Reference to Snowflake documentation on sharing data and managing access:
✑ Data Sharing Overview
✑ Privileges Required for Sharing Data
- (Topic 1)
What is a limitation of a Materialized View?
Correct Answer:
D
Materialized Views in Snowflake are designed to store the result of a query and can be refreshed to maintain up-to-date data. However, they have certain limitations, one of which is that they cannot be defined using a JOIN clause. This means that a Materialized View can only be created based on a single source table and cannot combine data from multiple tables using JOIN operations.
References:
✑ Snowflake Documentation on Materialized Views
✑ SnowPro® Core Certification Study Guide
- (Topic 1)
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
Correct Answer:
B
The ACCOUNTADMIN role is the most powerful role in Snowflake and should be limited to a select number of users within an organization. It is responsible for account-level configurations and should not be used for day-to-day object creation or management. Granting a custom role to ACCOUNTADMIN could inadvertently give broad access to users with this role, which is not a recommended security practice.
Reference:https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
- (Topic 2)
The is the minimum Fail-safe retention time period for transient tables?
Correct Answer:
D
Transient tables in Snowflake have a minimum Fail-safe retention time period of 0 days. This means that once the Time Travel retention period ends, there is no additional Fail-safe period for transient tables
