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

Good News !!! SnowPro-Core SnowPro Core Certification Exam is now Stable and With Pass Result

SnowPro-Core Practice Exam Questions and Answers

SnowPro Core Certification Exam

Last Update 4 days ago
Total Questions : 427

SnowPro Core Certification Exam is stable now with all latest exam questions are added 4 days ago. Incorporating SnowPro-Core practice exam questions into your study plan is more than just a preparation strategy.

SnowPro-Core exam questions often include scenarios and problem-solving exercises that mirror real-world challenges. Working through SnowPro-Core dumps allows you to practice pacing yourself, ensuring that you can complete all SnowPro Core Certification Exam practice test within the allotted time frame.

SnowPro-Core PDF

SnowPro-Core PDF (Printable)
$42
$119.99

SnowPro-Core Testing Engine

SnowPro-Core PDF (Printable)
$49
$139.99

SnowPro-Core PDF + Testing Engine

SnowPro-Core PDF (Printable)
$61.95
$176.99
Question # 1

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Options:

A.  

Data is hashed by the cluster key to facilitate fast searches for common data values

B.  

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

C.  

Smaller micro-partitions are created for common data values to allow for more parallelism

D.  

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Discussion 0
Question # 2

Which statement about billing applies to Snowflake credits?

Options:

A.  

Credits are billed per-minute with a 60-minute minimum

B.  

Credits are used to pay for cloud data storage usage

C.  

Credits are consumed based on the number of credits billed for each hour that a warehouse runs

D.  

Credits are consumed based on the warehouse size and the time the warehouse is running

Discussion 0
Question # 3

What is a limitation of a Materialized View?

Options:

A.  

A Materialized View cannot support any aggregate functions

B.  

A Materialized View can only reference up to two tables

C.  

A Materialized View cannot be joined with other tables

D.  

A Materialized View cannot be defined with a JOIN

Discussion 0
Question # 4

What Snowflake role must be granted for a user to create and manage accounts?

Options:

A.  

ACCOUNTADMIN

B.  

ORGADMIN

C.  

SECURITYADMIN

D.  

SYSADMIN

Discussion 0
Question # 5

Which of the following can be executed/called with Snowpipe?

Options:

A.  

A User Defined Function (UDF)

B.  

A stored procedure

C.  

A single copy_into statement

D.  

A single insert__into statement

Discussion 0
Question # 6

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

Options:

A.  

Bytes scanned

B.  

Bytes sent over the network

C.  

Number of partitions scanned

D.  

Percentage scanned from cache

E.  

External bytes scanned

Discussion 0
Question # 7

What happens when a cloned table is replicated to a secondary database? (Select TWO)

Options:

A.  

A read-only copy of the cloned tables is stored.

B.  

The replication will not be successful.

C.  

The physical data is replicated

D.  

Additional costs for storage are charged to a secondary account

E.  

Metadata pointers to cloned tables are replicated

Discussion 0
Question # 8

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:

COPY INTO my__table FROM @my__stage;

The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.

If the user runs the same copy into command what will happen?

Options:

A.  

All data from all of the files on the stage will be appended to the table

B.  

Only data about new customers from the new files will be appended to the table

C.  

The operation will fail with the error uncertain files in stage.

D.  

All data from only the newly-added files will be appended to the table.

Discussion 0
Question # 9

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Options:

A.  

Customer-managed encryption keys through Tri-Secret Secure

B.  

Automatic encryption of all data

C.  

Up to 90 days of data recovery through Time Travel

D.  

Object-level access control

E.  

Column-level security to apply data masking policies to tables and views

Discussion 0
Question # 10

What can be used to view warehouse usage over time? (Select Two).

Options:

A.  

The load HISTORY view

B.  

The Query history view

C.  

The show warehouses command

D.  

The WAREHOUSE_METERING__HISTORY View

E.  

The billing and usage tab in the Snowflake web Ul

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

Free Exams Sample Questions