SnowPro-Core SnowPro Core Certification Exam is now Stable and With Pass Result | Test Your Knowledge for Free

SnowPro-Core Practice Questions

SnowPro Core Certification Exam

Last Update 2 days ago
Total Questions : 427

Dive into our fully updated and stable SnowPro-Core practice test platform, featuring all the latest SnowPro Core Certification exam questions added this week. Our preparation tool is more than just a Snowflake study aid; it's a strategic advantage.

Our free SnowPro Core Certification practice questions crafted to reflect the domains and difficulty of the actual exam. The detailed rationales explain the 'why' behind each answer, reinforcing key concepts about SnowPro-Core. Use this test to pinpoint which areas you need to focus your study on.

SnowPro-Core PDF

$43.75
~~$124.99~~

Add to Cart

SnowPro-Core Testing Engine

$50.75
~~$144.99~~

Add to Cart

SnowPro-Core PDF + Testing Engine

$63.7
~~$181.99~~

Add to Cart

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

Get SnowPro-Core dumps and pass your exam in 24 hours!

Spring Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 65pass65

SnowPro-Core SnowPro Core Certification Exam is now Stable and With Pass Result | Test Your Knowledge for Free

SnowPro-Core Practice Questions

SnowPro-Core PDF

SnowPro-Core Testing Engine

SnowPro-Core PDF + Testing Engine

Options:

Options:

Options:

Options:

Answer:

Options:

Options:

Options:

Options:

Options:

Options:

Free Exams Sample Questions

We Accept

Secure Site

Customer Review

Money Back Guarantee