Snowflake includes administration settings for resource consumption in order to

A media company needs a data pipeline that will ingest customer review data into a Snowflake table, and apply some transformations. The company also needs to use Amazon Comprehend to do sentiment analysis and make the de-identified final data set available publicly for advertising companies who use different cloud providers in different regions.
The data pipeline needs to run continuously ang efficiently as new records arrive in the object storage leveraging event notifications. Also, the operational complexity, maintenance of the infrastructure, including platform upgrades and security, and the development effort should be minimal.
Which design will meet these requirements?

For this object, Snowflake executes code outside Snowflake; the executed code is known as remote service.
What is this object called?

You have created a table as below
CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR);
Which of the below select query will fail for this table?

A stream stores data with the same columns as the source data but with additional columns.
What are those additional columns?