What is the MOST performant file format for loading data in Snowflake?

• A.CSV (Unzipped)
• B.Parquet
• C.CSV (Gzipped)
• D.ORC

Comment: *

Name: *

Email: *

Verification: *

Which command is used to upload data files from a local directory or folder on a client machine to an internal stage, for a specified table?

• A.GET
• B.PUT
• C.CREATE STREAM
• D.COPY INTO <location>

Comment: *

Name: *

Email: *

Verification: *

Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?

• A.The column name and element names are both case-insensitive.
• B.The column name and element names are both case-sensitive.
• C.The column name is case-insensitive but element names are case-sensitive.
• D.The column name is case-sensitive but element names are case-insensitive.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

In a Snowflake role hierarchy, what is the top-level role?

• A.SYSADMIN
• B.ORGADMIN
• C.ACCOUNTADMIN
• D.SECURITYADMIN

Comment: *

Name: *

Email: *

Verification: *