- All Exams Instant Download
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...
Clones can be cloned, with no limitations on the number or iterations of clones that can be created (e.g. you can create a clone of a clone of a clone, and so on), which results in a n-level hierarchy of cloned objects, each with their own portion of shared and independent data storage?
Clones can be cloned, with no limitations on the number or iterations of clones that can be created (e.g. you can create a clone of a clone of a clone, and so on), which results in a n-level hierarchy of cloned objects, each with their own portion of shared and...
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...
Regular views do not cache data, and therefore cannot improve performance by caching?
Regular views do not cache data, and therefore cannot improve performance by caching?A . TRUEB . FALSEView AnswerAnswer: A Explanation: Regular views do not cache data, and therefore cannot improve performance by caching.
Which of the following security and governance tools/technologies are known to provide native connectivity to Snowflake? [Select 2]
Which of the following security and governance tools/technologies are known to provide native connectivity to Snowflake? [Select 2]A . ALTRB . BaffleC . BIG SquidD . DataikuE . ZeplView AnswerAnswer: A, B Explanation: Security and governance tools ensure sensitive data maintained by an organization is protected from inappropriate access and...
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...
