Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 791:

  According to Snowflake best practice recommendations, which role should be used to create databases?

  A. ACCOUNTADMIN
  B. SYSADMIN
  C. SECURITYADMIN
  D. USERADMIN
  B. SYSADMIN

  ---

  Explanation

• Question 792:

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

  A. Variant
  B. Object
  C. Geometry
  D. Geography
  D. Geography

  ---

  Explanation

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

• Question 793:

  What are valid values for the field_optionally_enclosed_by option in the copy into command used during data unloading? (Select TWO).

  A. Single quote character (')
  B. NULL
  C. 'NULL'
  D. NONE
  E. 'NONE'
  A. Single quote character (')
  B. NULL

  ---

  Explanation

  The FIELD_OPTIONALLY_ENCLOSED_BY option in the COPY INTO command specifies how fields are optionally enclosed when unloading data.

  Valid values are:

  Examples:

  COPY INTO 's3://mybucket/mypath/'

  FROM my_table

  FILE_FORMAT = (TYPE = CSV FIELD_OPTIONALLY_ENCLOSED_BY = ''''); COPY INTO 's3://mybucket/mypath/'

  FROM my_table

  FILE_FORMAT = (TYPE = CSV FIELD_OPTIONALLY_ENCLOSED_BY = NULL);

  References:

  Snowflake Documentation: COPY INTO

  Snowflake File Format Options

• Question 794:

  Which of the following statements is true of Snowflake micro-partitioning?

  A. Micro-partitioning has been known to introduce data skew
  B. Micro-partitioning: requires a partitioning schema to be defined up front
  C. Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded
  D. Micro-partitioning can be disabled within a Snowflake account
  C. Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html

• Question 795:

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

  A. True
  B. False
  B. False

  ---

  Explanation

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

• Question 796:

  This query was executed:

  Assuming the weather_events table has not changed, which query would benefit from cached results?

  A. SELECT DISTINCT(severity) FROM weather_events we; if run within 24 hours after the initial query execution
  B. select distinct (severity) from weather_events; if run within 24 hours after the initial query execution
  C. SELECT DISTINCT(severity) FROM weather_events ; if run within 24 hours after the initial query execution
  D. select distinct(severity) from weather_events; if run within 48 hours after the initial query execution
  D. select distinct(severity) from weather_events; if run within 48 hours after the initial query execution

  ---

  Explanation

• Question 797:

  Which strings will be converted to TRUE using the TO_BOOLEAN() or CAST() functions when unloading data? (Choose two.)

  B. n
  C. no
  D. on
  E. yes
  D. on
  E. yes

  ---

  Explanation

• Question 798:

  Which data type can store more than one type of data structure?

  A. JSON
  B. BINARY
  C. VARCHAR
  D. VARIANT
  D. VARIANT

  ---

  Explanation

• Question 799:

  How would a user execute a series of SQL statements using a task?

  A. Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..
  B. A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();
  C. Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();
  D. Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.
  C. Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();

  ---

  Explanation

  https://community.snowflake.com/s/question/0D53r00009kC6WhCAK/can-a-task-have-multiple-sql-queries

• Question 800:

  If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?

  A. 1 minute
  B. 2 minutes
  C. 6 minutes
  D. 8 minutes
  C. 6 minutes

  ---

  Explanation

  Economy - 6 minutes Standard - immediately https://community.snowflake.com/s/article/Cluster-Spin-up-criteria-in-MCW