Explanation
COALESCE is the function that returns the first value from a list that isn't empty. It takes a list of values as arguments and returns the first non-empty value. For example, COALESCE(NULL, '', 'Hello', 'World') returns 'Hello'. If all values are empty, it returns NULL. References: COALESCE

These two steps are required when configuring a Marketing Cloud activation. You need to select an activation target that represents a Marketing Cloud business unit and a contact point that represents a Marketing Cloud data extension.References:https://help.salesforce.com/s/articleView?id=sf.c360_a_data_cloud_marketing_cloud.htm&

Explanation
These two options are recommended ways to bring transactional data from a data warehouse into Data Cloud via a SFTP site. You can use the Cloud Storage Connector to ingest files from Google Cloud Storage or Amazon S3 buckets into Data Cloud. References:
https://help.salesforce.com/s/articleView?id=sf.c360_a_data_cloud_google_cloud_storage.htm&type=5https://he

These data sources are available from Marketing Cloud as a starter bundle. Theyprovide basic contact data, such as email address, mobile number, and device ID, as well as engagement data, such as email opens, clicks, bounces, unsubscribes, SMS sends, deliveries, opt-outs, and push sends, opens, and opt-outs.
References:https://help.salesforce.com/s/articleView?id=sf.c360_a_data_cloud_marketing_cloud_data_foundatio

Explanation
These two ways can help Data Cloud honor a request to be forgotten by a customer. The Consent API allows you to set a consent flag for an individual that prevents further processing of their data and deletes their records from source data streams. The delete from file functionality allows you to upload a file with individual IDs that will be deleted from Data Cloud. References:
https://help.salesforce.com/s/articleView?id=sf.c360_a_data_cloud_consent_api.htm&type=5https://help.salesfo