The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

In the metadata of the pipe for 64 days

In the metadata of the target table for 14 days

In the metadata of the pipe for 14 days

In the metadata of the target table for 64 days

In the metadata of the pipe for 64 days

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.How does Snowflake recommend maximizing the load performance?

Produce the largest files possible, reducing the overall number of files to process.

Use auto-ingest Snowpipes to load large files in a serverless model.

Produce the largest files possible, reducing the overall number of files to process.

Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.

Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

The columns most actively used in the select filters.

The columns that are queried in the select clause.

The columns with very high cardinality.

The columns with many different values.

The columns most actively used in the select filters.

What privilege should a user be granted to change permissions for new objects in a managed access schema?

Grant the MANAGE GRANTS global privilege.

Grant the OWNERSHIP privilege on the schema.

Grant the OWNERSHIP privilege on the database.

Grant the MANAGE GRANTS global privilege.

Grant ALL privileges on the schema.

A materialized view should be created when which of the following occurs? (Choose two.)

The query consumes many compute resources every time it runs.

The results of the query do not change often and are used frequently.

There is minimal cost associated with running the query.

The query consumes many compute resources every time it runs.

The base table gets updated frequently.

The query is highly optimized and does not consume many compute resources.

The results of the query do not change often and are used frequently.

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

SELECT on tables used by the secure view

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.

Snowflake SnowPro Core Practice Test 7 - Free Online Exam Questions 241-280

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.

Which command will show all privileges granted to that schema?

Become a Premium Member for full access

Unlock Premium Member

Snowflake SnowPro Core Practice Test 7

Question

Snowflake SnowPro Core Practice Tests

Practice Tests