Question 70
A new reporting analyst can sign in but cannot SELECT from the finance table using the active role. After implementing the approach, which observation best demonstrates the required outcome?
Explanation
Correct Answer
The intended role can query finance data while an unrelated role remains unable to read it. This demonstrates the outcome for the stated requirement rather than just a saved configuration.
Incorrect Answers
Candidate sensitive columns are discovered and mapped for approval of safeguards. That measures a different outcome: data stewards need to identify which previously unlabeled tables contain likely personal information. In this case, verify that the intended role can query finance data while an unrelated role remains unable to read it.
The owner can isolate specific high-cost query patterns and their execution context. That measures a different outcome: a performance owner wants to identify which expensive SQL statements consumed warehouse time last week. In this case, verify that the intended role can query finance data while an unrelated role remains unable to read it.
Usage reports separate the workloads' warehouse costs in a repeatable way. That measures a different outcome: two business units contend over warehouse credits and need separately accountable compute usage. In this case, verify that the intended role can query finance data while an unrelated role remains unable to read it.





SnowPro Core COF-C03 Practice Tests