Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 761:

  Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?

  A. Access history

  B. Data classification

  C. Dynamic Data Masking

  D. Object tagging

  Correct Answer: A

• Question 762:

  What information is stored in the ACCESS_HISTORY view?

  A. History of the files that have been loaded into Snowflake

  B. Names and owners of the roles that are currently enabled in the session

  C. Query details such as the objects included and the user who executed the query

  D. Details around the privileges that have been granted for all objects in an account

  Correct Answer: C

• Question 763:

  What role is required to use Partner Connect?

  A. ACCOUNTADMIN

  B. ORGADMIN

  C. SECURITYADMIN

  D. SYSADMIN

  Correct Answer: A

• Question 764:

  A Snowflake user wants to share data using my_share with account xy12345.

  Which command should be used?

  A. grant usage on share my_share to account xy12345;

  B. grant select on share my_share to account xy12345;

  C. alter share my_share add accounts = xy12345;

  D. alter account xy12345 add share my_share;

  Correct Answer: C

• Question 765:

  Which identity providers are valid type values for federated authentication on the SAML_IDENTITY_PROVIDER parameter? (Choose two.)

  A. Identity Access Management (IAM)

  B. Microsoft Active Directory Federation Services (AD FS)

  C. OAuth

  D. Okta

  E. PingFederate

  Correct Answer: BD

• Question 766:

  Which Snowflake database object can be shared with other accounts?

  A. Tasks

  B. Pipes

  C. Secure User-Defined Functions (UDFs)

  D. Stored Procedures

  Correct Answer: C

• Question 767:

  What privilege does a user need in order to receive or request data from the Snowflake Marketplace?

  A. CREATE DATA EXCHANGE LISTING

  B. CREATE SHARE

  C. IMPORT SHARE

  D. IMPORTED PRIVILEGES

  Correct Answer: D

• Question 768:

  How can a Snowflake user configure a virtual warehouse to support over 100 users if their company has Enterprise Edition?

  A. Add additional warehouses and configure them as a cluster.

  B. Set the auto-scale to 100.

  C. Use a multi-cluster warehouse.

  D. Use a larger warehouse.

  Correct Answer: C

• Question 769:

  What will be the output of the below query against the table name gold_data?

  select * from gold_data tablesample (100);

  A. It will return an empty sample.

  B. It will return a random 100 rows.

  C. It will return an entire table.

  D. It will produce an error message.

  Correct Answer: C

• Question 770:

  How is table data compressed in Snowflake?

  A. Each column is compressed as it is stored in a micro-partition.

  B. Each micro-partition is compressed as it is written into cloud storage using GZIP.

  C. The micro-partitions are stored in compressed cloud storage and the cloud storage handles compression.

  D. The text data in a micro-partition is compressed with GZIP but other types are not compressed.

  Correct Answer: A