Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 931:

  Which statement is true about running tasks in Snowflake?

  A. A task can be called using a CALL statement to run a set of predefined SQL commands.

  B. A task allows a user to execute a single SQL statement/command using a predefined schedule.

  C. A task allows a user to execute a set of SQL commands on a predefined schedule.

  D. A task can be executed using a SELECT statement to run a predefined SQL command.

  Correct Answer: B

• Question 932:

  When should a multi-cluster warehouse be used in auto-scaling mode?

  A. When it is unknown how much compute power is needed

  B. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

  C. If the runtime of the executed query is very slow

  D. When a large number of concurrent queries are run on the same warehouse

  Correct Answer: D

• Question 933:

  The Snowflake Search Optimization Services supports improved performance of which kind of query?

  A. Queries against large tables where frequent DML occurs

  B. Queries against tables larger than 1 TB

  C. Selective point lookup queries

  D. Queries against a subset of columns in a table

  Correct Answer: C

  Reference: https://docs.snowflake.com/en/user-guide/search-optimization-service.html#:~:text=The%20search%20optimization%20service%20can%20improve% 20the%20performance%20of%20point,OBJECT%2C%20and%20ARRAY% 20columns)

• Question 934:

  What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

  A. Row level access policies

  B. Data masking policies

  C. Data encryption

  D. Time Travel

  E. External tokenization

  Correct Answer: CD

• Question 935:

  Which of the following statements apply to Snowflake in terms of security? (Choose two.)

  A. Snowflake leverages a Role-Based Access Control (RBAC) model.

  B. Snowflake requires a user to configure an IAM user to connect to the database.

  C. All data in Snowflake is encrypted.

  D. Snowflake can run within a user's own Virtual Private Cloud (VPC).

  E. All data in Snowflake is compressed.

  Correct Answer: AC

• Question 936:

  What is the maximum Time Travel retention period for a temporary Snowflake table?

  A. 90 days

  B. 1 day

  C. 7 days

  D. 45 days

  Correct Answer: B

• Question 937:

  User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.

  Which command will show all privileges granted to that schema?

  A. SHOW GRANTS ON ROLE DATA_SCIENCE

  B. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

  C. SHOW GRANTS TO USER INQUISITIVE_PERSON

  D. SHOW GRANTS OF ROLE DATA_SCIENCE

  Correct Answer: B

• Question 938:

  Which of the following are best practices for loading data into Snowflake? (Choose three.)

  A. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

  B. Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

  C. Enclose fields that contain delimiter characters in single or double quotes.

  D. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

  E. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

  F. Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

  Correct Answer: ACD

• Question 939:

  When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

  A. The cloned views and the stored procedures will reference the cloned tables in the cloned database.

  B. An error will occur, as views with qualified references cannot be cloned.

  C. An error will occur, as stored objects cannot be cloned.

  D. The stored procedures and views will refer to tables in the source database.

  Correct Answer: D

• Question 940:

  Which of the following can be used when unloading data from Snowflake? (Choose two.)

  A. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

  B. Use the ENCODING file format option to change the encoding from the default UTF-8.

  C. The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

  D. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

  E. Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

  Correct Answer: CD