Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1041:

  What is a responsibility of Snowflake's virtual warehouses?

  A. Infrastructure management

  B. Metadata management

  C. Query execution

  D. Query parsing and optimization

  E. Management of the storage layer

  Correct Answer: C

• Question 1042:

  Which of the following commands cannot be used within a reader account?

  A. CREATE SHARE

  B. ALTER WAREHOUSE

  C. DROP ROLE

  D. SHOW SCHEMAS

  E. DESCRBE TABLE

  Correct Answer: A

• Question 1043:

  A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

  A. SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS;

  B. SELECT EVENT_TIMESTAMP, USER_NAME FROM table(information_schema.login_history_by_user())

  C. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY;

  D. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;

  Correct Answer: D

• Question 1044:

  Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

  A. ORC

  B. XML

  C. Avro

  D. Parquet

  E. JSON

  Correct Answer: DE

  Semi-structured JSON, Parquet

  https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20fileandtext=Delimited%20(CSV% 2C%20TSV%2C%20etc.)

• Question 1045:

  What is the MOST performant file format for loading data in Snowflake?

  A. CSV (Unzipped)

  B. Parquet

  C. CSV (Gzipped)

  D. ORC

  Correct Answer: C

• Question 1046:

  The fail-safe retention period is how many days?

  A. 1 day

  B. 7 days

  C. 45 days

  D. 90 days

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html

• Question 1047:

  Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

  A. An FTP server with TLS encryption

  B. An HTTPS server with WebDAV

  C. A Google Cloud storage bucket

  D. A Windows server file share on Azure

  Correct Answer: C

• Question 1048:

  Which of the following objects can be shared through secure data sharing?

  A. Masking policy

  B. Stored procedure

  C. Task

  D. External table

  Correct Answer: D

  Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared: Tables External tables Secure views Secure materialized views Secure UDFs Snowflake enables the sharing of databases through shares, which are created by data providers and "imported" by data consumers.

  https://docs.snowflake.com/en/user-guide/data-sharing-intro.html#:~:text=Secure%20Data%20Sharing%20enables%20sharing,External%20tables

• Question 1049:

  When is the result set cache no longer available? (Select TWO)

  A. When another warehouse is used to execute the query

  B. When another user executes the query

  C. When the underlying data has changed

  D. When the warehouse used to execute the query is suspended

  E. When it has been 24 hours since the last query

  Correct Answer: CE

• Question 1050:

  Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

  A. The user has the appropriate privileges on the objects associated with the query

  B. Micro-partitions have been reclustered since the query was last run

  C. The new query is run using the same virtual warehouse as the previous query

  D. The query includes a User Defined Function (UDF)

  E. The query has been run within 24 hours of the previously-run query

  Correct Answer: AE