Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 251:

  Which type of table corresponds to a single Snowflake session?

  A. Temporary
  B. Translent
  C. Provisional
  D. Permanent
  A. Temporary

  ---

  Explanation/Reference:

  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%2 0remainder%20of%20the%20session.

• Question 252:

  True or False: An active warehouse is required to run a COPY INTO statement.

  A. True
  B. False
  A. True

• Question 253:

  What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers

  A. On-premise availability
  B. Simplicity
  C. Open source based
  D. Concurrency
  E. Performance
  B. Simplicity
  D. Concurrency
  E. Performance

• Question 254:

  Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

  A. An FTP server with TLS encryption
  B. An HTTPS server with WebDAV
  C. A Google Cloud storage bucket
  D. A Windows server file share on Azure
  C. A Google Cloud storage bucket

• Question 255:

  What is the maximum Time Travel retention period for a temporary Snowflake table?

  A. 90 days
  B. 1 day
  C. 7 days
  D. 45 days
  B. 1 day

• Question 256:

  How many resource monitors can be assigned at the account level?

  A. 1
  B. 2
  C. 3
  D. 4
  A. 1

• Question 257:

  Where is Snowflake metadata stored?

  A. Within the data files
  B. In the virtual warehouse layer
  C. In the cloud services layer
  D. In the remote storage layer
  B. In the virtual warehouse layer

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/querying-metadata.html#:~:text=Snowflake%20automatically%20generates%20metadata%20for,using%20a%20standard%20SELECT%20statement

• Question 258:

  Which cache type is used to cache data output from SQL queries?

  A. Metadata cache
  B. Result cache
  C. Remote cache
  D. Local file cache
  B. Result cache

  ---

  Explanation/Reference:

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

• Question 259:

  Which of the following are benefits of micro-partitioning? (Select TWO)

  A. Micro-partitions cannot overlap in their range of values
  B. Micro-partitions are immutable objects that support the use of Time Travel.
  C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
  D. Rows are automatically stored in sorted order within micro-partitions
  E. Micro-partitions can be defined on a schema-by-schema basis
  A. Micro-partitions cannot overlap in their range of values
  D. Rows are automatically stored in sorted order within micro-partitions

  ---

  Explanation/Reference:

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

• Question 260:

  Which Snowflake layer is always leveraged when accessing a query from the result cache?

  A. Metadata
  B. Data Storage
  C. Compute
  D. Cloud Services
  D. Cloud Services