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

What are purposes for creating a storage integration? (Choose three.)
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.

View Answer

Answer: BCD

Explanation:

The purpose of creating a storage integration in Snowflake includes:

B. Store a generated identity and access management (IAM) entity for an external cloud provider – This helps in managing authentication and authorization with external cloud storage without embedding credentials in Snowflake. It supports various cloud providers like AWS, Azure, or GCP, ensuring that the identity management is streamlined across platforms.

C. Support multiple external stages using one single Snowflake object – Storage integrations allow you to set up access configurations that can be reused across multiple external stages, simplifying the management of external data integrations.

D. Avoid supplying credentials when creating a stage or when loading or unloading data – By using a storage integration, Snowflake can interact with external storage without the need to continuously manage or expose sensitive credentials, enhancing security and ease of operations.

Reference: Snowflake documentation on storage integrations, found within the SnowPro Advanced:

Architect course materials.