- (Topic 1)
What SQL command would be used to view all roles that were granted to user.1?
Correct Answer:
A
The correct command to view all roles granted to a specific user in Snowflake is SHOW GRANTS TO USER <user_name>;. This command lists all access control privileges that have been explicitly granted to the specified user.
References: SHOW GRANTS | Snowflake Documentation
- (Topic 6)
What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?
Correct Answer:
A
TheENABLE_ACCOUNT_DATABASE_REPLICATIONparameter is a critical setting in Snowflake that allows or restricts the replication of databases across Snowflake accounts. Given the significant impact of this parameter on data management and security, only the ACCOUNTADMINrole has the minimum required privileges to set or modify it. This ensures that only users with the highest level of access and responsibility within the Snowflake environment can controldatabase replication settings, maintaining strict governance and security standards.References:Snowflake Documentation on Database Replication
- (Topic 1)
Which command is used to unload data from a Snowflake table into a file in a stage?
Correct Answer:
A
The COPY INTO command is used in Snowflake to unload data from a table into a file in a stage. This command allows for the export of data from Snowflake tables into flat files, which can then be used for further analysis, processing, or storage in external systems.
References:
✑ Snowflake Documentation on Unloading Data
✑ Snowflake SnowPro Core: Copy Into Command to Unload Rows to Files in Named Stage
- (Topic 3)
Which user object property requires contacting Snowflake Support in order to set a value for it?
Correct Answer:
B
The user property ??MINS TO BYPASS MFA?? in Snowflake allows temporary bypass of MFA for a user, which can be set by an account administrator without contacting Snowflake Support2.
- (Topic 5)
If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 seconds, for how many seconds is it billed?
Correct Answer:
C
Snowflake bills virtual warehouse usage in one-minute increments, rounding up to the nearest minute for any partial minute of compute time used. If a virtual warehouse runs for 61 seconds and then, after being shut down, restarts and runs for an additional 30 seconds, the total time billed would be 120 seconds or 2 minutes. The first 61 secondsare rounded up to 2 minutes, and the subsequent 30 seconds are within a new minute, which is also rounded up to the nearest minute.
References:
✑ Snowflake Documentation: Virtual Warehouses Billing
