Free Snowflake DEA-C01 Exam Questions

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)?

Michael, a Data Engineer Running a Data query to achieve Union of Data sets coming from Multi-ple data sources, later he figured out that Data processing query is taking more time than expected. He started analyzing the Query performance using query profile interface. He discovered & realized that he used UNION when the UNION ALL semantics was sufficient. Which Extra Data Processing Operator Michael figured out while doing query profile analysis in this case which helps him to identify this performance bottlenecks?

Which of the below query will be used to identify the long running queries in the last 1 hour?

What will happen if you try to create a materialized view as below
    create or replace materialized view employee_view as
        select id, role, name
            from employee where role = current_role();

Which of the below concepts/functions helps while implementing advanced Column-level Security?