Free Salesforce Marketing-Cloud-Consultant Practice Exam with Questions & Answers | Set: 3

The LookupRows AMPscript function returns a rowset from a data extension that matches the specified criteria. It can be used to retrieve multiple rows of data from a data extension based on one or more column values. For example, NTO can use the LookupRows functionto retrieve all rows from the second data extension that have the same session ID as the subscriber in the sendable data extension, and then loop through the rowset to display the product data for each abandoned cart item in the email.References:https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic- content.meta/mc-programmatic-content/lookuprows.htm

Two best practices that should be utilized for configuring customer data for long-term cleanliness and maintainability are:

• When using an external database of record, utilize that system’s identifier as the contact key. This will ensure that contacts can be identified and tracked across different channels and platforms using a consistent and persistent value.
• Define the subscriber key as a unique value that does not relate to a specific channel. This will allow contacts to change their email or mobile device without affecting their subscriber key or losing their tracking history.

Configuring Contact Builder to automatically generate a unique subscriber key is not recommended, as it may create duplicate or inconsistent records if contacts already have an identifier in another system. Regularly merging duplicate contacts is not a best practice, but rather a remedial action that should be avoided by using proper data hygiene techniques.References: https://help.salesforce.com/s/articleView?id=sf.mc_co_subscriber_key.htm &type=5

A contact is a person who interacts with a brand across one or more channels, such as email, mobile, web, etc. A contact is identified by a contact key, which is usually the same as the subscriber key in Marketing Cloud or the contact or lead ID in Sales Cloud. Whenusers register with the mobile app, they will create new contacts in Marketing Cloud with their device IDs as contact keys. However, these contacts will not be associated with their contact keys in Sales Cloud until they are synchronized through Marketing Cloud Connect, which can take up to 24 hours. Therefore, newly registered users will create additional contacts in Marketing Cloud until they are matched with their existing contacts in Sales Cloud. References: https://help.salesforce.com/articleView?id=sf.mc_co_what_is_a_contact.htm &type=5https://help.salesforce.com/articleView?id=sf.mc_co_implementing_contacts_in_the_marketing_cloud.htm &type=5

Data views are system-generated tables that store information about subscriber actions, such as sends, opens, clicks, bounces, etc. Data views can be queried using SQL statements in automation studio or query studio to retrieve email metrics for analysis and reporting purposes. Data views store data for up to six months (or longer for some tables), and can be queried as frequently as needed, such as hourly or daily.References:https://help.salesforce.com/articleView?id=sf.mc_as_data_views.htm &type=5

This allows you to specify the exact name of the file when running the automation. The File DropStarting Source is an automation activity that allows you to specify the source of the File Drop as either a Scheduled or Manual event. This allows you to control when the data is imported from the Enhanced FTP file.

To set up their automation to import the data from the file on a nightly basis, Northern Trail Outfitters should use two ways to start their automation:

• File Drop Starting Source. This is a trigger that starts an automation when a file is dropped in an Enhanced FTP folder or an external SFTP location.
• Scheduled Starting Source. This is a trigger that starts an automation at a specified date and time or at recurring intervals.

%%BASEFILENAME_FROM_TRIGGER%% and %%BASEFILENAME_FROM_FILEDROP%% are not starting sources, but variables that can be used in file transfer or import activities to reference file names.References: https://help.salesforce.com/s/articleView?id=sf.mc_as_automation_studio_triggers.htm &type=5

Using personalization strings created by selecting the data extension can be used to include the warehouse ID in their tracking parameters so that the third-party system can identify the subscriber. Personalization strings are placeholders that can be inserted into emails or landing pages to display information from data extensions or lists, such as subscriber attributes or custom fields. Personalization strings can also be used as tracking parameters in links or image tags. References: https://help.salesforce.com/s/articleView?id=sf.mc_es_create_personalization_strings_by_selecting_a_data_extension.htm &type=5https://help.salesforce.com/s/articleView? id=sf.mc_es_tracking_parameters_for_links_and_image_tags.htm&type=5

A synchronized data extension is a data extension that is automatically populated with data from Sales Cloud objects using Marketing Cloud Connect. A query activity is an automation studio activity that allows querying data from data extensions or data views using SQL statements. A Salesforce data extension is a type of data extension that stores data imported from Sales Cloud reports or campaigns using Marketing Cloud Connect. By querying synchronized data extensions using a query activity to a Salesforce data extension, the customer can segment contacts based on complex criteria without relying on Sales Cloud reports or campaigns. Then, by sending via Email Studio Send Flow to the Salesforce data extension, the customer can leverage tracking and reporting features of Marketing Cloud Connect. References: https://help.salesforce.com/articleView?id=sf.mc_co_data_integration_synchronized_data_sources.htm &type=5https://help.salesforce.com/articleView?id=sf.mc_es_send_email_send_flow.htm &type=5

Datorama is a product that enables marketers to connect and unify their data sources, visualize and analyze their data, and optimize their marketing performance. Datorama can help NTO centralize their analytics data from Marketing Cloud, Sales Cloud, and other sources, and provide insights and recommendations to drive return on investment and growth via their marketing sends. References: https://www.salesforce.com/products/marketing-cloud/platform/datorama-marketing-intelligence/ https://help.salesforce.com/articleView?id=sf.mc_dtm_datorama.htm &type=5

To send an email with 10 personalized fields from multiple data extensions to an audience of over one million subscribers, Northern Trail Outfitters should create and send to a sendable data extension containing those needed fields using a query activity. A query activity can join and filter data from multiple data extensions and populate a sendable data extension with the required fields for personalization. This will improve the email send performance and avoid timeouts or errors. References: https://help.salesforce.com/s/articleView?id=sf.mc_as_query_activity.htm &type=5https://help.salesforce.com/s/articleView?id=sf.mc_es_send_email_using_a_data_extension.htm &type=5

Two solutions that could pull in the RSS feed at the time of send for Northern Trail Outfitters’ weekly email newsletter are:

• AMPscript. AMPscript is a scripting language that can be used to retrieve and display dynamic content from external sources, such as RSS feeds, in emails.
• External Content. External Content is a feature that allows marketers to create blocks of content from external sources, such as RSS feeds, in Content Builder.

Dynamic Content is not a solution for pulling in RSS feeds, as it is used to display different content based on subscriber attributes or rules. Personalization Strings are not a solution for pulling in RSS feeds, as they are used to display subscriber or account information in emails. References: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/ampscriptUseCasesRetrieveRSSFeed.htm https://help.salesforce.com/s/articleView?id=sf.mc_ceb_external_content_blocks.htm &type=5