Which command is used to unload files from an internal or external stage to a local file system?

• A.COPY INTO
• B.GET
• C.PUT
• D.TRANSFER

Comment: *

Name: *

Email: *

Verification: *

Which data type can be used to store geospatial data in Snowflake?

• A.Variant
• B.Object
• C.Geometry
• D.Geography

Comment: *

Name: *

Email: *

Verification: *

Which command can be used to list all the file formats for which a user has access privileges?

• A.LIST
• B.DESCRIBE FILE FORMAT
• C.SHOW FILE FORMATS
• D.ALTER FILE FORMAT

Comment: *

Name: *

Email: *

Verification: *

What tasks can be completed using the copy command? (Select TWO)

• A.Columns can be joined with an existing table
• B.Data can be loaded without the need to spin up a virtual warehouse
• C.Columns can be aggregated
• D.Columns can be omitted
• E.Columns can be reordered

Comment: *

Name: *

Email: *

Verification: *

What is the MINIMUM role required to set the value for the parameter
ENABLE_ACCOUNT_DATABASE_REPLICATION?

• A.ACCOUNTADMIN
• B.SECURITYADMIN
• C.SYSADMIN
• D.ORGADMIN

Comment: *

Name: *

Email: *

Verification: *