Which commands can only be executed using SnowSQL? (Select TWO).

• A.COPY INTO
• B.GET
• C.LIST
• D.PUT
• E.REMOVE

Comment: *

Name: *

Email: *

Verification: *

What can a Snowflake user do with the information included in the details section of a Query Profile?

• A.Determine the total duration of the query.
• B.Determine the role of the user who ran the query.
• C.Determine the source system that the queried table is from.
• D.Determine if the query was on structured or semi-structured data.

Comment: *

Name: *

Email: *

Verification: *

Which SQL command can be used to verify the privileges that are granted to a role?

• A.SHOW GRANTS ON ROLE <Role Name>
• B.SHOW ROLES <Role Name>
• C.SHOW GRANTS TO ROLE <Role Name>
• D.SHOW GRANTS FOR ROLE <Role Name>

Comment: *

Name: *

Email: *

Verification: *

Which property or parameter can be used to temporarily disable Multi-Factor Authentication (MFA) for a Snowflake user?

• A.EXT_AUTHN_DUO
• B.MINS_TO_BYPASS_MFA
• C.DISABLE_MFA
• D.ALLOW_CLIENT_MFA_CACHING

Comment: *

Name: *

Email: *

Verification: *

Which command will unload data from a table into an external stage?

• A.PUT
• B.INSERT
• C.COPY INTO <location>
• D.GET

Comment: *

Name: *

Email: *

Verification: *