Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 111:

  What commands can be used to see what files are stored in a stage? (Choose two.)

  A. LIST

  B. SELECT

  C. LS

  D. GET

  E. DESCRIBE

  Correct Answer: AC

• Question 112:

  Which stages are created by default, with no need to use the CREATE STAGE command? (Choose two.)

  A. External stage

  B. Internal stage

  C. Named stage

  D. Table stage

  E. User stage

  Correct Answer: DE

• Question 113:

  While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

  A. BUILD_STAGE_FILE_URL

  B. GET_ABSOLUTE_PATH

  C. BUILD_SCOPED_FILE_URL

  D. GET_PRESIGNED_URL

  Correct Answer: A

• Question 114:

  Who can create and manage reader accounts? (Choose two.)

  A. A user with ACCOUNTADMIN role

  B. A user with SECURITYADMIN role

  C. A user with SYSADMIN role

  D. A user with ORGADMIN role

  E. A user with CREATE ACCOUNT privilege

  Correct Answer: AE

• Question 115:

  Which command allows for continuous loading of data files as soon as they are available in a stage?

  A. COPY INTO [table]

  B. PUT

  C. CREATE PIPE

  D. GET

  Correct Answer: C

• Question 116:

  What is an advantage of using database roles instead of granting privileges on objects directly to a share in Snowflake?

  A. Easier management of cross-region data sharing

  B. Greater flexibility in including objects from multiple databases

  C. More control over object-level access for different user groups

  D. Reduction in the number of shares required for different objects in the same database

  Correct Answer: C

• Question 117:

  What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?

  A. Data Replication

  B. Secure Data Sharing

  C. Data Exchange

  D. Snowflake Marketplace

  Correct Answer: C

• Question 118:

  Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?

  A. PARSE_JSON

  B. CHECK_JSON

  C. JSON_EXTRACT_PATH_TEXT

  D. PARSE_XML

  Correct Answer: A

• Question 119:

  Which Snowflake data types can be used to build nested hierarchical data? (Choose two.)

  A. INTEGER

  B. OBJECT

  C. VARIANT

  D. VARCHAR

  E. LIST

  Correct Answer: BC

• Question 120:

  Which statistics can be used to identify queries that have inefficient pruning? (Choose two.)

  A. Bytes scanned

  B. Bytes written to result

  C. Partitions scanned

  D. Partitions total

  E. Percentage scanned from cache

  Correct Answer: CD