Question 891 · 1323 in bank
Select 2Which data types can be used in a Snowflake table that holds semi-structured data? (Choose two.)
Show answer
Answer: AD
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
Which data types can be used in a Snowflake table that holds semi-structured data? (Choose two.)
Answer: AD
Which constraint is enforced in Snowflake?
Answer: B
Which pages are included in the Activity area of Snowsight? (Choose two.)
Answer: CD
When should a user consider disabling auto-suspend for a virtual warehouse? (Choose two.)
Answer: BC
What can a Snowflake user do in the Activity section in Snowsight?
Answer: D
How does Snowflake reorganize data when it is loaded? (Choose two.)
Answer: BC
Which operations are handled in the Cloud Services layer of Snowflake? (Choose two.)
Answer: AE
Which of the following commands are not blocking operations? (Choose two.)
Answer: BD
BD The following guidelines apply in most situations: COMMIT operations (including both AUTOCOMMIT and explicit COMMIT) lock resources, but usually only briefly. UPDATE, DELETE, and MERGE statements hold locks that generally prevent them from running in parallel with other UPDATE, DELETE, and MERGE statements. Most INSERT and COPY statements write only new partitions. Those statements often can run in parallel with other INSERT and COPY operations, and sometimes can run in parallel with an UPDATE, DELETE, or MERGE statement.
Source: Adapted from community discussion — AGuru2020
What type of columns does Snowflake recommend to be used as clustering keys? (Choose two.)
Answer: DE
Which objects together comprise a namespace in Snowflake? (Choose two.)
Answer: BC
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 891. 1323 questions available.
Version 1.0.0. How we source questions