Here you have the best Salesforce Certified Marketing Cloud Consultant practice exam questions
A bank wants to send out a series of emails to new customers that open a checking or savings account. The emails will be used to educate and inform customers regarding their current account and other bank offerings.
✑ Data for the campaign will be in two data extensions: Customer and New Accounts.
✑ The Customer data extension is currently used for multiple campaigns and is updated at 1:00 a.m.
✑ The New Accounts data is encrypted and will be placed on the SFTP at 10:00 p.m.
Which automated workflow meets the customers' requirements?
To meet the bank's requirements, the automation needs to start after the Customer data extension is updated at 1:00 a.m. Since the New Accounts data is encrypted, a File Transfer Activity is necessary to decrypt and process this data. The workflow should then import the data, run SQL queries to manipulate and prepare the data, include a wait activity if necessary, and finally send the email to the customers. Option C correctly schedules the automation to start at 2:00 a.m., after the Customer data extension update, and includes all required activities in the appropriate sequence.
ABC Company wants to automate the sending of shipping notices and a customer survey.
- Shipping notices will be sent once a day.
- The shipping file will be placed on the FTP some time after 4:00 p.m.
- The shipping data will be sorted in the Shipping Notice data extension.
- A field in the data extension will contain the shipping date.
- The survey needs to be sent at 9:00 a.m., exactly 10 days after the customer's order ships.
Which workflow would most effectively enable ABC Company to do this?
A.
B.
C.
D.
The workflow required to automate the sending of shipping notices and a customer survey needs to account for the following details mentioned in the question: shipping notices will be sent once a day, and the survey should be sent at 9:00 a.m. exactly 10 days after the order ships. Hence, it is important to ensure the correct timing for both activities. Option C is the best fit here because Automation 1 can be triggered whenever the file is uploaded (irrespective of the exact time), ensuring the shipping notices are promptly sent. Automation 2, which is scheduled to run daily at 9:00 a.m., will send the survey 10 days after the shipping date by filtering the data. This separates the tasks cleanly without overlapping schedules and ensures precise timing for the customer survey. Therefore, the correct answer is C.
During discovery, the customer outlines data requirements and the anticipated use of Marketing Cloud with the following criteria:
✑ Customer data will be fully refreshed every night via Import File Activity from the customer's data warehouse.
✑ Contact records will be augmented by relational data tables via Contact Builder.
✑ Customer ID will be used as the unique identifier for each contact.
Which statement differentiates the use of data extensions over lists?
Data extensions support the use of Customer ID as the Subscriber Key in Marketing Cloud. This is crucial when you need to use a unique identifier other than the email address, which allows for more flexible and complex data management strategies. The other options do not directly address the criteria presented in the customer's data requirements.
A customer wants Sales Cloud users to create and send Marketing Cloud emails.
Which two recommendations should the consultant make? (Choose two.)
For Sales Cloud users to create and send Marketing Cloud emails, each user should have a one-to-one relationship between their Marketing Cloud and Sales Cloud accounts to ensure proper synchronization and permissions. Additionally, enabling the Create Email feature on the user's Profile in Sales Cloud is necessary to allow users to initiate and send emails directly from Sales Cloud.
A customer is collecting data from a Smart Capture form that stores submissions in a data extension. The customer wants an email was sent to the marketing manager each morning that contains the previous days submissions as a CSV attachment. Assuming that the customer has the attachments feature enabled.
Which automation workflow will accomplish this?
The most appropriate automation workflow for this scenario involves several steps to ensure the correct data is sent each morning. First, you need a SQL Query to filter the data extension for the previous day's submissions. Next, a Data Extract activity exports the filtered data. Then, a Transfer File activity prepares the file for sending, and finally, a Send Email activity sends the email with the CSV attachment. Since the email needs to be sent each morning at a specific time, a Scheduled Automation is required.