While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
Correct Answer: B,D
The file format option in Snowflake can be specified in the following commands: CREATE STAGE: This command allows users to define the file format when creating a stage, which applies to any data loaded or unloaded via that stage. COPY INTO <location>: This command enables data export from a table to an external location, where the file format can be specified to ensure the data is structured as needed for downstream systems. Other commands, such as PUT or GET, do not support the specification of file formats directly within the command syntax.
Question 217
The effects of query pruning can be observed by evaluating which statistics? (Select TWO).
Correct Answer: A,C
Query pruning in Snowflake refers to the optimization technique where the system reduces the amount of data scanned by a query based on the query conditions. This typically involves skipping unnecessary data partitions that do not contribute to the query result. The effectiveness of this technique can be observed through: * Option A: Partitions scanned. This statistic indicates how many data partitions were actually scanned as a result of query pruning, showing the optimization in action. * Option C: Bytes scanned. This measures the volume of data physically read during query execution, and a reduction in this number indicates effective query pruning, as fewer bytes are read when unnecessary partitions are skipped. Options B, D, and E do not directly relate to observing the effects of query pruning. "Partitions total" shows the total available, not the impact of pruning, while "Bytes read from result" and "Bytes written" relate to output rather than the efficiency of data scanning. References:Snowflake documentation on performance tuning and query optimization techniques, specifically how query pruning affects data access.
Question 218
What COPY INTO SQL command should be used to unload data into multiple files?
Correct Answer: D
The COPY INTO SQL command with the option SINGLE=FALSE is used to unload data into multiple files. This option allows the data to be split into multiple files during the unload process. References: SnowPro Core Certification COPY INTO SQL command unload multiple files
Question 219
True or False: Data Providers can share data with only the Data Consumer.
Correct Answer: A
Question 220
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
Correct Answer: A,B
Snowflake supports querying semi-structured data using specific data types that are capable of handling the flexibility and structure of such data. The data types supported for this purpose are: A . VARIANT: This is a universal data type that can store values of any other type, including structured and semi-structured types. It is particularly useful for handling JSON, Avro, ORC, Parquet, and XML data formats1. B . ARRAY: An array is a list of elements that can be of any data type, including VARIANT, and is used to handle semi-structured data that is naturally represented as a list1. These data types are part of Snowflake's built-in support for semi-structured data, allowing for the storage, querying, and analysis of data that does not fit into the traditional row-column format. Reference: Snowflake Documentation on Semi-Structured Data [COF-C02] SnowPro Core Certification Exam Study Guide
