What is Snowflake's general guideline for files used to load data?
A. Files can be loaded directly into a table.
B. Any delimiter is supported: the default is a semicolon.
C. Electronic Data Interchange (EDI) is one of the supported semi-structured formats.
D. For delimited files, the default character set is UTF-8.
How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?
A. Use Snowpipe.
B. Use the INSERT command.
C. Use an external table.
D. Use the COPY command.
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?
A. Use an UNDROP TABLE statement.
B. Use a CREATE TABLE AS SELECT statement
C. Rename the cloned schema and use an UNDROP SCHEMA statement.
D. Contact Snowflake Support to retrieve the data from Fail-safe
What is the compressed size limit for semi-structured data loaded into a VARIANT data type using the COPY command?
A. 8 MB
B. 16 MB
C. 32 MB
D. 64 MB
When unloading data from Snowflake, the user executes a COPY INTO command into an internal stage.
What additional command is required to load the file onto the local file system?
A. GET
B. LIST
C. PUT
D. REMOVE
How does a Snowflake user execute an anonymous block of code?
A. The user must run the CALL command to execute the block.
B. The statements that define the block must also execute the block.
C. The SUBMIT command must run immediately after the block is defined
D. The block must be saved to a worksheet and executed using a connector.
Which chart type does Snowsight support to visualize worksheet data?
A. Box plot
B. Bubble chart
C. Pie chart
D. Scatterplot
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?
A. The result cache is almost full and is unable to hold the results.
B. The cloud storage staging area is not sufficient to hold the data results.
C. Clustering has not been applied to the table so the table is not optimized.
D. The warehouse memory is not sufficient to hold the intermediate query results.
Which file format is MOST performant in Snowflake for data loading?
A. Parquet
B. CSV
C. ORC
D. Avro
Which clustering indicator will show if a large table in Snowflake will benefit from explicitly defining a clustering key?
A. Percentage
B. Depth
C. Ratio
D. Total partition count
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Snowflake exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your SNOWPRO-CORE exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.