Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1681:

  There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production.

  How can data be easily transferred from the production account to the non-production account?

  A. Clone the data from the production account to the non-production account.
  B. Create a data share from the production account to the non-production account.
  C. Create a subscription in the production account and have it publish to the non-production account.
  D. Create a reader account using the production account and link the reader account to the non-production account.
  B. Create a data share from the production account to the non-production account.

  ---

  Explanation

• Question 1682:

  When unloading Snowflake relational data to a Parquet le format, why should the PARTITION BY clause be used?

  A. It will provide a mechanism to encrypt each micro-partition with a unique key.
  B. It will guarantee data integrity by splitting the data into smaller, manageable chunks.
  C. It will increase storage e ciency by automatically compressing data based on access patterns.
  D. It will optimize query performance by ltering relevant partitions without scanning the entire dataset.
  D. It will optimize query performance by ltering relevant partitions without scanning the entire dataset.

  ---

  Explanation

• Question 1683:

  Which role has the ability to create and manage users and roles?

  A. ORGADMIN
  B. USERADMIN
  C. SYSADMIN
  D. SECURITYADMIN
  B. USERADMIN

  ---

  Explanation

• Question 1684:

  What ensures that a user with the role SECURITYADMIN can activate a network policy for an individual user?

  A. A role that has been granted the EXECUTE TASK privilege
  B. A role that has been granted the global ATTACH POLICY privilege
  C. Ownership privilege on only the role that created the network policy
  D. Ownership privilege on both the user and the network policy
  D. Ownership privilege on both the user and the network policy

  ---

  Explanation

• Question 1685:

  A user needs to know this information about an object:

  1.Who accessed the data?

  2.When was the data accessed?

  3.What columns were accessed?

  Which ACCOUNT_USAGE schema view should be used?

  A. QUERY_HISTORY
  B. ACCESS_HISTORY
  C. EVENT_USAGE_HISTORY
  D. OBJECT_DEPENDENCIES
  B. ACCESS_HISTORY

  ---

  Explanation

• Question 1686:

  Which parameters can be used together to ensure that a virtual warehouse never has a backlog of queued SQL statements? (Select TWO).

  A. STATEMENT_QUEUED_TIME0UT_IN_SECONDS
  B. STATEMENT_TIMEOUT_IN_SECONDS
  C. DATA_RETENTION_TIME_IN_DAYS
  D. MAX_CONCURRENCY_LEVEL
  E. MAX DATA EXTENSION TIME IN DAYS
  A. STATEMENT_QUEUED_TIME0UT_IN_SECONDS
  D. MAX_CONCURRENCY_LEVEL

  ---

  Explanation

  To prevent backlogs of queued SQL statements: Why Other Options Are Incorrect:

  B. STATEMENT_TIMEOUT_IN_SECONDS: Defines the total execution time for queries, not queuing behavior.

  C. DATA_RETENTION_TIME_IN_DAYS: Related to table retention policies, not query concurrency.

  E. MAX_DATA_EXTENSION_TIME_IN_DAYS: Related to time travel, not query queuing.

  References:

  Managing Query Concurrency

• Question 1687:

  How is the hierarchy of database objects organized in Snowflake?

  A. A database consists of one or more schemas. A schema contains tables and views.
  B. A schema consists of one or more databases. A database contains tables and views.
  C. A schema consists of one or more databases. A database contains tables, views, and warehouses.
  D. A database consists of one of more schemas and warehouses. A schema contains tables and views.
  A. A database consists of one or more schemas. A schema contains tables and views.

  ---

  Explanation

• Question 1688:

  Which result shows efficient pruning?

  A. Partitions scanned is greater than partitions total.
  B. Partitions scanned is less than partitions total.
  C. Partitions scanned is equal to the partitions total.
  D. Partitions scanned is greater than or equal to the partitions total.
  B. Partitions scanned is less than partitions total.

  ---

  Explanation

• Question 1689:

  What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

  A. Standard
  B. Premier
  C. Enterprise
  D. Business Critical Edition
  C. Enterprise

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/intro-editions.html

• Question 1690:

  What impacts the credit consumption of maintaining a materialized view? (Choose two.)

  A. Whether or not it is also a secure view
  B. How often the underlying base table is queried
  C. How often the base table changes
  D. Whether the materialized view has a cluster key defined
  E. How often the materialized view is queried
  C. How often the base table changes
  D. Whether the materialized view has a cluster key defined

  ---

  Explanation