Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam
Question 53

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

    Correct Answer: B, D, F

    Creating a storage integration in Snowflake can serve several purposes. First, it can store a generated identity and access management (IAM) entity for an external cloud provider, regardless of the hosting provider, ensuring consistent access control across environments. Second, it allows users to avoid supplying credentials when creating a stage or when loading or unloading data, simplifying the process and enhancing security. Third, it can manage credentials from multiple cloud providers in a single Snowflake object, providing a unified and efficient way to handle multi-cloud environments.

Discussion
hillcat111Options: BCD

Answer is B,C,D and is validated

OscarWest2023Options: BCD

B,C,D https://docs.snowflake.com/en/sql-reference/sql/create-storage-integration 1 - A storage integration is a Snowflake object that stores a generated identity and access management (IAM) entity for your external cloud storage. 2 - This option allows users to avoid supplying credentials when creating stages or when loading or unloading data. 3 - A single storage integration can support multiple external stages. The URL in the stage definition must align with the storage location specified for the STORAGE_ALLOWED_LOCATIONS parameter.

hillcat111Options: CDF

changing to C,D,F

hillcat111Options: BDF

Answer here B, D, F