Exam Prep 1

Which commands can only be executed using SnowSQL? (Choose two.)

• COPY INTO

• GET

• LIST

• PUT

• REMOVE

A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table.

What will the query from the view return?

• The data from the permanent table.

• The data from the temporary table.

• An error stating that the view would not be compiled.

• An error stating that the referenced object could not be uniquely identified.

Which Snowsight feature can be used to perform data manipulations and transformations using a programming language?

• SnowSQL

• Dashboards

• Python worksheets

• Provider Studio

Use of which Snowflake function is recommended when unloading data from a relational table into a JSON file?

• TO_JSON

• TO_VARIANT

• OBJECT_INSERT

• OBJECT_CONSTRUCT

What user setting can be configured to disable Multi-Factor Authentication (MFA) for a Snowflake user? (Choose two.)

• DISABLE_MFA

• MINS_TO_BYPASS_MFA

• PASSWORD

• MINS_TO_UNLOCK

• MUST_CHANGE_PASSWORD

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

• parse_json()

• json_extract_path_text()

• object_construct()

• flatten

What computer language can be selected when creating User-Defined Functions (UDF) using the Snowpark API?

• Swift

• JavaScript

• Python

• SQL

How does a scoped URL expire?

• When the data cache clears.

• When the persisted query result period ends.

• The encoded URL access is permanent.

• The length of time is specified in the expiration_time argument.

When unloading data, which combination of parameters should be used to differentiate between empty strings and NULL values? (Choose two.)

• ESCAPE_UNENCLOSED_FIELD

• REPLACE_INVALID_CHARACTERS

• FIELD_OPTIONALLY_ENCLOSED_BY

• EMPTY_FIELD_AS_NULL

• SKIP_BLANK_LINES

How does Snowflake enable OAuth?

• By creating an external integration.

• By configuring a security integration.

• By establishing IP allowed lists and IP blocked lists.

• By using SnowSQL to enable an external OAuth using the Snowflake protocol.