- All Exams Instant Download
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 Best techniques she should consider here?
Melissa, Senior Data Engineer, looking out to optimize query performance for one of the Critical Control Dashboard, she found that most of the searches by the users on the control dashboards are based on Equality search on all the underlying columns mostly. Which Best techniques she should consider here?A ....
Mark the Correct Statements:
Mark the Correct Statements: Statement 1. Snowflake’s zero-copy cloning feature provides a convenient way to quickly take a “snapshot” of any table, schema, or database. Statement 2. Data Engineer can use zero-copy cloning feature for creating instant backups that do not incur any additional costs (until changes are made to...
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...
He has been asked to extend the data retention period of the stream for 90 days, which parameter he can utilize to enable this extension?
Stuart, a Lead Data Engineer in MACRO Data Company created streams on set of External tables. He has been asked to extend the data retention period of the stream for 90 days, which parameter he can utilize to enable this extension?A . MAX_DATA_EXTENSION_TIME_IN_DAYSB . DATA_RETENTION_TIME_IN_DAYSC . DATA_EXTENSION_TIME_IN_DAYSD . None of...
Which column provides information when the stream became stale or may become stale if not consumed?
Which column provides information when the stream became stale or may become stale if not consumed?A . STREAM_STALE_PERIODB . STALE_PERIOD_AFTERC . STALE_STREAM_PERIODD . STALE_AFTERView AnswerAnswer: D Explanation: execute SHOW STREAMS command. Column Name: STALE_AFTER Timestamp when the stream became stale or may become stale if not consumed. The value is...
If you need to connect to Snowflake using a BI tool or technology, which of the following BI tools and technologies are known to provide native connectivity to Snowflake?
If you need to connect to Snowflake using a BI tool or technology, which of the following BI tools and technologies are known to provide native connectivity to Snowflake?A . SISENSEB . SELECT STARC . ALATIOND . PROTEGRITYView AnswerAnswer: A Explanation: SISENSE is BI tools and technologies which is known...
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...
Please select what Alex is doing wrong here?
group by m.item_id; Step 3: After 1 hour, he decided to temporarily suspend the use (and maintenance) of the DataReportMV materialized view for cost saving purpose. alter materialized view DataReportMV suspend; Please select what Alex is doing wrong here?A . A materialized view, DataReportMV does not support Join operations, so...
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...
