ARA-C01 practice question 9 of 25

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:

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.

Keep practicing

Take the free ARA-C01 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test