Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1041:

  This command is executed:

  CREATE TABLE new_table CLONE existing_table COPY GRANT;

  What will happen to the privileges of any cloned objects?

  A. The clone will only inherit SELECT privileges from the source object.
  B. The clone will inherit all privileges, including OWNERSHIP, from the source object.
  C. The clone will inherit all privileges except OWNERSHIP from the source object.
  D. The clone will not inherit any privileges from the source object.
  C. The clone will inherit all privileges except OWNERSHIP from the source object.

  ---

  Explanation

• Question 1042:

  What will happen if multiple identical COPY INTO statements using the default settings are executed in parallel on the same data file?

  A. The COPY INTO commands will load the data only once in the table.
  B. The COPY INTO commands will duplicate the data in the table.
  C. The COPY INTO commands will all fail with an error due to reading the same file.
  D. The COPY INTO commands will overwrite the data in the table.
  B. The COPY INTO commands will duplicate the data in the table.

  ---

  Explanation

• Question 1043:

  A security review identified several roles that are no longer being used. Which of the roles can be dropped?

  A. ACCOUNTADMIN
  B. USERADMIN
  C. FINANCEADMIN
  D. PUBLIC
  C. FINANCEADMIN

  ---

  Explanation

• Question 1044:

  Which Data Definition Language (DDL) commands are supported by Snowflake to manage tags? (Choose two.)

  A. ALTER TAG
  B. DESCRIBE TAG
  C. DROP TAG
  D. GRANT ... TO TAG
  E. GRANT TAG
  A. ALTER TAG
  C. DROP TAG

  ---

  Explanation

• Question 1045:

  What data is stored in the Snowflake storage layer? (Select TWO).

  A. Snowflake parameters
  B. Micro-partitions
  C. Query history
  D. Persisted query results
  E. Standard and secure view results
  B. Micro-partitions
  C. Query history

  ---

  Explanation

  B. Micro-partitions

  C. Query history (also stored in the data layer of SNOWFLAKE.USAGE_SCHEMA)

• Question 1046:

  Which command can be executed from a reader account?

  A. INSERT
  B. CREATE SHARE
  C. SHOW PROCEDURES
  D. COPY INTO
  D. COPY INTO

  ---

  Explanation

• Question 1047:

  A Snowflake user is actively logged into Snowflake when a user-level network policy is assigned to that user.

  Which Snowflake do it the user's IP address does not match the user-level network policy rules?

  A. Log the user out.
  B. Deactivate the network policy.
  C. Prevent the user from executing additional queries.
  D. Allow the user to continue until the session or login token expires.
  C. Prevent the user from executing additional queries.

  ---

  Explanation

• Question 1048:

  Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?

  A. The column name and element names are both case-sensitive.
  B. The column name and element names are both case-insensitive.
  C. The column name is case-sensitive but element names are case-insensitive.
  D. The column name is case-insensitive but element names are case-sensitive.
  D. The column name is case-insensitive but element names are case-sensitive.

  ---

  Explanation

• Question 1049:

  What is the LEAST-PRIVILEGED role that can create a share in Snowflake by default?

  A. SYSADMIN
  B. SECURITYADMIN
  C. USERADMIN
  D. ACCOUNTADMIN
  D. ACCOUNTADMIN

  ---

  Explanation

• Question 1050:

  A Snowflake user needs to share unstructured data from an internal stage to a reporting tool that does not have Snowflake access.

  Which file function should be used?

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

  ---

  Explanation