Question 250
Consider this Snowflake situation: A BI service must obtain time-limited delegated authorization instead of storing a long-lived account password. Which platform behavior BEST explains the appropriate solution?
Explanation
Correct Answer
The decisive Snowflake behavior is: OAuth access tokens support delegated or scoped authentication for compatible clients. It supports the response: Use an approved Snowflake OAuth integration and appropriate client authorization flow. Confirm it with this observable result: A valid scoped token permits an authorized sample query and an expired token is rejected. Distinguish this mechanism from superficially related Snowflake features.
Incorrect Answers
This principle describes a separate cause: Snowflake role inheritance and active role selection both affect effective access. The reported condition is governed by: OAuth access tokens support delegated or scoped authentication for compatible clients. The two mechanisms should not be conflated.
Fast individual queries can still accumulate high credit consumption when run frequently or on large warehouses. That explanation applies to a different technical failure. Here the controlling principle is: OAuth access tokens support delegated or scoped authentication for compatible clients.
The offered statement is true for this other mechanism: Repeated executions may consume additional warehouse compute independently of whether the result is identical. It does not explain the facts described here, which follow from: OAuth access tokens support delegated or scoped authentication for compatible clients.