Snowflake SnowPro Core Certification - SnowPro-Core Exam Practice Test
What happens to the privileges granted to Snowflake system-defined roles?
Correct Answer: B
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
Correct Answer: B
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?
Correct Answer: C
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
Which views are included in the DATA SHARING USAGE schema? (Select TWO).
Correct Answer: A,C
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Correct Answer: A
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?
Correct Answer: B
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
What can the Snowflake SCIM API be used to manage? (Select TWO).
Correct Answer: C,D
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
When cloning a database, what is cloned with the database? (Choose two.)
Correct Answer: B,E
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
Correct Answer: C
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?
Correct Answer: A
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
Which Snowflake view is used to support compliance auditing?
Correct Answer: D
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).