A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:
1.
Runs a query that takes 3 minutes to complete
2.
Leaves for 15 minutes
3.
Returns and runs a query that takes 10 seconds to complete
4.
Manually suspends the warehouse as soon as the last query was completed
When the user returns, how much billable compute time will have been consumed?
A. 4 minutes
B. 10 minutes
C. 14 minutes
D. 24 minutes
What is the recommended compressed file size range for continuous data loads using Snowpipe?
A. 8-16 MB
B. 16-24 MB
C. 10-99 MB
D. 100-250 MB
How many days is load history for Snowpipe retained?
A. 1 day
B. 7 days
C. 14 days
D. 64 days
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used.
The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?
A. Compress the file and load the compressed file.
B. Split the file into multiple files in the recommended size range (100 MB-250 MB).
C. Use a larger-sized warehouse.
D. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
A. Enterprise
B. Business Critical
C. Standard
D. Virtual Private Snowflake
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
A. Custom Edition
B. Virtual Private Snowflake
C. Business Critical Edition
D. Standard Edition
E. Enterprise Edition
Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)
A. Query execution
B. Data loading
C. Time Travel data
D. Security
E. Authentication and access control
What impacts the credit consumption of maintaining a materialized view? (Choose two.)
A. Whether or not it is also a secure view
B. How often the underlying base table is queried
C. How often the base table changes
D. Whether the materialized view has a cluster key defined
E. How often the materialized view is queried
A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?
A. 1 second
B. 60 seconds
C. 5 minutes
D. 60 minutes
What are common issues found by using the Query Profile? (Choose two.)
A. Identifying queries that will likely run very slowly before executing them
B. Locating queries that consume a high amount of credits
C. Identifying logical issues with the queries
D. Identifying inefficient micro-partition pruning
E. Data spilling to a local or remote disk
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 COF-C02 exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.