Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 211:

  When unloading to a stage, which of the following is a recommended practice or approach?

  A. Set SINGLE: = true for larger files

  B. Use OBJECT_CONSTRUCT ( * ) when using Parquet

  C. Avoid the use of the CAST function

  D. Define an individual file format

  Correct Answer: C

• Question 212:

  The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

  A. Users

  B. Tables

  C. Databases

  D. Internal Stages

  Correct Answer: ABC

• Question 213:

  What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

  A. Data can be filtered by an optional where clause

  B. Incoming data can be joined with other tables

  C. Columns can be reordered

  D. Columns can be omitted

  E. Row level access can be defined

  Correct Answer: CD

• Question 214:

  What happens when an external or an internal stage is dropped? (Select TWO).

  A. When dropping an external stage, the files are not removed and only the stage is dropped

  B. When dropping an external stage, both the stage and the files within the stage are removed

  C. When dropping an internal stage, the files are deleted with the stage and the files are recoverable

  D. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable

  E. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

  Correct Answer: AC

• Question 215:

  What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

  A. The ability to scale up warehouses

  B. The use of warehouse auto scaling

  C. The ability to resize warehouses

  D. Use of multi-clustered warehouses

  E. The use of warehouse indexing

  Correct Answer: BD

• Question 216:

  A user unloaded a Snowflake table called mytable to an internal stage called mystage.

  Which command can be used to view the list of files that has been uploaded to the staged?

  A. list @mytable;

  B. list @%raytable;

  C. list @ %m.ystage;

  D. list @mystage;

  Correct Answer: D

• Question 217:

  Which Snowflake feature is used for both querying and restoring data?

  A. Cluster keys

  B. Time Travel

  C. Fail-safe

  D. Cloning

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%20CDP%20features,days%20through%20Snowflake%20Time%20Travel.

• Question 218:

  What is a limitation of a Materialized View?

  A. A Materialized View cannot support any aggregate functions

  B. A Materialized View can only reference up to two tables

  C. A Materialized View cannot be joined with other tables

  D. A Materialized View cannot be defined with a JOIN

  Correct Answer: D

  There are several limitations to using materialized views:

  A materialized view can query only a single table.

  Joins, including self-joins, are not supported.

• Question 219:

  A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

  Which of the following statements will accommodate this request?

  A. ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

  B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

  C. GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

  D. GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

  Correct Answer: B

• Question 220:

  What is the purpose of an External Function?

  A. To call code that executes outside of Snowflake

  B. To run a function in another Snowflake database

  C. To share data in Snowflake with external parties

  D. To ingest data from on-premises data sources

  Correct Answer: A

  https://docs.snowflake.com/en/sql-reference/external-functions.html