SnowPro-Core Snowflake Exam Questions and Free Practice Test

Question 49

- (Exam Topic 3)
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

A. CONTENT

B. PATH

C. BYTE_SIZE

D. INDEX

E. DATATYPE

Correct Answer:BC

Question 50

- (Exam Topic 1)
True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

A. True

B. False

Correct Answer:A
Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

Question 51

- (Exam Topic 3)
What privilege should a user be granted to change permissions for new objects in a managed access schema?

A. Grant the OWNERSHIP privilege on the schema.

B. Grant the OWNERSHIP privilege on the database.

C. Grant the MANAGE GRANTS global privilege.

D. Grant ALL privileges on the schema.

Correct Answer:C

Question 52

- (Exam Topic 2)
What happens when an external or an internal stage is dropped? (Select TWO).

A. When dropping an external stage, the files are not removed and only the stage is dropped

B. When dropping an external stage, both the stage and the files within the stage are removed

C. When dropping an internal stage, the files are deleted with the stage and the files are recoverable

D. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable

E. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

Correct Answer:AC

Question 53

- (Exam Topic 3)
What is a responsibility of Snowflake’s virtual warehouses?

A. Infrastructure management

B. Metadata management

C. Query execution

D. Query parsing and optimization

E. Permanent storage of micro-partitions

Correct Answer:C
Reference:
https://docs.snowflake.com/en/user-guide/warehouses.html#:~:text=A warehouse provides the re

Question 54

- (Exam Topic 1)
True or False: All Snowflake table types include fail-safe storage.

A. True

B. False

Correct Answer:B

START SnowPro-Core EXAM