By default, Snowpark-optimized warehouses are provisioned with Medium size , unless specified otherwise. This provides balanced compute for handling Snowpark operations.
Reference:
Snowflake Docs: Snowpark-Optimized Warehouses

Two key metrics in Snowflake'sQuery Profilethat provide insights for performance improvement are:
Remote Disk IO: This measures the time the query spends waiting on remote disk access, indicating potential performance issues related to I/O bottlenecks.
Pruning: This metric reflects how effectively Snowflake's micro-partition pruning is reducing the data scanned. Better pruning (more partitions excluded) leads to faster query performance, as fewer micro- partitions need to be processed.
These metrics are essential for identifying and addressing inefficiencies in data retrieval and storage access, optimizing overall query performance.

For Snowpipe auto-ingest on Amazon S3, cloud event notifications are configured so Snowflake is notified when new files arrive. The pipe must also be created with AUTO_INGEST = TRUE.
Why A and D are correct:
Amazon S3 event notifications can publish file arrival events through Amazon SNS/SQS integration, and Snowpipe uses those notifications when AUTO_INGEST is enabled.
Reference: Snowflake Documentation - Snowpipe auto-ingest on Amazon S3; CREATE PIPE.
==

The correct answer is D. ACCOUNT_USAGE.TABLE_STORAGE_METRICS .
ACCOUNT_USAGE.TABLE_STORAGE_METRICS provides detailed storage metrics for tables, including active bytes, Time Travel bytes, Fail-safe bytes, and retained-for-clone bytes. This view is more detailed for table-level storage than SHOW TABLES or DESC TABLE.
Why D is correct:
TABLE_STORAGE_METRICS is designed specifically to report table-level storage usage.
Why the other options are incorrect:
A). SHOW TABLES provides table metadata, but not the most detailed storage breakdown.
B). DESC TABLE describes the table structure, such as columns and data types, not detailed storage consumption.
C). ACCOUNT_USAGE.STORAGE_USAGE provides account-level storage usage, not the most detailed table-level storage metrics.
Official Snowflake documentation reference:
Snowflake documentation describes ACCOUNT_USAGE.TABLE_STORAGE_METRICS as a view that provides storage information for tables, including active, Time Travel, Fail-safe, and retained-for-clone storage.
Reference: Snowflake Documentation - ACCOUNT_USAGE.TABLE_STORAGE_METRICS; Snowflake Documentation - Storage usage; SnowPro Core Study Guide - Snowflake Account and Resource Management.
==

Secure data sharing in Snowflake allows users to share various objects between Snowflake accounts without physically copying the data, thus not consuming additional storage. Among the options provided, external tables can be shared through secure data sharing. External tables are used to query data directly from files in a stage without loading the data into Snowflake tables, making them suitable for sharing across different Snowflake accounts.
References:
Snowflake Documentation on Secure Data Sharing
SnowPro Core Certification Companion: Hands-on Preparation and Practice