Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1071:

  What type of function returns one value for each invocation?

  A. Aggregate
  B. Scalar
  C. Table
  D. Window
  B. Scalar

  ---

  Explanation

  https://docs.snowflake.com/en/sql-reference/functions

• Question 1072:

  What are characteristics of Secure Data Sharing? (Select TWO)

  A. It allows regular views to be shared.
  B. Sensitive data is automatically masked.
  C. Data is not transferred between accounts.
  D. A consumer account will incur compute costs.
  E. Source data can be edited by users with reader accounts.
  C. Data is not transferred between accounts.
  D. A consumer account will incur compute costs.

  ---

  Explanation

• Question 1073:

  What is the purpose of the use of the VALIDATE command?

  A. To view any queries that encountered an error
  B. To verify that a SELECT query will run without error
  C. To prevent a PUT statement from running if an error occurs
  D. To see all errors from a previously run COPY INTO statement
  D. To see all errors from a previously run COPY INTO statement

  ---

  Explanation

• Question 1074:

  What is the MINIMUM Snowftake edition that supports database replication?

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

  ---

  Explanation

  The minimum Snowflake edition that supports database replication is the Enterprise edition. Database replication allows data to be replicated between different Snowflake accounts or regions, providing high availability and disaster recovery capabilities.

  Snowflake Documentation: Database Replication

• Question 1075:

  Which is a best practice recommendation when planning to load data into a table?

  A. Use the largest size virtual warehouse allowed to maximize the available threads for uploading files.
  B. Dedicate separate virtual warehouses for loading operations and querying operations.
  C. Use different stages to store files, identifying data source identifiers.
  D. Upload files that are equal to or larger than 100 GB each.
  B. Dedicate separate virtual warehouses for loading operations and querying operations.

  ---

  Explanation

  Snowflake recommends using separate virtual warehouses for loading and querying to avoid resource contention.

  This ensures that querying operations are not delayed by resource-intensive loading tasks.

  References:

  Snowflake Documentation: Best Practices for Data Loading Snowflake Virtual Warehouse Management

• Question 1076:

  How can a data provider ensure that a data consumer is going to have access to the required objects?

  A. Enable the data sharing feature in the account and validate the view.
  B. Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.
  C. Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.
  D. Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.
  A. Enable the data sharing feature in the account and validate the view.

  ---

  Explanation

• Question 1077:

  What virtual warehouse feature or setting will reduce the performance impact when running larger-than-average queries, by offloading portions of the query processing work to shared compute resources?

  A. Using a multi-cluster virtual warehouse
  B. Using the query acceleration service
  C. Using the search optimization service
  D. Disabling auto-suspend
  B. Using the query acceleration service

  ---

  Explanation

  The Query Acceleration Service offloads portions of query processing to shared compute resources to handle larger-than-average queries without impacting virtual warehouse performance.

  This feature is ideal for resource-intensive queries and operates independently of virtual warehouse scaling.

  References:

  Snowflake Documentation: Query Acceleration Service Snowflake Performance Optimization

• Question 1078:

  Which command should a Snowflake user execute to load data into a table?

  A. copy into mytable purge_mode = TRUE;
  B. copy into mytable from @my_int_stage;
  C. copy into mytable file_format = (format_name);
  D. copy into mytable validation = `RETURN_ERRORS';
  B. copy into mytable from @my_int_stage;

  ---

  Explanation

• Question 1079:

  The use of which Snowflake table type will reduce costs when working with ETL workflows?

  A. External
  B. Permanent
  C. Temporary
  D. Transient
  C. Temporary

  ---

  Explanation

• Question 1080:

  Who can access a referenced file through a scoped URL?

  A. Only the ACCOUNTADMIN
  B. Only the user who generates the URL
  C. Any role specified in the GET REST API call with sufficient privileges
  D. Any user specified in the GET REST API call with sufficient privileges
  B. Only the user who generates the URL

  ---

  Explanation

  Scoped URL Only the user who generated the scoped URL can use the URL to access the referenced file. File URL Any role that has sufficient privileges on the stage can access the file: External stage: USAGE Internal stage: READ