Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 221:

  What is a key feature of Snowflake architecture?

  A. Zero-copy cloning creates a mirror copy of a database that updates with the original

  B. Software updates are automatically applied on a quarterly basis

  C. Snowflake eliminates resource contention with its virtual warehouse implementation

  D. Multi-cluster warehouses allow users to run a query that spans across multiple clusters

  E. Snowflake automatically sorts DATE columns during ingest for fast retrieval by date

  Correct Answer: D

• Question 222:

  Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

  A. Compute layer

  B. Storage layer

  C. Cloud infrastructure layer

  D. Cloud services layer

  Correct Answer: A

  For query execution, Snowflake uses the Virtual Warehouse. The query processing layer is separated from the disk storage layer in the Snowflake data architecture. You can use the data from the storage layer to run queries in this layer

  https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556#:~:text=Query%20Processing%20Layer%2FCompute%20Layer,run%20queries%20in%20this%20layer.

• Question 223:

  Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

  A. Pipe

  B. External stage

  C. Task

  D. Stream

  Correct Answer: A

  Snowpipe enables loading data from files as soon as they're available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

• Question 224:

  When is the result set cache no longer available? (Select TWO)

  A. When another warehouse is used to execute the query

  B. When another user executes the query

  C. When the underlying data has changed

  D. When the warehouse used to execute the query is suspended

  E. When it has been 24 hours since the last query

  Correct Answer: CE

• Question 225:

  Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

  A. Customer-managed encryption keys through Tri-Secret Secure

  B. Automatic encryption of all data

  C. Up to 90 days of data recovery through Time Travel

  D. Object-level access control

  E. Column-level security to apply data masking policies to tables and views

  Correct Answer: BD

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

• Question 226:

  Which of the following commands cannot be used within a reader account?

  A. CREATE SHARE

  B. ALTER WAREHOUSE

  C. DROP ROLE

  D. SHOW SCHEMAS

  E. DESCRBE TABLE

  Correct Answer: B

  A reader account is intended primarily for querying data shared by the provider of the account. Adding new data to the account and/or updating shared data in the account is not supported. Changing the configuration of virtual warehouses is also not permitted as those resources are owned and managed by the provider of the account which is sharing the data.

• Question 227:

  Which command can be used to stage local files from which Snowflake interface?

  A. SnowSQL

  B. Snowflake classic web interface (Ul)

  C. Snowsight

  D. .NET driver

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/snowsql-use.html

• Question 228:

  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

  Correct Answer: B

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

• Question 229:

  Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

  A. Internal stages

  B. Incremental backups

  C. Time Travel

  D. Zero-copy clones

  E. Fail-safe

  Correct Answer: CE

  Time travel and fail safe are the two continuous data protection features support the recovery of data automatically.

  Snowflake provides powerful CDP features for ensuring the maintenance and availability of your historical data (i.e. data that has been changed or deleted):

  Querying, cloning, and restoring historical data in tables, schemas, and databases for up to 90 days through Snowflake Time Travel. Disaster recovery of historical data (by Snowflake) through Snowflake Fail-safe. https://docs.snowflake.com/

  en/user-guide/data-availability.html

• Question 230:

  Which command is used to unload data from a Snowflake table into a file in a stage?

  A. COPY INTO

  B. GET

  C. WRITE

  D. EXTRACT INTO

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#:~:text=Your%20User%20Stage-,Use%20the%20COPY%20INTO%20command%20to%20unload%20all%20the,more%20files%20in%20your%20stage.