Free SnowPro-Core Practice Exam Questions Online

Why Snowflake SnowPro-Core Practice Exam Questions?

Ready to level up your Snowflake SnowPro-Core exam study? Just TheExamsLab SnowPro-Core practice tests free.

SnowPro-Core exam questions are expertly crafted practice tests designed to simulate the real Snowflake certification exam environment and help you assess your knowledge and figure out where you are lacking. From our free SnowPro Core Certification (COF-C02) SnowPro-Core practice exam, you will feel secure in passing any question type or time limit. TheExamsLab offers the SnowPro-Core exam questions 2024. Don’t settle or do it half-heartedly get the best and invest in the best what you want is what you get.

Page: 1 / 382

Total 1910 Questions | Updated On: Nov 18, 2024

Add To Cart

Question 1

What are supported file formats for unloading data from Snowflake? (Choose three.)

A : XML

B : JSON

C : Parquet

D : ORC

E : AVRO

F : CSV

Answer: A,B,C

Question 2

Robert, A Data Engineer, found that Pipe become stale as it was paused for longer than the limited retention period for event messages received for the pipe (14 days by default) & also the previous pipe owner transfers the ownership of this pipe to Robert role while the pipe was paused. How Robert in this case, Resume this stale pipe?

A : PIPE needs to recreate in this scenarios, as pipe already past 14 days of period & stale.

B : He can apply System function SYSTEM$PIPE_STALE_RESUME with ALTER PIPE statement

C : Robert can use SYSTEM$PIPE_FORCE_RESUME function to resume this stale priceselect system$pipe_force_resume('mydb.myschema.stalepipe','staleness_check_override, ownership_transfer_check_override');

D : ALTER PIPES ... RESUME statement will resume the pipe

Answer: C

Question 3

What of the following Snowflake edition allows data clustering to improve query performance?

A : Virtual Private Snowflake

B : Business Critical

C : Enterprise

D : Standard

Answer: B,C,D

Question 4

Under which condition a stored procedure will execute under the privileges of the role that created the stored procedure?

A : The stored procedure has been configured to run under the owner's rights.

B : The stored procedure performs account-level modifications.

C : The stored procedure changes the system security settings.

D : The stored procedure has been configured to run under the caller's rights.

Answer: A

Question 5

Which of the following can be used to find the query ID of the 2nd most recent query executed in the current session?

A : SELECT LAST_QUERY_ID(-2);

B : SELECT LAST_QUERY_ID(2);

C : SELECT LAST_QUERY_ID(1);

D : SELECT LAST_QUERY_ID(-1);

Answer: A

Page: 1 / 382

Total 1910 Questions | Updated On: Nov 18, 2024

Add To Cart