A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.What will occur?

No virtual warehouse will be used, data will be read from the result cache.

No virtual warehouse will be used, data will be read from the local disk cache.

The default virtual warehouse will be used to read all data.

The virtual warehouse that is defined at the session level will be used to read all data.

Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

A Data Exchange allows groups of accounts to share data privately among the accounts.

The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.

A Data Exchange allows groups of accounts to share data privately among the accounts.

A Data Exchange allows accounts to share data with third, non-Snowflake parties.

Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.

The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

Secure User-Defined Functions (UDFs)

Which of the following is the Snowflake Account_Usage.Metering_History view used for?

Gathering the hourly credit usage for an account

Compiling an account's average cloud services cost over the previous month

Summarizing the throughput of Snowpipe costs for an account

Calculating the funds left on an account's contract

Which statement describes pruning?

The filtering or disregarding of micro-partitions that are not needed to return a query.

The return of micro-partitions values that overlap with each other to reduce a query's runtime.

A service that is handled by the Snowflake Cloud Services layer to optimize caching.

The ability to allow the result of a query to be accessed as if it were a table.

How can a user change which columns are referenced in a view?

Recreate the view with the required changes

Modify the columns in the underlying table

Use the ALTER VIEW command to update the view

Recreate the view with the required changes

Materialize the view to perform the changes

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

grant SELECT on all tables in database DB1 to role MYROLE;

grant SELECT on future tables in database DB1 to role MYROLE;

What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

The shared objects become accessible.

The shared objects are transferred.

The shared objects become accessible.

The shared objects can be re-shared.

What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?

Convert the rows in a relational table lo a single VARIANT column and then unload the rows into a file.

Reorder the rows in a relational table and then unload the rows into a file

Convert the rows in a relational table lo a single VARIANT column and then unload the rows into a file.

Reorder the data columns according to a target table definition and then unload the rows into the table.

Convert the rows in a source file to a single variant column and then load the rows from the file to a variant table.

Which Snowflake object can be accessed in he FROM clause of a query, returning a set of rows having one or more columns?

A User-Defined Table Function (UDTF)

How can a data provider ensure that a data consumer is going to have access to the required objects?

Enable the data sharing feature in the account and validate the view.

Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.

Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.

Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.

How can a user improve the performance of a single large complex query in Snowflake?

Scale up the virtual warehouse.

Scale out the virtual warehouse.

Enable standard warehouse scaling.

Enable economy warehouse scaling.

A Snowflake user has been granted the create data EXCHANGE listing privilege with their role.Which tasks can this user now perform on the Data Exchange? (Select TWO).

Submit listings for approval/publishing.

Modify incoming listing access requests.

Submit listings for approval/publishing.

What can a Snowflake user do in the Admin area of Snowsight?

Write queries and execute them.

Provide an overview of the listings in the Snowflake Marketplace.

Connect to Snowflake partners to explore extended functionality.

How can a Snowflake user optimize query performance in Snowflake? (Select TWO).

Enable the search optimization service.

Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).

Multi-cluster virtual warehouses

What can a Snowflake user do with the information included in the details section of a Query Profile?

Determine the total duration of the query.

Determine the role of the user who ran the query.

Determine the source system that the queried table is from.

Determine if the query was on structured or semi-structured data.

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

Which feature allows a user the ability to control the organization of data in a micro-partition?

Range Partitioning

Search Optimization Service

Automatic Clustering

Horizontal Partitioning

Comment (0)

Snowflake COF-C02 Practice Test 7

Question

Snowflake COF-C02 Practice Tests

Practice Tests