Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 551:

  Which SQL statement will require a virtual warehouse to run?

  A. SELECT COUNT(*) FROM TBL_EMPLOYEE;
  B. ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGION VARCHAR(20);
  C. INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1, 'Adam', 20000, 'Finance');
  D. CREATE OR REPLACE TABLE TBL_EMPLOYEE ( EMP_ID NUMBER, EMP_NAME VARCHAR(30), EMP_SALARY NUMBER, DEPT VARCHAR(20) );
  C. INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1, 'Adam', 20000, 'Finance');

  ---

  Explanation

• Question 552:

  From which locations can data files be downloaded using the GET command? (Choose two.)

  A. External stage
  B. Table stage
  C. User stage
  D. Directory table
  E. Permanent table
  B. Table stage
  C. User stage

  ---

  Explanation

• Question 553:

  What is a best practice after creating a custom role?

  A. Create the custom role using the SYSADMIN role.
  B. Assign the custom role to the SYSADMIN role
  C. Assign the custom role to the PUBLIC role
  D. Add__CUSTOM to all custom role names
  B. Assign the custom role to the SYSADMIN role

  ---

  Explanation

  When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top- most custom role assigned to the system role SYSADMIN. This role structure allows system administrators to manage all objects in the account, such as warehouses and database objects, while restricting management of users and roles to the USERADMIN role.

• Question 554:

  Which Snowflake tasks are managed in the cloud services layer? (Select TWO)

  A. Performance tuning
  B. Query acceleration
  C. Metadata management
  D. Query processing
  E. Query parsing
  C. Metadata management
  E. Query parsing

  ---

  Explanation

• Question 555:

  Which function is used to unload a relational table into a JSON file?

  A. PARSE_JSON
  B. JSON_EXTRACT_PATH_TEXT
  C. OBJECT_CONSTRUCT
  D. TO_JSON
  D. TO_JSON

  ---

  Explanation

• Question 556:

  A Snowflake user wants to design a series of transformations that need to be executed in a specific order, on a given schedule.

  What Snowflake objects should be used?

  A. Pipes
  B. Tasks
  C. Streams
  D. Sequences
  B. Tasks

  ---

  Explanation

  Tasks in Snowflake are used to create workflows or schedules for executing SQL statements, including transformations, in a specific order. By defining dependencies between tasks, users can ensure they execute in a defined sequence.

  Example:

  sql

  CopyEdit

  CREATE TASK task_1

  SCHEDULE = '5 MINUTE'

  AS

  INSERT INTO transformed_table SELECT * FROM raw_table;

  CREATE TASK task_2

  AFTER task_1

  AS

  DELETE FROM raw_table WHERE processed = TRUE;

  Tasks can also run on a fixed schedule or be triggered by preceding tasks in a chain.

  Why Other Options Are Incorrect:

  A. Pipes: Automates data loading but does not handle transformation workflows.

  C. Streams: Tracks table changes but does not schedule or sequence transformations.

  D. Sequences: Generate unique numbers, unrelated to task scheduling or transformations.

  References:

  Snowflake Tasks Documentation

• Question 557:

  Which command removes a role from another role or a user in Snowflak?

  A. ALTER ROLE
  B. REVOKE ROLE
  C. USE ROLE
  D. USE SECONDARY ROLES
  B. REVOKE ROLE

  ---

  Explanation

• Question 558:

  What are ways to create and manage data shares in Snowflake? (Select TWO)

  A. Through the Snowflake web interface (Ul)
  B. Through the DATA_SHARE=TRUE parameter
  C. Through SQL commands
  D. Through the enable__share=true parameter
  E. Using the CREATE SHARE AS SELECT * TABLE command
  A. Through the Snowflake web interface (Ul)
  C. Through SQL commands

  ---

  Explanation

• Question 559:

  Which database objects can be shared with Secure Data Sharing? (Choose two.)

  A. Views
  B. Materialized views
  C. External stages
  D. External tables
  E. Dynamic tables
  A. Views
  D. External tables

  ---

  Explanation

• Question 560:

  Which Snowflake object uses credits for maintenance?

  A. Regular table
  B. Regular view
  C. Materialized view
  D. Cached query result
  C. Materialized view

  ---

  Explanation