A customer would like to store financial data related to invoicing in its data extensions.
Which field type should be used?

A customer wants Sales Cloud users to create and send Marketing Cloud emails.
Which two recommendations should the consultant make? Choose 2 answers

A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions--Subscribers and OrderTable, and the customer would like to include key information from both tables, such as:
* CustomerlD
* FirstName
* EmailAddress
* OrderlD
* OrderDate
* ShippedDate
Which SQL statement should the consultant use?

A customer wants to reports on 'Not Sent' contacts in Journey Builder.
Which method should be used?

A real estate agency wants to send out a biweekly newsletter with the list of properties for all new contacts added to a newsletter campaign in their Salesforce CRM. The journey consists of an initial message with property listings and a follow up to those who have engaged with the content.
The rules around which properties are matched to the contact depend on agent assigned as a contact owner, other agents who might have interacted with the contact, and contact's property interest. The data model has a relationship between contact > person account > real estate agent > property objects and all of those are available in CRM as well as synchronized to Marketing Cloud.
What solution should be recommended for execution efficiency?