Adeveloper wants to create a Synchronized Data Extension containing Lead data from Sales Cloud. They only want to include record which contain a phone number. Each of the following flied contains this information per these rules: -Phone is not black (Data Type = Phone) -PhoneExist is true (Data Type = Boolean)
-ValidPhone is 'true' (Data Type = Formula(Boolean)) -ContactType equals 'Phone' (Data Type = Text).
Which field could be used to select a subset of records in the synchronization configuration?

A developer wants to write a query to compile data originating from an HTML form so it can be exported in CSV format. However, the source data extension may contain line breaks within the Comments field, which makes it difficult to read and sort the resulting CSV.
Which SQL functions could be used to change each line break to a single space?

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

A developer wants to extract tracking data from the Market Activity in the user interface.
Which option would be available to extract the data"?

A developer created a landing page in CloudPages which return unique content when subscriber data is located on a related data extension. The developer does not know if all subscribers have rows in the related data extension, and want default content to render if no subscriber data is found on the related data extension. Which best practice should the developer follow to control the unique and default content?