Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 851:

  The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

  

  A user needs to extract the dealership information from the JSON.

  How can this be accomplished?

  A. select src:dealership from car_sales;

  B. select src.dealership from car_sales;

  C. select src:Dealership from car_sales;

  D. select dealership from car_sales;

  Correct Answer: A

• Question 852:

  The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

  A. USERADMIN

  B. PUBLIC

  C. ORGADMIN

  D. SYSADMIN

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html#using-the-accountadmin-role By default, when your account is provisioned, the first user is assigned the ACCOUNTADMIN role. This user should then create one or more additional users who are assigned the USERADMIN role. All remaining users should be created by the user(s) with the USERADMIN role or another role that is granted the global CREATE USER privilege

• Question 853:

  In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

  A. When the system has enough load for 2 minutes

  B. When the system has enough load for 6 minutes

  C. When the system has enough load for 8 minutes

  D. When the system has enough load for 10 minutes

  Correct Answer: B

• Question 854:

  Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

  A. Data is live, ready-to-query, and can be personalized.

  B. Data needs to be loaded into a cloud provider as a consumer account.

  C. Data is not available for copying or moving to an individual Snowflake account.

  D. Data is available without copying or moving.

  E. Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

  Correct Answer: AD

• Question 855:

  Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

  A. parse_json()

  B. json_extract_path_text()

  C. object_construct()

  D. flatten

  Correct Answer: A

• Question 856:

  Which statement describes how Snowflake supports reader accounts?

  A. A reader account can consume data from the provider account that created it and combine it with its own data.

  B. A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

  C. The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

  D. The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

  Correct Answer: D

  https://docs.snowflake.com/en/sql-reference/sql/show-managed-accounts.html

• Question 857:

  Which Snowflake tool would be BEST to troubleshoot network connectivity?

  A. SnowCLI

  B. SnowUI

  C. SnowSQL

  D. SnowCD

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/snowcd.html#:~:text=SnowCD%20(i.e.%20Snowflake%20Connectivity%20Diagnostic,their%20network%20connection %20to%20Snowflake.

• Question 858:

  What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

  A. The Pipe load history is reset to empty.

  B. The REFRESH command is executed.

  C. The stage will be purged.

  D. The destination table is truncated.

  Correct Answer: B

• Question 859:

  What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

  A. Authentication

  B. Resource management

  C. Virtual warehouse caching

  D. Query parsing and optimization

  E. Query execution

  F. Physical storage of micro-partitions

  Correct Answer: ABD

• Question 860:

  If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

  A. The columns that are queried in the select clause.

  B. The columns with very high cardinality.

  C. The columns with many different values.

  D. The columns most actively used in the select filters.

  Correct Answer: D