Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1241:

  What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

  A. Business Critical Edition
  B. Standard Edition
  C. Virtual Private Snowflake (VPS)
  D. Enterprise Edition
  B. Standard Edition

  ---

  Explanation

• Question 1242:

  Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

  A. CREATE_SHARE on the account
  B. SHARE on databases and schemas
  C. SELECT on tables used by the secure view
  D. REFERENCE_USAGE on databases
  D. REFERENCE_USAGE on databases

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html

• Question 1243:

  What does the Remote Disk I/O statistic in the Query Profile indicate?

  A. Time spent reading from the result cache.
  B. Time spent reading from the virtual warehouse cache.
  C. Time when the query processing was blocked by remote disk access.
  D. The level of network activity between the Cloud Services layer and the virtual warehouse.
  C. Time when the query processing was blocked by remote disk access.

  ---

  Explanation

  The Remote Disk I/O statistic in the Query Profile reflects time spent waiting on remote disk access, which can occur when data needs to be retrieved from external storage (remote). This metric is crucial for identifying bottlenecks related to I/ O delays, often suggesting a need for performance optimization in data retrieval paths. The other options relate to caching and network activity, but Remote Disk I/O specifically measures the wait time for data access from remote storage locations.

• Question 1244:

  Which command allows a user to unload data from a Snowflake database table into one or more files in a Snowflake or external stage?

  A. GET
  B. LIST
  C. PUT
  D. COPY INTO
  D. COPY INTO

  ---

  Explanation

  The COPY INTO command is used to unload data from a Snowflake table into a Snowflake or external stage.

  Syntax Example:

  COPY INTO 's3://mybucket/'

  FROM my_table

  FILE_FORMAT = (TYPE = CSV);

  References:

  Snowflake Documentation: COPY INTO

  Snowflake Data Unloading Best Practices

• Question 1245:

  What is the purpose of the STRIP_NULL_VALUES file format option when loading semi-structured data files into Snowflake?

  A. It removes null values from all columns in the data.
  B. It converts null values to empty strings during loading.
  C. It skips rows with null values during the loading process.
  D. It removes object or array elements containing null values.
  D. It removes object or array elements containing null values.

  ---

  Explanation

• Question 1246:

  How would a user run a multi-cluster warehouse in maximized mode?

  A. Configure the maximum clusters setting to "Maximum."
  B. Turn on the additional clusters manually after starting the warehouse.
  C. Set the minimum Clusters and maximum Clusters settings to the same value.
  D. Set the minimum clusters and maximum clusters settings to different values.
  C. Set the minimum Clusters and maximum Clusters settings to the same value.

  ---

  Explanation

• Question 1247:

  What is a characteristic of the Snowflake query profiler?

  A. It can provide statistics on a maximum number of 100 queries per week.
  B. It provides a graphic representation of the main components of the query processing.
  C. It provides detailed statistics about which queries are using the greatest number of compute resources.
  D. It can be used by third-party software using the query profiler API.
  B. It provides a graphic representation of the main components of the query processing.

  ---

  Explanation

• Question 1248:

  If a virtual warehouse is suspended, what happens lo the warehouse cache?

  A. The cache is dropped when the warehouse is suspended and is no longer available upon restart.
  B. The warehouse cache persists for as long the warehouse exists, regardless of its suspension status.
  C. The cache is maintained for up to two hours and can be restored If the warehouse Is restarted within this limit.
  D. The cache is maintained for the auto suspend duration and can be restored it the warehouse 15 restarted within this limit.
  A. The cache is dropped when the warehouse is suspended and is no longer available upon restart.

  ---

  Explanation

• Question 1249:

  What is the primary purpose of using a masking policy in Snowflake?

  A. To protect sensitive data from unauthorized access when queries are run.
  B. To automatically encrypt sensitive data when data is stored in Snowflake.
  C. To protect multiple columns that have different data types in a given table.
  D. To protect both column-level and row-level data.
  A. To protect sensitive data from unauthorized access when queries are run.

  ---

  Explanation

  Masking policies in Snowflake are designed to protect sensitive information by dynamically hiding or obfuscating data based on the role of the user executing the query. This helps enforce data privacy and security by allowing only authorized users to see sensitive information. Masking policies do not encrypt data but apply rules to limit data visibility, ensuring sensitive data is protected during query execution without altering the underlying data.

• Question 1250:

  Which database objects can be shared using Secure Data Sharing? (Select TWO).

  A. Users
  B. Roles
  C. Stages
  D. Tables
  E. Dynamic tables
  A. Users
  D. Tables

  ---

  Explanation