Question 1

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

Options :

A : parse_json()

B : json_extract_path_text()

C : object_construct()

D : flatten

Answer: A

Question 2

Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).

Options :

A : The separation allows independent scaling of computing resources.

B : The separation ensures consistent data encryption across all virtual data warehouses.

C :

The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.

D : Storage volume growth and compute usage growth can be tightly coupled.

E : Compute can be scaled up or down without the requirement to add more storage.

Answer: A,E

Question 3

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

Options :

A : SHOW STORAGE BY TABLE;

B : SHOW TABLES;

C : Information Schema -> TABLE_HISTORY

D : Information Schema -> TABLE_FUNCTION

E : Information Schema -> TABLE_STORAGE_METRICS

Answer: A,E

Question 4

Which of the following are characteristics of security in Snowflake?

Options :

A : Account and user authentication is only available with the Snowflake Business Critical edition.

B : Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

C : Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

D : Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Answer: C

Question 5

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

A user needs to extract the dealership information from the JSON. How can this be accomplished?

Options :

A : select src:dealership from car_sales;

B : select src.dealership from car_sales;

C : select dealership from car_sales;

Answer: B

Higher Test Marks with Free Online SnowPro-Core Exam Practice