
Explanation:
The SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function is specifically used by ORGADMIN role users to configure account-level settings. According to Snowflake documentation and the community consensus with 100% agreement and upvoted comments, this function enables two key features: Client redirect (B) - which allows redirecting client connections to different accounts, and Account and database replication (E) - which enables replication of databases across different Snowflake accounts. The other options are incorrect: Clustering (A) is managed through table settings, Fail-safe (C) is a built-in data protection feature that cannot be enabled/disabled via this function, and Search optimization service (D) is configured at the table level.
Which two Snowflake features can be enabled by a user with the ORGADMIN role using the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?
A
Clustering
B
Client redirect
C
Fail-safe
D
Search optimization service
E
Account and database replication
No comments yet.