Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 231:

  Snowflake users can create a resource monitor at which levels? (Select TWO).

  A. User level

  B. Pipe level

  C. Account level

  D. Cloud services level

  E. Virtual warehouse level

  Correct Answer: CE

• Question 232:

  Snowflake's access control framework combines which models for securing data? (Select TWO).

  A. Attribute-based Access Control (ABAC)

  B. Discretionary Access Control (DAC)

  C. Access Control List (ACL)

  D. Role-based Access Control (RBAC)

  E. Rule-based Access Control (RuBAC)

  Correct Answer: BD

• Question 233:

  Which common query problems are identified by the Query Profile? (Select TWO.)

  A. Syntax error

  B. Inefficient pruning

  C. Ambiguous column names

  D. Queries too large to fit in memory

  E. Object does not exist or not authorized

  Correct Answer: BD

• Question 234:

  Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?

  A. DELETE

  B. DROP

  C. REMOVE

  D. TRUNCATE

  Correct Answer: C

• Question 235:

  For Directory tables, what stage allows for automatic refreshing of metadata?

  A. User stage

  B. Table stage

  C. Named internal stage

  D. Named external stage

  Correct Answer: D

• Question 236:

  Which sequence (order) of object privileges should be used to grant a custom role read-only access on a table?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 237:

  A column named "Data" contains VARIANT data and stores values as follows:

  

  How will Snowflake extract the employee's name from the column data?

  A. Data:employee.name

  B. DATA:employee.name

  C. data:Employee.name

  D. data:employee.name

  Correct Answer: C

• Question 238:

  A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

  A. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

  B. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

  C. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

  D. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

  Correct Answer: A

  https://docs.snowflake.com/en/sql-reference/sql/grant-privilege.html#examples

• Question 239:

  Where would a Snowflake user find information about query activity from 90 days ago?

  A. account__usage . query history view

  B. account__usage.query__history__archive View

  C. information__schema . cruery_history view

  D. information__schema-query history_by_ses s i on view

  Correct Answer: A

• Question 240:

  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: D