Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1141:

  Which queries will require a running virtual warehouse? (Select TWO).

  A. SELECT COUNT(*) FROM ;
  B. DELETE FROM ;
  C. UPDATE SET;
  D. DROP TABLE ;
  E. SELECT CURRENT_DATABASE();
  A. SELECT COUNT(*) FROM ;
  C. UPDATE SET;

  ---

  Explanation

• Question 1142:

  Which file function provides a URL with access to a file on a stage without the need for authentication and authorization?

  A. GET_RELATIVE_PATH
  B. GET_PRESIGNED_URL
  C. BUILD_STAGE_FILE_URL
  D. BUILD_SCOPED_FILE_URL
  B. GET_PRESIGNED_URL

  ---

  Explanation

• Question 1143:

  Which Snowflake virtual warehouse con guration enables horizontal scaling?

  A. Increasing the WAREHOUSE_SIZE.
  B. Increasing the MAX_CLUSTER_COUNT.
  C. Increasing the MAX_CONCURRENCY_LEVEL.
  D. Increasing the MIN_CLUSTER_COUNT.
  B. Increasing the MAX_CLUSTER_COUNT.

  ---

  Explanation

• Question 1144:

  Which security feature is available in all Snowflake editions?

  A. Data masking policies
  B. Object-level access control
  C. Object tagging
  D. Customer-managed encryption keys
  B. Object-level access control

  ---

  Explanation

• Question 1145:

  The COPY command must specify a File Format in order to execute.

  A. True
  B. False
  B. False

  ---

  Explanation

  Create Stage: https://docs.snowflake.com/en/sql-reference/sql/create-stage.html Create Table (STAGE_FILE_FORMAT option): https://docs.snowflake.com/en/sql-reference/sql/create-table.html Copy Into: https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html

• Question 1146:

  Which command will allow users to query data from files in cloud storage without ingesting the data ?

  A. CREATE EXTERNAL TABLE
  B. CREATE PIPE
  C. CREATE TABLE
  D. CREATE FILE FORMAT
  A. CREATE EXTERNAL TABLE

  ---

  Explanation

  An external table allows users to query files stored in external stages (e.g., S3, Azure Blob, GCS) without loading them into Snowflake tables . This enables cost-effective access to external datasets.

  Snowflake Docs: External Tables

• Question 1147:

  It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

  A. True
  B. False
  A. True

  ---

  Explanation

  Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.

• Question 1148:

  Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?

  A. Materialized View
  B. Pipe
  C. Stream
  D. Task
  C. Stream

  ---

  Explanation

• Question 1149:

  What is the maximum compressed row size in Snowflake?

  A. 8KB
  B. 16MB
  C. 50MB
  D. 4000GB
  B. 16MB

  ---

  Explanation

  MAX size for compressed data for semi-structured data type is also 16 MB. That means if our table has a semi-structured data type column with 16MB data other columns will have NULL data.

• Question 1150:

  Which function returns the URL of a stage using the stage name as the input?

  A. BUILD_STAGE_FILE_URL
  B. BUILD_SCOPED_FILE_URL
  C. GET_PRESIGNED_URL
  D. GET_STAGE_LOCATION
  D. GET_STAGE_LOCATION

  ---

  Explanation