- (Topic 6)
What type of account can be used to share data with a consumer who does have a Snowflake account?
Correct Answer:
C
A Reader account in Snowflake can be used to share data with a consumer who does not have a Snowflake account. Reader accounts are a type of shared account provided by data providers to external data consumers, allowing them to access and query shared data using Snowflake's web interface without needing their own Snowflake account. References:
✑ Snowflake Documentation: Reader Accounts
- (Topic 6)
A Snowflake user needs to share unstructured data from an internal stage to a reporting tool that does not have Snowflake access.
Which file function should be used?
Correct Answer:
C
The GET_PRESIGNED_URL function in Snowflake generates a presigned URL for a file stored in an internal stage, allowing direct access to the file without requiring Snowflake access. This feature is particularly useful for sharing unstructured data with external applications or tools that do not have direct access to Snowflake. The presigned URL provides temporary access to the file, making it an ideal solution for securely sharing unstructured data from an internal stage with a reporting tool or any other external application.
References:
✑ Snowflake Documentation: Generating Presigned URLs
- (Topic 3)
Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Select TWO).
Correct Answer:
CD
Multi-Factor Authentication (MFA) token caching is typically supported for clients that maintain a persistent connection or session with Snowflake, such as the ODBC driver and Python connector, to reduce the need for repeated MFA challenges. References: Based on general security practices in cloud services as of 2021.
- (Topic 6)
Which command is used to remove files from either external cloud storage or an internal staged
Correct Answer:
B
The REMOVE command in Snowflake is used to delete files from either external cloud storage locations or internal stages. This command helps manage staged files by removing them when they are no longer needed, which is useful for maintaining organization and managing storage costs.
References:
✑ Snowflake Documentation: REMOVE Command
- (Topic 3)
What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?
Correct Answer:
A
Snowflake provides Multi-Factor Authentication (MFA) support as an integrated feature, powered by the Duo Security service. This service is managed completely by Snowflake, and users do not need to sign up separately with Duo1