SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
What is the purpose of using the OBJECT_CONSTRUCT function with the COPY INTO command?
Answer: B
Unloading a Relational Table to JSON¶ You can use the OBJECT_CONSTRUCT function combined with the COPY command to convert the rows in a relational table to a single VARIANT column and unload the rows into a file.
Source: Adapted from community discussion — ukpino
Which URL provides access to files in Snowflake without authorization?
Answer: C
What type of NULL values are supported in semi-structured data? (Choose two.)
Answer: BE
https://docs.snowflake.com/en/user-guide/semistructured-considerations Snowflake supports two types of NULL values in semi-structured data: SQL NULL: SQL NULL means the same thing for semi-structured data types as it means for structured data types: the value is missing or unknown. JSON null (sometimes called “VARIANT NULL”): In a VARIANT column, JSON null values are stored as a string containing the word “null” to distinguish them from SQL NULL values.
Source: Adapted from community discussion — ukpino
What are characteristics of transient tables in Snowflake? (Choose two.)
Answer: CE
Transient tables are a type of table in Snowflake that persist until they are explicitly dropped. They do not have a Fail-safe period, and they can only have a Time Travel retention period of 0 or 1 day. Transient tables cannot be cloned to permanent tables, and they cannot be altered to make them permanent tables.
Source: Adapted from community discussion — JG1984
The INFORMATION_SCHEMA included in each database contains which objects? (Choose two.)
Answer: AD
What is INFORMATION_SCHEMA?¶ Each database created in your account automatically includes a built-in, read-only schema named INFORMATION_SCHEMA. The schema contains the following objects: Views for all the objects contained in the database, as well as views for account-level objects (i.e. non-database objects such as roles, warehouses, and databases) Table functions for historical and usage data across your account. https://docs.snowflake.com/en/sql-reference/info-schema
Source: Adapted from community discussion — ukpino
The use of which technique or tool will improve Snowflake query performance on very large tables?
Answer: B
Which Snowflake layer is associated with virtual warehouses?
Answer: B
Which MINIMUM set of privileges is required to temporarily bypass an active network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY?
Answer: D
It is possible to temporarily bypass a network policy for a set number of minutes by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY, which can be viewed by executing DESCRIBE USER. Only Snowflake can set the value for this object property. Please contact Snowflake Support to set a value for this property.
Source: Adapted from community discussion — sid1604
What authentication method does the Kafka connector use within Snowflake?
Answer: A
What is the purpose of the Snowflake SPLIT_TO_TABLE function?
Answer: C
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 921. 1323 questions available.
Version 1.0.0. How we source questions