A developer needs to identify all subscribers who were sent Job ID 420 but did not click any links. Which SQL statement would produce the desired results?

A data extension contains two fields which are being populated by a query activity. A third field has recently been added to the data extension.
Which SELECT statement is optimal for returning all of the columns in the data extension?

A developer wants to use the Marketing Cloud SOAP API to retrieve which subscribers were sent a particular email. Which SOAP API object should be used?

A developer wants to upload a base64-encoded file to Content Builder using an API Installed Package but receives an insufficient Privileges error. What should the developer check to troubleshoot the error?

A developer is building an integration with the Marketing Cloud API. In which two ways should the Client ID and Client Secret credentials be stored? Choose 2