How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Configure the warehouse to a size larger than generally required

Set the minimum and maximum clusters to autoscale

Use the standard warehouse scaling policy

Use the economy warehouse scaling policy

Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

Force an immediate password change.

Set a default role for the user.

Configure the user to be initially disabled.

Force an immediate password change.

Set a default role for the user.

Set the number of minutes to unlock to 15 minutes.

Set the user's access to expire within a specified timeframe.

Which statement MOST accurately describes clustering in Snowflake?

Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.

Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

The clustering key must be included in the COPY command when loading data into Snowflake.

Clustering can be disabled within a Snowflake account.

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

The clone is created almost instantly.

The clone saves space by not duplicating storage.

The clone always stays in sync with the original table.

The clone has better query performance.

The clone is created almost instantly.

The clone will have time travel history from the original table.

The clone saves space by not duplicating storage.

Which of the following statements describes a schema in Snowflake?

A logical grouping of objects that belongs to a single database

A logical grouping of objects that belongs to multiple databases

A named Snowflake object that includes all the information required to share a database

A uniquely identified Snowflake account within a business entity

What is a responsibility of Snowflake's virtual warehouses?

Permanent storage of micro-partitions

Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

Authentication and access control

Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

The size of the virtual warehouse

The length of time the warehouse is running

The number of active users assigned to the warehouse

The size of the virtual warehouse

The length of time the warehouse is running

The duration of the queries that are executed

Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

Secure User-Defined Functions (UDFs)

How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

Which statement describes how Snowflake supports reader accounts?

A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

A reader account can consume data from the provider account that created it and combine it with its own data.

A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

Directory tables store data file metadata.

Directory tables do not have their own grantable privileges.

A directory table is a separate database object.

Directory tables store data file metadata.

A directory table will be automatically added to a stage.

Directory tables do not have their own grantable privileges.

Directory table data can not be refreshed manually.

How would a user run a multi-cluster warehouse in maximized mode?

Set the minimum Clusters and maximum Clusters settings to the same value.

Configure the maximum clusters setting to 'Maximum.'

Turn on the additional clusters manually after starting the warehouse.

Set the minimum Clusters and maximum Clusters settings to the same value.

Set the minimum clusters and maximum clusters settings to different values.

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

Information Schema -> TABLE_STORAGE_METRICS

Information Schema -> TABLE_HISTORY

Information Schema -> TABLE_FUNCTION

Information Schema -> TABLE_STORAGE_METRICS

How would a user execute a series of SQL statements using a task?

Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();

Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..

A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();

Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();

Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.

A user has a standard multi-cluster warehouse auto-scaling policy in place.Which condition will trigger a cluster to shut-down?

When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

What is cached during a query on a virtual warehouse?

The columns in the result set of the query

All columns in a micro-partition

Any columns accessed during the query

The columns in the result set of the query

All rows accessed during the query

Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

Running EXPLAIN and SHOW commands

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:1. Created a user called 'CONSUMER'2. Created a database to hold the share and an extra-small warehouse to query the data3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the shareBased on this configuration what is true of the reader account?

The reader account compute will be billed to the provider account.

The reader account will automatically use the Standard edition of Snowflake.

The reader account compute will be billed to the provider account.

The reader account can clone data the provider has shared, but cannot re-share it.

The reader account can create a copy of the shared data using CREATE TABLE AS...

Which of the following can be used when unloading data from Snowflake? (Choose two.)

The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

Use the ENCODING file format option to change the encoding from the default UTF-8.

The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

It does not return from the command until the warehouse has finished changing its size.

The warehouse size does not change until all queries currently running in the warehouse have completed.

The warehouse size does not change until all queries currently in the warehouse queue have completed.

The warehouse size does not change until the warehouse is suspended and restarted.

It does not return from the command until the warehouse has finished changing its size.

Which of the following are characteristics of security in Snowflake?

Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

Account and user authentication is only available with the Snowflake Business Critical edition.

Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Snowflake SnowPro Core Practice Test 6 - Free Online Exam Questions 201-240

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.

Which SQL command should be used to delete the files?

Become a Premium Member for full access

Unlock Premium Member

Snowflake SnowPro Core Practice Test 6

Question

Drag and Drop

Hot Area

Snowflake SnowPro Core Practice Tests

Practice Tests