COF-C02 Snowflake Exam Questions and Free Practice Test

Question 19

- (Topic 2)
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

A. The cloned views and the stored procedures will reference the cloned tables in the cloned database.

B. An error will occur, as views with qualified references cannot be cloned.

C. An error will occur, as stored objects cannot be cloned.

D. The stored procedures and views will refer to tables in the source database.

Correct Answer:A
When cloning a database containing stored procedures and regular views with fully qualified table references, the cloned views and stored procedures will reference the cloned tables in the cloned database (A). This ensures that the cloned database is a self-contained copy of the original, with all references pointing to objects within the same cloned database. References: SnowPro Core Certification cloning database stored procedures views

Question 20

- (Topic 6)
Which command will unload data from a table into an external stage?

A. PUT

B. INSERT

C. COPY INTO

D. GET

Correct Answer:C
In Snowflake, theCOPY INTO <location>command is used to unload (export) data from a Snowflake table to an external stage, such as an S3 bucket, Azure Blob Storage, or Google Cloud Storage. This command allows users to specify the format, file size, and other options for the data being unloaded, making it a flexible solution for exporting data from Snowflake to external storage solutions for further use or analysis.References:Snowflake Documentation on Data Unloading

Question 21

- (Topic 6)
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.

Correct Answer:C
For users assigned theACCOUNTADMINrole, Snowflake recommends enforcing Multi-Factor Authentication (MFA) to enhance security. TheACCOUNTADMIN role has extensive permissions, making it crucial to secure accounts held by such users against unauthorized access. MFA adds an additional layer of security by requiring a second form of verification beyond just the username and password, significantly reducing the risk of account compromise.References:Snowflake Security Best Practices

Question 22

- (Topic 6)
A Snowflake account administrator has set the resource monitors as shown in the diagram, with actions defined for each resource monitor as "Notify & Suspend Immediately".
What is the MAXIMUM limit of credits that Warehouse 2 can consume?

A. 1500

B. 3500

C. 5000

Correct Answer:B

Question 23

- (Topic 2)
Which statement is true about running tasks in Snowflake?

A. A task can be called using a CALL statement to run a set of predefined SQL commands.

B. A task allows a user to execute a single SQL statement/command using a predefined schedule.

C. A task allows a user to execute a set of SQL commands on a predefined schedule.

D. A task can be executed using a SELECT statement to run a predefined SQL command.

Correct Answer:B
In Snowflake, a task allows a user to execute a single SQL statement/command using a predefined schedule (B). Tasks are used to automate the execution of SQL statements at scheduled intervals.

Question 24

- (Topic 6)
Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?

A. Area chart

B. Box plot

C. Heat grid

D. Pie chart

Correct Answer:A
Snowsight, Snowflake's user interface for exploring, analyzing, and visualizing data, supports a variety of chart types for creating dashboards and visualizations. One of the supported chart types in Snowsight is the Area Chart (A). Area charts are useful for representing quantities over time and can be used to highlight volume change and rate of change, as well as to compare multiple quantities.
While Snowsight supports many types of visualizations to help users analyze their data effectively, including line charts, bar charts, and scatter plots, it's important to select the specific reference documentation or release notes for the most current list of supported chart types, as Snowflake continues to enhance and update Snowsight's capabilities.
As of the last update, Box plots (B), Heat grids (C), and Pie charts (D) are types of visualizations that may be supported in various analytics and visualization tools, but for the specific context of Snowsight's currently confirmed features, Area charts are a verified option for users to visualize their data.
Reference: Snowflake Documentation on Snowsight (https://docs.snowflake.com/en/user-
guide/ui-snowsight.html)

START COF-C02 EXAM