A user executed a SELECT query in Snowsight which returned a 1 GB result set. The user then downloads the files.
What will occur?

• A.The download will fail because the result set needs to be broken up into files no greater than 50 MB before downloading.
• B.The result set will be successfully downloaded from Snowsight.
• C.The result set will be automatically compressed and the data will be downloaded as individual files.
• D.The download will result in an error because the filters of the SELECT query need to be changed so that Snowsight returns a smaller result set.

Comment: *

Name: *

Email: *

Verification: *

Which table type is optimized for transactional workloads?

• A.Event
• B.Hybrid
• C.Dynamic
• D.Permanent

Comment: *

Name: *

Email: *

Verification: *

Which DDL/DML operation is allowed on an inbound data share?

• A.ALTER TA3LE
• B.INSERT INTO
• C.MERGE
• D.SELECT

Comment: *

Name: *

Email: *

Verification: *

Which type of join will list a I rows in the specified table, even if those rows have no match in the other table?

• A.Cross join
• B.Inner join
• C.Natural join
• D.Outer join

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake feature enables loading data from cloud storage as soon as files ate available in a stage?

• A.Data replication
• B.COPY_INTO <location> command
• C.Snowpipe
• D.Direct share

Comment: *

Name: *

Email: *

Verification: *