Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

• A.CONTENT
• B.PATH
• C.BYTE_SIZE
• D.INDEX
• E.DATATYPE

Comment: *

Name: *

Email: *

Verification: *

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

• A.SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
• B.A user cannot specify a default warehouse when using the ODBC driver.
• C.The default virtual warehouse size can be changed at any time.
• D.Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
• E.The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.

Comment: *

Name: *

Email: *

Verification: *

True or False: You can define multiple columns within a clustering key on a table.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

What is the purpose of an External Function?

• A.To call code that executes outside of Snowflake
• B.To run a function in another Snowflake database
• C.To share data in Snowflake with external parties
• D.To ingest data from on-premises data sources

Comment: *

Name: *

Email: *

Verification: *

Which types of subqueries does Snowflake support? (Select TWO).

• A.Uncorrelated scalar subqueries in WHERE clauses
• B.Uncorrelated scalar subqueries in any place that a value expression can be used
• C.EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be uncorrelated only
• D.EXISTS, ANY / ALL, and IN subqueries in where clauses: these subqueries can be correlated only
• E.EXISTS, ANY /ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated

Comment: *

Name: *

Email: *

Verification: *