- (Topic 4)
Which command is used to start configuring Snowflake for Single Sign-On (SSO)?
Correct Answer:
C
To start configuring Snowflake for Single Sign-On (SSO), the CREATE SECURITY INTEGRATION command is used. This command sets up a security integration object in Snowflake, which is necessary for enabling SSO with external identity providers using SAML 2.01.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
- (Topic 2)
What happens to historical data when the retention period for an object ends?
Correct Answer:
C
When the retention period for an object ends in Snowflake, Time Travel on the historical data is dropped ©. This means that the ability to access historical data via Time Travel is no longer available once the retention period has expired2.
- (Topic 3)
What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?
Correct Answer:
C
The Snowpark API allows developers to create User-Defined Functions (UDFs) in various languages, including Python, which is known for its ease of use and wide adoption in data-related tasks. References: Based on general programming and cloud data service knowledge as of 2021.
- (Topic 2)
In a Snowflake role hierarchy, what is the top-level role?
Correct Answer:
C
In a Snowflake role hierarchy, the top-level role is ACCOUNTADMIN. This role has the highest level of privileges and is capable of performing all administrative functions within the Snowflake account
- (Topic 6)
Which views are included in the data_sharing_usage schema? (Select TWO).
Correct Answer:
DE
https://docs.snowflake.com/en/sql-reference/data-sharing-usage
