Question 111 · 1323 in bank
A column named “Data” contains VARIANT data and stores values as follows:
How will Snowflake extract the employee’s name from the column data?
Show answer
Answer: C
COF-C02AssociateSnowflakeAll questions freePage 12 of 133
COF-C02 practice questions 111–120
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 112 · 1323 in bank
Use of which Snowflake function is recommended when unloading data from a relational table into a JSON file?
Show answer
Answer: D
Question 113 · 1323 in bank
True or False: The COPY command must specify a File Format in order to execute.
Show answer
Answer: B
Explanation
The correct answer is FALSE. The file format can be defined at the stage, table, or copy into command. Create Stage: https://docs.snowflake.com/en/sql-reference/sql/create-stage.html Create Table (STAGE_FILE_FORMAT option): https://docs.snowflake.com/en/sql-reference/sql/create-table.html Copy Into: https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
Source: Adapted from community discussion — jjordan
Question 114 · 1323 in bank
True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.
Show answer
Answer: A
Explanation
Check this document: https://docs.snowflake.com/en/user-guide/warehouses-overview#auto-suspension-and-auto-resumption "By default, auto-suspend is enabled. Snowflake automatically suspends the warehouse if it is inactive for the specified period of time." At that point Snowflake makes clear distinction between "active/inactive" and "suspended". And considering this article: https://docs.snowflake.com/en/user-guide/cost-understanding-compute#virtual-warehouse-credit-usage The only conclusion is that the answer to the question is A - Virtual Warehouse consumes credits even if it's inactive, as long as it's not suspended manually or by the auto-suspend functionality.
Source: Adapted from community discussion — rogerek077
Question 115 · 1323 in bank
Which command should be used to generate a single file when unloading data from a Snowflake table into a file?
Show answer
Answer: C
Question 116 · 1323 in bank
Which function can be used to convert semi-structured data into rows and columns?
Show answer
Answer: B
Question 117 · 1323 in bank
Select 2What user setting can be configured to disable Multi-Factor Authentication (MFA) for a Snowflake user? (Choose two.)
Show answer
Answer: AB
References
Question 118 · 1323 in bank
Which table type has a Fail-safe period of 7 days?
Show answer
Answer: C
Question 119 · 1323 in bank
How does Snowflake enable OAuth?
Show answer
Answer: B
Explanation
https://docs.snowflake.com/en/user-guide/oauth-intro Administrators configure OAuth using a Security integration, which enables clients that support OAuth to redirect users to an authorization page and generate access tokens (and optionally, refresh tokens) for accessing Snowflake.
Source: Adapted from community discussion — 03146c3
References
Question 120 · 1323 in bank
Which type of workload traditionally benefits from the use of the query acceleration service?
Show answer
Answer: B
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 111. 1323 questions available.
About this question bank
Version 1.0.0. How we source questions