Free SnowPro Core Certification Exam Practice Questions

Question # 21

True or False: Snowpipe via REST API can only reference External Stages as source.

Options:

True

False

Discussion 0

Question # 22

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

Options:

CHECK_OPTION

IS_SECURE

IS_UPDATEABLE

TABLE_NAME

Discussion 0

Question # 23

Using variables in Snowflake is denoted by using which SQL character?

Options:

Discussion 0

Question # 24

What is true about sharing data in Snowflake? (Choose two.)

Options:

The Data Consumer pays for data storage as well as for data computing.

The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

A Snowflake account can both provide and consume shared data.

The Provider is charged for compute resources used by the Data Consumer to query the shared data.

The Data Consumer pays only for compute resources to query the shared data.

Discussion 0

Question # 25

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

Options:

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.

Discussion 0

Question # 26

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

Options:

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.

Discussion 0

Question # 27

A running virtual warehouse is suspended.

What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

Options:

1 second

60 seconds

5 minutes

60 minutes

Discussion 0

Question # 28

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

Options:

SELECT SUM (ORDER_AMT) FROM SALES;

SELECT AVG(ORDER_QTY) FROM SALES;

SELECT MIN(ORDER_AMT) FROM SALES;

SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Discussion 0

Question # 29

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

Options:

parse_json()

json_extract_path_text()

object_construct()

flatten

Discussion 0

Question # 30

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?

Options:

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.

Discussion 0