What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?

• A.OWNERSHIP
• B.USAGK
• C.WRTTF
• D.READ

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

A JSON object is loaded into a column named data using a Snowflake variant datatype. The root node of the object is BIKE. The child attribute for this root node is BIKEID.
Which statement will allow the user to access BIKEID?

• A.select data:BIKEID
• B.select data.BIKE.BIKEID
• C.select data:BIKE.BIKEID
• D.select data:BIKE:BIKEID

Comment: *

Name: *

Email: *

Verification: *

Which command is used to start configuring Snowflake for Single Sign-On (SSO)?

• A.CREATE SESSION POLICY
• B.CREATE NETWORK RULE
• C.CREATE SECURITY INTEGRATION
• D.CREATE PASSWORD POLICY

Comment: *

Name: *

Email: *

Verification: *

What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

• A.Warehouses that are multi-cluster can have nodes of different sizes.
• B.Warehouses can be started and stopped at any time.
• C.Warehouses can be resized at any time, even while running.
• D.Warehouses are billed on a per-minute usage basis.
• E.Warehouses can only be used for querying and cannot be used for data loading.

Comment: *

Name: *

Email: *

Verification: *