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?
Answer(s): C
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?
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?
Answer(s): B
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?
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.)
Answer(s): A,E
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?
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?
Answer(s): A
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?
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.
Post your Comments and Discuss Snowflake SnowPro Core COF-C03 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the SnowPro Core COF-C03 content, but please register or login to continue.