The correct answers are A. Document AI and E. Cortex Analyst .
Snowflake Cortex is Snowflake's integrated AI and machine learning capability set. It includes features for working with language models, document extraction, natural language analytics, and AI-powered application development.
Why A is correct:
Document AI is part of Snowflake Cortex. It is used to extract information from unstructured documents using AI.
Why E is correct:
Cortex Analyst is part of Snowflake Cortex. It enables natural language questions over structured data by using semantic models and Cortex capabilities.
Why the other options are incorrect:
B). Snowpipe is a data ingestion service, not part of the Cortex AI suite.
C). Streams are change data capture objects used to track table changes, not Cortex AI components.
D). Secure views are security/governance objects used to protect view definitions and support secure data sharing, not Cortex AI components.
Official Snowflake documentation reference:
Snowflake documentation describes Snowflake Cortex as a set of AI and ML capabilities and includes features such as Document AI and Cortex Analyst. Snowpipe, streams, and secure views belong to other Snowflake feature areas.
Reference: Snowflake Documentation - Snowflake Cortex; Snowflake Documentation - Document AI; Snowflake Documentation - Cortex Analyst; SnowPro Core Study Guide - Snowflake Architecture.

In Snowflake, the default access level for any securable object (such as a table, view, or schema) is "No access" until explicit access is granted. This means that when an object is created, only the owner of the object and roles with the necessary privileges can access it. Other users or roles will not have any form of access to the object until it is explicitly granted.
This design adheres to the principle of least privilege, ensuring that access to data is tightly controlled and that users and roles only have the access necessary for their functions. To grant access, the owner of the object or a role with the GRANT option can use the GRANT statement to provide specific privileges to other users or roles.
For example, to grant SELECT access on a table to a specific role, you would use a command similar to:
GRANT SELECT ON TABLE my_table TO ROLE my_role;
Reference: Snowflake Documentation on Access Control (https://docs.snowflake.com/en/user-guide/security- access-control-overview.html)

The correct answer is B. To track DML changes that have been made to tables .
A stream is a Snowflake object used for change data capture. It records changes made to a source table so those changes can be consumed later by SQL logic, usually as part of an incremental processing pipeline.
Why B is correct:
Streams track DML changes such as:
INSERT
UPDATE
DELETE
They also expose metadata columns such as:
METADATA$ACTION
METADATA$ISUPDATE
METADATA$ROW_ID
These columns help identify the type of change and the affected row.
Why the other options are incorrect:
A). Tasks execute scheduled SQL and can be used to run data pipelines. Streams track the changes consumed by those pipelines.
C). File formats define how staged files are interpreted during loading or unloading. Streams are unrelated to file format definitions.
D). Caching is handled by Snowflake result cache and warehouse cache mechanisms, not by streams.
Official Snowflake documentation reference:
Snowflake documentation describes streams as objects that record DML changes made to tables, including inserts, updates, and deletes.
Reference: Snowflake Documentation - Streams; Snowflake Documentation - Change data capture; SnowPro Core Study Guide - SQL and Snowflake Objects.

The OWNERSHIP privilege is unique in that it must be granted by one role to another and cannot be revoked.
This ensures that the transfer of ownership is deliberate and permanent, reflecting the importance of ownership in managing access and permissions.