A developer wants to expand their knowledge of Query Activities. They want to identify email addresses that have bounced in the last 30 days, along with the Bounce Reason and some additional subscriber specific data; however, the SQL they have written does not return any records. Below is the SQL statement:

What updates should be made to ensure this SQL statement returns the desired results?

Certification Aid uses Marketing Cloud Connect and wants to create a lead capture form on a landing page.
When a customer submits the form, a Lead record should be created in Salesforce. Which scripting language can be used for this? Choose 2.

Certification Aid wants to create Contacts in Marketing Cloud via API calls. Which API should be used for this? Choose 2.

A developer wants to add an image to Content Builder via the API and retrieve the image's published URL. Which method should the developer use?

A developer wants to build an audience by identifying subscribers who opened a specific email. Which query should the developer use?