Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1151:

  Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

  A. USAGE
  B. OPERATE
  C. MONITOR
  D. MODIFY
  B. OPERATE

  ---

  Explanation

  https://community.snowflake.com/s/question/0D50Z00008yHYdqSAG/auto-resume-operate-warehouse-privilege

• Question 1152:

  Which Snowflake table objects can be shared with other accounts? (Choose two.)

  A. Temporary tables
  B. Permanent tables
  C. Transient tables
  D. External tables
  E. User-Defined Table Functions (UDTFs)
  B. Permanent tables
  D. External tables

  ---

  Explanation

• Question 1153:

  Which SQL command can be used to see the CREATE definition of a masking policy?

  A. SHOW MASKING POLICIES
  B. DESCRIBE MASKING POLICY
  C. GET_DDL
  D. LIST MASKING POLICIES
  C. GET_DDL

  ---

  Explanation

• Question 1154:

  How are privileges inherited in a role hierarchy in Snowflake?

  A. Privileges are inherited by any roles above that role in the hierarchy.
  B. Privileges are inherited by any roles at the same level in the hierarchy.
  C. Privileges are only inherited by the direct parent role in the hierarchy.
  D. Privileges are only inherited by the direct child role in the hierarchy.
  A. Privileges are inherited by any roles above that role in the hierarchy.

  ---

  Explanation

  The privileges associated with a role are inherited by any roles above that role in the hierarchy. Do not spam with wrong answer votes

• Question 1155:

  Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

  A. Standard
  B. Premium
  C. Enterprise
  D. Business Critical
  D. Business Critical

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/privatelink-azure.html

• Question 1156:

  Which object can be shared using Secure Data Sharing?

  A. Secure view
  B. Materialized view
  C. Externa! function
  D. User-Defined Function (UDF)
  A. Secure view

  ---

  Explanation

  Snowflake's Secure Data Sharing enables sharing of data objects (e.g., tables and secure views) with other Snowflake accounts without copying or transferring the data.

  Secure views are sharable because they enforce access control and prevent unauthorized access to underlying data.

  Why Other Options Are Incorrect:

  B. Materialized view: Materialized views cannot be shared via Secure Data Sharing.

  C. External function: External functions are not supported for Secure Data Sharing.

  D. User-Defined Function (UDF): UDFs cannot be shared.

  References: Secure Data Sharing

• Question 1157:

  Snowflake will return an error when a user attempts to share which object?

  A. Tables
  B. Secure views
  C. Standard views
  D. Secure materialized views
  C. Standard views

  ---

  Explanation

• Question 1158:

  Which typos of charts does Snowsight support? (Select TWO).

  A. Area charts
  B. Bar charts
  C. Column charts
  D. Radar charts
  E. Scorecards
  A. Area charts
  B. Bar charts

  ---

  Explanation

  Snowsight, Snowflake's user interface for executing and analyzing queries, supports various types of visualizations to help users understand their data better. Among the supported types, area charts and bar charts are two common options. Area charts are useful for representing quantities through the use of filled areas on the graph, often useful for showing volume changes over time. Bar charts, on the other hand, are versatile for comparing different groups or categories of data. Both chart types are integral to data analysis, enabling users to visualize trends, patterns, and differences in their data effectively.

  References: Snowflake Documentation on Snowsight Visualizations

• Question 1159:

  What are characteristics of Snowsight worksheets? (Choose two.)

  A. Worksheets can be grouped under folders, and a folder of folders.
  B. Each worksheet is a unique Snowflake session.
  C. Users are limited to running only one query on a worksheet.
  D. The Snowflake session ends when a user switches worksheets.
  E. Users can import worksheets and share them with other users.
  B. Each worksheet is a unique Snowflake session.
  E. Users can import worksheets and share them with other users.

  ---

  Explanation

• Question 1160:

  When an ACCOUNTADMIN gives a user a custom role, what privilege or privileges is the user granted by default?

  A. All privileges that have been granted to the ACCOUNTADMIN
  B. All privileges on objects allowed by the custom role
  C. Access to the PUBLIC role
  D. Access to all the objects owned by the USERADMIN role
  C. Access to the PUBLIC role

  ---

  Explanation