Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1081:

  Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

  A. Is available to all Snowflake Editions

  B. Is only available to customers with Business Critical Edition

  C. Restricts or enables access to specific IP addresses

  D. Is activated using an "ALTER DATABASE" command

  Correct Answer: AC

  Reference: https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html

• Question 1082:

  Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

  A. To accommodate more queries

  B. To accommodate more users

  C. To accommodate fluctuations in workload

  D. To accommodate a more complex workload

  Correct Answer: D

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

• Question 1083:

  Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

  A. Scaling rhythmically

  B. Scaling max

  C. Scaling out

  D. Scaling Up

  Correct Answer: C

  https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#scaling-up-vs-scaling-out "Scale out by adding warehouses to a multi-cluster warehouse"

• Question 1084:

  The PUT command: (Choose two.)

  A. Automatically creates a File Format object

  B. Automatically uses the last Stage created

  C. Automatically compresses files using Gzip

  D. Automatically encrypts files

  Correct Answer: CD

  Reference: https://docs.snowflake.com/en/sql-reference/sql/put.html

• Question 1085:

  True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

  A. True

  B. False

  Correct Answer: A

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

• Question 1086:

  True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

  A. True

  B. False

  Correct Answer: A

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

• Question 1087:

  True or False: Snowflake charges a premium for storing semi-structured data.

  A. True

  B. False

  Correct Answer: B

  Reference: https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges-premium-for-storing-semi-structured-data

• Question 1088:

  True or False: You can query the files in an External Stage directly without having to load the data into a table.

  A. True

  B. False

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/tables-external-intro.html

  External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external tables.

• Question 1089:

  What are the three layers that make up Snowflake's architecture? Choose 3 answer

  A. Compute

  B. Tri-Secret Secure

  C. Storage

  D. Cloud Services

  Correct Answer: ACD

  Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

• Question 1090:

  If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

  A. All Snowflake sessions using the warehouse are terminated.

  B. The last query using the warehouse completes.

  C. There are no users loaned into Snowflake.

  D. The Warehouse is inactive for a specified period of time.

  Correct Answer: D

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