What type of query benefits the MOST from search optimization?

A query that uses equality predicates or predicates that use IN

A query that uses only disjunction (i.e., OR) predicates

A query that includes analytical expressions

A query that uses equality predicates or predicates that use IN

A query that filters on semi-structured data types

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

The default virtual warehouse size can be changed at any time.

Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.

The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.

SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

A user cannot specify a default warehouse when using the ODBC driver.

The default virtual warehouse size can be changed at any time.

The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

Authentication and access control

When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

The listing is replicated into all selected regions automatically, the data is not.

The user must have the ORGADMIN role available in at least one account to link accounts for replication.

There is no need to have a Snowflake account in the target region, a share will be created for each user.

The listing is replicated into all selected regions automatically, the data is not.

The user must have the ORGADMIN role available in at least one account to link accounts for replication.

Shares attached to listings in remote regions can be viewed from any account in an organization.

For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

User-Defined Table Functions (UDTF)

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

Physical storage of micro-partitions

How long is the Fail-safe period for temporary and transient tables?

There is no Fail-safe period for these tables.

How does Snowflake Fail-safe protect data in a permanent table?

Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

Fail-safe makes data available up to 1 day, recoverable by user operations.

Fail-safe makes data available for 7 days, recoverable by user operations.

Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

A virtual warehouse is created using the following command:Create warehouse my_WH withwarehouse_size = MEDIUMmin_cluster_count = 1max_cluster_count = 1auto_suspend = 60auto_resume = true;The image below is a graphical representation of the warehouse utilization across two days. What action should be taken to address this situation?

Configure the warehouse to a multi-cluster warehouse.

Increase the warehouse size from Medium to 2XL.

Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

Configure the warehouse to a multi-cluster warehouse.

Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.

Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 30 days. Fail Safe retention time is 1 day.

Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 365 days. Fail Safe retention time is 7 days.

Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.

Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.

Default Time Travel Retention is set to 7 days. Maximum Time Travel Retention is 1 day. Fail Safe retention time is 90 days.

Default Time Travel Retention is set to 90 days. Maximum Time Travel Retention is 7 days. Fail Safe retention time is 356 days.

Which of the following statements describe features of Snowflake data caching? (Choose two.)

When the data cache is full, the least-recently used data will be cleared to make room.

The RESULT_SCAN table function can access and filter the contents of the query result cache.

When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

When the data cache is full, the least-recently used data will be cleared to make room.

A user can only access their own queries from the query result cache.

A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

The RESULT_SCAN table function can access and filter the contents of the query result cache.

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)The load failed with this error:Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.How can this issue be resolved?

Split the file into multiple files in the recommended size range (100 MB - 250 MB).

Compress the file and load the compressed file.

Split the file into multiple files in the recommended size range (100 MB - 250 MB).

Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

Where can a user find and review the failed logins of a specific user for the past 30 days?

The LOGIN_HISTORY view in ACCOUNT_USAGE

The USERS view in ACCOUNT_USAGE

The LOGIN_HISTORY view in ACCOUNT_USAGE

The ACCESS_HISTORY view in ACCOUNT_USAGE

The SESSIONS view in ACCOUNT_USAGE

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

Snowflake leverages a Role-Based Access Control (RBAC) model.

All data in Snowflake is encrypted.

Snowflake leverages a Role-Based Access Control (RBAC) model.

Snowflake requires a user to configure an IAM user to connect to the database.

All data in Snowflake is encrypted.

Snowflake can run within a user's own Virtual Private Cloud (VPC).

All data in Snowflake is compressed.

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

Stopping the virtual warehouse that the query is running against

Executing the RESULTS_SCAN() table function

Removing a column from the query SELECT list

Stopping the virtual warehouse that the query is running against

Clustering of the data used by the query

Executing the RESULTS_SCAN() table function

Changing a column that is not in the cached query

Which statement is true about running tasks in Snowflake?

A task allows a user to execute a single SQL statement/command using a predefined schedule.

A task can be called using a CALL statement to run a set of predefined SQL commands.

A task allows a user to execute a single SQL statement/command using a predefined schedule.

A task allows a user to execute a set of SQL commands on a predefined schedule.

A task can be executed using a SELECT statement to run a predefined SQL command.

In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

When the system has enough load for 2 minutes

When the system has enough load for 6 minutes

When the system has enough load for 8 minutes

When the system has enough load for 10 minutes

Which of the following describes a Snowflake stored procedure?

They can be created to run with a caller's rights or an owner's rights.

They can be created as secure and hide the underlying metadata from the user.

They can only access tables from a single database.

They can contain only a single SQL statement.

They can be created to run with a caller's rights or an owner's rights.

How are serverless features billed?

Per minute multiplied by an automatic sizing for the job, with a minimum of one minute

Per second multiplied by an automatic sizing for the job

Per minute multiplied by an automatic sizing for the job, with a minimum of one minute

Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter

Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

INSERT INTO TABLE SELECT FROM STREAM

ALTER TABLE AS SELECT FROM STREAM

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

Specify the PURGE copy option in the COPY INTO <table> command.

Use the REMOVE command after the load completes.

Use the DROP <file> command after the load completes.

Specify the TEMPORARY option when creating the file format.

Specify the PURGE copy option in the COPY INTO <table> command.

Use the REMOVE command after the load completes.

Use the DELETE LOAD HISTORY command after the load completes.

Snowflake SnowPro Core Practice Test 4 - Free Online Exam Prep & Questions

What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

30 days

7 days

48 hours

24 hours

Comment (0)

Snowflake SnowPro Core Practice Test 4

Question

Snowflake SnowPro Core Practice Tests

Practice Tests