SOL-C01 · Question #30
A security architect is designing a role hierarchy in Snowflake for a data analytics team. They need to grant specific privileges to different user groups. 'DATA ENGINEER' role should have the ability
The correct answer is E. Option E. The actual SQL content for options A through E is missing from your question - all five choices are listed only as "Option A," "Option B," etc., without the SQL commands themselves. To write the explanation you need, please paste the full text of each option (the actual CREATE RO
Question
A security architect is designing a role hierarchy in Snowflake for a data analytics team. They need to grant specific privileges to different user groups. 'DATA ENGINEER' role should have the ability to create and manage databases. 'DATA ANALYST' role should be able to query data from those databases. 'REPORT USER' role needs read-only access to specific views. The architect wants to ensure minimum privilege and enforce role separation. Which of the following sequences of SQL commands would correctly establish this role hierarchy and grant necessary privileges?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
- EOption E
How the community answered
(61 responses)- A10% (6)
- B21% (13)
- C5% (3)
- D2% (1)
- E62% (38)
Explanation
The actual SQL content for options A through E is missing from your question - all five choices are listed only as "Option A," "Option B," etc., without the SQL commands themselves.
To write the explanation you need, please paste the full text of each option (the actual CREATE ROLE, GRANT, and related SQL statements). Once you share those, I can explain exactly why E is correct and where each distractor goes wrong.
Topics
Community Discussion
No community discussion yet for this question.