Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 831:

  Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

  A. Configure the user to be initially disabled.

  B. Force an immediate password change.

  C. Set a default role for the user.

  D. Set the number of minutes to unlock to 15 minutes.

  E. Set the user's access to expire within a specified timeframe.

  Correct Answer: BC

• Question 832:

  Which of the following accurately describes shares?

  A. Tables, secure views, and secure UDFs can be shared

  B. Shares can be shared

  C. Data consumers can clone a new table from a share

  D. Access to a share cannot be revoked once granted

  Correct Answer: A

• Question 833:

  Which formats does Snowflake store unstructured data in? (Choose two.)

  A. GeoJSON

  B. Array

  C. XML

  D. Object

  E. BLOB

  Correct Answer: BD

• Question 834:

  How does Snowflake Fail-safe protect data in a permanent table?

  A. Fail-safe makes data available up to 1 day, recoverable by user operations.

  B. Fail-safe makes data available for 7 days, recoverable by user operations.

  C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

  D. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

  Correct Answer: C

• Question 835:

  Which statement MOST accurately describes clustering in Snowflake?

  A. The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.

  B. Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

  C. The clustering key must be included in the COPY command when loading data into Snowflake.

  D. Clustering can be disabled within a Snowflake account.

  Correct Answer: B

• Question 836:

  Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

  A. Files

  B. External tables

  C. Secure User-Defined Functions (UDFs)

  D. Sequences

  E. Streams

  Correct Answer: BC

• Question 837:

  What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

  A. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 30 days. Fail Safe retention time is 1 day.

  B. Default Time Travel Retention is set to 1 day.

  Maximum Time Travel Retention is 365 days.

  Fail Safe retention time is 7 days.

  C. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.

  D. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.

  E. Default Time Travel Retention is set to 7 days. Maximum Time Travel Retention is 1 day. Fail Safe retention time is 90 days.

  F. Default Time Travel Retention is set to 90 days. Maximum Time Travel Retention is 7 days. Fail Safe retention time is 356 days.

  Correct Answer: D

• Question 838:

  Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

  A. Database replication and failover

  B. Automated index management

  C. Customer managed keys (Tri-secret secure)

  D. Extended time travel

  E. Native support for geospatial data

  Correct Answer: DE

• Question 839:

  Which of the following are characteristics of security in Snowflake?

  A. Account and user authentication is only available with the Snowflake Business Critical edition.

  B. Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

  C. Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

  D. Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

  Correct Answer: C

• Question 840:

  What COPY INTO SQL command should be used to unload data into multiple files?

  A. SINGLE=TRUE

  B. MULTIPLE=TRUE

  C. MULTIPLE=FALSE

  D. SINGLE=FALSE

  Correct Answer: D