Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?
Answer : B
The Snowflake feature that allows for small volumes of data to be continuously loaded into Snowflake and incrementally made available for analysis is Snowpipe.Snowpipe is designed for near-real-time data loading, enabling data to be loaded as soon as it's available in the storage layer3
Question 2
Why would a Snowflake user load JSON data into a VARIANT column instead of a string column?
Answer : C
A VARIANT column in Snowflake is specifically designed to store semi-structured data, such as JSON, and allows for the creation of a data hierarchy. Unlike string columns, VARIANT columns can natively handle JSON data structures, enabling complex querying and manipulation of hierarchical data using functions designed for semi-structured data.
References:
Snowflake Documentation: VARIANT Data
Question 3
Which function will convert semi-structured data to a relational data representation?
Answer : B
Question 4
True or False: A Virtual Warehouse can be resized while suspended.
Answer : A
Question 5
Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?
Answer : A
Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should ideally be granted to the ACCOUNTADMIN role. This recommendation stems from the best practices for implementing a least privilege access control model, ensuring that only the necessary permissions are granted at each level of the role hierarchy. The ACCOUNTADMIN role has the highest level of privileges in Snowflake, including the ability to manage all aspects of the Snowflake account. By assigning the top-most custom role to ACCOUNTADMIN, you ensure that the administration of role hierarchies and the assignment of roles remain under the control of users with the highest level of oversight and responsibility within the Snowflake environment.
References:
Snowflake Documentation on Access Control: Managing Access Control
Question 6
Which feature is only available in the Enterprise or higher editions of Snowflake?
Answer : A
Column-level security is a feature that allows fine-grained control over access to specific columns within a table. This is particularly useful for managing sensitive data and ensuring that only authorized users can view or manipulate certain pieces of information. According to my last update, this feature was available in the Enterprise Edition or higher editions of Snowflake.
References: Based on my internal data as of 2021, column-level security is an advanced feature typically reserved for higher-tiered editions like the Enterprise Edition in data warehousing solutions such as Snowflake.
Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?
Answer : D
The search optimization service improves the performance of point lookup queries on large tables by using selective filters to quickly return a small number of rows.It creates an optimized data structure that helps in pruning the micro-partitions that do not contain the queried values3. References: [COF-C02] SnowPro Core Certification Exam Study Guide
All Official Question Types