- (Exam Topic 2)
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.
Which of the following statements will accommodate this request?

1. A. ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
2. B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
3. C. GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
4. D. GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Correct Answer: B

- (Exam Topic 1)
Which of the following statements are true about Schemas in Snowflake? (Choose two.)

1. A. A Schema may contain one or more Databases
2. B. A Database may contain one or more Schemas
3. C. A Schema is a logical grouping of Database Objects
4. D. Each Schema is contained within a Warehouse

Correct Answer: BC
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html

- (Exam Topic 3)
Which TABLE function helps to convert semi-structured data to a relational representation?

1. A. CHECK_JSON
2. B. TO_JSON
3. C. FLATTEN
4. D. PARSE_JSON

Correct Answer: D

- (Exam Topic 2)
What is the purpose of an External Function?

1. A. To call code that executes outside of Snowflake
2. B. To run a function in another Snowflake database
3. C. To share data in Snowflake with external parties
4. D. To ingest data from on-premises data sources

Correct Answer: A
https://docs.snowflake.com/en/sql-reference/external-functions.html

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

1. A. Java
2. B. JavaScript
3. C. SQL
4. D. Python

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