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
How does the PARTITION BY option affect an expression for a COPY INTO [location] command?
Answer: B
B. The PARTITION BY option in a COPY INTO command specifies an expression that partitions the unloaded table rows into separate files unloaded to the specified stage. The expression must be based on one or more columns in the table.
Source: Adapted from community discussion — Gwo
How does Snowflake improve the performance of queries that are designed to filter out a significant amount of data?
Answer: B
A JSON document is stored in the source_column of type VARIANT. The document has an array called elements. The array contains the name key that has a string value. How can a Snowflake user extract the name from the first element?
Answer: D
Which function should be used to insert JSON formatted string data into a VARIANT field?
Answer: C
Which permission on a Snowflake virtual warehouse allows the role to resize the warehouse?
Answer: B
What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?
Answer: C
What is the COPY INTO [location] command option default for unloading data into multiple files?
Answer: D
A size 3X-Large multi-cluster warehouse runs one cluster for one full hour and then runs two clusters for the next full hour. What would be the total number of credits billed?
Answer: D
I hope I don't have to calculate this in my head on the exam :) D XS - S - M - L - XL - 2XL - 3XL 1 - 2 -4 - 8 - 16 - 32 -64 1st hr - 1 2nd hr - 2 64*3 = 192
Source: Adapted from community discussion — 0e504b5
What is the impact of increasing the number of concurrent users on a Snowflake virtual warehouse?
Answer: C
What are the three things customer want most from their enterprise data warehouse solution? (Choose three.)
Answer: BDE
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 1051. 1323 questions available.
Version 1.0.0. How we source questions