Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 991:

  What are value types that a VARIANT column can store? (Select TWO)

  A. STRUCT

  B. OBJECT

  C. BINARY

  D. ARRAY

  E. CLOB

  Correct Answer: BD

  Characteristics of a VARIANT

  A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB. https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics%

  20of%20a%20VARIANT,a%20VARIANT%20is% 2016%20MB.

• Question 992:

  When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

  A. A single join node uses more than 50% of the query time

  B. Partitions scanned is equal to partitions total

  C. An AggregateOperacor node is present

  D. The query is spilling to remote storage

  Correct Answer: D

• Question 993:

  Which of the following compute resources or features are managed by Snowflake? (Select TWO).

  A. Execute a COPY command

  B. Updating data

  C. Snowpipe

  D. AUTOMATIC__CLUSTERING

  E. Scaling up a warehouse

  Correct Answer: CD

• Question 994:

  Which command can be used to load data into an internal stage?

  A. LOAD

  B. copy

  C. GET

  D. PUT

  Correct Answer: D

  https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9

• Question 995:

  A user has an application that writes a new Tile to a cloud storage location every 5 minutes.

  What would be the MOST efficient way to get the files into Snowflake?

  A. Create a task that runs a copy into operation from an external stage every 5 minutes

  B. Create a task that puts the files in an internal stage and automate the data loading wizard

  C. Create a task that runs a GET operation to intermittently check for new files

  D. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

• Question 996:

  What are the default Time Travel and Fail-safe retention periods for transient tables?

  A. Time Travel-1 day. Fail-safe-1 day

  B. Time Travel-0 days. Fail-safe-1 day

  C. Time Travel-1 day. Fail-safe-0 days

  D. Transient tables are retained in neither Fail-safe nor Time Travel

  Correct Answer: C

  https://docs.snowflake.com/en/user-guide/data-cdp-storage-costs.html#:~:text=Temporary%20and%20Transient%20Tables,-To%20help% 20manageandtext=Temporary%20tables%20can%20also%20have,have%20no%20Fail%2Dsafe% 20period.

• Question 997:

  What can be used to view warehouse usage over time? (Select Two).

  A. The load HISTORY view

  B. The Query history view

  C. The show warehouses command

  D. The WAREHOUSE_METERING__HISTORY View

  E. The billing and usage tab in the Snowflake web Ul

  Correct Answer: DE

• Question 998:

  Which command can be used to stage local files from which Snowflake interface?

  A. SnowSQL

  B. Snowflake classic web interface (Ul)

  C. Snowsight

  D. .NET driver

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/snowsql-use.html

• Question 999:

  Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

  A. The table contains a column that has very low cardinality

  B. DML statements that are being issued against the table are blocked

  C. The table has a small number of micro-partitions

  D. Queries on the table are running slower than expected

  E. The clustering depth for the table is large

  Correct Answer: DE

• Question 1000:

  How often are encryption keys automatically rotated by Snowflake?

  A. 30 Days

  B. 60 Days

  C. 90 Days

  D. 365 Days

  Correct Answer: A

  All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When Snowflake determines the retired key is no longer needed, the key is automatically destroyed. https://docs.snowflake.com/en/user-guide/security-encryption-manage.html#:~:text=All%20Snowflake%2Dmanaged%20keys%20are,the%20key%20is% 20automatically%20destroyed.