- All Exams Instant Download
Which Function would Data engineer used to recursively resume all tasks in Chain of Tasks rather than resuming each task individually (using ALTER TASK … RESUME)?
Which Function would Data engineer used to recursively resume all tasks in Chain of Tasks rather than resuming each task individually (using ALTER TASK … RESUME)?A . SYSTEM$TASK_DEPENDENTSB . SYSTEM$TASK_DEPENDENTS_ENABLEC . SYSTEM$TASK_DEPENDENTS_RESUMED . SYSTEM$TASK_RECURSIVE_ENABLEView AnswerAnswer: B Explanation: To recursively resume all tasks in a DAG(A Directed Acyclic Graph (DAG) is...
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...
To advance the offset of a stream to the current table version without consuming the change data in a DML operation, which of the following operations can be done by Data Engineer? [Select 2]
To advance the offset of a stream to the current table version without consuming the change data in a DML operation, which of the following operations can be done by Data Engineer? [Select 2]A . using the CREATE OR REPLACE STREAM syntax, Recreate the STREAMB . Insert the current change...
Mark a Data Engineer, looking to implement streams on local views & want to use change tracking metadata for one of its Data Loading use case. Please select the incorrect understanding points of Mark with respect to usage of Streams on Views?
Mark a Data Engineer, looking to implement streams on local views & want to use change tracking metadata for one of its Data Loading use case. Please select the incorrect understanding points of Mark with respect to usage of Streams on Views?A . For streams on views, change tracking must...
John, Data Engineer, do have technical requirements to refresh the External tables Metadata periodically or in auto mode, which approach John can take to meet this technical specification?
John, Data Engineer, do have technical requirements to refresh the External tables Metadata periodically or in auto mode, which approach John can take to meet this technical specification?A . John can use AUTO_REFRESH parameter if the underlying External Cloud host sup-ports this for External tables.B . He can create a...
John, Data Engineer, do have technical requirements to refresh the External tables Metadata periodically or in auto mode, which approach John can take to meet this technical specification?
John, Data Engineer, do have technical requirements to refresh the External tables Metadata periodically or in auto mode, which approach John can take to meet this technical specification?A . John can use AUTO_REFRESH parameter if the underlying External Cloud host sup-ports this for External tables.B . He can create a...
John, Data Engineer, do have technical requirements to refresh the External tables Metadata periodically or in auto mode, which approach John can take to meet this technical specification?
John, Data Engineer, do have technical requirements to refresh the External tables Metadata periodically or in auto mode, which approach John can take to meet this technical specification?A . John can use AUTO_REFRESH parameter if the underlying External Cloud host sup-ports this for External tables.B . He can create a...
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 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 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...
