The read_only_rl role has a comment indicating it is limited to querying tables in schema_1.

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

The read_only_rl role has a comment indicating it is limited to querying tables in schema_1.

Explanation:
The statement tests how to interpret a role’s metadata about its allowed scope. If the read_only_rl role has a comment that it is limited to querying tables in a specific schema (schema_1), the precise takeaway is that the role’s description indicates it can only access that particular schema. That’s exactly what option describing the role as having a comment that it can only access a specific schema is saying, so it’s the best fit. In practice, actual access is controlled by privileges granted (like USAGE on the schema and SELECT on tables), but the question focuses on what the comment communicates about scope.

The statement tests how to interpret a role’s metadata about its allowed scope. If the read_only_rl role has a comment that it is limited to querying tables in a specific schema (schema_1), the precise takeaway is that the role’s description indicates it can only access that particular schema. That’s exactly what option describing the role as having a comment that it can only access a specific schema is saying, so it’s the best fit.

In practice, actual access is controlled by privileges granted (like USAGE on the schema and SELECT on tables), but the question focuses on what the comment communicates about scope.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy