Free Snowflake SnowPro-Advanced-Data-Engineer Exam Questions

Become Snowflake Certified with updated SnowPro-Advanced-Data-Engineer exam questions and correct answers

Page: 1 / 48

Total 240 Questions | Updated On: Feb 18, 2025

Add To Cart

Question 1

Lets say you created a schema and a table as below
CREATE OR REPLACE SCHEMA TIME_TRAVEL_SCHEMA DATA_RETENTION_TIME_IN_DAYS =10;
CREATE OR REPLACE TABLE TIME_TRAVEL_SCHEMA.TIME_TRAVEL_TABLE (ID NUMBER) DATA_RETENTION_TIME_IN_DAYS =20;
Later you dropped the schema. In this scenario what data retention value will be honored for the table, if we need to retrieve the table data

A : 10

B : 20

C : 30

Answer: A

Question 2

Which system table will you use to get the total credit consumption over a specific time period?

A : WAREHOUSE_METERING_HISTORY

B : WAREHOUSE_CREDIT_USAGE_HISTORY

C : WAREHOUSE_USAGE_HISTORY

Answer: A

Question 3

Which of the below stored procedure will convert null to string?

A : CREATE OR REPLACE PROCEDURE stored_proc_example(TEST_VALUE STRING) RETURNS string LANGUAGE JAVASCRIPT AS $$ if (TEST_VALUE == null) { var str = "String is null"; return str; } else { return TEST_VALUE; } $$ ;

B : CREATE OR REPLACE PROCEDURE stored_proc_example(TEST_VALUE STRING) RETURNS string LANGUAGE JAVASCRIPT AS $$ if (TEST_VALUE === null) { var str = "String is null"; return str; } else { return TEST_VALUE; } $$ ;

C : CREATE OR REPLACE PROCEDURE stored_proc_example(TEST_VALUE STRING) RETURNS string LANGUAGE JAVASCRIPT AS $$ if (TEST_VALUE === 'null') { var str = "String is null"; return str; } else { return TEST_VALUE; } $$ ;

D : CREATE OR REPLACE PROCEDURE stored_proc_example(TEST_VALUE STRING) RETURNS string LANGUAGE JAVASCRIPT AS $$ if (TEST_VALUE == 'null') { var str = "String is null"; return str; } else { return TEST_VALUE; } $$ ;

Answer: A

Question 4

Streams record the differences between two offsets. If a row is added and then updated in the cur-rent offset, what will be the value of METADATA$ISUPDATE Columns in this scenario?

A : TRUE

B : FALSE

C : UPDATE

D : INSERT

Answer: B

Question 5

Which are the Cloud Platforms that Support Calling an External Function?

A : GCP

B : AWS & AZURE

C : AWS only

D : AWS,GCP,AZURE

Answer: D

Page: 1 / 48

Total 240 Questions | Updated On: Feb 18, 2025

Add To Cart