Question 631 · 1323 in bank
What is the compressed size limit for semi-structured data loaded into a VARIANT data type using the COPY command?
Show answer
Answer: B
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 compressed size limit for semi-structured data loaded into a VARIANT data type using the COPY command?
Answer: B
User A cloned a schema and overwrote a schema that User B was working on. User B no longer has access to their version of the tables. However, this all occurred within the Time Travel retention period defined at the database level. How should the missing tables be restored?
Answer: C
C is correct! If an object with the same name already exists, UNDROP fails. Need to rename the existing object, which then enables us to restore the previous version of the object.
Source: Adapted from community discussion — BobFar
How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?
Answer: D
What is Snowflake's general guideline for files used to load data?
Answer: D
by discard, not A because you have to load the data on a stage before being able to load it into a table. not b because comma is the default delimiter. not c because edi is not supported.
Source: Adapted from community discussion — SnowProCertDec22
How does a Snowflake user execute an anonymous block of code?
Answer: B
The BEGIN … END statement that defines the block also executes the block. (You don’t run a separate CALL command to execute the block.) https://docs.snowflake.com/en/developer-guide/snowflake-scripting/blocks.html#using-an-anonymous-block
Source: Adapted from community discussion — SnowProCertDec22
When unloading data from Snowflake, the user executes a COPY INTO [location] command into an internal stage. What additional command is required to load the file onto the local file system?
Answer: A
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are: (Choose two.)
Answer: AB
A Snowflake user has a query that is running for a long time. When the user opens the query profiler, it indicates that a lot of data is spilling to disk. What is causing this to happen?
Answer: D
What is the MOST performant file format for loading data in Snowflake?
Answer: C
Loading from Gzipped CSV is several times faster than loading from ORC and Parquet at an impressive 15 TB/Hour. While 5-6 TB/hour is decent if your data is originally in ORC or Parquet, don’t go out of your way to CREATE ORC or Parquet files from CSV in the hope that it will load Snowflake faster. Loading data into fully structured (columnarized) schema is ~10-20% faster than landing it into a VARIANT. https://community.snowflake.com/s/article/How-to-Load-Terabytes-Into-Snowflake-Speeds-Feeds-and-Techniques
Source: Adapted from community discussion — leozhang
Which chart type does Snowsight support to visualize worksheet data?
Answer: D
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 631. 1323 questions available.
Version 1.0.0. How we source questions