Learn about the key purposes of Snowflake storage integration, including secure data access control, simplified credential management, and support for multiple external stages.
Table of Contents
Question
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.
Answer
A. Control access to Snowflake data using a master encryption key that is maintained in the cloud provider’s key management service.
D. Avoid supplying credentials when creating a stage or when loading or unloading data.
F. Manage credentials from multiple cloud providers in one single Snowflake object.
Explanation
Storage integrations in Snowflake serve the following purposes:
A. Control access to Snowflake data using a master encryption key maintained in the cloud provider’s key management service. This ensures data security by leveraging the cloud provider’s robust encryption capabilities.
D. Avoid supplying credentials when creating a stage or when loading or unloading data. Storage integrations simplify the process by securely storing and managing the necessary credentials.
F. Manage credentials from multiple cloud providers in a single Snowflake object. This centralized credential management streamlines the integration of different cloud storage services.
Storage integrations do not directly involve creating private VPC endpoints (E) or supporting multiple external stages using a single Snowflake object (C). While storage integrations can store generated IAM entities (B), this is not one of their primary purposes.
Snowflake SnowPro Advanced Architect certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Snowflake SnowPro Advanced Architect exam and earn Snowflake SnowPro Advanced Architect certification.