Question 1

A data platform team creates two multi-cluster virtual warehouses with the AUTO_SUSPEND value set to NULL on one. and '0' on the other. What would be the execution behavior of these virtual warehouses?

Options :

A : Setting a '0' or NULL value means the warehouses will never suspend.

B : Setting a '0' or NULL value means the warehouses will suspend immediately.

C : Setting a '0' or NULL value means the warehouses will suspend after the default of 600 seconds.

D :

Setting a '0' value means the warehouses will suspend immediately, and NULL means the warehouses will never suspend.

Answer: D

Question 2

An Architect is designing a data lake with Snowflake. The company has structured, semi-structured, and unstructured data. The company wants to save the data inside the data lake within the Snowflake system. The company is planning on sharing data among its corporate branches using Snowflake data sharing. What should be considered when sharing the unstructured data within Snowflake?

Options :

A :

A pre-signed URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with no time limit for the URL.

B :

A scoped URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with a 24-hour time limit for the URL.

C :

A file URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with a 7-day time limit for the URL.

D :

A file URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with the "expiration_time" argument defined for the URL time limit.

Answer: B

Question 3

What will happen to ALTER a column setting it to NOT NULL if it contains NULL values?

Options :

A : Snowflake deletes the rows with NULL values.

B : NULL values are changed to an empty string " "

C : Snowflake returns an error

D : NULL values are changed to 0

Answer: C

Question 4

VALIDATION_MODE does not support COPY statements that transform data during a load

Options :

A : TRUE

B : FALSE

Answer: A

Question 5

What integration object should be used to place restrictions on where data may be exported?

Options :

A : Stage integration

B : Security integration

C : Storage integration

D : API integration

Answer: C