NEW QUESTION 120
SNOWPIPE_AUTO_INGEST is supported for external stages only

NEW QUESTION 121
Consider the following COPY command which is loading data with CSV format into a Snowflake table from an internal stage through a data transformation query.

This command results in the following error:
SQL compilation error: invalid parameter ‘validation_mode’
Assuming the syntax is correct, what is the cause of this error?

NEW QUESTION 122
Which of the two are limitations of the insertReport API of SnowPipe?

NEW QUESTION 123
Data sharing is supported only between provider and consumer accounts in same region

NEW QUESTION 124
While choosing a cluster key, what is recommended by snowflake?

NEW QUESTION 125
You got a response code of 429 from the insertFiles API.
What does that mean?

NEW QUESTION 126
To convert JSON null value to SQL null value, you will use

NEW QUESTION 127
Which of the below objects cannot be replicated?

NEW QUESTION 128
Dynamic data masking is supported in which editions of snowflake

NEW QUESTION 129
An Architect would like to save quarter-end financial results for the previous six years.
Which Snowflake feature can the Architect use to accomplish this?

NEW QUESTION 130
You ran the below query. I have a warehouse with auto suspend set at 5 seconds
SELECT * FROM INVENTORY;
The query profile looks like as below. Please see below ‘Percentage scanned from cache’ is 0%

You ran the query again before 5 seconds has elapsed and the query profile looks as below. Look at the ‘Percentage scanned for cache’, it is 75%

You ran the query again after 5 seconds. The query profile looks as below. Look at the ‘Percentage scanned from cache’, it is zero again.

Why is this happening?

NEW QUESTION 131
A healthcare company is deploying a Snowflake account that may include Personal Health Information (PHI). The company must ensure compliance with all relevant privacy standards.
Which best practice recommendations will meet data protection and compliance requirements? (Choose three.)

NEW QUESTION 132
EXECUTE TASK privilege can be granted by whom

NEW QUESTION 133
As of today snowflake supports replication for databases only

NEW QUESTION 134
What is the data size limit for loading into a variant column?

NEW QUESTION 135
While creating a clustering key, what is the recommendation for maximum number of columns that you can include as part of the key?

NEW QUESTION 136
When does a multi-cluster warehouse shuts down with default scaling policy

NEW QUESTION 137
Privileges granted on database objects are not replicated to a secondary database.