Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1541:

  When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

  A. Concurrency
  B. Performance
  A. Concurrency

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

• Question 1542:

  What will be the retention period for an object if the parameter MIN_DATA_RETENTION_TIME_IN_DAYS is set at the account level and the DATA_RETENTION_TIME_IN_DAYS is set at the object level?

  A. The retention period will be equal to the value of the parameter MIN_DATA_RETENTION_TIME_IN_DAYS set at the account level.
  B. The retention period will be equal to the value of the parameter DATA_RETENTION_TIME_IN_DAYS set at the object level.
  C. The retention period will be equal to the greatest of the two values of parameters DATA_RETENTION_TIME_IN_DAYS set at the object level, and MIN_DATA_RETENTION_TIME_IN_DAYS set at the account level.
  D. The retention period will be equal to the lesser of the two values of parameters DATA_RETENTION_TIME_IN_DAYS set at the object level and MIN_DATA_RETENTION_TIME_IN_DAYS set at the account level.
  D. The retention period will be equal to the lesser of the two values of parameters DATA_RETENTION_TIME_IN_DAYS set at the object level and MIN_DATA_RETENTION_TIME_IN_DAYS set at the account level.

  ---

  Explanation

• Question 1543:

  What actions will prevent leveraging of the ResultSet cache? (Choose two.)

  A. Removing a column from the query SELECT list
  B. Stopping the virtual warehouse that the query is running against
  C. Clustering of the data used by the query
  D. Executing the RESULTS_SCAN() table function
  E. Changing a column that is not in the cached query
  A. Removing a column from the query SELECT list
  C. Clustering of the data used by the query

  ---

  Explanation

• Question 1544:

  Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):

  A. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
  B. SECURITYADMIN ACCOUNTADMIN, SYSADMIN
  C. SECURITYADMIN, ACCOUNTADMIN
  D. ACCOUNTADMIN
  D. ACCOUNTADMIN

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/security-mfa.html

• Question 1545:

  A Snowflake account is charged for data stored in both Internal and External Stages.

  A. True
  B. False
  B. False

  ---

  Explanation

• Question 1546:

  A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned.

  How should this query be optimized?

  A. Create a view on the table.
  B. Add a clustering key to the table.
  C. Add a LIMIT clause to the query.
  D. Add a Dynamic Data Masking policy to the table.
  B. Add a clustering key to the table.

  ---

  Explanation

• Question 1547:

  What function, combined with the copy command, should be used to unload data from a relational table into a JSON file?

  A. LATERAL
  B. CAST
  C. FLATTEN
  D. OBJECT_CONSTRUCT
  D. OBJECT_CONSTRUCT

  ---

  Explanation

• Question 1548:

  Which of the following statements apply to Snowflake in terms of security? (Choose two.)

  A. Snowflake leverages a Role-Based Access Control (RBAC) model.
  B. Snowflake requires a user to configure an IAM user to connect to the database.
  C. All data in Snowflake is encrypted.
  D. Snowflake can run within a user's own Virtual Private Cloud (VPC).
  E. All data in Snowflake is compressed.
  A. Snowflake leverages a Role-Based Access Control (RBAC) model.
  C. All data in Snowflake is encrypted.

  ---

  Explanation

• Question 1549:

  How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

  A. The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.
  B. The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.
  C. The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.
  D. The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.
  D. The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

  ---

  Explanation

• Question 1550:

  What is the MINIMUM Snowflake edition required to use the query acceleration service?

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

  ---

  Explanation

  The Query Acceleration Service is available starting with the Enterprise Edition of Snowflake.

  This feature provides additional compute resources to accelerate query execution without manual scaling.

  References:

  Snowflake Documentation: Query Acceleration Service Snowflake Editions Overview