Snowflake DEA-C01 Practice Test - Questions Answers, Page 4

Search optimization works best to improve the performance of a query when the following conditions are true:[Select All that apply]

Regular views do not cache data, and therefore cannot improve performance by caching?

Mark the correct statements about Cache?

Marko, a Data Engineer is using Snowpipe for data loading in micro batches for one of the Finance

Data workloads. There are set of files he attempted to load into the snowflake table using Snow-pipe.

While monitoring he found that there are set of files has multiple issue, He queried the COPY_HISTORY view & checked the STATUS column which indicates whether a particular set of files was loaded, partially loaded, or failed to load. But he wants to view all errors in the files along with Load status, how he can check all errors?

Robert, A Data Engineer, found that Pipe become stale as it was paused for longer than the limited retention period for event messages received for the pipe (14 days by default) & also the previous pipe owner transfers the ownership of this pipe to Robert role while the pipe was paused. How Robert in this case, Resume this stale pipe?

How Data Engineer can do Monitoring of Files which are Staged Internally during Continuous data pipelines loading process? [Select all that apply]

To help manage STAGE storage costs, Data engineer recommended to monitor stage files and remove them from the stages once the data has been loaded and the files which are no longer needed.

Which option he can choose to remove these files either during data loading or afterwards?

Pascal, a Data Engineer, have requirement to retrieve the 10 most recent executions of a specified task (completed, still running, or scheduled in the future) scheduled within the last hour, which of the following is the correct SQL Code ?

Snowflake does not provide which of following set of SQL functions to support retrieving information about tasks?