- (Topic 1)
Which of the following are benefits of micro-partitioning? (Select TWO)
Correct Answer:BC
Micro-partitions in Snowflake are immutable objects, which means once they are written, they cannot be modified. This immutability supports the use of Time Travel, allowing users to access historical data within a defined period. Additionally, micro-partitions can significantly reduce the amount of I/O from object storage to virtual warehouses. This is because Snowflake??s query optimizer can skip over micro-partitions that do not contain relevant data for a query, thus reducing the amount of data that needs to be scanned and transferred.
References: [COF-C02] SnowPro Core Certification Exam Study Guide https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html
- (Topic 1)
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
Correct Answer:B
The ACCOUNTADMIN role is the most powerful role in Snowflake and should be limited to a select number of users within an organization. It is responsible for account-level configurations and should not be used for day-to-day object creation or management. Granting a custom role to ACCOUNTADMIN could inadvertently give broad access to users with this role, which is not a recommended security practice.
Reference:https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
- (Topic 3)
At what levels can a resource monitor be configured? (Select TWO).
Correct Answer:AE
Resource monitors in Snowflake can be configured at the account and virtual warehouse levels. They are used to track credit usage and control costs associated with running virtual warehouses. When certain thresholds are reached, resource monitors can trigger actions such as sending alerts or suspending warehouses to prevent excessive credit consumption. References: [COF-C02] SnowPro Core Certification Exam Study Guide
- (Topic 2)
Which command can be used to load data files into a Snowflake stage?
Correct Answer:C
The PUT command is used to load data files into a Snowflake stage. This command uploads data files from a local file system to a specified stage in Snowflake
- (Topic 5)
Which data types optimally store semi-structured data? (Select TWO).
Correct Answer:AE
In Snowflake, semi-structured data is optimally stored using specific data types that are designed to handle the flexibility and complexity of such data. TheVARIANT data type can store structured and semi-structured data types, including JSON, Avro, ORC, Parquet, or XML, in a single column. TheARRAYdata type, on the other hand, is suitable for storing ordered sequences of elements, which can be particularly useful for semi- structured data types like JSON arrays. These data types provide the necessary flexibility to store and query semi-structured data efficiently in Snowflake.
References:
✑ Snowflake Documentation: Semi-structured Data Types
- (Topic 6)
What are the possible values within a METADATASACTION column in a Snowflake stream? (Select TWO).
Correct Answer:AC
In Snowflake streams, theMETADATASACTIONcolumn indicates the type of data manipulation operation that has occurred. The possible values includeINSERTandDELETE.
✑ INSERT:Indicates that a new row has been inserted into the table.
✑ DELETE:Indicates that a row has been deleted from the table.
References:
✑ Snowflake Documentation: Change Data Capture (CDC) with Streams
✑ Snowflake Documentation: Stream Data Capture