- (Topic 1)
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
Correct Answer:
BD
In all Snowflake editions, two key capabilities are universally available:
✑ B. Automatic encryption of all data: Snowflake automatically encrypts all data stored in its platform, ensuring security and compliance with various regulations. This encryption is transparent to users and does not require any configuration or management.
✑ D. Object-level access control: Snowflake provides granular access control mechanisms that allow administrators to define permissions at the object level, including databases, schemas, tables, and views. This ensures that only authorized users can access specific data objects.
These features are part of Snowflake??s commitment to security and governance, and they are included in every edition of the Snowflake Data Cloud.
References:
✑ Snowflake Documentation on Security Features
✑ SnowPro® Core Certification Exam Study Guide
- (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 3)
When unloading data to an external stage, what is the MAXIMUM file size supported?
Correct Answer:
B
When unloading data to an external stage, the maximum file size supported is 5 GB. This limit ensures efficient data transfer and management within Snowflake??s architecture
- (Topic 3)
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
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.
- (Topic 6)
What are potential impacts of storing non-native values like dates and timestamps in a variant column in Snowflake?
Correct Answer:
B
Storing non-native values, such as dates and timestamps, in a VARIANT column in Snowflake can lead to slower query performance and increased storage consumption. VARIANT is a semi-structured data type that allows storing JSON, AVRO, ORC, Parquet, or XML data in a single column. When non-native data types are stored as VARIANT, Snowflake must perform implicit conversion to process these values, which can slow down query execution. Additionally, because the VARIANT data type is designed to accommodate a wide variety of data formats, it often requires more storage spacecompared to storing data in native, strongly-typed columns that are optimized for specific data types.
The performance impact arises from the need to parse and interpret the semi-structured data on the fly during query execution, as opposed to directly accessing and operating on optimally stored data in its native format. Furthermore, the increased storage consumption is a result of the overhead associated with storing data in a format that is less space- efficient than the native formats optimized for specific types of data.
References:
✑ Snowflake Documentation on Semi-Structured Data: Semi-Structured Data
