Online Access Free SOL-C01 Practice Test

What type of mode available in PARSE_DOCUMENT function? (Select two)

• A.OCR
• B.CONTENT
• C.LAYOUT
• D.OMR

What is the purpose of the USE SCHEMA command in Snowflake?

• A.To create a new schema in a database
• B.To set the current schema for a session
• C.To modify the schema structure in a session
• D.To take ownership of an existing schema

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.List the file formats in the currently-selected schema.
• D.Get information about how different file formats should be used.

What is a key feature of custom roles in Snowflake? (Choose any 2 options)

• A.They are created by Snowflake administrators
• B.They cannot be granted to users
• C.They have predefined privileges
• D.They can be tailored to specific organizational requirements

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

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