When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).

• A.When users will be using compute at different times throughout a 24/7 period
• B.When managing a steady workload
• C.When the compute must be available with no delay or lag time
• D.When the user does not want to have to manually turn on the warehouse each time it is needed
• E.When the warehouse is shared across different teams

Comment: *

Name: *

Email: *

Verification: *

Which roles are needed to access Document AI? Select TWO.

• A.PUBLIC
• B.SYSADMIN
• C.ACCOUNTADMIN
• D.OBJECT_VIEWER
• E.DOCUMENT_INTELLIGENCE_CREATOR

Comment: *

Name: *

Email: *

Verification: *

A Snowflake user is querying JSON data and all values in the result set are wrapped in quotes. Which step will unwrap the data from all the columns in the query results?

• A.Use the TRIM function to remove the quotes.
• B.Use the INSTR function to remove the quotes.
• C.Use the SUBSTRING function to select the values that are inside the quotes.
• D.Use the CAST function to convert the columns to the correct data type.

Comment: *

Name: *

Email: *

Verification: *

A user creates a stage using the following command:
What will be the outcome?

• A.A stage with a directory table set to automatically refresh will be created.
• B.The command will fail to run because the name of the directory table is not specified.
• C.An error will be received stating that the storage location for the stage must be identified when creating a stage with a directory table.
• D.A stage with a directory table that has metadata that must be manually refreshed will be created.

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake feature is used to track sensitive data to ensure compliance, identify data, and monitor resource usage?

• A.Data quality monitoring
• B.Data classification
• C.Multi-Factor Authentication (MFA)
• D.Object tagging

Comment: *

Name: *

Email: *

Verification: *