In Snowflake, the use of federated authentication enables which Single Sign-On (SSO) workflow activities? (Select TWO).
Correct Answer: B,C
Federated authentication in Snowflake allows users to use their organizational credentials to log in to Snowflake, leveraging Single Sign-On (SSO). The key activities enabled by this setup include: * B. Initiating user sessions: Federated authentication streamlines the process of starting a user session in Snowflake by using the existing authentication mechanisms of an organization. * C. Logging into Snowflake: It simplifies the login process, allowing users to authenticate with their organization's identity provider instead of managing separate credentials for Snowflake. References: * Snowflake Documentation: Configuring Federated Authentication
Question 552
What can the Snowflake SCIM API be used to manage? (Select TWO).
Correct Answer: A,B
Question 553
Which stage type can be altered and dropped?
Correct Answer: B
External stages can be altered and dropped in Snowflake. An external stage points to an external location, such as an S3 bucket, where data files are stored. Users can modify the stage's definition or drop it entirely if it's no longer needed. This is in contrast to table stages, which are tied to specific tables and cannot be altered or dropped independently. Reference: [COF-C02] SnowPro Core Certification Exam Study Guide Snowflake Documentation on Stages1
Question 554
The fail-safe retention period is how many days?
Correct Answer: B
Question 555
Who can activate a network policy for users in a Snowflake account? (Select TWO)
Correct Answer: A,E
Network policies in Snowflake are used to control access to Snowflake accounts based on IP address ranges. These policies can be activated by specific roles that have the necessary privileges. * Role: ACCOUNTADMIN: * The ACCOUNTADMIN role has full administrative rights across the Snowflake account. * This role can manage all aspects of the Snowflake environment, including network policies. * Role with Global ATTACH POLICY Privilege: * Any role that has been granted the global ATTACH POLICY privilege can activate network policies. * This privilege allows the role to attach policies that control network access to the account. : Snowflake Documentation: Network Policies
