Free SnowPro Core COF-C03 Exam Braindumps
SnowPro Core COF-C03 Questions 17–24 (page: 4)

Updated On: 9-Apr-2026

A user adds a new connection called [dev_project] to their config.toml file, which includes setting role = DEVELOPER.

Then the user runs this command: snowsql -c dev_project. When they run SELECT current_role(); inside the session, the query returns SYSADMIN.

Why did Snowflake CLI use the SYSADMIN role?

  1. SYSADMIN is the Engineer's default role and cannot be overridden by the config.toml file.
  2. The [dev_project] connection in the config.toml file was missing a warehouse parameter, which caused the CLI to ignore the role parameter.
  3. A SNOWFLAKE_ROLE environment variable was set to SYSADMIN, which takes precedence over the config.toml file.
  4. The config.toml file is used if the connection is also passed as a command-line flag, such as snowsql --role DEVELOPER.

Answer(s): C

Explanation:

Environment variables take precedence over configuration file settings, so if a role is defined via an environment variable, it overrides the role specified in the config.toml file.



A table is created with a column set to a data type of CHARACTER(25).

If the table is viewed in the database section of Snowsight, what data type will be shown for the column?

  1. STRING(25)
  2. TEXT(25)
  3. VARCHAR(25)
  4. CHARACTER(25)

Answer(s): C

Explanation:

Snowflake normalizes character string data types to VARCHAR, so CHARACTER(25) is displayed as VARCHAR(25) in Snowsight.



A user oversees a database with several large, frequently updated tables. They observe rising storage costs, mainly due to the Continuous Data Protection (CDP) features.

To reduce storage expenses while keeping data protection intact, which table type should they choose?

  1. Permanent
  2. Transient
  3. Temporary
  4. External

Answer(s): B

Explanation:

Transient tables retain Time Travel but do not include Fail-safe storage, reducing storage costs associated with continuous data protection while still maintaining a level of recoverability.



A large global company needs to maximize system availability in the event of a cloud provider failure that affects Snowflake services.

Which configuration will support this requirement?

  1. Scheduled database downloads to cloud storage.
  2. A failover group to a separate region and cloud provider.
  3. Account replication within the same region and cloud provider.
  4. Scheduled database cloning maintained in the Snowflake account.

Answer(s): B

Explanation:

Failover groups enable cross-region and cross-cloud replication and failover, providing resilience against cloud provider outages by allowing workloads to continue in a different region and provider.



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

Answer(s): A,E

Explanation:

The Snowpark API enables developers to write and run Python code directly within Snowflake, while the Snowflake CLI supports executing Python-based workflows and scripts to interact with Snowflake programmatically.



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.

Answer(s): C

Explanation:

This view provides detailed lineage and access information, including which users, queries, and downstream objects accessed specific tables and columns, enabling accurate impact analysis before making structural changes.



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

Answer(s): A

Explanation:

Tags allow assigning metadata to Snowflake objects such as tables, views, and columns, enabling classification of sensitive data and making it possible to query and track those classifications across the environment.



Which feature uses a Snowflake key with a customer-managed key to protect data?

  1. Trust Center
  2. Tri-Secret Secure
  3. Key-pair authentication
  4. Multi-Factor Authentication (MFA)

Answer(s): B

Explanation:

This feature combines a Snowflake-managed key with a customer-managed key to encrypt data, ensuring that both keys are required to access the data for enhanced security control.



Viewing page 4 of 14
Viewing questions 25 - 32 out of 100 questions


Post your Comments and Discuss Snowflake SnowPro Core COF-C03 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!