Which command is used to unload data from a Snowflake table into a file in a stage?

• A.COPY INTO
• B.GET
• C.WRITE
• D.EXTRACT INTO

Comment: *

Name: *

Email: *

Verification: *

What happens when an external or an internal stage is dropped? (Select TWO).

• A.When dropping an external stage, the files are not removed and only the stage is dropped
• B.When dropping an external stage, both the stage and the files within the stage are removed
• C.When dropping an internal stage, the files are deleted with the stage and the files are recoverable
• D.When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
• E.When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

Comment: *

Name: *

Email: *

Verification: *

What is a best practice after creating a custom role?

• A.Create the custom role using the SYSADMIN role.
• B.Assign the custom role to the SYSADMIN role
• C.Assign the custom role to the PUBLIC role
• D.Add__CUSTOM to all custom role names

Comment: *

Name: *

Email: *

Verification: *

What is the MINIMUM size requirement when creating a Snowpark-optimized virtual warehouse?

• A.X-Small
• B.Small
• C.Medium
• D.Large

Comment: *

Name: *

Email: *

Verification: *

How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?

• A.Use the SHOW STAGES command.
• B.Use the DESCRIBE STAGE command.
• C.Use the GET_ABSOLUTE_PATH function.
• D.Use the GET_STAGE_LOCATION function.

Comment: *

Name: *

Email: *

Verification: *