- (Topic 6)
A user wants to access stored in a stage without authenticating into Snowflake. Which type of URL should be used?
Correct Answer:D
A pre-signed URL provides a way to access objects stored in a stage without requiring authentication to Snowflake. This URL contains all the necessary information for access control, including an expiration time, and it??s signed by the service's credentials. This mechanism allows users or applications to access specific files stored in a cloud storage location (stage) directly, bypassing the need to authenticate into Snowflake, ensuring secure and temporary access to the data.References:Snowflake Documentation on Stages and Data Loading
- (Topic 6)
What activities can a user with the ORGADMIN role perform? (Select TWO).
Correct Answer:BD
The ORGADMIN role in Snowflake is designed to manage organization-level activities. This role can perform several tasks that span across multiple accounts within the organization.
✑ View Usage Information:The ORGADMIN role can view usage statistics and billing
information for all accounts within the organization.
-- Example: Viewing usage information SELECT *
FROM organization_usage_history;
✑ Enable Database Replication:The ORGADMIN role has the authority to enable and manage database replication for accounts within the organization.
-- Example: Enabling database replication
ALTER DATABASE my_database ENABLE REPLICATION TO ACCOUNT other_account;
References:
✑ Snowflake Documentation: Organization Administration
✑ Snowflake Documentation: Replication
- (Topic 4)
What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?
Correct Answer:C
The minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data is the Business Critical Edition. This edition offers enhanced security features necessary for compliance with regulations such as HIPAA and HITRUST CSF4.
- (Topic 6)
What compute resource is used when loading data using Snowpipe?
Correct Answer:C
Snowpipe is Snowflake's continuous data ingestion service that allows for loading data as soon as it's available in a cloud storage stage. Snowpipe uses compute resources managed by Snowflake, separate from the virtual warehouses that users create for querying data. This means that Snowpipe operations do not consume the computational credits of user-created virtual warehouses, offering an efficient and cost-effective way to continuously load data into Snowflake.
References:
✑ Snowflake Documentation: Understanding Snowpipe
- (Topic 1)
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
Correct Answer:CE
Snowflake??s Continuous Data Protection (CDP) encompasses a set of features that help protect data stored in Snowflake against human error, malicious acts, and software failure. Time Travel allows users to access historical data (i.e., data that has been changed or deleted) for a defined period, enabling querying and restoring of data. Fail-safe is an additional layer of data protection that provides a recovery option in the event of significant data loss or corruption, which can only be performed by Snowflake. References:
✑ Continuous Data Protection | Snowflake Documentation1
✑ Data Storage Considerations | Snowflake Documentation2
✑ Snowflake SnowPro Core Certification Study Guide3
✑ Snowflake Data Cloud Glossary
https://docs.snowflake.com/en/user-guide/data-availability.html
- (Topic 5)
How are network policies defined in Snowflake?
Correct Answer:D
Network policies in Snowflake are defined as a set of rules that manage the network-level access to Snowflake accounts. These rules specify which IP addresses or IP ranges are permitted to connect to Snowflake, enhancing the security of Snowflake accounts by preventing unauthorized access. Network policies are an essential aspect of Snowflake's security model, allowing administrators to enforce access controls based on network locations.
References:
✑ Snowflake Documentation: Network Policies