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

The FLATEEN function is used to query which type of data in Snowflake?

• A.Semi-structured data
• B.Structured data
• C.Both of the above
• D.None of the above

Comment: *

Name: *

Email: *

Verification: *

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

Which of the following terms best describes Snowflake's database architecture?

• A.Columnar shared nothing
• B.Shared disk
• C.Multi-cluster, shared data
• D.Cloud-native shared memory

Comment: *

Name: *

Email: *

Verification: *

What is the recommended compressed file size range for continuous data loads using Snowpipe?

• A.100-250 MB
• B.10-99 MB
• C.8-16 MB
• D.16-24 MB

Comment: *

Name: *

Email: *

Verification: *