Question 270
Consider this Snowflake situation: A company wants private connectivity to Snowflake without routing sensitive application sessions across the public Internet. Which platform behavior BEST explains the appropriate solution?
Explanation
Correct Answer
The decisive Snowflake behavior is: Private connectivity mechanisms use supported provider networking paths with their own prerequisites. It supports the response: Evaluate supported cloud-provider private connectivity endpoints for the account region and edition. Confirm it with this observable result: An authorized client resolves and reaches the approved private endpoint while public access follows the documented policy. Distinguish this mechanism from superficially related Snowflake features.
Incorrect Answers
This principle describes a separate cause: ACCOUNTADMIN is highly privileged, and normal application execution should use narrower functional roles. The reported condition is governed by: Private connectivity mechanisms use supported provider networking paths with their own prerequisites. The two mechanisms should not be conflated.
Secure views can limit disclosed query definitions and sharing surfaces when configured for the use case. That explanation applies to a different technical failure. Here the controlling principle is: Private connectivity mechanisms use supported provider networking paths with their own prerequisites.
The offered statement is true for this other mechanism: A properly applied masking policy follows the protected column rather than the specific SQL alias. It does not explain the facts described here, which follow from: Private connectivity mechanisms use supported provider networking paths with their own prerequisites.