- (Topic 5)
Which command removes a role from another role or a user in Snowflak?
Correct Answer:B
TheREVOKE ROLEcommand is used to remove a role from another role or a user in Snowflake. This command is part of Snowflake's role-based access control system, allowing administrators to manage permissions and access to database objects efficiently by adding or removing roles from users or other roles.
References:
✑ Snowflake Documentation: REVOKE ROLE
- (Topic 4)
Which commands can only be executed using SnowSQL? (Select TWO).
Correct Answer:CD
The LIST and PUT commands are specific to SnowSQL and cannot be executed in the web interface or other SQL clients. LIST is used to display the contents of a stage, and PUT is used to upload files to a stage. References: [COF-C02] SnowPro Core Certification Exam Study Guide
- (Topic 3)
How can a Snowflake user optimize query performance in Snowflake? (Select TWO).
Correct Answer:BC
To optimize query performance in Snowflake, users can cluster a table, which organizes the data in a way that minimizes the amount of data scanned during queries. Additionally, enabling the searchoptimization service can improve the performance of selective point lookup queries on large tables34.
- (Topic 6)
In Snowflake, the use of federated authentication enables which Single Sign-On (SSO) workflow activities? (Select TWO).
Correct Answer:BC
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
- (Topic 5)
When using the ALLOW_CLI£NT_MFA_CACHING parameter, how long is a cached Multi- Factor Authentication (MFA) token valid for?
Correct Answer:C
A cached MFA token is valid for up to four hours.https://docs.snowflake.com/en/user-guide/security-mfa#using-mfa-token-caching-to-minimize-the-number-of-prompts-during-authentication-optional