Marketing-Cloud-Administrator Salesforce Certified Marketing Cloud Administrator (SP23) Questions and Answers

Three Filter Activities and three Send Activities to the filtered audiences are the steps that should be included in the customer’s automation. Filter Activities are used to segment a data extension based on specific criteria, such as the member’s renewal date. Send Activities are used to send an email to a data extension or a filtered audience.

Product code, application ID, and subscriber ID are values that can be used as personalization strings in query string parameters without violating PII regulations. Email address and name are considered PII and should not be used in query string parameters.

Cloud Pages and Content Builder are two Marketing Cloud features that will support this effort. Cloud Pages are web pages that can be created and hosted in Marketing Cloud and can be used to collect transactional data from customers. Content Builder is a tool that allows marketers to create, manage, and deliver content for emails, landing pages, mobile messages, and more

 To give the marketing analyst access to all tracking data but no send activities, the admin should apply the Analyst and Marketing Cloud Viewer default user roles. The Analyst role allows the user to view tracking data, reports, and dashboards for all channels. The Marketing Cloud Viewer role allows the user to view content, subscribers, and data extensions, but not modify or send them

This is the same question as Question No: 124. The answer is still A.

To avoid storing sensitive data in the cloud, the admin should use Tokenized Sending. This feature allows Marketing Cloud to send emails without storing sensitive data such as credit card numbers or social security numbers. Instead, Marketing Cloud uses tokens that are replaced with actual data at send time by an external system.

 To ensure a notification is received when the query fails, the admin should add their email address in the automation “Runtime Error or Skipped Run Notification Settings”. This setting allows the admin to specify an email address or a data extension to receive notifications when an automation encounters a runtime error or a skipped run. A runtime error occurs when an activity within an automation fails to execute, such as a query that has invalid syntax or references a non-existent data extension. A skipped run occurs when an automation is scheduled to run but does not run because the previous run is still in progress. The other options are incorrect because:

• Install the Marketing Cloud App on phone to receive Push Messages. This option will not ensure a notification is received when the query fails, as the Marketing Cloud App does not support push notifications for automation errors or skipped runs. The Marketing Cloud App only supports push notifications for Journey Builder entry events and email sends.
• Add their Email Address in the Query Activity Notifications Field. This option will not ensure a notification is received when the query fails, as the Query Activity Notifications Field only sends notifications when the query completes successfully. The notifications include information such as the number of records processed, added, updated, skipped, or failed.
• Configure the “Event Notification Service” in Setup with their Email Address. This option will not ensure a notification is received when the query fails, as the Event Notification Service is a feature that allows external systems to subscribe to events that occur in Marketing Cloud, such as email sends, opens, clicks, bounces, and unsubscribes. The Event Notification Service does not support events related to automation errors or skipped runs.

To ensure Individual Email Results are pushed back into Sales Cloud for a particular send, the admin should confirm that the data extension is located in the Salesforce Data Extensions folder. The Salesforce Data Extensions folder is a special folder that contains data extensions that are integrated with Salesforce CRM via Marketing Cloud Connect. Only data extensions in this folder can be used for sending emails with Individual Email Results tracking enabled. The other options are incorrect because:

• The send relationship links Subscriber Key to Subscribers on Email Address. This is a setting that defines how subscribers are identified and matched between a sendable data extension and All Subscribers. However, this setting does not affect whether Individual Email Results are pushed back into Sales Cloud; it only affects how email addresses and subscription statuses are updated in Marketing Cloud.
• The data extension is located in the Synchronized Data Extensions folder. The Synchronized Data Extensions folder is a special folder that contains data extensions that are synchronized from Salesforce CRM via Marketing Cloud Connect. However, these data extensions cannot be used for sending emails directly; they can only be used as sources for filtered or query-based data extensions.
• The triggered Send Data Extension data extension template was used. This is a predefined data extension template that contains a set of standard fields for logging triggered send data. However, this template does not affect whether Individual Email Results are pushed back into Sales Cloud; it only affects what information is stored in Marketing Cloud.

Data Extension, Audience Studio, API Event, Date Based Event are entry source types for Journey Builder. Entry source types are types of events or data sources that can trigger contacts to enter a journey in Journey Builder. Data Extension is an entry source type that allows contacts from a data extension to enter a journey based on a schedule or an automation. Audience Studio is an entry source type that allows contacts from Audience Studio segments to enter a journey based on a schedule or an automation. API Event is an entry source type that allows contacts to enter a journey based on an API call from an external system or application. Date Based Event is an entry source type that allows contacts from a data extension to enter a journey based on a date field in the data extension, such as birthday or anniversary.

A triggered message is a type of email that is sent automatically based on a subscriber’s behavior or a predefined event. This reduces the manual workload on the team and improves the customer experience by sending timely and relevant messages

To create a suppression list for hard-bounced email addresses, the Marketing Cloud admin should query the Bounce Data View. The Bounce Data View is a system data view that stores information about bounced emails, such as the subscriber key, email address, bounce category, bounce type, and bounce reason. The admin can use SQL queries to filter the records in the Bounce Data View based on the bounce category or type and create a suppression list from the results. The other options are incorrect because:

• Run a Bounce Email Report. This is a standard report that shows the number and percentage of bounced emails by category and type for a specific time period or email job. However, this report does not provide the details of the bounced email addresses, which are needed to create a suppression list.
• Query the Send Log. The Send Log is a custom data extension that stores information about sent emails, such as the subscriber key, email name, subject line, send date, and any additional attributes. However, this data extension does not store information about bounced emails, which are needed to create a suppression list.
• Run an Account Send Summary Report. This is a standard report that shows the summary of email sends across an account or a business unit for a specific time period. However, this report does not provide the details of the bounced email addresses, which are needed to create a suppression list.

Validate will check if words or phrases used may trigger spam filters, if correct syntax is used on any AMPScript in the email’s code, and if personalization strings map to attributes or data extension fields. A is incorrect because Validate will not check if each content area specified in a dynamic content rule exists. C is incorrect because Validate will not check grammar and spelling in the email text.

The Einstein STO activity allows the journey to send five different versions of an initial welcome email to new subscribers at the optimal time for each subscriber. This activity requires only one email and one activity, whereas the Join activity would require five emails and five activities.

 Einstein Email Recommendations is a product that enables a Marketing Cloud admin to observe customer behavior, build performance profiles and deliver the next best content. This product uses predictive intelligence to recommend products or content based on each customer’s preferences and actions. The other products do not have this capability.

For long term success of their Send Log data extension, NTO should consider the following three aspects:

• Apply an appropriately-scoped Data Retention period. A Data Retention period is a setting that determines how long records are kept in a data extension before they are deleted or archived. Applying an appropriate Data Retention period can help NTO manage their storage space and performance by removing old or unnecessary data from their Send Log data extension.
• Add custom fields not included in the Send Log Template. The Send Log Template is a predefined data extension template that contains a set of standard fields for logging send data. However, NTO can add custom fields to their Send Log data extension to capture additional information that is relevant to their business needs or reporting requirements.
• Log attribute data necessary for auditing communications. Attribute data is any data that is associated with a subscriber or a message, such as name, address, email type, or campaign name. Logging attribute data can help NTO audit their communications and track their performance by various criteria. The other option is incorrect because:
• Log all variable data captured in emails at send time. Variable data is any data that can change or vary depending on different factors, such as personalization strings, dynamic content, or AMPscript variables. Logging all variable data can result in excessive storage consumption and performance degradation for NTO’s Send Log data extension. NTO should only log the variable data that is essential for their reporting or analysis needs.

The Setup Assistant guides the Marketing Cloud admin through creating users and assigning roles, classifying sends and defining parameters, and building the data structure for storing audience information. These are essential tasks for setting up Marketing Cloud. The Setup Assistant does not cover creating a SMS message or importing data using the Data Loader.

 To search for a Salesforce contact in All Subscribers, the admin should use the 18-digit contact ID as the subscriber key. This is because Marketing Cloud Connect uses the 18-digit contact ID as the subscriber key for contacts synchronized from Salesforce. The email address is not a reliable identifier as it can change or be duplicated

Data Management is where in Setup they could accomplish this task. Data Management is a section in Setup that allows marketers to manage their data sources, imports, exports, and transfers in Marketing Cloud. Data Management includes a subsection called FTP Accounts, where marketers can create and manage their SFTP users and passwords for secure file transfers.

Run Once schedule type and Winner evaluation are two settings that should be selected before the admin can configure the Holdback percentage. Path Optimizer is a feature that allows marketers to test different paths in a journey and select a winner based on a specific metric. To use Path Optimizer, the admin needs to select a schedule type of Run Once, which means the journey will run only once for a single batch of contacts. The admin also needs to select a winner evaluation, which determines how long the test will run and how the winner will be chosen. After selecting these settings, the admin can configure the Holdback percentage, which is the percentage of contacts that will not enter any path until a winner is selected

To monitor whether all records were added to the target data structure each day, NTO should use the Notification Settings within the Import File Activity. The Notification Settings allow NTO to specify an email address or a data extension to receive notifications about the status and results of the import. The notifications include information such as the number of records processed, added, updated, skipped, or failed. This way, NTO can track and verify the import process and identify any issues or errors. The other options are incorrect because:

• External Key within the Import File Activity. The External Key is a unique identifier for the Import File Activity that can be used for API calls or SQL queries. However, it does not provide any information about the status and results of the import.
• Run Completion within the File Drop Automation. The Run Completion is a summary of the execution of the File Drop Automation that shows the start time, end time, duration, and status. However, it does not provide any information about the status and results of the import.
• Runtime Error within the File Drop Automation. The Runtime Error is a message that indicates an error occurred during the execution of the File Drop Automation that prevented it from completing successfully. However, it does not provide any information about the status and results of the import.

SQL Query Activities can reference Send Logs in combination with system data views and a business unit can support up to three Send Logs. These statements are correct about Send Logging, which is a feature that allows marketers to capture additional information about email sends that are not available in standard reports or data view

Publication lists are the feature that should be utilized to make this happen. Publication lists are used to manage subscribers’ preferences for different types of communications, such as newsletters, promotions, or alerts. The built-in subscription center allows subscribers to opt-in or opt-out of publication lists, as well as the master list

To configure Sales Cloud Objects to be synced and leveraged in Marketing Cloud, NTO’s Marketing Cloud admin should go to Contact Builder > Data Sources. Data Sources is a page that allows NTO to manage their data sources and integrations in Contact Builder. NTO can use Data Sources to select which Sales Cloud Objects they want to sync with Marketing Cloud and configure their sync settings and filters. The other options are incorrect because:

• Setup > Data Management > Synchronized Data Extensions. This is a page that allows NTO to view and manage their synchronized data extensions in Marketing Cloud. Synchronized data extensions are data extensions that store the data from synced Sales Cloud Objects in Marketing Cloud. However, this page does not allow NTO to configure which Sales Cloud Objects they want to sync with Marketing Cloud; it only shows the results of the sync process.
• Contact Builder > Data Extensions > Synchronized Data Extensions. This is a folder that contains all the synchronized data extensions in Marketing Cloud. Synchronized data extensions are data extensions that store the data from synced Sales Cloud Objects in Marketing Cloud. However, this folder does not allow NTO to configure which Sales Cloud Objects they want to sync with Marketing Cloud; it only shows the data extensions that are created by the sync process.
• Setup > Apps > Salesforce Integration. This is a page that allows NTO to view and manage their Salesforce Integration app in Marketing Cloud. Salesforce Integration is an app that enables Marketing Cloud Connect, which is a feature that integrates Sales Cloud and Marketing Cloud. However, this page does not allow NTO to configure which Sales Cloud Objects they want to sync with

To automatically unsubscribe customers who respond to marketing emails asking to be removed from the mailing list, the admin should take two steps:

• Ensure a Custom response is enabled for Automated Response in Reply Mail Management. This will allow Marketing Cloud to process replies that contain keywords such as unsubscribe, remove, or opt out and update the subscriber status accordingly.
• Verify Reply Mail Management has been enabled in the account. This will allow Marketing Cloud to handle replies to marketing emails and route them to a designated email address or domain.

Create child business units for each brand and nest another level of child business units for GEOs is how the rest of the business units should be organized. Business units are organizational units that allow marketers to segment their Marketing Cloud account based on different brands, regions, products, or channels. By creating child business units for each brand and nesting another level of child business units for GEOs, NTO can manage their marketing activities and assets for each subsidiary brand and location separately

Importing a file of logged-in customers into NTO’s existing Abandoned Cart journey in Journey Builder is the best action to take. This way, NTO can leverage the existing journey logic and content to send personalized emails to the customers who had their shopping sessions disrupted. The emails can include the items they left in their cart and a link to resume their shopping. Creating a user-initiated message or an apology email are not as effective as using Journey Builder, which allows creating more engaging and relevant customer experiences. Doing nothing is not a good option, as it may result in losing potential sales and customer loyalty.

 Lifetime Purchase Value, Conversion Rate, and Last Purchase Date are three criteria that the customer should use to create an audience for this campaign. These criteria help to identify the highest-value outdoor sports customers who are most likely to respond to the product discount

Subscriber Key is the component that should be discussed with the customer to allow for this use case. Subscriber Key is a unique identifier for each subscriber in Marketing Cloud that can be different from the email address. Subscriber Key allows for multiple records to share the same email address but have different subscriber attributes and preferences

 To determine if a Dedicated IP is the right choice for NTO, the admin should consider the following:

• All of NTO’s accounts should be on the same stack1. A stack is a group of servers that host Marketing Cloud accounts. A Dedicated IP can only be shared across accounts that are on the same stack1.
• Send volume is large enough to maintain a positive or neutral reputation2. A Dedicated IP requires a consistent and high volume of email sends to establish and maintain a good sender reputation with ISPs2. If the send volume is too low or irregular, the reputation of the IP may suffer and affect the deliverability of NTO’s emails2. The other options are incorrect because:
• Length of time needed to pause sending is greater than one month. This is not a consideration for choosing a Dedicated IP, but rather a consequence of having one. If NTO pauses sending for more than a month, their Dedicated IP may lose its reputation and need to be re-warmed before resuming sending2.
• Pre-warmed IP address can be purchased from Salesforce. This is not a consideration for choosing a Dedicated IP, but rather an option for acquiring one. A pre-warmed IP address is one that has already been used by another sender and has an established reputation. NTO can purchase a pre-warmed IP address from Salesforce if they want to avoid the warming process for a new IP address

 The security setting ‘Enable Username and Password for Web Services’ allows users to access the API with their Marketing Cloud username and password. If this setting is deselected, users will need to use an API user or an installed package to access the API

When using a filename pattern for a File Drop Automation trigger, the import File Activity should use %%FILENAME_FROM_TRIGGER%% as the file name. This ensures that the import activity will use the same file name as the trigger, regardless of the date stamp or other variations

The option to convert a qualified Lead to a Contact is a functionality that is contained in Journey Builder but not in Automation Studio. This option allows marketers to create journeys that interact with Salesforce CRM data and automate lead conversion based on predefined criteria

Overwrite is the import type that should be used when the data extension contains all current product information and the product catalog is never the same. This import type will delete all existing records in the data extension and replace them with the new records from the CSV file

The two prerequisites for configuring Social Studio to manage NTO’s social media accounts are:

• Bitly URL Shortener. This is a service that allows NTO to shorten and customize the URLs that they share on their social media posts. Bitly URL Shortener can also provide analytics and insights on the performance of the URLs, such as clicks, impressions, and conversions2. NTO needs to have a Bitly account and connect it to Social Studio before they can use Bitly URL Shortener for their social media posts.
• Login details for each social media account. These are the credentials that NTO needs to access and manage their social media accounts, such as Facebook, Twitter, Instagram, or YouTube. NTO needs to have login details for each social media account and connect them to Social Studio before they can use Social Studio to create and publish social media posts. The other options are incorrect because:
• Facebook ad manager. This is a tool that allows NTO to create and manage advertising campaigns on Facebook and its partner platforms, such as Instagram or Messenger. Facebook ad manager can also provide analytics and insights on the performance of the campaigns, such as reach, impressions, and conversions3. However, this is not a prerequisite for configuring Social Studio to manage NTO’s social media accounts; it is an optional feature that NTO can use if they want to run paid ads on Facebook or its partner platforms.
• Google URL shortener. This is a service that allows NTO to shorten and customize the URLs that they share on their social media posts. Google URL shortener can also provide analytics and insights on the performance of the URLs, such as clicks, impressions, and conversions4. However, this is not a prerequisite for configuring Social Studio to manage NTO’s social media accounts; it is an alternative service that NTO can use instead of Bitly URL Shortener.

To correct the issue of not being designated as an integrated Marketing Cloud user, the admin should apply the administrator and Marketing Cloud Administrator permission sets to the user5. The administrator permission set grants the user access to all standard objects and settings in Sales Cloud, while the Marketing Cloud Administrator permission set grants the user access to Marketing Cloud Connect features and settings in Sales Cloud. These permission sets are required for completing the integration between Sales Cloud and Marketing Cloud. The other options are incorrect because:

• Apply the Marketing Cloud for AppExchange User option as well. This option will not correct the issue, as it only grants the user access to Marketing Cloud Connect features in Marketing Cloud, not in Sales Cloud. The user also needs access to Marketing Cloud Connect features in Sales Cloud to complete the integration5.
• Reset all passwords to force new tokens. This option will not correct the issue, as it only affects the authentication tokens for API users, not for integrated users. The user needs to be designated as an integrated user before they can use their credentials to log in to Marketing Cloud from Sales Cloud5.
• Apply the appropriate user mappings in the CRM configuration. This option will not correct the issue, as it only affects how users are mapped between Sales Cloud and Marketing Cloud based on their email addresses or usernames. The user needs to be designated as an integrated user before they can be mapped between the two systems5.

Parameter Manager is the solution that the admin should suggest. Parameter Manager is a feature that enables marketers to automatically append tracking parameters to links in emails, such as UTM variables. Parameter Manager can be configured at the account, email, or link level

The three statements that should be considered before using Goals in Journey Builder are:

• Goals are created to evaluate journey performance. This statement is true, as goals are used to measure how well a journey is achieving its desired outcome or objective. Goals can also help NTO to optimize their journey by identifying which activities or paths are more effective in reaching the goal1.
• Goals can act as exit criteria. This statement is true, as goals can be configured to exit contacts from a journey when they meet the goal criteria. This can help NTO to save resources and avoid sending irrelevant messages to contacts who have already achieved the desired outcome or objective1.
• Contacts are evaluated against the goal after a wait activity. This statement is true, as contacts are only evaluated against the goal when they reach a wait activity in the journey. Wait activities are used to pause the journey for a specified amount of time or until a specific date or event occurs. After the wait period ends, contacts are evaluated against the goal and either exit the journey or continue to the next activity

Separating regions into business units and applying subscriber filters is the best way to ensure distinct data integrity across the regions. Subscriber filters allow you to control which subscribers are visible in each business unit based on criteria such as location, language, or preference.

Advertising Studio supports lookalike audiences directly from Facebook only. For other networks, such as Google and Twitter, Advertising Studio can create audience segments based on Marketing Cloud data and export them to the network’s platform, where the lookalike audience can be created manually.

 Event registration and venue details are the two data sources that must be incorporated inside Contact Builder. Event registration contains the event ID, event name, event type, and venue ID, which are needed for the decision split and the dynamic content in the email. Venue details contain the venue ID, venue name, and venue address, which are needed for populating the venue details in the email with AMPscript. Customer data and payment details are not essential for this scenario and can be excluded from Contact Builder.

To create and schedule a weekly report with high-level metrics, the Marketing Cloud admin should use Analytics Builder. Analytics Builder allows users to create, view, and share reports and dashboards. The Account Send Summary report shows how many emails were sent in a given time period

To send a promotional email to one million subscribers, NTO should use a data extension as their data structure. A data extension is a table that stores subscriber data in Marketing Cloud. A data extension can store up to 30 million records per data extension and up to 100 million records per account2. A data extension can also support advanced segmentation, personalization, and reporting features for email sends

Email Form Content Block is the feature that could be used to solicit website feedback without navigating away from the email. Email Form Content Block is a type of content block that allows marketers to create and insert forms within emails, such as surveys, polls, or feedback requests. Email Form Content Block can be customized with different fields, labels, buttons, and actions. Email Form Content Block can capture subscriber responses within the email without requiring them to visit a landing page or a website