Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 421:

  Why do Snowflake's virtual warehouses have scaling policies?

  A. To help save extra storage costs
  B. To help increase the performance of serverless computing features
  C. To help control the credits consumed by a multi-cluster warehouse running in auto-scale mode
  D. To help control the credits consumed by a multi-cluster warehouse running in maximized mode
  C. To help control the credits consumed by a multi-cluster warehouse running in auto-scale mode

  ---

  Explanation

• Question 422:

  How many network policies can be assigned to an account or specific user at a time?

  A. One
  B. Two
  C. Three
  D. Unlimited
  A. One

  ---

  Explanation

• Question 423:

  Why would a Snowflake user decide to use a materialized view instead of a regular view?

  A. The base tables do not change frequently.
  B. The results of the view change often.
  C. The query is not resource intensive.
  D. The query results are not used frequently.
  A. The base tables do not change frequently.

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/views-materialized

• Question 424:

  Which Snowflake table type is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is dropped at the end of the session?

  A. Temporary
  B. Local
  C. User
  D. Transient
  A. Temporary

  ---

  Explanation

• Question 425:

  Which multi-cluster virtual warehouse setting will help process queued queries as quickly as possible?

  A. An economy scaling policy
  B. A standard scaling policy
  C. Maximized mode
  D. Auto-scale mode
  D. Auto-scale mode

  ---

  Explanation

  In Auto-scale mode, a Snowflake multi-cluster virtual warehouse dynamically adds or removes clusters to process queued queries efficiently. This ensures that workloads are handled quickly without manual intervention, especially during

  peak demand.

  References:

  Snowflake Documentation: Multi-Cluster Warehouses Snowflake Scaling Policies

• Question 426:

  Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

  A. Optimizes the virtual warehouse size and multi-cluster setting to economy mode
  B. Allows a user to import the files in a sequential order
  C. Increases the latency staging and accuracy when loading the data
  D. Allows optimization of parallel operations
  D. Allows optimization of parallel operations

  ---

  Explanation

• Question 427:

  A Snowflake user wants to share data with someone who does not have a Snowflake account.

  How can the Snowflake user share the data?

  A. Use the Snowflake Marketplace.
  B. Create a reader account.
  C. Create a consumer account.
  D. Use a Snowflake share.
  B. Create a reader account.

  ---

  Explanation

• Question 428:

  A user wants to access stored in a stage without authenticating into Snowflake. Which type of URL should be used?

  A. File URL
  B. Staged URL
  C. Scoped URL
  D. Pre-signed URL
  D. Pre-signed URL

  ---

  Explanation

• Question 429:

  Which Snowflake layer can be configured?

  A. Database Storage
  B. Cloud Services
  C. Query Processing
  D. Application Services
  C. Query Processing

  ---

  Explanation

• Question 430:

  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
  B. Microsoft Active Directory Federation Services (AD FS)
  D. Okta

  ---

  Explanation