Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 671:

  When a Snowflake user loads CSV data from a stage, which COPY INTO [table] command guideline should they follow?

  A. The CSV field delimiter must be a comma character (`,').
  B. The number of columns in each row should be consistent.
  C. The data file in the stage must be in a compressed format.
  D. The data file must have the same number of columns as the target table.
  B. The number of columns in each row should be consistent.

  ---

  Explanation

• Question 672:

  Several users are using the same virtual warehouse. The users report that the queries are running slowly, and that many queries are being queued.

  What is the recommended way to resolve this issue?

  A. Reduce the warehouse STATEMENT_QUEUED_TIMEOUT_IN SECONDS parameter.
  B. Reduce the warehouse AUTO_SUSPEND parameter.
  C. Increase the warehouse MAX_CONCURRENCY_LIMIT parameter.
  D. Increase the warehouse MAX_CLUSTER_COUNT parameter.
  D. Increase the warehouse MAX_CLUSTER_COUNT parameter.

  ---

  Explanation

• Question 673:

  When cloning tables, which information_schema view will show different columns for owned storage and referenced storage?

  A. DATABASE_ST0RAGE_USAGE_HISTORY
  B. STAGE_STORAGE_USAGE_HISTORY
  C. TABLE_STORAGE_METRICS
  D. STORAGE USAGE
  C. TABLE_STORAGE_METRICS

  ---

  Explanation

  The TABLE_STORAGE_METRICS view in Snowflake provides details about table storage, including owned storage (storage exclusively used by the table) and referenced storage (shared storage due to cloning or Time Travel). This view

  helps distinguish between data directly owned by the table and data shared with other tables through features like cloning.

  Why Other Options Are Incorrect:

  A. DATABASE_STORAGE_USAGE_HISTORY: Tracks storage usage at the database level, not specific to tables or cloning.

  B. STAGE_STORAGE_USAGE_HISTORY: Tracks storage usage for stages, not tables.

  D. STORAGE_USAGE: Provides high-level account storage details, not specific to cloning or tables.

  References:

  TABLE_STORAGE_METRICS Documentation

• Question 674:

  Which system-defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?

  A. ACCOUNTADMIN
  B. SECURITYADMIN
  C. SYSADMIN
  D. ORGADMIN
  D. ORGADMIN

  ---

  Explanation

• Question 675:

  What is true about sharing data in Snowflake? (Choose two.)

  A. The Data Consumer pays for data storage as well as for data computing.
  B. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
  C. A Snowflake account can both provide and consume shared data.
  D. The Provider is charged for compute resources used by the Data Consumer to query the shared data.
  E. The Data Consumer pays only for compute resources to query the shared data.
  C. A Snowflake account can both provide and consume shared data.
  E. The Data Consumer pays only for compute resources to query the shared data.

  ---

  Explanation

• Question 676:

  Use of which virtual warehouse or warehouse con guration will improve the performance of workloads that have large memory requirements, such as Machine Learning (ML) training using a stored procedure?

  A. Snowpark-optimized warehouse
  B. Standard warehouse
  C. Multi-cluster warehouse
  D. Serverless compute
  A. Snowpark-optimized warehouse

  ---

  Explanation

• Question 677:

  Which types of charts does Snowsight support? (Choose two.)

  A. Area charts
  B. Bar charts
  C. Column charts
  D. Radar charts
  E. Scorecards
  A. Area charts
  B. Bar charts

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/ui-snowsight-visualizations

• Question 678:

  What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

  A. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
  B. Scaling out adds clusters of varying sizes to a virtual warehouse.
  C. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
  D. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
  E. Scaling up resizes a virtual warehouse so it can handle more complex workloads.
  F. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.
  A. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
  E. Scaling up resizes a virtual warehouse so it can handle more complex workloads.

  ---

  Explanation

• Question 679:

  When using SnowSQL, which configuration options are required when unloading data from a SQL query run on a local machine? (Choose two.)

  A. echo
  B. quiet
  C. output_file
  D. output_format
  E. force_put_overwrite
  C. output_file
  D. output_format

  ---

  Explanation

• Question 680:

  Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

  A. True
  B. False
  A. True

  ---

  Explanation