
[Jun-2023] Updated and Accurate Marketing-Cloud-Consultant Questions & Answers for passing the exam Quickly
Download Real Marketing-Cloud-Consultant Exam Dumps for candidates. 100% Free Dump Files
NEW QUESTION # 77
Northern Trail Outfitters (NTO) stores customer purchase data m an external system. NTO ingests this data into Marketing Cloud through a file drop automation. The automation contains an import activity which overwrites a staging data extension, as well as an SQL Query activity which brings this data into a sendable data extension.
NTO's marketing manager wants to be informed If mort than 1,000 records are ever imported through this automation, and would also like to prevent the sendable date extension from being updated that day.
Which solution ts appropriate in this situation?
- A. Write a custom SSJS script to
- B. Place a Verification Activity between the import and SQL Query activity.
- C. Split the existing activities into two separate automations.
- D. Implement a Wait Activity to wait until the data extension is populated with records.
- E. validate the row count of the staging data extension and send a notification email.
Answer: D
Explanation:
Explanation
By placing a Verification Activity between the import and SQL Query activities, you can check to see if more than 1,000 records have been imported from the external system. If the row count exceeds 1,000, the automation can be paused and a notification email can be sent. This will allow NTO's marketing manager to be informed if more than 1,000 records are imported, and will also prevent the sendable data extension from being updated that day. For further information, please refer to the following Salesforce documentation:
* Automation Studio Overview: https://help.salesforce.com/articleView?id=mc_as_overview.htm&type=5 * Automation Studio Activities: https://help.salesforce.com/articleView?id=mc_as_activities.htm&type=5 * Verification Activity in Automation Studio: https://help.salesforce.com/articleView?id=mc_as_verification_activity.htm&type=5 * Wait Activity in Automation Studio: https://help.salesforce.com/articleView?id=mc_as_wait_activity.htm&type=5
NEW QUESTION # 78
A customer has an eCommerce site and imports Data into three data extensions daily: 'Orders,'
'Order_Details,' and 'Products.' The data extensions contain the following information:
*Orders: OrderId, CustomerId, OrderNumber, OrderDate, OrderTotal, GrandTotal
*Order_Details: ProductId, OrderId, Qty, UnitPrice, ExtendedPrice, Discount
*Products: ProductId, SKU, Name, Description, Cost, Price
Which two relationships should be established in Data Designer? Choose 2 answers
- A. One-to-one relationship between Orders and Order_Details
- B. One-to many relationship between Orders and Order_Details
- C. One-to-one relationship between Order_Details and Products
- D. One-to-one relationship between the contact record and Order_Detail
Answer: C,D
NEW QUESTION # 79
A customer wants to configure appointment reminders for patients in their clinic. The reminder should be sent day before the appointment date at 10 a.m and the appointment record should be updated in the patient was sent a reminder email.
What solution could be recommended?
- A. Create a journey with CRM data source triggered on the reminder data and use Journey Builder activities to send a reminder and update the record in Synchronized Data Extension.
- B. Create a daily scheduled automation to refresh the audience, and use Data Extension entry source for a journey with activates a reminder and updates the record in CRM.
- C. Create a daily scheduled automation to refresh the audience, and use Automation Studio activities to send a reminder with AMPscript in the message to update the record in Synchronized Data Extension.
- D. Create a journey with CRM date based entry source, and use journey Builder activates to send a reminder and update the record in CRM.
Answer: B
NEW QUESTION # 80
A customer wants to reports on 'Not Sent' contacts in Journey Builder.
Which method should be used?
- A. Create an Analytics Builder Discover report.
- B. Use an automation with Tracking Extract.
- C. Query the _sent Data View for the contact's send status.
- D. Use the standard report 'Subscribers Not Sent to'.
Answer: B
NEW QUESTION # 81
Northern Trail Outfitters has created child business units (BU) for their different regional offices. They want to limit subscriber records by BU, so users who are assigned to a BU can only view and send to Subscriber records in their region. A Profile Attribute named 'Region' associates a subscriber to a geographical region.
How could they ensure subscribers with a matching 'Region' Profile Attribute value are available in each BU?
- A. Create a list in each BU and add subscribers with a matching Region to the list.
- B. Select 'Define Subscriber Filter' for each BU on the BU Setup page and configure a condition to match the corresponding Profile Attribute.
- C. Create a measure for each corresponding 'Region' Profile Attribute and include the measure in a Filtered Data Extension for each BU.
- D. Open the the Profile Attribute Properties for the Region' Profile Attribute and select the 'Filter Subscribers by Attribute' option.
Answer: B
NEW QUESTION # 82
Northern Trail Outfitters wants to implement a Welcome email. New subscribers signing up on their website should receive the email promptly. They are utilizing Marketing Cloud Connect to connect Sales Cloud and Marketing Cloud.
Which solution should capture the new subscribers?
- A. Smart Capture form on website
- B. File import to data extension
- C. Salesforce Triggered Sends
- D. Batch file dropped to SFTP
Answer: C
NEW QUESTION # 83
Northern Trail Outfitters (NTO) needs to provide an IT staff member with access to Marketing Cloud. The staff member needs to perform the following tasks:
* Maintain NTO's master suppression list
* Configure data relationships
* Create new subscriber attributes
Which role should be assigned to the IT staff member?
- A. Content Creator
- B. Administrator
- C. Analyst
- D. Data Manager
Answer: D
NEW QUESTION # 84
Northern Trail Outfitters wants to include a 'view online' link in an email template to enable users to view a web page version of the email.
Which personalization string should they include as the href attribute in the link?
- A. %%view_as_webpage%%
- B. %%vawp%%
- C. %%view_online%%
- D. %%view_email_url%%
Answer: D
Explanation:
Explanation
This personalization string is used to direct a subscriber to a web version of the email, allowing them to view the email online even if their email client does not support HTML. For more information on personalization strings, please see the documentation here: https://help.salesforce.com/articleView?id=mc_es_personalization_strings.htm&type=5.
NEW QUESTION # 85
A customer needs to link demographic information to its model in Contact Builder.
What type of relationship should be used?
- A. One-to-One
- B. Many-to-Many
- C. Many-to-One
- D. One-to-Many
Answer: A
NEW QUESTION # 86
Northern Trail Outfitters has several business units (BU) and each BU uses specific data extensions, like Product Information.
How Should they configure these data sources?
- A. Share data extensions from the top-level BU.
- B. Use the File Transfer Activity to import data into each BU.
- C. Give users the Administrator Role so they can see all of the data.
- D. Create a local copy of the product data in each BU.
Answer: A
NEW QUESTION # 87
A customer wants to create a journey in Journey Builder with the goal of making users activate their accounts within 72 hours of registration.
* New account registrations are stored in a data extension via an API call with a Boolean field indicating whether the subscriber has activated their account.
* The journey should send activation reminder emails 24 hours and 48 hours after creating an account.
Which sequence of activities should be used for the customer's journey?
- A. 24 hour Wait > Decision Split > Send Email > 48 hour Wait > Decision Split > Send Email
- B. Decision Split >24 hour Wait > Send Email > Decision Split > 24 hour Wait > Send Email
- C. 24 hour Wait > Decision Split > Send Email > 24 hour Wait > Decision Split > Send Email
- D. Decision Split >24 hour Wait > Send Email > Decision Split > 48 hour Wait > Send Email
Answer: C
NEW QUESTION # 88
A customer needs to compare the engagement across three creative versions, and then send a follow-up email for those contacts who did not engage with any of the test versions.
Which sequence of activities would best accomplish this?
- A. Engagement Split > Send email > Wait > Random Split > Send email
- B. Decision Split > Send email > Engagement Split > Send email
- C. Random Split > Send email > Join > Decision Split > Wait > Send email
- D. Random Split > Send email > Wait > Engagement Split > Join > Send email
Answer: D
NEW QUESTION # 89
What action should be taken to increase subscriber engagement? (Choose two.)
- A. Increase volume of emails to a wider audience.
- B. Increase the use of dynamic content in emails.
- C. Adopt a Cart Abandonment Email Campaign.
- D. Introduce more identity verification steps in check out process.
Answer: B,C
NEW QUESTION # 90
Northern Trail Outfitters injects customers into journey B based upon email engagement in journey A.
Which method would facilitate this solution?
- A. In journey A, engagement split afteremail send. In Automation studio, query JourneyActivity data new for the Engagement split result Boolean field, Use result Data
- B. In journey A engagement split followed by Contact Activity to Boolean on an engagement data extension; Query engagement data extension injections.
- C. In Automation Studio, use verification activity to verify engagement on email in journey A' Query engagement data extension for journey B Subjects.
- D. In Automation Studio, query activity engagement on Journey System data view for email send to journey A; Use result data extension for journey B Subjects.
Answer: B
NEW QUESTION # 91
Northern Trail Outfitters wants to set up an automation that imports a file and sends an email to the contacts when the file is dropped on the SFTP. The name of the file will change, though it will always start with thankyou_customers.
How would they set up the Import Activity to know the name of the file?
- A. Set File Naming Pattern to %%BASEFILENAME_FROM_TRIGGER%%
- B. Filename is automatically passed to Import Activity with File Drop Automations
- C. Check the 'Use filename from Automation' checkbox
- D. Set File Naming Pattern to %%AUTOMATED_FILENAME%%
Answer: A
NEW QUESTION # 92
......
Prepare Important Exam with Marketing-Cloud-Consultant Exam Dumps: https://www.exam4labs.com/Marketing-Cloud-Consultant-practice-torrent.html
Pass Exam Questions Efficiently With Marketing-Cloud-Consultant Questions: https://drive.google.com/open?id=1QDn02jq_7FHCcRpqUHPdH6TBeLbr8n1h