Free SnowPro Core Certification Exam COF-C02 Exam Practice Test

When should a multi-cluster warehouse be used in auto-scaling mode?

• When it is unknown how much compute power is needed
• If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
• If the runtime of the executed query is very slow
• When a large number of concurrent queries are run on the same warehouse

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

• USAGE
• OPERATE
• MONITOR
• MODIFY

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.How can this requirement be met?

• Use data encryption.
• Use dynamic data masking.
• Use secure materialized views.
• Revoke all roles for functional managers and end users.

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

• Informatica
• Power Bl
• Adobe
• Data Robot

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

• Optimizes the virtual warehouse size and multi-cluster setting to economy mode
• Allows a user to import the files in a sequential order
• Increases the latency staging and accuracy when loading the data
• Allows optimization of parallel operations

What is a limitation of a Materialized View?

• A Materialized View cannot support any aggregate functions
• A Materialized View can only reference up to two tables
• A Materialized View cannot be joined with other tables
• A Materialized View cannot be defined with a JOIN

Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?

• Authy
• Duo Security
• One Login
• RSA SecurlD Access

What does Snowflake recommend regarding database object ownership? (Select TWO).

• Create objects with ACCOUNTADMIN and do not reassign ownership.
• Create objects with SYSADMIN.
• Create objects with SECURITYADMIN to ease granting of privileges later.
• Create objects with a custom role and grant this role to SYSADMIN.
• Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.

Which Snowflake partner specializes in data catalog solutions?

• Alation
• DataRobot
• dbt
• Tableau

By default, which Snowflake role is required to create a share?

• ORGADMIN
• SECURITYADMIN
• SHAREADMIN
• ACCOUNTADMIN