Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1191:

  Which SQL command can be used to verify the privileges that are granted to a role?

  A. SHOW GRANTS ON ROLE
  B. SHOW ROLES
  C. SHOW GRANTS TO ROLE
  D. SHOW GRANTS FOR ROLE
  C. SHOW GRANTS TO ROLE

  ---

  Explanation

• Question 1192:

  For Directory tables, what stage allows for automatic refreshing of metadata?

  A. User stage
  B. Table stage
  C. Named internal stage
  D. Named external stage
  D. Named external stage

  ---

  Explanation

• Question 1193:

  Which statistics on a Query Profile reflect the efficiency of the query pruning? (Choose two.)

  A. Partitions scanned
  B. Partitions total
  C. Bytes scanned
  D. Bytes spilled
  E. Bytes written
  A. Partitions scanned
  B. Partitions total

  ---

  Explanation

• Question 1194:

  Which Snowflake tool is recommended for data batch processing?

  A. SnowCD
  B. SnowSQL
  C. Snowsight
  D. The Snowflake API
  B. SnowSQL

  ---

  Explanation

• Question 1195:

  Snowflake Partner Connect is limited to users with a verified email address and which role?

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

  ---

  Explanation

• Question 1196:

  What are common issues found by using the Query Profile? (Choose two.)

  A. Identifying queries that will likely run very slowly before executing them
  B. Locating queries that consume a high amount of credits
  C. Identifying logical issues with the queries
  D. Identifying inefficient micro-partition pruning
  E. Data spilling to a local or remote disk
  D. Identifying inefficient micro-partition pruning
  E. Data spilling to a local or remote disk

  ---

  Explanation

• Question 1197:

  Which stage type is used for loading data from files that are stored outside of Snowflake?

  A. Internal named
  B. External named
  C. User
  D. Table
  B. External named

  ---

  Explanation

• Question 1198:

  Which object types are protected by Fail-safe? (Choose two.)

  A. Permanent Tables
  B. Temporary Tables
  C. External Tables
  D. Materialized Views
  E. Transient Tables
  A. Permanent Tables
  D. Materialized Views

  ---

  Explanation

• Question 1199:

  A table named car_sales contains a single VARIANT column named src. Below is the output of the query SELECT * FROM car_sales;

  

  Which queries will return the element "phone number" from the data? (Choose two.)

  A. SELECT src:customer.'phone number' FROM car_sales;
  B. SELECT SRC:customer."phone number" FROM car_sales;
  C. SELECT src:customer."phone number" FROM car_sales;
  D. SELECT SRC:customer.phone number FROM car_sales;
  E. SELECT SRC:CUSTOMER."phone number" FROM car_sales;
  C. SELECT src:customer."phone number" FROM car_sales;
  E. SELECT SRC:CUSTOMER."phone number" FROM car_sales;

  ---

  Explanation

• Question 1200:

  A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

  A. SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS;
  B. SELECT EVENT_TIMESTAMP, USER_NAME FROM table(information_schema.login_history_by_user())
  C. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY;
  D. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;
  D. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;

  ---

  Explanation