- (Topic 4)
A column named "Data" contains VARIANT data and stores values as follows:

How will Snowflake extract the employee's name from the column data?

1. A. Data:employee.name
2. B. DATA:employee.name
3. C. data:Employee.name
4. D. data:employee.name

Correct Answer: D
In Snowflake, to extract a specific value from a VARIANT column, you use the column name followed by a colon and then the key. The keys are case-sensitive.
Therefore, to extract the employee??s name from the ??Data?? column, the correct syntax is data:employee.name.

- (Topic 5)
How are network policies defined in Snowflake?

1. A. They are a set of rules that define the network routes within Snowflake.
2. B. They are a set of rules that dictate how Snowflake accounts can be used between multiple users.
3. C. They are a set of rules that define how data can be transferred between different Snowflake accounts within an organization.
4. D. They are a set of rules that control access to Snowflake accounts by specifying the IP addresses or ranges of IP addresses that are allowed to connectto Snowflake.

Correct Answer: D
Network policies in Snowflake are defined as a set of rules that manage the network-level access to Snowflake accounts. These rules specify which IP addresses or IP ranges are permitted to connect to Snowflake, enhancing the security of Snowflake accounts by preventing unauthorized access. Network policies are an essential aspect of Snowflake's security model, allowing administrators to enforce access controls based on network locations.
References:
✑ Snowflake Documentation: Network Policies

- (Topic 1)
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

1. A. Load files that are approximately 25 MB or smaller.
2. B. Remove all dates and timestamps.
3. C. Load files that are approximately 100-250 MB (or larger)
4. D. Avoid using embedded characters such as commas for numeric data types
5. E. Remove semi-structured data types

Correct Answer: CD
When loading data into Snowflake, it is recommended to:
✑ C. Load files that are approximately 100-250 MB (or larger): This size is optimal for parallel processing and can help to maximize throughput. Smaller files can lead to overhead that outweighs the actual data processing time.
✑ D. Avoid using embedded characters such as commas for numeric data types:
Embedded characters can cause issues during data loading as they may be interpreted incorrectly. It??s best to clean the data of such characters to ensure accurate and efficient data loading.
These best practices are designed to optimize the data loading process, ensuring that data is loaded quickly and accurately into Snowflake.
References:
✑ Snowflake Documentation on Data Loading Considerations
✑ [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 4)
A permanent table and temporary table have the same name, TBL1, in a schema. What will happen if a user executes select * from TBL1 ;?

1. A. The temporary table will take precedence over the permanent table.
2. B. The permanent table will take precedence over the temporary table.
3. C. An error will say there cannot be two tables with the same name in a schema.
4. D. The table that was created most recently will take precedence over the older table.

Correct Answer: A
In Snowflake, if a temporary table and a permanent table have the same name within the same schema, the temporary table takes precedence over the permanent table within the session where the temporary table was created4.

- (Topic 1)
What is the default File Format used in the COPY command if one is not specified?

1. A. CSV
2. B. JSON
3. C. Parquet
4. D. XML

Correct Answer: A
The default file format for the COPY command in Snowflake, when not specified, is CSV (Comma-Separated Values). This format is widely used for data exchange because it is simple, easy to read, and supported by many data analysis tools.