Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 751:

  What happens to foreign key constraints when a table is cloned to another database?

  A. All referenced tables will be cloned.
  B. The cloned table will reference the primary key in the source table
  C. The cloned table will lose all references to the primary key.
  D. The cloned table will lose all references to the foreign and primary keys.
  D. The cloned table will lose all references to the foreign and primary keys.

  ---

  Explanation

  When a table is cloned in Snowflake, it creates a duplicate of the table's data and metadata. However, foreign key constraints and primary key references are not retained in the cloned table.

  This behavior is because Snowflake treats constraints as informational and does not enforce them during query execution.

  As a result, the cloned table will lose all references to both foreign and primary keys.

  Why Other Options Are Incorrect:

  A. All referenced tables will be cloned: Only the specific table is cloned, not its referenced tables.

  B. The cloned table will reference the primary key in the source table: References to primary keys are lost during cloning.

  C. The cloned table will lose all references to the primary key: While correct for primary keys, this does not account for foreign keys, making it incomplete.

  References:

  Cloning Tables in Snowflake

• Question 752:

  In which Snowsight section can a user switch roles, modify their profile, and access documentation?

  A. The user menu
  B. The activity page
  C. The content pane
  D. The worksheets page
  A. The user menu

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/ui-snowsight-quick-tour#user-menu

• Question 753:

  What activities can be monitored by a user directly from Snowsight's Activity tab without using the Account_Usage views? (Choose two.)

  A. Login history
  B. Query history
  C. Copy history
  D. Event usage history
  E. Virtual warehouse metering history
  B. Query history
  C. Copy history

  ---

  Explanation

• Question 754:

  Which service or tool is a Command Line Interface (CLI) client used for connecting to Snowflake to execute SQL queries?

  A. Snowsight
  B. SnowCD
  C. Snowpark
  D. SnowSQL
  D. SnowSQL

  ---

  Explanation

• Question 755:

  How long can a data consumer who has a pre-signed URL access data files using Snowflake?

  A. Indefinitely
  B. Until the result_cache expires
  C. Until the retention_time is met
  D. Until the expiration_time is exceeded
  D. Until the expiration_time is exceeded

  ---

  Explanation

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

• Question 756:

  What Snowflake features are recommended to restrict unauthorized users from accessing Personal Identifiable Information (PII)? (Select TWO).

  A. Dynamic Data Masking
  B. Transient tables
  C. Secure views
  D. Multi-Factor Authentication (MFA)
  E. Data encryption
  A. Dynamic Data Masking
  C. Secure views

  ---

  Explanation

• Question 757:

  What does Snowflake recommend for a user assigned the ACCOUNTADMIN role?

  A. The ACCCUKTMKIN role should be set as tie user's default role.
  B. The user should use federated authentication instead of a password
  C. The user should be required to use Multi-Factor Authentication (MFA).
  D. There should be just one user with the ACCOUNTADMIN role in each Snowflake account.
  C. The user should be required to use Multi-Factor Authentication (MFA).

  ---

  Explanation

• Question 758:

  Which features can be used with the Snowflake Standard edition? (Choose two.)

  A. Materialized views
  B. External functions
  C. Multi-cluster virtual warehouses
  D. Fail-safe
  E. Row-level security
  A. Materialized views
  D. Fail-safe

  ---

  Explanation

• Question 759:

  How many resource monitors can be assigned at the account level?

  A. 1
  B. 2
  C. 3
  D. 4
  A. 1

  ---

  Explanation

• Question 760:

  An organization is preparing for a data structure change on a critical table, SALES_BUDGET, and needs to identify which users, dashboards, reports and processes might be affected. What action should be performed to determine the impact of this change?

  A. Create a stream on SALES_BUDGET and check for inserted or updated rows to identify the users responsible for data access.
  B. Use SHOW GRANTS ON SALES_BUDGET to see which roles or users accessed the table and track their query frequency.
  C. Query SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY to see who accessed the SALES_BUDGET table and what columns were read.
  D. Review TABLE_STORAGE_METRICS in the INFORMATION_SCHEMA to estimate read-frequency based on the table size and compression changes.
  C. Query SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY to see who accessed the SALES_BUDGET table and what columns were read.

  ---

  Explanation