Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 301:

  True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

  A. True

  B. False

  Correct Answer: A

• Question 302:

  True or False: Data Providers can share data with only the Data Consumer.

  A. True

  B. False

  Correct Answer: B

• Question 303:

  Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what? Select one.

  A. More micro-partitions

  B. Better query scheduling

  C. Double the numbers of servers In the compute duster

  D. Higher storage costs

  Correct Answer: C

• Question 304:

  True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

  A. True

  B. False

  Correct Answer: A

  Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/

• Question 305:

  True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

  A. True

  B. False

  Correct Answer: B

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

• Question 306:

  The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers

  A. The complexity of each query

  B. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

  C. The size of the data required for each query

  D. The tool that s executing the query

  Correct Answer: AC

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

• Question 307:

  True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

  A. True

  B. False

  Correct Answer: B

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

• Question 308:

  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 309:

  True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

  A. True

  B. False

  Correct Answer: A

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

• Question 310:

  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