SnowPro Core COF-C03

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

Question 16

The data retention time for a schema is set for 5 days, and the data retention time for the database that contains the schema is set for 10 days.Based on these settings, what would the default data retention time be for a permanent table created in the schema?

  1. 0 days
  2. 1 day
  3. 5 days
  4. 10 days

Question 17

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.

Question 18

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)

Question 19

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

Question 20

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.