Free Marketing-Cloud-Developer Exam Braindumps

In which three ways should a developer optimize a query activity if it is currently timing out? Choose 3

1. A. Use intrisic functions in the WHERE clause
2. B. Use SELECT * to include all fields
3. C. Use Primary key(s) on fields used in joins
4. D. Use intermediate tables to stage data
5. E. Only update records that have changed since last execution

Correct Answer: CDE

In what order is AMPscript evaluated before an email is sent?

1. A. Subject Line, HTML Body, Text Body
2. B. HTML Body, Text Body, Subject Line
3. C. Text Body, HTML Body, Subject Line
4. D. HTML Body, Text Body, Text Body

Correct Answer: B

A developer needs to import a file nightly that will be used for multiple SQL Query Activities. The file could arrive any time between 2 a.m. and 5 a.m., and one of the requirements is that there is a unique file name for each import, rather than overwriting the file on the FTP site.
Which action should be configured?

1. A. File Drop Automation
2. B. Scheduled Automation
3. C. Dynamic File Import

Correct Answer: B

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

1. A. Set credentials as environment variables in the application platform
2. B. Pass credentials in URL parameters over HTTPS
3. C. Set credentials as variables in application source code
4. D. Store credentials in a key management system (KMS)

Correct Answer: AD

What can be created in Attribute Groups within Contact Builder? Choose 2.

1. A. Data Extensions
2. B. Relationships
3. C. Populations
4. D. Attribute Groups

Correct Answer: AB