Which of the following statements would be used to export/unload data from Snowflake?

• A.COPY INTO @stage
• B.EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);
• C.INSERT INTO @stage
• D.EXPORT TO @stage

Comment: *

Name: *

Email: *

Verification: *

What privileges are required to execute a task?

• A.To execute a task, you need the EXECUTE TASK.
• B.Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.
• C.Tasks run automatically and do run under any rote.
• D.A task is an account-level object and can only be executed by the Account Admin role.

Comment: *

Name: *

Email: *

Verification: *

Which statement accurately describes a characteristic of a materialized view?

• A.A materialized view can query only a single table.
• B.Data accessed through materialized views can be stale.
• C.Materialized view refreshes need to be maintained by the user.
• D.Querying a materialized view is slower than executing a query against the base table of the view.

Comment: *

Name: *

Email: *

Verification: *

Which kind of Snowflake table stores file-level metadata for each file in a stage?

• A.Directory
• B.External
• C.Temporary
• D.Transient

Comment: *

Name: *

Email: *

Verification: *

What are supported file formats for unloading data from Snowflake? (Choose three.)

• A.AVRO
• B.JSON
• C.CSV
• D.ORC
• E.XML
• F.Parquet

Comment: *

Name: *

Email: *

Verification: *