Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?

• A.list @bronzestage;
• B.select * from directory(@bronzestage);
• C.select metadata$filename from @bronzestage;
• D.select * from table(information_schema.stage_directory_file_registration_history(stage name= > ' bronzestage1));

Comment: *

Name: *

Email: *

Verification: *

What virtual warehouse configuration should be used when processing a large number of complex queries?

• A.Use the auto-resume feature.
• B.Run the warehouse in auto-scale mode.
• C.Increase the size of the warehouse.
• D.Increase the number of warehouse clusters.

Comment: *

Name: *

Email: *

Verification: *

Why would the SINGLE = TRUE option be included in a COPY INTO < location > statement?

• A.To set the file format to one data type
• B.To unload data to one output file
• C.To limit a user ' s ability to split data into multiple files
• D.To ensure that there is one attempt to load the data

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: *

Which of the following are considerations when using a directory table when working with unstructured data?
(Choose two.)

• A.A directory table is a separate database object.
• B.Directory tables store data file metadata.
• C.A directory table will be automatically added to a stage.
• D.Directory tables do not have their own grantable privileges.
• E.Directory table data can not be refreshed manually.

Comment: *

Name: *

Email: *

Verification: *