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

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

Comment: *

Name: *

Email: *

Verification: *

What SQL command would be used to view all roles that were granted to user.1?

• A.show grants to user USER1;
• B.show grants of user USER1;
• C.describe user USER1;
• D.show grants on user USER1;

Comment: *

Name: *

Email: *

Verification: *

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

• A.4
• B.8
• C.16
• D.32

Correct Answer: B

Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:

https://docs.snowflake.com/en/user-guide/warehouses-overview.html

Comment: *

Name: *

Email: *

Verification: *

How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?

• A.60 minutes
• B.24 hours
• C.14 days
• D.30 days

Comment: *

Name: *

Email: *

Verification: *

Which type of table corresponds to a single Snowflake session?

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

Comment: *

Name: *

Email: *

Verification: *