Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 801:

  What is the default size for a newly-provisioned Snowpark-optimized virtual warehouse ?

  A. X-Large
  B. Large
  C. Medium
  D. Small
  C. Medium

  ---

  Explanation

  By default, Snowpark-optimized warehouses are provisioned with Medium size , unless specified otherwise. This provides balanced compute for handling Snowpark operations.

  Snowflake Docs: Snowpark-Optimized Warehouses

• Question 802:

  A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?

  A. Create a task that runs a copy into operation from an external stage every 5 minutes
  B. Create a task that puts the files in an internal stage and automate the data loading wizard
  C. Create a task that runs a GET operation to intermittently check for new files
  D. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest
  D. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

• Question 803:

  Which statement describes when a virtual warehouse can be resized?

  A. A resize will affect running, queued, and new queries.
  B. A resize can only be completed when the warehouse is in an auto-resume status.
  C. A resize must be completed when the warehouse is suspended.
  D. A resize can be completed at any time.
  D. A resize can be completed at any time.

  ---

  Explanation

• Question 804:

  Which command is used to unload data from a table or move a query result to a stage?

  A. COPY INTO
  B. GET
  C. MERGE
  D. PUT
  A. COPY INTO

  ---

  Explanation

• Question 805:

  What technique does Snowflake use to limit the number of micro-partitions scanned by each query?

  A. B-tree
  B. Indexing
  C. Map reduce
  D. Pruning
  D. Pruning

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions

• Question 806:

  What are the default Time Travel and Fail-safe retention periods for transient tables?

  A. Time Travel-1 day. Fail-safe-1 day
  B. Time Travel-0 days. Fail-safe-1 day
  C. Time Travel-1 day. Fail-safe-0 days
  D. Transient tables are retained in neither Fail-safe nor Time Travel
  C. Time Travel-1 day. Fail-safe-0 days

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-cdp-storage-costs.html#:~:text=Temporary%20and%20Transient%20Tables,-To%20help% 20manageandtext=Temporary%20tables%20can%20also%20have,have%20no%20Fail%2Dsafe% 20period.

• Question 807:

  What privileges are required to allow role RL_CUST_WH to start warehouse CUST_WH?

  A. GRANT OPERATE ON CUST_WH TO ROLE RL_CUST_WH;
  B. GRANT CREATE WAREHOUSES ON ACCOUNT TO ROLE RL_CUST_WH;
  C. GRANT MANAGE WAREHOUSES ON ACCOUNT TO ROLE RL_CUST_WH;
  D. GRANT USAGE ON CUST_WH TO ROLE RL_CUST_WH;
  A. GRANT OPERATE ON CUST_WH TO ROLE RL_CUST_WH;

  ---

  Explanation

  To start, resume, or suspend a warehouse, the role needs the OPERATE privilege. USAGE only allows reference to the object but not its activation. Required Privileges for Starting a Warehouse:

  USAGE (to reference)

  OPERATE (to start/stop)

  Snowflake Docs: Warehouse Privileges

• Question 808:

  What actions will trigger a data pipe to load? (Choose two.)

  A. Use of an INSERT statement
  B. Use of a COPY INTO statement
  C. Use of the insertFiles REST endpoint
  D. Use of the insertReport REST endpoint
  E. Set the pipe parameter to auto-ingest
  C. Use of the insertFiles REST endpoint
  E. Set the pipe parameter to auto-ingest

  ---

  Explanation

• Question 809:

  Which command line parameter value can be pre-specified as an environment variable in SnowSQL?

  A. HOST
  B. VARIABLE
  C. OPTION
  D. MFA-PASSCODE
  A. HOST

  ---

  Explanation

• Question 810:

  Which function can be combined with the copy command to unload a relational table into a JSON file?

  A. FLATTEN
  B. LISTAGG
  C. OBJECT_CONSTRUCT
  D. PARSE_JSON
  C. OBJECT_CONSTRUCT

  ---

  Explanation