Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 631:

  Which statement about data sharing is true?

  A. Accounts can share with other accounts regardless of their Snowflake edition, without requiring help from Snowflake Support.

  B. Data sharing can cross regions, but not cloud providers.

  C. The Data Consumer can only see objects in the Data Provider's source database that have been explicitly added to the share.

  D. A Data Provider can only share with other Snowflake customers.

  Correct Answer: C

• Question 632:

  What happens when the size of a virtual warehouse is changed?

  A. Queries that are running on the current warehouse configuration are not impacted.

  B. Queries that are running on the current warehouse configuration are aborted and have to be resubmitted by the user.

  C. Queries that are running on the current warehouse configuration are aborted and are automatically resubmitted.

  D. Queries that are running on the current warehouse configuration are moved to the new configuration and finished there.

  Correct Answer: A

• Question 633:

  A Snowflake user wants to share transactional data with retail suppliers. However, some of the suppliers do not use Snowflake.

  According to best practice, what should the Snowflake user do? (Choose two.)

  A. Provide each non-Snowflake supplier with their own reader account.

  B. Deploy a single reader account to be shared by all of the non-Snowflake suppliers.

  C. Create an ETL pipeline that uses select and inserts statements from the source to the target supplier accounts.

  D. Use a data share for suppliers in the same cloud region and a replicated proxy share for other cloud deployments.

  E. Extract the shared transactional data to an external stage and use cloud storage utilities to reload the suppliers' regions.

  Correct Answer: AD

• Question 634:

  What does Snowflake recommend regarding database object ownership? (Choose two.)

  A. Create objects with ACCOUNTADMIN and do not reassign ownership.

  B. Create objects with SYSADMIN.

  C. Create objects with SECURITYADMIN to ease granting of privileges later.

  D. Create objects with a custom role and grant this role to SYSADMIN.

  E. Use only managed access schemas for objects owned by ACCOUNTADMIN.

  Correct Answer: BD

• Question 635:

  How are micro-partitions typically generated in Snowflake?

  A. Automatically

  B. ORDER BY <>;

  C. PARTITION BY <>;

  D. GROUP BY <>;

  Correct Answer: A

• Question 636:

  Which Snowflake object can be accessed in the FROM clause of a query, returning a set of rows having one or more columns?

  A. A User-Defined Table Function (UDTF)

  B. A Scalar User Defined Function (UDF)

  C. A stored procedure D. A task

  Correct Answer: A

• Question 637:

  As a best practice, all custom roles should be granted to which system-defined role?

  A. ACCOUNTADMIN

  B. ORGADMIN

  C. SECURITYADMIN

  D. SYSADMIN

  Correct Answer: D

• Question 638:

  Which statements reflect valid commands when using secondary roles? (Choose two.)

  A. USE SECONDARY ROLES RESUME

  B. USE SECONDARY ROLES SUSPEND

  C. USE SECONDARY ROLES ALL

  D. USE SECONDARY ROLES ADD

  E. USE SECONDARY ROLES NONE

  Correct Answer: CE

• Question 639:

  Which semi-structured data formats can be loaded into Snowflake with a COPY command? (Choose two.)

  A. CSV

  B. EDI

  C. HTML

  D. ORC

  E. XML

  Correct Answer: DE

• Question 640:

  How can a Snowflake user share data with another user who does not have a Snowflake account?

  A. Share the data by implementing User-Defined Functions (UDFs)

  B. Create a reader account and create a share of the data

  C. Grant the READER privilege to the database that is going to be shared

  D. Move the Snowflake account to a region where data sharing is enabled

  Correct Answer: B