Question 110
A user has two approved account roles and needs to read a table from each without constantly changing the primary role. The team proposes this action: Enable permitted secondary roles for SELECT operations where the role model allows it. Why should that action address the stated requirement?
Explanation
Correct Answer
Secondary roles can contribute granted privileges to many session operations together with the primary role. This explains the proposed action: enable permitted secondary roles for SELECT operations where the role model allows it.
Incorrect Answers
ACCOUNT_USAGE views provide historical usage evidence that can be aggregated for cost reporting. That rationale explains query supported usage views in the SNOWFLAKE.ACCOUNT_USAGE schema. It does not establish the mechanism needed here: secondary roles can contribute granted privileges to many session operations together with the primary role.
Dedicated warehouses let teams tune and attribute compute consumption to specific workloads. That rationale explains give the workloads distinct warehouses and monitor their credit usage independently. It does not establish the mechanism needed here: secondary roles can contribute granted privileges to many session operations together with the primary role.
Lineage reveals upstream and downstream relationships used for governance and change impact analysis. That rationale explains use available data lineage information to inspect dependencies among governed objects. It does not establish the mechanism needed here: secondary roles can contribute granted privileges to many session operations together with the primary role.





SnowPro Core COF-C03 Practice Tests