Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 911:

  What metadata can be accessed through the INFORMATION_SCHEMA? (Select TWO).

  A. The date a database was created.
  B. A query ID from the query plan.
  C. The micro-partition pruning efficiency of a table.
  D. The clustering status of a table.
  E. A table's credit consumption.
  A. The date a database was created.
  B. A query ID from the query plan.

  ---

  Explanation

• Question 912:

  Which virtual warehouse consideration can help lower compute resource credit consumption?

  A. Setting up a multi-cluster virtual warehouse
  B. Resizing the virtual warehouse to a larger size
  C. Automating the virtual warehouse suspension and resumption settings
  D. Increasing the maximum cluster count parameter for a multi-cluster virtual warehouse
  C. Automating the virtual warehouse suspension and resumption settings

  ---

  Explanation

• Question 913:

  What privileges are required to create a task?

  A. The global privilege create task is required to create a new task.
  B. Tasks are created at the Application level and can only be created by the Account Admin role.
  C. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
  D. The role must have access to the target schema and the create task privilege on the schema itself.
  D. The role must have access to the target schema and the create task privilege on the schema itself.

  ---

  Explanation

  All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the same schema. https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks

• Question 914:

  Which SQL command will download all the data files from an internal table stage named TBL_EMPLOYEE to a local window directory or folder on a client machine in a folder named folder with space within the C drive?

  A. GET @%TBL_EMPLOYEE 'file://C:\folder with space\';
  B. GET @%TBL_EMPLOYEE 'file://C:/folder with space/';
  C. PUT 'file://C:\folder with space\*' @%TBL_EMPLOYEE;
  D. PUT 'file://C:/folder with space/*' @%TBL_EMPLOYEE;
  A. GET @%TBL_EMPLOYEE 'file://C:\folder with space\';

  ---

  Explanation

• Question 915:

  Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?

  A. Standard
  B. Enterprise
  C. Business Critical
  D. Virtual Private Snowflake (VPS)
  D. Virtual Private Snowflake (VPS)

  ---

  Explanation

• Question 916:

  Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

  A. CREATE STAGE
  B. COPY INTO
  C. COPY INTO
  D. CREATE PIPE
  C. COPY INTO

  ---

  Explanation

• Question 917:

  Which Snowflake edition supports Protected Health Information (PHI) data (in accordance with HIPAA and HITRUST CSF regulations), and has a dedicated metadata store and pool of compute resources?

  A. Standard
  B. Enterprise
  C. Business Critical
  D. Virtual Private Snowflake (VPS)
  D. Virtual Private Snowflake (VPS)

  ---

  Explanation

• Question 918:

  Which chart type does Snowsight support to visualize worksheet data?

  A. Box plot
  B. Bubble chart
  C. Pie chart
  D. Scatterplot
  D. Scatterplot

  ---

  Explanation

• Question 919:

  Snowflake's hierarchical key mode includes which keys? (Choose two.)

  A. Account master keys
  B. Database master keys
  C. File keys
  D. Secure view keys
  E. Schema master keys
  A. Account master keys
  C. File keys

  ---

  Explanation

• Question 920:

  Which DDL/DML operation is allowed on an inbound data share?

  A. ALTER TABLE
  B. INSERT INTO
  C. MERGE
  D. SELECT
  A. ALTER TABLE

  ---

  Explanation