How can a Snowflake user optimize query performance in Snowflake? (Select TWO).
Correct Answer: A,D
Question 777
How can a Snowflake user access a JSON object, given the following table? (Select TWO).
Correct Answer: A,C
To access a JSON object in Snowflake, dot notation is used where the path to the object is specified after the column name containing the JSON data. Both lowercase and uppercase can be used for attribute names, so both "name" and "Name" are valid. References: [COF-C02] SnowPro Core Certification Exam Study Guide
Question 778
A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake. What table type should be used?
Correct Answer: B
For minimizing the cost of large tables that are used to store transitory data, which does not need to be protected against failures because it can be reconstructed outside of Snowflake, the best table type to use is Transient. Transient tables in Snowflake are designed for temporary or transitory data storage and offer reduced storage costs compared to permanent tables. However, unlike temporary tables, they persist across sessions until explicitly dropped. * Why Transient Tables: Transient tables provide a cost-effective solution for storing data that is temporary but needs to be available longer than a single session. They have lower data storage costs because Snowflake does not maintain historical data (Time Travel) for as long as it does for permanent * tables. * Creating a Transient Table: * To create a transient table, use the TRANSIENT keyword in the CREATE TABLE statement: CREATE TRANSIENT TABLE my_transient_table (...); * Use Case Considerations: Transient tables are ideal for scenarios where the data is not critical, can be easily recreated, and where cost optimization is a priority. They are suitable for development, testing, or staging environments where data longevity is not a concern. Reference: For more details on transient tables and their usage scenarios, refer to the Snowflake documentation on table types: https://docs.snowflake.com/en/sql-reference/sql/create-table.html#table-types
Question 779
What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?
Correct Answer: C
Question 780
Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).
Correct Answer: B,E
In Snowflake, a user with the SECURITYADMIN role or higher can activate and enforce a network policy for all users in an account. Additionally, a role that has ownership of the network policy can also activate and enforce it
