Snowflake DEA-C01 SnowPro Advanced Data Engineer Certification Online Training
Snowflake DEA-C01 Online Training
The questions for DEA-C01 were last updated at Jan 02,2025.
- Exam Code: DEA-C01
- Exam Name: SnowPro Advanced Data Engineer Certification
- Certification Provider: Snowflake
- Latest update: Jan 02,2025
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_DAYS
- B . DATA_RETENTION_TIME_IN_DAYS
- C . DATA_EXTENSION_TIME_IN_DAYS
- D . None of the above
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_DAYS
- B . DATA_RETENTION_TIME_IN_DAYS
- C . DATA_EXTENSION_TIME_IN_DAYS
- D . None of the above
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_DAYS
- B . DATA_RETENTION_TIME_IN_DAYS
- C . DATA_EXTENSION_TIME_IN_DAYS
- D . None of the above
at(timestamp => (select current_timestamp())); Select the Correct Query Execution Output option below:
- A . Developer missed to create stream on the source table which can further query to capture DML records.
- B . Select query will fail with error: ‘SQL compilation error-Incorrect Keyword "Chang-es()" found’
- C . No Error reported, select command gives Changed records with Metadata columns as change tracking enabled on the Source views & its underlying tables.
- D . Select statement complied but gives erroneous results.
Which column provides information when the stream became stale or may become stale if not consumed?
- A . STREAM_STALE_PERIOD
- B . STALE_PERIOD_AFTER
- C . STALE_STREAM_PERIOD
- D . STALE_AFTER
When created, a stream logically takes an initial snapshot of every row in the source object and the contents of a stream change as DML statements execute on the source table.
A Data Engineer, Sophie Created a view that queries the table and returns the CURRENT_USER and CURRENT_TIMESTAMP values for the query transaction. A Stream has been created on views to capture CDC.
Tony, another user inserted the data e.g.
insert into <table> values (1),(2),(3);
Emily, another user also inserted the data e.g.
insert into <table> values (4),(5),(6);
What will happened when Different user queries the same stream after 1 hour?
- A . All the 6 records would be shown with METADATA$ACTION as ‘INSERT’ out of which 3 records would be displayed with username ‘Tony’ & rest 3 records would be displayed with username ‘Emily’.
- B . All the Six Records would be displayed with CURRENT_USER & CUR-RENT_TIMESTAMP while querying Streams.
- C . All the Six records would be displayed with User ‘Sohpie’ Who is the owner of the View.
- D . User would be displayed with the one who queried during the session, but Recorded timestamp would be of past 1 hour i.e. actual records insertion time.
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_DEPENDENTS
- B . SYSTEM$TASK_DEPENDENTS_ENABLE
- C . SYSTEM$TASK_DEPENDENTS_RESUME
- D . SYSTEM$TASK_RECURSIVE_ENABLE
Steven created the task, what additional privileges required by Steven on the task so that he can suspend or resume the tasks?
- A . Steven is already owner of the task; he can execute the task & suspend/resume the task without any additional privileges.
- B . In addition to the task owner, a Steven Role must have OPERATE privilege on the task so that he can suspend or resume the task.
- C . Steven must have SUSPEND privilege on the task so that he can suspend or resume the task.
- D . Steven needs to have Global Managed RESUME privilege by TASK administrator.
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 task that executes an ALTER EXTERNAL TABLE … REFRESH statement every 5 minutes.
- C . External table cannot be scheduled via Snowflake Tasks, 3rd party tools/scripts needs to be used provided by External cloud storage provider.
- D . Snowflake implicitly take care this Infrastructure needs, as underlying warehouse layer internally manage the refresh. No action needed from John.
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 . SISENSE
- B . SELECT STAR
- C . ALATION
- D . PROTEGRITY
Latest DEA-C01 Dumps Valid Version with 100 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
