Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 921:

  By default, which Snowflake role is required to create a share?

  A. ORGADMIN

  B. SECURITYADMIN

  C. SHAREADMIN

  D. ACCOUNTADMIN

  Correct Answer: D

• Question 922:

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

  A. JSON

  B. BINARY

  C. VARCHAR

  D. VARIANT

  Correct Answer: D

• Question 923:

  Network policies can be applied to which of the following Snowflake objects? (Choose two.)

  A. Roles

  B. Databases

  C. Warehouses

  D. Users

  E. Accounts

  Correct Answer: DE

  https://docs.snowflake.com/en/user-guide/network-policies.html#label-verify-network-policy-activation

• Question 924:

  Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

  A. Optimizes the virtual warehouse size and multi-cluster setting to economy mode

  B. Allows a user to import the files in a sequential order

  C. Increases the latency staging and accuracy when loading the data

  D. Allows optimization of parallel operations

  Correct Answer: D

• Question 925:

  Which command can be used to load data files into a Snowflake stage?

  A. JOIN

  B. COPY INTO

  C. PUT

  D. GET

  Correct Answer: C

• Question 926:

  Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

  A. COPY INTO

  B. CREATE PIPE

  C. INSERT INTO

  D. TABLE STREAM

  Correct Answer: B

• Question 927:

  In the Snowflake access control model, which entity owns an object by default?

  A. The user who created the object

  B. The SYSADMIN role

  C. Ownership depends on the type of object

  D. The role used to create the object

  Correct Answer: D

• Question 928:

  Which TABLE function helps to convert semi-structured data to a relational representation?

  A. CHECK_JSON

  B. TO_JSON

  C. FLATTEN D. PARSE_JSON

  Correct Answer: C

  https://docs.snowflake.com/en/sql-reference/functions/flatten.html

• Question 929:

  Which services does the Snowflake Cloud Services layer manage? (Choose two.)

  A. Compute resources

  B. Query execution

  C. Authentication

  D. Data storage

  E. Metadata

  Correct Answer: CE

• Question 930:

  Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

  A. UPDATE TABLE FROM STREAM

  B. SELECT FROM STREAM

  C. INSERT INTO TABLE SELECT FROM STREAM

  D. ALTER TABLE AS SELECT FROM STREAM

  E. BEGIN COMMIT

  Correct Answer: AC