Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 721:

  What does it mean when the sample function uses the Bernoulli sampling method?

  A. The data is based on sampling every row.

  B. The data is based on sampling 10% of the source data.

  C. The data is based on sampling blocks of the source data.

  D. The data is based on sampling 1000 rows of the source data.

  Correct Answer: A

• Question 722:

  How is the hierarchy of database objects organized in Snowflake?

  A. A database consists of one or more schemas. A schema contains tables and views.

  B. A schema consists of one or more databases. A database contains tables and views.

  C. A schema consists of one or more databases. A database contains tables, views, and warehouses.

  D. A database consists of one of more schemas and warehouses. A schema contains tables and views.

  Correct Answer: A

• Question 723:

  Which data types in Snowflake are synonymous for FLOAT? (Choose two.)

  A. DECIMAL

  B. DOUBLE

  C. NUMBER

  D. NUMERIC

  E. REAL

  Correct Answer: BE

• Question 724:

  Which role can execute the SHOW ORGANIZATION ACCOUNTS command successfully?

  A. ACCOUNTADMIN

  B. SECURITYADMIN

  C. ORGADMIN

  D. USERADMIN

  Correct Answer: C

• Question 725:

  While loading data from a JSON file, what enables the removal of the outer array structure from the file and loads the records into separate table rows?

  A. SKIP_BYTE_ORDER_MARK

  B. STRIP_NULL_VALUE

  C. STRIP_OUTER_ARRAY

  D. STRIP_OUTER_ELEMENT

  Correct Answer: C

• Question 726:

  A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.

  What table type should be used?

  A. Permanent

  B. Transient

  C. Temporary

  D. External

  Correct Answer: B

• Question 727:

  Which function can be combined with the copy command to unload a relational table into a JSON file?

  A. FLATTEN

  B. LISTAGG

  C. OBJECT_CONSTRUCT

  D. PARSE_JSON

  Correct Answer: C

• Question 728:

  What ensures that a user with the role SECURITYADMIN can activate a network policy for an individual user?

  A. A role that has been granted the EXECUTE TASK privilege

  B. A role that has been granted the global ATTACH POLICY privilege

  C. Ownership privilege on only the role that created the network policy

  D. Ownership privilege on both the user and the network policy

  Correct Answer: D

• Question 729:

  Which functions can be used to share unstructured data through a secure view? (Choose two.)

  A. BUILD_SCOPED_FILE_URL

  B. BUILD_STAGE_FILE_URL

  C. GET_ABSOLUTE_PATH

  D. GET_PRESIGNED_URL

  E. GET_RELATIVE_PATH

  Correct Answer: AD

• Question 730:

  Which function will return a row for each for each object in a VARIANT, OBJECT, or ARRAY column?

  A. CAST

  B. FLATTEN

  C. GET

  D. PARSE_JSON

  Correct Answer: B