https://docs.snowflake.com/en/sql-reference/data-sharing-usage

Query pruning in Snowflake refers to the optimization technique where the system reduces the amount of data scanned by a query based on the query conditions. This typically involves skipping unnecessary data partitions that do not contribute to the query result. The effectiveness of this technique can be observed through:
* Option A: Partitions scanned. This statistic indicates how many data partitions were actually scanned as
* a result of query pruning, showing the optimization in action.
* Option C: Bytes scanned. This measures the volume of data physically read during query execution, and a reduction in this number indicates effective query pruning, as fewer bytes are read when unnecessary partitions are skipped.
Options B, D, and E do not directly relate to observing the effects of query pruning. "Partitions total" shows the total available, not the impact of pruning, while "Bytes read from result" and "Bytes written" relate to output rather than the efficiency of data scanning.References:Snowflake documentation on performance tuning and query optimization techniques, specifically how query pruning affects data access.

Snowflake supports several semi-structured data formats for loading data. The supported formats include JSON, Avro, and Parquet12. These formats allow for efficient storage and querying of data that does not conform to a traditional relational database schema.

Network policies in Snowflake can be applied to users and accounts. These policies control inbound access to the Snowflake service and internal stages, allowing or denying access based on the originating network identifiers12.

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; Reference:
Snowflake Documentation: Organization Administration
Snowflake Documentation: Replication