Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 171:

  What is the recommended file sizing for data loading using Snowpipe?

  A. A compressed file size greater than 100 MB, and up to 250 MB

  B. A compressed file size greater than 100 GB, and up to 250 GB

  C. A compressed file size greater than 10 MB, and up to 100 MB

  D. A compressed file size greater than 1 GB, and up to 2 GB

  Correct Answer: A

  https://www.phdata.io/blog/how-to-optimize-snowpipe-data-load/#:~:text=Snowpipe%20is%20typically%20used%20to,data%20within%20one%2Dminute%20intervals.

• Question 172:

  Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

  A. Pipes

  B. Streams

  C. Tasks

  D. Procedures

  Correct Answer: B

  https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%20a%20Snowflake,as%20metadata%20about%20each%20change.

• Question 173:

  What are value types that a VARIANT column can store? (Select TWO)

  A. STRUCT

  B. OBJECT

  C. BINARY

  D. ARRAY

  E. CLOB

  Correct Answer: BD

  Characteristics of a VARIANT

  A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.

  https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics%20of%20a%20VARIANT,a%20VARIANT%20is%2016%20MB.

• Question 174:

  Which of the following can be executed/called with Snowpipe?

  A. A User Defined Function (UDF)

  B. A stored procedure

  C. A single copy_into statement

  D. A single insert__into statement

  Correct Answer: C

• Question 175:

  What Snowflake role must be granted for a user to create and manage accounts?

  A. ACCOUNTADMIN

  B. ORGADMIN

  C. SECURITYADMIN

  D. SYSADMIN

  Correct Answer: A

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

• Question 176:

  True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

  A. True

  B. False

  Correct Answer: B

  By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. To unload data to a single output file (at the potential cost of decreased performance), specify the SINGLE = true copy option in your statement. You can optionally specify a name for the file in the path.

• Question 177:

  What is the MOST performant file format for loading data in Snowflake?

  A. CSV (Unzipped)

  B. Parquet

  C. CSV (Gzipped)

  D. ORC

  Correct Answer: A

• Question 178:

  True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

  A. True

  B. False

  Correct Answer: A

• Question 179:

  Which stage type can be altered and dropped?

  A. Database stage

  B. External stage

  C. Table stage

  D. User stage

  Correct Answer: C

  https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#table-stages

• Question 180:

  Which of the following describes external functions in Snowflake?

  A. They are a type of User-defined Function (UDF).

  B. They contain their own SQL code.

  C. They call code that is stored inside of Snowflake.

  D. They can return multiple rows for each row received

  Correct Answer: A

  External functions are user-defined functions that are stored and executed outside of Snowflake.

  External functions make it easier to access external API services such as geocoders, machine learning models, and other custom code running outside of Snowflake. This feature eliminates the need to export and reimport data when using

  third-party services, significantly simplifying your data pipelines.

  https://docs.snowflake.com/en/sql-reference/external-functions.html#:~:text=External%20functions%20are%20user%2Ddefined,code%20running%20outside%20of%20Snowflake.