SnowPro Core COF-C03

SnowPro Core COF-C03 practice questions, page 5 of 5, with answer review and explanations.

Question 21

Which interface or service allow users to connect to Snowflake with Python? (Choose two.)

  1. Snowpark API
  2. Snowsight
  3. Streamlit in Snowflake
  4. AI_EXTRACT
  5. Snowflake CLI

Question 22

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?

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

Question 23

Which Snowflake feature can be used to identify tables, views, and columns that contain sensitive information by assigning and querying metadata?

  1. Tags
  2. External Tokens
  3. Row access policies
  4. Tag-based masking policies