Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1031:

  True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

  A. True

  B. False

  Correct Answer: B

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

• Question 1032:

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

• Question 1033:

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

  Which data type can be used to store geospatial data in Snowflake?

  A. Variant

  B. Object

  C. Geometry

  D. Geography

  Correct Answer: D

  https://docs.snowflake.com/en/sql-reference/data-types-geospatial.html#:~:text=have%20SRID%3D4326.-,Geospatial%20Object%20Types,Point

• Question 1035:

  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.

• Question 1036:

  Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

  A. Standard

  B. Premium

  C. Enterprise

  D. Business Critical

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/privatelink-azure.html

• Question 1037:

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

  A user has unloaded data from Snowflake to a stage

  Which SQL command should be used to validate which data was loaded into the stage?

  A. list @file__stage

  B. show @file__stage

  C. view @file__stage

  D. verify @file__stage

  Correct Answer: A

• Question 1039:

  When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

  A. Use multi-clustered warehousing to scale out warehouse capacity.

  B. Scale up the warehouse size to allow Queries to execute faster.

  C. Stop and start the warehouse to clear the queued queries

  D. Migrate some queries to a new warehouse to reduce load

  E. Limit user access to the warehouse so fewer queries are run against it.

  Correct Answer: AD

• Question 1040:

  Which Snowflake partner specializes in data catalog solutions?

  A. Alation

  B. DataRobot

  C. dbt

  D. Tableau

  Correct Answer: A

  Alation provides Data Cataloging functionality. They state they are the 'One Place to Find, Understand, and Govern Data Across an Enterprise.

  https://docs.snowflake.com/en/user-guide/ecosystem-all.html