SnowPro Advanced: Architect — Question 51

What are purposes for creating a storage integration? (Choose three.)

Answer options

• A. Control access to Snowflake data using a master encryption key that is maintained in the cloud provider’s key management service.
• B. Store a generated identity and access management (IAM) entity for an external cloud provider regardless of the cloud provider that hosts the Snowflake account.
• C. Support multiple external stages using one single Snowflake object.
• D. Avoid supplying credentials when creating a stage or when loading or unloading data.
• E. Create private VPC endpoints that allow direct, secure connectivity between VPCs without traversing the public internet.
• F. Manage credentials from multiple cloud providers in one single Snowflake object.

Correct answer: B, C, D

Explanation

The correct answers B, C, and D highlight key purposes of storage integration, such as managing IAM entities across different providers, supporting multiple external stages in one object, and simplifying credential management during data operations. Options A and E, while relevant to security and connectivity, do not directly pertain to the specific purposes of storage integration in Snowflake. Option F, although relevant, does not reflect the primary focus of integration for external stages and credential handling.