Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 191:

  Which type of role can be granted to a share?

  A. Account role

  B. Custom role

  C. Database role

  D. Secondary role

  Correct Answer: C

• Question 192:

  When unloading data with the COPY INTO command, what is the purpose of the PARTITION BY parameter option?

  A. To sort the contents of the output file by the specified expression.

  B. To delimit the records in the output file using the specified expression.

  C. To include a new column in the output using the specified window function expression.

  D. To split the output into multiple files, one for each distinct value of the specified expression.

  Correct Answer: D

• Question 193:

  How does Snowflake define its approach to Discretionary Access Control (DAC)?

  A. A defined level of access to an object.

  B. An entity to which access can be granted.

  C. Each object has an owner, who can in turn grant access to that object.

  D. Access privileges are assigned to roles, which are in turn assigned to users.

  Correct Answer: C

• Question 194:

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

  A. DELETE

  B. DROP

  C. REMOVE

  D. TRUNCATE

  Correct Answer: C

• Question 195:

  The Snowflake VARIANT data type imposes a 16 MB size limit on what?

  A. An individual row

  B. An individual column

  C. A view

  D. A file in a stage

  Correct Answer: A

• Question 196:

  Which Snowflake feature records changes made to a table so actions can be taken using that change data capture?

  A. Materialized View

  B. Pipe

  C. Stream

  D. Task

  Correct Answer: C

• Question 197:

  Which system-defined, read-only view displays information on column lineage that specifies how data flows from source to target in a SQL write operation?

  A. ACCESS_HISTORY

  B. LOAD_HISTORY

  C. QUERY_HISTORY

  D. COPY_HISTORY

  Correct Answer: A

• Question 198:

  Which Snowflake feature supports continuous, serverless data loading into tables as soon as new data arrives?

  A. Snowpark

  B. SnowSQL

  C. SnowCD

  D. Snowpipe

  Correct Answer: D

• Question 199:

  Which command can be used to delete staged files from a Snowflake stage when the files are no longer needed?

  A. DELETE

  B. DROP

  C. REMOVE

  D. TRUNCATE TABLE

  Correct Answer: C

• Question 200:

  A virtual warehouse initially suffers from poor performance as a result of queries from multiple concurrent processes that are queuing. Over time, the problem resolved.

  What action can be taken to prevent this from happening again?

  A. Increase the size of the virtual warehouse.

  B. Add a cluster key to the most used JOIN key.

  C. Change the multi-cluster settings to add additional clusters.

  D. Enable the search optimization service for the underlying tables.

  Correct Answer: C