- All Exams Instant Download
Which Scenario Data engineer decide Materialized views are not useful. Select All that apply.
Which Scenario Data engineer decide Materialized views are not useful. Select All that apply.A . Query results contain a small number of rows and/or columns relative to the base table (the table on which the view is defined).B . Query results contain results that require significant processing.C . The query...
Which one is not the limitation he must be aware of before using MVs in their use case?
Data Engineer identified use case where he decided to use materialized view for query performance. Which one is not the limitation he must be aware of before using MVs in their use case?A . Truncating a materialized view is not supported.B . Time Travel is not currently supported on materialized...
Mark the correct statements about Cache?
Mark the correct statements about Cache?A . Materialized views are more flexible than, but typically slower than, cached results.B . Materialized views are faster than tables because of their “cache” (i.e. the query results for the view); in addition, if data has changed, they can use their “cache” for data...
The smaller the average depth, the better clustered the table is with regards to the specified column?
The smaller the average depth, the better clustered the table is with regards to the specified column?A . TRUEB . FALSEView AnswerAnswer: A
Which System Function can be used by Data engineer to verify whether a stream contains changed data for a table?
Tasks may optionally use table streams to provide a convenient way to continuously process new or changed data. A task can transform new or changed rows that a stream surfaces. Each time a task is scheduled to run, it can verify whether a stream contains change data for a table...
Snowflake does not provide which of following set of SQL functions to support retrieving information about tasks?
Snowflake does not provide which of following set of SQL functions to support retrieving information about tasks?A . SYSTEM$CURRENT_USER_TASK_NAMEB . TASK_HISTORYC . TASK_DEPENDENTSD . TASK_QUERY_HISTORYE . SYSTEM$TASK_DEPENDENTS_ENABLEView AnswerAnswer: C Explanation: SYSTEM$CURRENT_USER_TASK_NAME Returns the name of the task currently executing when invoked from the statement or stored procedure defined by the...
How Robert in this case, Resume this stale pipe?
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...
Which System Function can be used by Data engineer to verify whether a stream contains changed data for a table?
Tasks may optionally use table streams to provide a convenient way to continuously process new or changed data. A task can transform new or changed rows that a stream surfaces. Each time a task is scheduled to run, it can verify whether a stream contains change data for a table...
Which System Function can be used by Data engineer to verify whether a stream contains changed data for a table?
Tasks may optionally use table streams to provide a convenient way to continuously process new or changed data. A task can transform new or changed rows that a stream surfaces. Each time a task is scheduled to run, it can verify whether a stream contains change data for a table...
Streams cannot be created to query change data on which of the following objects? [Select All that Apply]
Streams cannot be created to query change data on which of the following objects? [Select All that Apply]A . Standard tables, including shared tables.B . Views, including secure viewsC . Directory tablesD . Query Log TablesE . External tablesView AnswerAnswer: D Explanation: Streams supports all the listed objects except Query...
