- (Topic 4)
A user with which privileges can create or manage other users in a Snowflake account? (Select TWO).
Correct Answer:DE
A user with the OWNERSHIP privilege on a user object or the CREATE USER privilege on the account can create or manage other users in a Snowflake account56.
- (Topic 1)
A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?
Correct Answer:A
The list command in Snowflake is used to validate and display the list of files in a specified stage. When a user has unloaded data to a stage, running the list @file stage command will show all the files that have been uploaded to that stage, allowing the user to verify the data that was unloaded.
References:
✑ Snowflake Documentation on Stages
✑ SnowPro® Core Certification Study Guide
- (Topic 5)
What happens when a network policy includes values that appear in both the allowed and blocked IP address list?
Correct Answer:B
In Snowflake, when setting up a network policy that specifies both allowed and blocked IP address lists, if an IP address appears in both lists, access from that IP address will be denied. The reason is that Snowflake prioritizes security, and the presence of an IP address in the blocked list indicates it should not be allowed regardless of its presence in the allowed list. This ensures that access controls remain stringent and that any potentially unsafe IP addresses are not inadvertently permitted access.
References:
✑ Snowflake Documentation: Network Policies
- (Topic 3)
What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)
Correct Answer:CE
Clones in Snowflake have the advantage of being created almost instantly and saving space by not duplicating storage. This is due to Snowflake??s zero-copy cloning feature, which allows for the creation of object clones without the additional storage costs typically associated with data duplication23. Clones are independent of the original table and do not stay in sync with it, nor do they inherently have better query performance. However, they do inherit the time travel history from the original table at the time of cloning
- (Topic 6)
Which DDL/DML operation is allowed on an inbound data share?
Correct Answer:D
In Snowflake, an inbound data share refers to the data shared with an account by another account. The only DDL/DML operation allowed on an inbound data share is SELECT. This restriction ensures that the shared data remains read-only for the consuming account, maintaining the integrity and ownership of the data by the sharing account.
References:
✑ Snowflake Documentation: Using Data Shares