Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 751:

  Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?

  A. Standard

  B. Enterprise

  C. Business Critical

  D. Virtual Private Snowflake (VPS)

  Correct Answer: D

• Question 752:

  There are 300 concurrent users on a production Snowflake account using a single cluster virtual warehouse. The queries are small, but the response time is very slow.

  What is causing this to occur?

  A. The warehouse is queuing the queries, increasing the overall query execution time.

  B. The warehouse parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS is set too low.

  C. The application is not using the latest native ODBC driver which is causing latency.

  D. The queries are not taking advantage of the data cache.

  Correct Answer: A

• Question 753:

  What is the MAXIMUM number of days that Snowflake resets the 24-hour retention period for a query result every time the result is used?

  A. 1 day

  B. 10 days

  C. 31 days

  D. 60 days

  Correct Answer: C

• Question 754:

  What criteria does Snowflake use to determine the current role when initiating a session? (Choose two.)

  A. If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.

  B. If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.

  C. If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.

  D. If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.

  E. If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.

  Correct Answer: AB

• Question 755:

  How does a Snowflake user reference a directory table created on stage mystage in a SQL query?

  A. SELECT * FROM @mystage::DIRECTORY

  B. SELECT * FROM DIRECTORY (@mystage)

  C. SELECT * FROM TO_TABLE (DIRECTORY @mystage)

  D. SELECT * FROM TABLE (@mystage DIRECTORY)

  Correct Answer: B

• Question 756:

  What command should be used to move data from a Snowflake database table into one or more files in an external stage?

  A. GET

  B. COPY INTO

  C. PUT

  D. SHOW

  Correct Answer: B

• Question 757:

  How can a Snowflake user improve long-running query performance?

  A. Reduce the virtual warehouse size.

  B. Cluster the underlying table being queried.

  C. Disable the result cache.

  D. Add ORDER BY to the query.

  Correct Answer: B

• Question 758:

  Which command can be added to the COPY command to make it load all files, whether or not the load status of the files is known?

  A. FORCE = TRUE

  B. FORCE = FALSE

  C. LOAD_UNCERTAIN_FILES = TRUE

  D. LOAD_UNCERTAIN_FILES = FALSE

  Correct Answer: A

• Question 759:

  Why would a Snowflake user create a secure view instead of a standard view?

  A. The secure view is only available to end users with the corresponding SECURE_ACCESS property.

  B. End users are unable to see the view definition, and internal optimizations differ with a secure view.

  C. With a secure view, the underlying data is replicated to a separate storage layer with enhanced encryption.

  D. Secure views support additional functionality that is not supported for standard views, such as column masking and row level access policies.

  Correct Answer: B

• Question 760:

  Which SQL commands should be used to write a recursive query if the number of levels is unknown? (Choose two.)

  A. CONNECT BY

  B. LISTAGG

  C. MATCH RECOGNIZE

  D. QUALIFY

  E. WITH

  Correct Answer: AE