How can a row access policy be applied to a table or a view? (Choose two.)
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
Which file formats are supported for unloading data from Snowflake? (Choose two.)
In a Snowflake role hierarchy, what is the top-level role?
By default, which Snowflake role is required to create a share?
Which of the following significantly improves the performance of selective point lookup queries on a table?
Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)
Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)
Which of the following statements describe features of Snowflake data caching? (Choose two.)
Which of the following objects are contained within a schema? (Choose two.)
What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)
What affects whether the query results cache can be used?
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?
When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?
