Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 201:

  Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

  A. Each Snowflake account can be hosted in a different cloud vendor and region.

  B. Each Snowflake account must be hosted in a different cloud vendor and region

  C. All Snowflake accounts must be hosted in the same cloud vendor and region

  D. Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/intro-regions.html

• Question 202:

  Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

  A. ORC

  B. XML

  C. Avro

  D. Parquet

  E. JSON

  Correct Answer: DE

  Semi-structured JSON, Parquet

  https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20fileandtext=Delimited%20(CSV%2C%20TSV%2C%20etc.

• Question 203:

  Which of the following objects can be shared through secure data sharing?

  A. Masking policy

  B. Stored procedure

  C. Task

  D. External table

  Correct Answer: D

  Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared: Tables External tables Secure views Secure materialized views Secure UDFs

  Snowflake enables the sharing of databases through shares, which are created by data providers and "imported" by data consumers. https://docs.snowflake.com/en/user-guide/data-sharing-intro.html#:~:text=Secure%20Data%20Sharing% 20enables%20sharing,External%20tables

• Question 204:

  True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

• Question 205:

  The fail-safe retention period is how many days?

  A. 1 day

  B. 7 days

  C. 45 days

  D. 90 days

  Correct Answer: B

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

• Question 206:

  What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

  A. Via the Snowflake Web Interface (Ul)

  B. Via the data_share=true parameter

  C. Via SQL commands

  D. Via Virtual Warehouses

  Correct Answer: AC

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

• Question 207:

  How long is Snowpipe data load history retained?

  A. As configured in the create pipe settings

  B. Until the pipe is dropped

  C. 64 days

  D. 14 days

  Correct Answer: C

  Bulk data load

  Stored in the metadata of the target table for 64 days. Available upon completion of the COPY statement as the statement output. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#:~:text=Load%20History,-Bulk%

  20data%20loadandtext=Stored%20in%20the%20metadata%20of,statement%20as%20the%20statement%20output.andtext=Stored%20in% 20the%20metadata%20of%20the%20pipe%20for%2014%20days.

• Question 208:

  Which data types does Snowflake support when querying semi-structured data? (Select TWO)

  A. VARIANT

  B. ARRAY

  C. VARCHAR

  D. XML

  E. BLOB

  Correct Answer: AB

  https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data

  A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.

  The maximum length of a VARIANT is 16 MB.

  A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.

• Question 209:

  Which services does the Snowflake Cloud Services layer manage? (Select TWO).

  A. Compute resources

  B. Query execution

  C. Authentication

  D. Data storage

  E. Metadata

  Correct Answer: CE

  https://docs.snowflake.com/en/user-guide/intro-key-concepts.html The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider. Services managed in this layer include: Authentication Infrastructure management Metadata management Query parsing and optimization Access control

• Question 210:

  True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

  A. True

  B. False

  Correct Answer: A

  Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.