Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1131:

  When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers

  A. When users will be using compute at different times throughout a 24/7 period

  B. When managing a steady workload

  C. When the compute must be available with no delay or lag time

  D. When you don't want to have to manually turn on the Warehouse each time a user needs it

  Correct Answer: BC

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

• Question 1132:

  True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

  A. True

  B. False

  Correct Answer: B

• Question 1133:

  Which of the following statements is true of Snowflake?

  A. It was built specifically for the cloud

  B. It was built as an on-premises solution and then ported to the cloud

  C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

  D. It was built for Hadoop architecture

  E. It's based on an Oracle Architecture

  Correct Answer: A

  Reference: https://www.stitchdata.com/resources/snowflake/

• Question 1134:

  True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

  A. True

  B. False

  Correct Answer: A

  Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.

• Question 1135:

  Which of the following statements are true about Schemas in Snowflake? (Choose two.)

  A. A Schema may contain one or more Databases

  B. A Database may contain one or more Schemas

  C. A Schema is a logical grouping of Database Objects

  D. Each Schema is contained within a Warehouse

  Correct Answer: BC

  Reference: https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html

• Question 1136:

  Which interfaces can be used to create and/or manage Virtual Warehouses?

  A. The Snowflake Web Interface (UI)

  B. SQL commands

  C. Data integration tools

  D. All of the above

  Correct Answer: D

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

• Question 1137:

  As a best practice, clustering keys should only be defined on tables of which minimum size?

  A. Multi-Kilobyte (KB) Range

  B. Multi-Megabyte (MB) Range

  C. Multi-Gigabyte (GB) Range

  D. Multi-Terabyte (TB) Range

  Correct Answer: D

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

• Question 1138:

  True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

  A. True

  B. False

  Correct Answer: B

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

• Question 1139:

  On which of the following cloud platforms can a Snowflake account be hosted? (Choose three.)

  A. Amazon Web Services

  B. Private Virtual Cloud

  C. Oracle Cloud

  D. Microsoft Azure Cloud

  E. Google Cloud Platform

  F. Alibaba Cloud

  Correct Answer: ADE

• Question 1140:

  Which type of table corresponds to a single Snowflake session?

  A. Temporary

  B. Translent

  C. Provisional

  D. Permanent

  Correct Answer: A

  Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.

  https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#:~:text=Snowflake%20supports%20creating%20temporary%20tables,the%20remainder% 20of%20the%20session.