- (Topic 5)
What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).

1. A. If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.
2. B. If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.
3. C. If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.
4. D. If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.
5. E. If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.

Correct Answer: AB
When initiating a session in Snowflake, the system determines the current role based on the user's connection details and role assignments. If a user specifies a role during the connection, and that role is already granted to them, Snowflake sets it as the current role for the session. Alternatively, if no role is specified during the connection, but the user has a default role assigned, Snowflake will use this default role as the current session role. These mechanisms ensure that users operate within their permissions, enhancing security and governance within Snowflake environments.
References:
✑ Snowflake Documentation: Understanding Roles

- (Topic 6)
Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?

1. A. DELETE
2. B. DROP
3. C. REMOVE
4. D. TRUNCATE

Correct Answer: C
TheREMOVEcommand is used in Snowflake to delete files from a stage after they have been successfully ingested into Snowflake tables. This command helps manage storage by allowing users to clean up staged files that are no longer needed, ensuring that the stage does not accumulate unnecessary data over time. UnlikeDELETE,DROP, orTRUNCATE commands, which are used for managing data within Snowflake tables or dropping objects, REMOVEspecifically targets the management of files in stages.References:Snowflake Documentation on Stages and File Management

- (Topic 6)
What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?

1. A. Repair the failed resources.
2. B. Restart failed resources.
3. C. Queue the failed resources
4. D. Provision the failed resources

Correct Answer: B
If any compute resources for a virtual warehouse fail to provision during startup, Snowflake will attempt to restart those failed resources. The system is designed to automatically handle transient issues that might occur during the provisioning of compute resources. By restarting the failed resources, Snowflake aims to ensure that the virtual warehouse has the necessarycompute capacity to handle the user's workloads without manual intervention.References:Snowflake Documentation on Virtual Warehouses

- (Topic 5)
Which statement accurately describes Snowflake's architecture?

1. A. It uses a local data repository for all compute nodes in the platform.
2. B. It is a blend of shared-disk and shared-everything database architectures.
3. C. It is a hybrid of traditional shared-disk and shared-nothing database architectures.
4. D. It reorganizes loaded data into internal optimized, compressed, and row-based format.

Correct Answer: C
Snowflake's architecture is unique in that it combines elements of both traditional shared-disk and shared-nothing database architectures. This hybrid approach allows Snowflake to offer the scalability and performance benefits of a shared-nothing architecture (with compute and storage separated) while maintaining the simplicity and flexibility of a shared-disk architecture in managing data across all nodes in the system. This results in an architecture that provides on-demand scalability, both vertically and horizontally, without sacrificing performance or data cohesion.
References:
✑ Snowflake Documentation: Snowflake Architecture

- (Topic 3)
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

1. A. Schemas
2. B. Roles
3. C. Secure Views
4. D. Stored Procedures
5. E. Tables
6. F. Secure User-Defined Functions (UDFs)

Correct Answer: ACF
In Snowflake, you can share several types of objects with other Snowflake accounts. These include schemas, secure views, and secure user-defined functions (UDFs). Sharing these objects allows for collaboration and data access across different Snowflake accounts while maintaining security and governance controls4.