A team uses a Snowflake task to copy data from an internal stage into a landing table. The task is owned by role LOAD_OWNER. A new analyst role, ANALYST, needs to be able to view the task's run history and see when it last succeeded, but must NOT be able to modify the task or see the data in the landing table. What is the minimum set of privileges to grant to ANALYST?

OWNERSHIP on the task and USAGE on the database and schema.

MONITOR on the task and USAGE on the database and schema containing the task.

SELECT on the landing table and USAGE on the database and schema.

OPERATE on the task and USAGE on the database and schema.

SnowflakeSnowPro Advanced — Data Engineer

Domain 5Objective 2

Manage Access Control for Data Pipelines DEA-C02 Practice Questions (Page 2)

Part of the Data Governance domain, which accounts for 14% of the DEA-C02 exam.

15questions here

3free pages

4concepts

14%of the exam

Questions 6–10

6foundation · easy
A role needs to read data from a stage that contains files for a pipeline. Which privilege must be granted on the stage to allow the role to list and read files?
Select an answer first
7foundation · easy
A data engineer is designing access controls for a new data pipeline. Which principle ensures that each role is granted only the minimum privileges required to perform its specific tasks?
Select an answer first
8application · medium
A team uses a Snowflake task to copy data from an internal stage into a landing table. The task is owned by role LOAD_OWNER. A new analyst role, ANALYST, needs to be able to view the task's run history and see when it last succeeded, but must NOT be able to modify the task or see the data in the landing table. What is the minimum set of privileges to grant to ANALYST?
Select an answer first
9foundation · easy
Which Snowflake feature provides a detailed record of when specific columns in a table were accessed by queries, useful for auditing data pipeline access?
Select an answer first
10foundation · easy
Which Snowflake feature can be used to enforce restrictions on user sessions, such as limiting idle timeout or blocking certain client types, to secure pipeline execution?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DEA-C02

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “DEA-C02” is a trademark of its owner, used for identification only.

Manage Access Control for Data Pipelines DEA-C02 Practice Questions (Page 2)

Questions 6–10

A role needs to read data from a stage that contains files for a pipeline. Which privilege must be granted on the stage to allow the role to list and read files?

A data engineer is designing access controls for a new data pipeline. Which principle ensures that each role is granted only the minimum privileges required to perform its specific tasks?

Which Snowflake feature provides a detailed record of when specific columns in a table were accessed by queries, useful for auditing data pipeline access?

Which Snowflake feature can be used to enforce restrictions on user sessions, such as limiting idle timeout or blocking certain client types, to secure pipeline execution?

Keep studying — Data Governance