COF-C02 Practice Questions

Which categories are included in the execution time summary in a Query Profile? (Select TWO).

Which command can be used to list all network policies available in an account?

What should be considered when deciding to use a secure view? (Select TWO).

Which virtual warehouse consideration can help lower compute resource credit consumption?

A Snowflake user wants to optimize performance for a query that queries only a small number of rows in a table. The rows require significant processing. The data in the table does...

To use the overwrite option on insert, which privilege must be granted to the role?

A user needs to MINIMIZE the cost of large tables that are used to store transitory dat

What is the default access of a securable object until other access is granted?

What happens when a suspended virtual warehouse is resized in Snowflake?

How does Snowflake handle the data retention period for a table if a stream has not been consumed?

Which task is supported by the use of Access History in Snowflake?

Which feature of Snowflake's Continuous Data Protection (CDP) has associated costs?

What command is used to export or unload data from Snowflake?

Which of the following SQL statements will list the version of the drivers currently being used?

Which object type is granted permissions for reading a table?

When should a stored procedure be created with caller's rights?

Which function can be used with the copy into <location> statement to convent rows from a relational table to a single variant column, and to unload rows into a JSON file?

By default, which role can create resource monitors?

What happens to the privileges granted to Snowflake system-defined roles?

Which type of role can be granted to a share?

When unloading data with the COPY into <location> command, what is the purpose of the PARTITION BY <expression> parameter option?

What are potential impacts of storing non-native values like dates and timestamps in a variant column in Snowflake?

Which views are included in the data_sharing_usage schema? (Select TWO).

How does the Access_History view enhance overall data governance pertaining to read and write operations? (Select TWO).

Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?

Which function returns the URL of a stage using the stage name as the input?

When does a materialized view get suspended in Snowflake?

What does a table with a clustering depth of 1 mean in Snowflake?

Which Snowflake object contains all the information required to share a database?

Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?

Which Snowflake table type is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is dropped at the end of the session?

The property mins_to_bypass_network_policy is set at which level?

Which privilege is required on a virtual warehouse to abort any existing executing queries?

What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?

What does the Activity area of Snowsight allow users to do? (Select TWO).

When a Snowflake user loads CSV data from a stage, which copy into <table> command guideline should they follow?

In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?

Which Snowsight feature can be used to perform data manipulations and transformations using a programming language?

Who can activate a network policy for users in a Snowflake account? (Select TWO)

What is the MINIMUM size requirement when creating a Snowpark-optimized virtual warehouse?

Awarding a user which privileges on all virtual warehouses is equivalent to granting the user the global MANAGE WAREHOUSES privilege?

In Snowflake's data security framework, how does column-level security contribute to the protection of sensitive information? (Select TWO).

How can a user MINIMIZE Continuous Data Protection costs when using large, high-churn, dimension tables?

Which function can be used to convert semi-structured data into rows and columns?

How does Snowflake utilize clustering information to improve query performance?

How can staged files be removed during data loading once the files have loaded successfully?

What can be used to process unstructured data?

Which type of workload is recommended for Snowpark-optimized virtual warehouses?

What is the benefit of using the STRIP_OUTER_ARRAY parameter with the COPY INTO <table> command when loading data from a JSON file into a table?

A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned How should this query be optimized?