- 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 option he can choose to remove these files either during data loading or afterwards?
To help manage STAGE storage costs, Data engineer recommended to monitor stage files and re-move 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?A . He...
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...
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...
Mark the correct Statements with respect to Secure views & its creation in the SnowFlake Account?
Mark the correct Statements with respect to Secure views & its creation in the SnowFlake Account?A . For a secure view, internal optimizations can indirectly expose data & the view definition is visible to other users.B . Secure views should not be used for views that are defined solely for...
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...
Which one of the following does not shows key similarities and differences between tables, regular views, cached query results, and materialized views while choosing any of them by David?
David, a Lead Data engineer with XYZ company looking out to improve query performance & other benefits while working with Tables, Regular Views, MVs and Cached Results. Which one of the following does not shows key similarities and differences between tables, regular views, cached query results, and materialized views while...
Which option he can choose to remove these files either during data loading or afterwards?
To help manage STAGE storage costs, Data engineer recommended to monitor stage files and re-move 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?A . He...
Partition columns optimize query performance by pruning out the data files that do not need to be scanned (i.e. partitioning the external table).
Partition columns optimize query performance by pruning out the data files that do not need to be scanned (i.e. partitioning the external table). Which pseudocolumn of External table evaluate as an expression that parses the path and/or filename information.A . METADATA$ROW_NUMBERB . METADATA$COLUMNNAMEC . METADATA$FILEPATHD . METADATA$FILENAMEView AnswerAnswer: D Explanation:...
