To show all privileges granted to a specific schema, the command SHOW GRANTS ON SCHEMA
<schema_name> should be used3. In this case, it would be SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING. References: [COF-C02] SnowPro Core Certification Exam Study Guide

The COPY INTO <location> command is used to unload data from Snowflake tables to external locations, typically cloud storage or a Snowflake stage. Supported destinations include:
* External stages: e.g., S3, Azure Blob Storage, Google Cloud Storage
* Internal named stages: Snowflake-managed storage
Local file systems are not supported as unload targets.
Reference:
Snowflake Docs: COPY INTO <location> (unloading)
"You can unload data to: Internal Named Stages and External Stages (S3, Azure, GCS)"

A pre-signed URL provides a way to access objects stored in a stage without requiring authentication to Snowflake. This URL contains all the necessary information for access control, including an expiration time, and it's signed by the service's credentials. This mechanism allows users or applications to access specific files stored in a cloud storage location (stage) directly, bypassing the need to authenticate into Snowflake, ensuring secure and temporary access to the data.
References: Snowflake Documentation on Stages and Data Loading

The default value for auto-suspending a Virtual Warehouse in the Snowflake Web Interface (UI) is 10 minutes. This setting helps manage compute costs by automatically suspending warehouses that are not in use, ensuring that compute resources are efficiently allocated and not wasted on idle warehouses.
References:
* Snowflake Documentation: Virtual Warehouses

Federated authentication in Snowflake allows users to use their organizational credentials to log in to Snowflake, leveraging Single Sign-On (SSO). The key activities enabled by this setup include:
* B. Initiating user sessions: Federated authentication streamlines the process of starting a user session in Snowflake by using the existing authentication mechanisms of an organization.
* C. Logging into Snowflake: It simplifies the login process, allowing users to authenticate with their organization's identity provider instead of managing separate credentials for Snowflake.
References:
* Snowflake Documentation: Configuring Federated Authentication