To change permissions for new objects in a managed access schema, a user should be granted the MANAGE GRANTS global privilege. This privilege allows the user to manage access control through grants on all securable objects within Snowflake2. References: [ COF-C03 ] SnowPro Core Certification Exam Study Guide

Alation is known for specializing in data catalog solutions and is a partner of Snowflake. Data catalog solutions are essential for organizations to effectively manage their metadata and make it easily accessible and understandable for users, which aligns with the capabilities provided by Alation.
References:
[ COF-C03 ] SnowPro Core Certification Exam Study Guide
Snowflake's official documentation and partner listings

The correct answer is C. Auto-ingest Snowpipe .
Auto-ingest Snowpipe continuously loads data from staged files as soon as notifications indicate that new files are available in cloud storage. It is designed for near-real-time ingestion from external stages.
Corrected wording:
A clearer version of the question is:
What can load data from an external stage shortly after the data arrives?
Why C is correct:
Auto-ingest Snowpipe uses cloud messaging notifications to detect when new files arrive in an external stage.
Snowpipe then automatically loads the new files into a target Snowflake table using the COPY statement defined in the pipe.
Why the other options are incorrect:
A). A scheduled COPY command with a task can load data periodically, but it does not automatically load files right after arrival unless the schedule happens to align.
B). The Snowflake Kafka Connector streams data from Kafka topics into Snowflake, but the question specifically asks about loading from an external stage.
D). An external table lets Snowflake query data in external storage, but it does not load the data into Snowflake tables.
Official Snowflake documentation reference:
Snowflake documentation describes Snowpipe auto-ingest as a feature that loads data from staged files automatically after receiving event notifications from cloud storage.
Reference: Snowflake Documentation - Snowpipe; Snowflake Documentation - Auto-ingest Snowpipe; SnowPro Core Study Guide - Data Loading and Unloading.
==

The settings shown in the image indicate that the data retention time in days is configured at two different levels: the account level and the object level. At the account level, theMIN_DATA_RETENTION_TIME_IN_DAYSis set to 5 days, and at the object level, theDATA_RETENTION_TIME_IN_DAYSis set to 2 days. Since the object level setting has a lower value, it takes precedence over the account level setting for the specific object. Therefore, the data will be retained for
2 days at the object level.
References: Snowflake Documentation on Data Retention Policies