SnowPro-Core Snowflake Exam Questions and Free Practice Test

Question 109

- (Exam Topic 1)
Which formats are supported for unloading data from Snowflake? Choose 2 answers

A. Delimited (CSV, TSV, etc.)

B. Avro

C. JSON

D. ORC

Correct Answer:AC
Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

Question 110

- (Exam Topic 3)
A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?

A. Use data encryption.

B. Use dynamic data masking.

C. Use secure materialized views.

D. Revoke all roles for functional managers and end users.

Correct Answer:B

Question 111

- (Exam Topic 3)
How long is the Fail-safe period for temporary and transient tables?

A. There is no Fail-safe period for these tables.

B. 1 day

C. 7 days

D. 31 days

E. 90 days

Correct Answer:A
Reference: https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

Question 112

- (Exam Topic 1)
Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)? Choose 2 answers

A. Java

B. JavaScript

C. SQL

D. Python

Correct Answer:BC
Reference: https://docs.snowflake.com/en/sql-reference/user-defined-functions.html

Question 113

- (Exam Topic 2)
What is a responsibility of Snowflake's virtual warehouses?

A. Infrastructure management

B. Metadata management

C. Query execution

D. Query parsing and optimization

E. Management of the storage layer

Correct Answer:C

Question 114

- (Exam Topic 3)
In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

A. When the system has enough load for 2 minutes

B. When the system has enough load for 6 minutes

C. When the system has enough load for 8 minutes

D. When the system has enough load for 10 minutes

Correct Answer:D

START SnowPro-Core EXAM