- (Exam Topic 2)
Which of the following describes external functions in Snowflake?

1. A. They are a type of User-defined Function (UDF).
2. B. They contain their own SQL code.
3. C. They call code that is stored inside of Snowflake.
4. D. They can return multiple rows for each row received

Correct Answer: A
External functions are user-defined functions that are stored and executed outside of Snowflake.
External functions make it easier to access external API services such as geocoders, machine learning models, and other custom code running outside of Snowflake. This feature eliminates the need to export and reimport data when using third-party services, significantly simplifying your data pipelines.
https://docs.snowflake.com/en/sql-reference/external-functions.html#:~:text=External%20functions%20are%20

- (Exam Topic 1)
True or False: It is possible to load data into Snowflake without creating a named File Format object.

1. A. True
2. B. False

Correct Answer: A
Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html

- (Exam Topic 1)
Which of the following accurately represents how a table fits into Snowflake’s logical container hierarchy? Select one.

1. A. Account -> Schema -> Database -> Table
2. B. Account -> Database -> Schema -> Table
3. C. Database -> Schema -> Table -> Account
4. D. Database -> Table -> Schema -> Account

Correct Answer: B
Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html

- (Exam Topic 3)
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

1. A. The warehouse size does not change until all queries currently running in the warehouse have completed.
2. B. The warehouse size does not change until all queries currently in the warehouse queue have completed.
3. C. The warehouse size does not change until the warehouse is suspended and restarted.
4. D. It does not return from the command until the warehouse has finished changing its size.

Correct Answer: D

- (Exam Topic 3)
How can a user change which columns are referenced in a view?

1. A. Modify the columns in the underlying table
2. B. Use the ALTER VIEW command to update the view
3. C. Recreate the view with the required changes
4. D. Materialize the view to perform the changes

Correct Answer: B