Which type of table corresponds to a single Snowflake session?

• A.Temporary
• B.Transient
• C.Permanent
• D.Provisional

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements is true of data loading?
Select one.

• A.Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast
• B.The "deal file size for loading is 16MB to match micro-partition size
• C.Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism

Comment: *

Name: *

Email: *

Verification: *

What is the default File Format used in the COPY command if one is not specified?

• A.CSV
• B.Parquet
• C.JSON
• D.XML

Comment: *

Name: *

Email: *

Verification: *

Which of the following DML commands isn't supported by Snowflake?

• A.UPSERT
• B.MERGE
• C.UPDATE
• D.TRUNCATE TABLE

Comment: *

Name: *

Email: *

Verification: *

Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy?
Select one.

• A.Database -> Schema -> Table -> Account
• B.Database -> Table -> Schema -> Account
• C.Account -> Schema -> Database -> Table
• D.Account -> Database -> Schema -> Table

Comment: *

Name: *

Email: *

Verification: *