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(

Comment: *

Name: *

Email: *

Verification: *

When an object is created in Snowflake. who owns the object?

• A.The public role
• B.The user's default role
• C.The current active primary role
• D.The owner of the parent schema

Comment: *

Name: *

Email: *

Verification: *

How long does Snowflake retain information in the ACCESS HISTORY view?

• A.7 days
• B.14 days
• C.28 days
• D.365 days

Comment: *

Name: *

Email: *

Verification: *

What activities can a user with the ORGADMIN role perform? (Select TWO).

• A.Create an account for an organization.
• B.Edit the account data for an organization.
• C.Delete the account data for an organization.
• D.View usage information for all accounts in an organization.
• E.Select all the data in tables for all accounts in an organization.

Comment: *

Name: *

Email: *

Verification: *

What is the recommended file sizing for data loading using Snowpipe?

• A.A compressed file size greater than 100 MB, and up to 250 MB
• B.A compressed file size greater than 100 GB, and up to 250 GB
• C.A compressed file size greater than 10 MB, and up to 100 MB
• D.A compressed file size greater than 1 GB, and up to 2 GB

Comment: *

Name: *

Email: *

Verification: *