What is a characteristic of the Snowflake Query Profile?

It provides a graphic representation of the main components of the query processing.

It can provide statistics on a maximum number of 100 queries per week.

It provides a graphic representation of the main components of the query processing.

It provides detailed statistics about which queries are using the greatest number of compute resources.

It can be used by third-party software using the Query Profile API.

What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).

Bytes spilled to local storage.

Bytes spilled to remote storage.

Bytes spilled to remote metastore.

Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?

select * from directory(@bronzestage);

select metadata$filename from @bronzestage;

select * from table(information_schema.stage_directory_file_registration_history( stage name=>'bronzestage1));

When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?

When using a paid listing on the Snowflake Marketplace

When using a private listing on the Snowflake Marketplace

When using a personalized listing on the Snowflake Marketplace

When using a Direct Share with another account

What are benefits of using Snowpark with Snowflake? (Select TWO).

Snowpark does not require that a separate cluster be running outside of Snowflake.

Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

Snowpark uses a Spark engine to generate optimized SQL query plans.

Snowpark automatically sets up Spark within Snowflake virtual warehouses.

Snowpark does not require that a separate cluster be running outside of Snowflake.

Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

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

A user with a SECURITYADMIN or higher role

A role that has the ownership of the network policy

A user with an USERADMIN or higher role

A user with a SECURITYADMIN or higher role

A role that has been granted the ATTACH POLICY privilege

A role that has the NETWORK_POLlCY account parameter set

A role that has the ownership of the network policy

A permanent table and temporary table have the same name, TBL1, in a schema.What will happen if a user executes select * from TBL1 ;?

The temporary table will take precedence over the permanent table.

The permanent table will take precedence over the temporary table.

An error will say there cannot be two tables with the same name in a schema.

The table that was created most recently will take precedence over the older table.

What will prevent unauthorized access to a Snowflake account from an unknown source?

Multi-Factor Authentication (MFA)

Role-Based Access Control (RBAC)

What is the purpose of a Query Profile?

To profile a particular query to understand the mechanics of the query, its behavior, and performance.

To profile how many times a particular query was executed and analyze its u^age statistics over time.

To profile a particular query to understand the mechanics of the query, its behavior, and performance.

To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.

To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.

What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?

Virtual Private Snowflake Edition

Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Select TWO).

Bytes spilled to remote storage

How can a Snowflake user validate data that is unloaded using the COPY INTO <location> command?

Use the VALlDATlON_MODE - SQL statement.

Load the data into a relational table.

Use the VALlDATlON_MODE - SQL statement.

Use the validation mode = return rows statement.

What tasks can an account administrator perform in the Data Exchange? (Select TWO).

Approve and deny listing approval requests.

Transfer ownership of a provider profile.

What is a directory table in Snowflake?

An object layered on a stage that is used to store file-level metadata

A separate database object that is used to store file-level metadata

An object layered on a stage that is used to store file-level metadata

A database object with grantable privileges for unstructured data tasks

A Snowflake table specifically designed for storing unstructured files

Which Snowflake command can be used to unload the result of a query to a single file?

Use COPY INTO <internal stage> with SINGLE = TRUE followed by a GET command to download the file.

Use COPY INTO <external stage> followed by a GET command to download the file.

Use COPY INTO <internal stage> followed by a put command to download the file.

Use COPY INTO <internal stage> with SINGLE = TRUE followed by a GET command to download the file.

Use COPY INTO <external stage> with SINGLE = TRUE followed by a PUT command to download the file.

What factors impact storage costs in Snowflake? (Select TWO).

The cloud region used by the account

Snowflake COF-C02 Practice Test 9 - Free Online Exam Prep & Questions

What column type does a Kafka connector store formatted information in a single column?

Become a Premium Member for full access

Unlock Premium Member

Snowflake COF-C02 Practice Test 9

Question

Snowflake COF-C02 Practice Tests

Practice Tests