When using the ALLOW_CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
Answer(s): C
When unloading data, which file formats are supported by the COPY INTO <location> command? (Choose two.)
Answer(s): B,D
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 custom role owns multiple tables. If this role is dropped from the system, who becomes the owner of these tables?
Answer(s): D
Which function produces a lateral view of a VARIANT column?
Answer(s): B
Post your Comments and Discuss Snowflake COF-C02 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the COF-C02 content, but please register or login to continue.