SOL-C01 · Question #38
A data science team needs to access data from several databases and schemas for model training. To simplify access management, you create a custom role, DATA SCIENCE ROLE. You need to grant this role
The correct answer is C. Option C. The answer choices appear to be missing their content - they're labeled "Option A" through "Option E" but no actual SQL statements or descriptions were included. Could you paste the actual text of each option? For example, they likely contain GRANT statements like: ``sql GRANT SE
Question
A data science team needs to access data from several databases and schemas for model training. To simplify access management, you create a custom role, DATA SCIENCE ROLE. You need to grant this role the ability to SELECT from all tables in any schema across the following databases: DB ANALYTICS, 'DB REPORTING'. Which of the following is the MOST efficient approach, minimizing the number of GRANT statements while adhering to least privilege?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
- EOption E
How the community answered
(39 responses)- A5% (2)
- B8% (3)
- C62% (24)
- D3% (1)
- E23% (9)
Explanation
The answer choices appear to be missing their content - they're labeled "Option A" through "Option E" but no actual SQL statements or descriptions were included.
Could you paste the actual text of each option? For example, they likely contain GRANT statements like:
GRANT SELECT ON ALL TABLES IN DATABASE DB_ANALYTICS TO ROLE DATA_SCIENCE_ROLE;
Once you share the option details, I can explain exactly why C is correct and why each distractor fails.
Topics
Community Discussion
No community discussion yet for this question.