Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1031:

  For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

  A. CHECK_OPTION
  B. IS_SECURE
  C. IS_UPDATEABLE
  D. TABLE_NAME
  B. IS_SECURE

  ---

  Explanation

• Question 1032:

  What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?

  A. FLATTEN
  B. GET_PATH
  C. CHECK_JSON
  D. PARSE_JSON
  A. FLATTEN

  ---

  Explanation

• Question 1033:

  Which command is used in Snowflake to manually refresh a directory table?

  A. TRUNCATE STAGE
  B. ALTER STAGE
  C. ALTER TABLE
  D. ALTER VIEW
  B. ALTER STAGE

  ---

  Explanation

• Question 1034:

  A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.

  Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

  A. CREATE TABLE LIKE TABLE_A;
  B. CREATE VIEW Mview_name> as SELECT * FROM TABLE_A;
  C. CREATE TABLE < table name> AS SELECT * FROM TABLE A;
  D. CREATE MTERIALIED VIEW As SELECT * FROM TABLE_A;
  A. CREATE TABLE LIKE TABLE_A;

  ---

  Explanation

• Question 1035:

  What command will grant the SELECT privilege on all new tables created in the mydb.myschema schema to the read_only role?

  A. GRANT SELECT ON ALL TABLES IN SCHEMA mydb.myschema TO ROLE read_only;
  B. GRANT USAGE ON FUTURE SCHEMAS IN DATABASE mydb TO ROLE read_only;
  C. GRANT SELECT ON FUTURE TABLES IN SCHEMA mydb.myschema TO ROLE read_only;
  D. GRANT USAGE ON ALL SCHEMAS IN DATABASE mydb TO ROLE read_only;
  A. GRANT SELECT ON ALL TABLES IN SCHEMA mydb.myschema TO ROLE read_only;

  ---

  Explanation

• Question 1036:

  On which of the following cloud platforms can a Snowflake account be hosted? (Choose three.)

  A. Amazon Web Services
  B. Private Virtual Cloud
  C. Oracle Cloud
  D. Microsoft Azure Cloud
  E. Google Cloud Platform
  F. Alibaba Cloud
  A. Amazon Web Services
  D. Microsoft Azure Cloud
  E. Google Cloud Platform

  ---

  Explanation

• Question 1037:

  What are type predicates used for?

  A. Extracting data from a VARIANT column
  B. Casting a value in a VARIANT column to a particular data type
  C. Determining if a value in a VARIANT column is a particular data type
  D. Manipulating objects and arrays in a VARIANT column
  C. Determining if a value in a VARIANT column is a particular data type

  ---

  Explanation

• Question 1038:

  Which command is used to unload data from a Snowflake table into a file in a stage?

  A. COPY INTO
  B. GET
  C. WRITE
  D. EXTRACT INTO
  A. COPY INTO

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#:~:text=Your%20User%20Stage-,Use%20the%20COPY%20INTO%20command%20to% 20unload%20all%20the,more%20files%20in%20your%20stage.

• Question 1039:

  When using a direct share, what privileges does a role need to control access to the objects that are in a share that is using database roles? (Choose two.)

  A. CREATE PIPE
  B. CREATE STREAM
  C. CREATE TASK
  D. CREATE SHARE
  E. CREATE DATABASE
  D. CREATE SHARE
  E. CREATE DATABASE

  ---

  Explanation

• Question 1040:

  Which command can be used to view the allowed and blocked IP list of a network policy?

  A. ALTER NETWORK POLICY
  B. CREATE NETWORK POLICY
  C. DESCRIBE NETWORK POLICY
  D. SHOW NETWORK POLICIES
  C. DESCRIBE NETWORK POLICY

  ---

  Explanation