Free Snowflake SOL-C01 Exam Dumps Questions & Answers

What a Database in Snowflake cant contain?

• A.  Views
• B.  Database Role
• C.  Role
• D.  Tables

What information is available when previewing a table in Snowsight?

• A.  The name of the virtual warehouse where the table is stored
• B.  The Entity Relationship (ER) diagram for the table
• C.  The table definition
• D.  The first 100 rows of the table

What is the recommended way to provide a role with access to a Snowflake object?

• A.  Assign the PUBLIC role.
• B.  Transfer ownership of the object to the role.
• C.  Grant privileges to the role.
• D.  Clone the object and grant the role privileges to the cloned object.

What is the purpose of a FILE FORMAT object in Snowflake?

• A.  To specify the format and structure of data files being loaded (e.g., CSV delimiter, JSON compression)
• B.  To define security policies for data files
• C.  To create data backups.
• D.  To manage virtual warehouse sizes.

Which data type in Snowflake is commonly used for storing semi-structured data?

• A.  VARCHAR
• B.  JSON
• C.  BLOB
• D.  VARIANT