Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 131:

  How is data protected in Snowflake throughout its lifecycle? (Choose two.)

  A. Users are responsible for encrypting data before uploading to Snow ake.
  B. Snow ake automatically tags and masks Personal Identi able Information (PII).
  C. Snow ake automatically encrypts data locally before copying the data to the cloud over an encrypted connection.
  D. Snow ake automatically rotates keys pairs regularly, using a hierarchical key model stored in a hardware security module.
  E. Users are responsible for uploading and con guring key pair rotation schedules and key sizes to encrypt stored data.
  C. Snow ake automatically encrypts data locally before copying the data to the cloud over an encrypted connection.
  D. Snow ake automatically rotates keys pairs regularly, using a hierarchical key model stored in a hardware security module.

  ---

  Explanation

• Question 132:

  Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

  A. Tri-Secret Secure
  B. Time Travel
  C. Fail-safe
  D. Data encryption
  E. External stages
  B. Time Travel
  C. Fail-safe

  ---

  Explanation

• Question 133:

  When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?

  A. When using a paid listing on the Snowflake Marktetplace
  B. When using a private listing on the Snowflake Marketplace
  C. When using a personalized listing on the Snowflake Marketplace
  D. When using a Direct Share with another account
  A. When using a paid listing on the Snowflake Marktetplace

  ---

  Explanation

• Question 134:

  it is best practice to define a clustering key on every table.

  A. True
  B. False
  B. False

  ---

  Explanation

  https://dwgeek.com/how-to-create-snowflake-clustered-tables-examples.html/

• Question 135:

  What is a feature of column-level security in Snowflake?

  A. Role access policies
  B. Network policies
  C. Internal tokenization
  D. External tokenization
  D. External tokenization

  ---

  Explanation

  https://docs.snowflake.com/user-guide/security-column-intro

• Question 136:

  What is the default value in the Snowflake Web Interface (UI) for auto suspending a Virtual Warehouse?

  A. 1 minute
  B. 5 minutes
  C. 10 minutes
  D. 15 minutes
  C. 10 minutes

  ---

  Explanation

• Question 137:

  What is the MINIMUM Snowflake edition that users storing protected information in Snowflake should use for regulatory compliance?

  A. Standard
  B. Enterprise
  C. Business Critical
  D. Virtual Private Snowflake (VPC)
  C. Business Critical

  ---

  Explanation

• Question 138:

  When unloading data to an external stage, which compression format can be used for Parquet files with the COPY INTO command?

  A. BROTLI
  B. GZIP
  C. LZO
  D. ZSTD
  C. LZO

  ---

  Explanation

• Question 139:

  What does Snowflake recommend a user do if they need to connect to Snowflake with a tool or technology that is not listed in Snowflake's partner ecosystem?

  A. Use Snowflake's native API.
  B. Use a custom-built connector.
  C. Contact Snowflake Support for a new driver.
  D. Connect through Snowflake's JDBC or ODBC drivers.
  D. Connect through Snowflake's JDBC or ODBC drivers.

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/ecosystem-all

• Question 140:

  How should Multi-Factor Authentication (MFA) be enabled for a user?

  A. A USERADMIN must enroll the user
  B. A SECURITYADMIN must enroll the user
  C. An ACCOUNTADMIN must enroll the user
  D. Each Snowflake user must enroll themselves
  D. Each Snowflake user must enroll themselves

  ---

  Explanation

  Users must self-enroll for MFA by logging into the web UI and scanning a QR code with an authenticator app. Administrators cannot do this on their behalf.

  Snowflake Docs: MFA Setup