Free Snowflake SOL-C01 Exam Dumps Questions & Answers

What is a fully qualified name in Snowflake used for?

• A.  To configure network settings
• B.  To uniquely identify database objects
• C.  To store data in tables
• D.  To manage user permissions

What a Database in Snowflake cant contain?

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

What is the SHOW FILE FORMATS SQL command used for in Snowflake?

• A.  List all of the files in a database that have data in a given file format.
• B.  Create a list of all of the file formats currently supported by Snowflake.
• C.  Get information about how different file formats should be used.
• D.  List the file formats in the currently-selected schema.

Which SQL command is used to create a new SCHEMA in Snowflake? (Choose any 3 options)

• A.  USE SCH Schema_name;
• B.  USE SCHEMA Schema_name;
• C.  CREATE SCH Schema_name;
• D.  CREATE SCHEMA Schema_name;

What is the LIST command used for in Snowflake?

• A.  Lists all the files in a given stage.
• B.  Lists all the users assigned to a given role.
• C.  Lists all the tables in a specific schema.
• D.  Lists all the privileges granted on a specific object.