Question 901 · 1323 in bank
Select 2What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Choose two.)
Show answer
Answer: BD
COF-C02AssociateSnowflakeAll questions freePage 91 of 133
COF-C02 practice questions 901–910
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
Official study references
1323 questions in this bank
Free access · progress saved on this device
Question 902 · 1323 in bank
How do Snowflake data providers share data that resides in different databases?
Show answer
Answer: B
Explanation
Snowflake data providers can share data that resides in different databases by using secure views. A secure view can reference objects such as schemas, tables, and other views from one or more databases, as long as these databases belong to the same account.
Source: Adapted from community discussion — nexerSnow
References
Question 903 · 1323 in bank
Select 2What operations can be performed while loading a simple CSV file into a Snowflake table using the COPY INTO command? (Choose two.)
Show answer
Answer: BD
References
Question 904 · 1323 in bank
Select 2Which commands support a multiple-statement request to access and update Snowflake data? (Choose two.)
Show answer
Answer: BE
References
Question 905 · 1323 in bank
Select 2Why should a Snowflake user implement a secure view? (Choose two.)
Show answer
Answer: CE
References
Question 906 · 1323 in bank
Select 2At what levels can a resource monitor be configured? (Choose two.)
Show answer
Answer: AE
Explanation
An account monitor monitors the credit usage of all the warehouses in the account. An account can only have one account monitor. A warehouse monitor monitors the credit usage of the warehouses assigned to the resource monitor. An account can have multiple warehouse monitors.
Source: Adapted from community discussion — nexerSnow
References
Question 907 · 1323 in bank
Select 2What activities can be monitored by a user directly from Snowsight's Activity tab without using the Account_Usage views? (Choose two.)
Show answer
Answer: BC
References
Question 908 · 1323 in bank
Select 2Which of the following is true of Snowpipe via REST API? (Choose two.)
Show answer
Answer: CD
Explanation
Answer is C & D. Not B as: https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html#usage-notes All COPY INTO copy options are supported except for the following: FILES = ( 'file_name1' [ , 'file_name2', ... ] ) ON_ERROR = ABORT_STATEMENT SIZE_LIMIT = num PURGE = TRUE | FALSE (i.e. automatic purging while loading) FORCE = TRUE | FALSE
Source: Adapted from community discussion — redsky0
Question 909 · 1323 in bank
What can a Snowflake user do with the information included in the details section of a Query Profile?
Show answer
Answer: A
References
Question 910 · 1323 in bank
Select 2How can a Snowflake user access a JSON object, given the following table? (Choose two.)
Show answer
Answer: BD
Explanation
https://docs.snowflake.com/en/user-guide/querying-semistructured Important Regardless of which notation you use, the column name is case-insensitive but element names are case-sensitive. For example, in the following list, the first two paths are equivalent, but the third is not: src:salesperson.name SRC:salesperson.name SRC:Salesperson.Name
Source: Adapted from community discussion — ravuri_rk
References
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 901. 1323 questions available.
About this question bank
Version 1.0.0. How we source questions