Online Access Free SnowPro-Core Practice Test

True or False: A Virtual Warehouse can be resized while suspended.

• A.True
• B.False

What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?

• A.Reorder the rows in a relational table and then unload the rows into a file
• B.Convert the rows in a relational table lo a single VARIANT column and then unload the rows into a file.
• C.Convert the rows in a source file to a single variant column and then load the rows from the file to a variant table.
• D.Reorder the data columns according to a target table definition and then unload the rows into the table.

What is the minimum Snowflake edition that has column-level security enabled?

• A.Virtual Private Snowflake
• B.Standard
• C.Enterprise
• D.Business Critical

Using variables in Snowflake is denoted by using which SQL character?

• A.$
• B.@
• C.#
• D.&

A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?

• A.list @my_stage
• B.view @my_stage
• C.display @my_stage
• D.show @my_stage