Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1171:

  Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI)? Choose 2 answers

  A. SnowSQL

  B. ODBC

  C. R

  D. HIVE

  Correct Answer: AB

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

• Question 1172:

  Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

  A. Customers can change the size of the Warehouse after creation

  B. A Warehouse can be resized while running

  C. A Warehouse can be configured to suspend after a period of inactivity

  D. A Warehouse can be configured to auto-resume when new queries are submitted

  Correct Answer: ABCD

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

• Question 1173:

  Which statement best describes '' clustering''?

  A. Clustering represents the way data is grouped together and stored within snowflake's micro-partitions

  B. The database administrator must define the clustering methodology for each Snowflake table.

  C. The clustering key must be included on the COPV command when loading data into Snowflake.

  D. Clustering can be disabled within a Snowflake account.

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html

• Question 1174:

  How a Snowpipe charges calculated?

  A. Per-second/per Warehouse size

  B. Per-second/per-core granularity

  C. Number of Pipes in account

  D. Total storage bucket size

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html

• Question 1175:

  True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html

• Question 1176:

  The Query History in the Snowflake Web Interface (UI) is kept for approximately:

  A. 60 minutes

  B. 24 hours

  C. 14 days

  D. 30 days

  E. 1 year

  Correct Answer: C

  Reference: https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html

• Question 1177:

  A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

  A. The primary duster in the virtual warehouse

  B. The entire Virtual Warehouse

  C. The database the Virtual Warehouse resides in

  D. The queries currently being run by the Virtual Warehouse

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

• Question 1178:

  What is the recommended method for loading data into Snowflake?

  A. Load row by row

  B. Load data in batch

  C. Load data by writing it In the Snowflake Web Interface (UI)

  D. Load data via frequent, angle row DML's

  Correct Answer: B

• Question 1179:

  Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred? Select one.

  A. 1 Hour

  B. 3 Hours

  C. 12 hours

  D. 24 hours

  Correct Answer: D

  Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

• Question 1180:

  True or False: The COPY command must specify a File Format in order to execute.

  A. True

  B. False

  Correct Answer: B

  Create Stage: https://docs.snowflake.com/en/sql-reference/sql/create-stage.html Create Table (STAGE_FILE_FORMAT option): https://docs.snowflake.com/en/sql-reference/sql/create-table.html Copy Into: https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html