Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1121:

  Which command should be used to drop files from an internal or external stage?

  A. DELETE
  B. DROP
  C. REMOVE
  D. TRUNCATE
  B. DROP

  ---

  Explanation

• Question 1122:

  A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.

  Which Snowflake feature will support this?

  A. Row access policies
  B. Data masking policies
  C. Data encryption
  D. Role based access control
  B. Data masking policies

  ---

  Explanation

• Question 1123:

  Which Snowflake feature or service is primarily used for managing and monitoring data and user activities?

  A. Snowsight
  B. SnowSQL
  C. Snowflake Marketplace
  D. Streamlit
  A. Snowsight

  ---

  Explanation

  Snowsight is Snowflake's web-based interface used for managing and monitoring data, query performance, and user activities.

  It provides detailed analytics and dashboards to track usage, monitor query execution, and review account activity for governance and optimization. Example: Administrators use Snowsight to track user sessions, queries, and compute

  resource utilization.

  References:

  Snowflake Documentation: Snowsight Overview

  Snowsight Usage Monitoring

• Question 1124:

  What are the recommended alternative data types in Snowflake for unsupported large object data types such as BLOB and CLOB? (Select TWO).

  A. VARIANT
  B. ARRAY
  C. BINARY
  D. OBJECT
  E. VARCHAR
  C. BINARY
  E. VARCHAR

  ---

  Explanation

  Snowflake does not support traditional large object data types like BLOB (Binary Large Object) and CLOB (Character Large Object).

  Recommended alternatives:

  References:

  Snowflake Documentation: Data Types

• Question 1125:

  Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

  A. ROLES
  B. POLICY_REFERENCES
  C. QUERY_HISTORY
  D. RESOURCE_MONIT ORS
  E. ACCESS_HISTORY
  F. MASKING_POLICIES
  B. POLICY_REFERENCES
  F. MASKING_POLICIES

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/security-column-ddm-intro.html#:~:text=DESCRIBE%20MASKING%20POLICY-,Auditing%20Dynamic%20Data% 20Masking,a%20masking%20policy%20is%20set.

• Question 1126:

  While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).

  A. GET
  B. CREATE STAGE
  C. PUT
  D. COPY INTO
  E. CREATE PIPE
  B. CREATE STAGE
  D. COPY INTO

  ---

  Explanation

  The file format option in Snowflake can be specified in the following commands:

  CREATE STAGE: This command allows users to define the file format when creating a stage, which applies to any data loaded or unloaded via that stage. COPY INTO : This command enables data export from a table to an

  external location, where the file format can be specified to ensure the data is structured as needed for downstream systems.

  Other commands, such as PUT or GET, do not support the specification of file formats directly within the command syntax.

• Question 1127:

  Which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

  A. BUILD_STAGE_FILE_URL
  B. GET_ABSOLUTE_PATH
  C. GET_RELATIVE_PATH
  D. GET_STAGE_LOCATION
  A. BUILD_STAGE_FILE_URL

  ---

  Explanation

• Question 1128:

  Masking policies are created at what level in Snowflake?

  A. Table
  B. Column
  C. Schema
  D. Database
  B. Column

  ---

  Explanation

• Question 1129:

  Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?

  A. Column compression
  B. Data clustering
  C. Micro-partitioning
  D. Metadata management
  D. Metadata management

  ---

  Explanation

• Question 1130:

  Snowflake provides a mechanism for its customers to override its clustering algorithms. This method is:

  A. Micro-partitions
  B. Clustering keys
  C. Key partitions
  D. Clustered partitions
  B. Clustering keys

  ---

  Explanation

  https://community.snowflake.com/s/article/Snowflake-What-the-Cluster