Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1471:

  Which functions can be used to identify the data type stored in a VARIANT column? (Choose two.)

  A. IS_NULL_VALUE
  B. IS_DATE_VALUE
  C. IS_GEOGRAPHY
  D. IS_XML
  E. IS_JSON
  B. IS_DATE_VALUE
  D. IS_XML

  ---

  Explanation

• Question 1472:

  In Snowflake, what allows users to perform recursive queries?

  A. QUALIFY
  B. LATERAL
  C. PIVOT
  D. CONNECT BY
  D. CONNECT BY

  ---

  Explanation

• Question 1473:

  What common query issues can be identified using the Query Profile? (Choose two.)

  A. Data classification
  B. Exploding joins
  C. Unions
  D. Inefficient pruning
  E. Data masking
  B. Exploding joins
  D. Inefficient pruning

  ---

  Explanation

• Question 1474:

  Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? (Choose three)

  A. Their default role should be set to SYSTEMADMIN (the lower of the two)
  B. They should not set up multi_Factor Authentication (MFA)--as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so
  C. They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation
  D. They should ensure all database objects in the account are owned by the ACCOUNTADMIN role
  E. They should use the SYSADMIN role to perform administrative work on database objects
  A. Their default role should be set to SYSTEMADMIN (the lower of the two)
  C. They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation
  E. They should use the SYSADMIN role to perform administrative work on database objects

  ---

  Explanation

• Question 1475:

  What transformations are supported when loading data into a table using the COPY INTO [table] command? (Choose two.)

  A. Column reordering
  B. Column omission
  C. JOIN function
  D. FLATTEN function
  E. GROUP BY function
  A. Column reordering
  B. Column omission

  ---

  Explanation

• Question 1476:

  How can a Snowsight user change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse?

  A. Use the ALTER WAREHOUSE command on an active Standard virtual warehouse.
  B. Use the ALTER WAREHOUSE command on an active Snowpark-optimized warehouse.
  C. Use the ALTER WAREHOUSE command on a suspended Standard virtual warehouse.
  D. Use the ALTER WAREHOUSE command on a suspended Snowpark-optimized warehouse.
  C. Use the ALTER WAREHOUSE command on a suspended Standard virtual warehouse.

  ---

  Explanation

• Question 1477:

  Which formats are supported for unloading data from Snowflake? (Choose two)

  A. Delimited (CSV, TSV, etc.)
  B. Avro
  C. JSON
  D. ORC
  A. Delimited (CSV, TSV, etc.)
  C. JSON

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

• Question 1478:

  When data is loaded into Snowflake, what formats does Snowflake use internally to store the data in cloud storage? (Choose two.)

  A. Key-value
  B. Columnar
  C. Graph
  D. Document
  E. Compressed
  B. Columnar
  E. Compressed

  ---

  Explanation

• Question 1479:

  When unloading data, which file format preserves the data values for floating-point number columns?

  A. Avro
  B. CSV
  C. JSON
  D. Parquet
  D. Parquet

  ---

  Explanation

• Question 1480:

  What are benefits of using the ACCESS_HISTORY view in the SNOWFLAKE database?

  A. Identification of unused data
  B. Identification of which roles have been used
  C. Tracking of network policy usage
  D. Highlighting of row access policy usage
  E. Identification of who has read data
  D. Highlighting of row access policy usage
  E. Identification of who has read data

  ---

  Explanation