Marketing-Cloud-Administrator Practice Exam Questions with Answers Salesforce Certified Marketing Cloud Administrator (SP25) Certification

IP Allowlist is the feature that NTO should enable to assist in reducing threats from malicious API attacks. IP Allowlist is a feature that restricts API access to Marketing Cloud from a specific set of IP addresses. By creating an IP Allowlist, NTO can ensure that only authorized users or applications can access their Marketing Cloud account via API

Create separate folders and add permissions is how they should accomplish this. Folders are used to organize data extensions and other assets in Marketing Cloud. Permissions can be applied to folders to control which users can view or update the data extensions or assets within them. By creating separate folders for B2C and B2B campaigns and adding permissions accordingly, they can restrict access to data extensions based on user roles

QUESTIONNO: 95

Northern Trail Outfitters wants to know how customers are engaging with marketing communications they have sent over the last year. What action should be taken to populate the Einstein Engagement Scoring Dashboard?

A. Select one of the Predictive Algorithms then click Deploy

B. Click Deploy and results are available immediately

C. Select the channels (Emails, Push, SMS) to report on then click Activate

D. Click Activate and wait for an email notification

Answer: D

Click Activate and wait for an email notification is the action that should be taken to populate the Einstein Engagement Scoring Dashboard. Einstein Engagement Scoring is a feature that uses artificial intelligence to score subscribers based on their likelihood to open, click, or unsubscribe from emails. To activate this feature, users need to click the Activate button in the dashboard and wait for an email notification that confirms the activation and provides a link to view the scores.

 Join is the activity that would allow NTO to build the journey with the fewest activities possible. Join allows you to combine multiple paths into one path based on a common attribute or event. This way, NTO can send five different versions of an initial welcome email using five different paths, and then join them into one path for the follow-up email

 Minimum password length is 12 characters and Once created, the user will need to be activated in order to use the SFTP are two considerations that should be taken when configuring an SFTP User. SFTP User is a type of user that allows marketers to securely transfer files between Marketing Cloud and an external location using Secure File Transfer Protocol (SFTP). SFTP User can be configured with different settings, such as username, password, folder access, and activation status. The password for an SFTP User must be at least 12 characters long and must meet certain complexity requirements. The user must also be activated before they can use the SFTP service.

Configure the business unit data retention setting to 12 months is the policy that the Marketing Cloud admin could configure in Setup. Business unit data retention setting is a setting that allows marketers to specify how long records in data extensions should be retained at the business unit level. By configuring the business unit data retention setting to 12 months, any inactive data that is older than 12 months will be automatically deleted from the data extensions in that business unit2

To address the issue of employees not receiving emails because the messages are being blocked by spam filters, the Marketing Cloud admin should provide the IT team a list of relevant IP addresses to whitelist in their spam filter. Whitelisting is a process that allows NTO to specify which IP addresses are trusted and can bypass the spam filter. By providing the IT team a list of relevant IP addresses, such as the ones used by Marketing Cloud to send emails, the admin can ensure that the emails from NTO will not be blocked or marked as spam by the employees’ email servers. The other options are incorrect because:

• Import employee email addresses into All Subscribers with an “Active” status. This option will not address the issue, as it only affects the subscription status of the employees in Marketing Cloud, not in their email servers. Importing employee email addresses into All Subscribers with an “Active” status means that NTO can send emails to those employees from Marketing Cloud, but it does not guarantee that the emails will be delivered or received by the employees’ email servers.
• Ensure employees have opted in to the test email list or data extension. This option will not address the issue, as it only affects the consent of the employees to receive emails from NTO, not their email servers. Ensuring employees have opted in to the test email list or data extension means that NTO has permission to send emails to those employees, but it does not guarantee that the emails will be delivered or received by the employees’ email servers.
• Ask employees to use personal email addresses instead of corporate email addresses. This option will not address the issue, as it only shifts the problem from one email server to another, not solving it. Asking employees to use personal email addresses instead of corporate email addresses means that NTO will send emails to different email servers, but it does not guarantee that those email servers will not block or mark the emails as spam.

AMPscript conditional against the Gender field is the best method to ensure content is displayed properly within the email. It allows creating dynamic content based on the value of the Gender field in the sendable data extension. Dynamic Content Wizard is not suitable for this scenario because it requires creating content areas for each variation of content, which can be cumbersome for a customer with limited technical resources. AMPscript lookupRows functions and A/B Test content type are not relevant for this scenario.

 Email attachments is the Marketing Cloud product that NTO should purchase as a solution. Email attachments allows you to attach files such as PDFs or CSVs to your email messages. The files are stored securely in Marketing Cloud and are not publicly accessible. Distributed sending is not a suitable solution because it allows franchisees to send their own emails using NTO’s content, not receive emails from NTO. Content syndication and Analytics Builder are not relevant for this scenario.

The aspects that would confirm that SAP has been set up on NTO’s account are:

• Upon receiving an email, all tracked links start with click.email.nto.com. This indicates that NTO has configured their SAP with their own domain name (email.nto.com) and subdomain name (click) for link tracking.
• Cloudpages personalized URLs are served from cloud.email.nto.com. This indicates that NTO has configured their SAP with their own domain name (email.nto.com) and subdomain name (cloud) for Cloudpages. The other options are incorrect because:
• The login page for Marketing Cloud Users is login.email.nto.com and is branded with NTO colors. This does not indicate that SAP has been set up, but rather that NTO has configured their own private domain for Marketing Cloud login. This is a separate feature from SAP and does not require SAP to be enabled.
• Users receive Marketing Cloud password reset emails from help@email nto.com. This does not indicate that SAP has been set up, but rather that NTO has configured their own sender address for Marketing Cloud system emails. This is a separate feature from SAP and does not require SAP to be enabled.

 Marketing Cloud authenticates if the user has login hours enabled on their profile when they log in through the user interface3. Login hours are a security feature that allows the admin to specify the time range when users can access Marketing Cloud. If a user tries to log in outside of their login hours, they will be denied access3. The other options are incorrect because:

• If the user is assigned a role in the parent business unit. This is not a factor for authentication, but rather for authorization. A role determines what permissions and access levels a user has within Marketing Cloud, but it does not affect their ability to log in through the user interface4.
• If the user is logging in from a whitelisted IP address. This is not a factor for authentication, but rather for verification. An IP address whitelist is a list of trusted IP addresses that can access Marketing Cloud without additional verification. If a user logs in from an IP address that is not on the whitelist, they will be asked to verify their identity via email or SMS5.
• If the user is an API User on their record. This is not a factor for authentication, but rather for integration. An API User is a user who can access Marketing Cloud via API calls from external applications or systems. This does not affect their ability to log in through the user interface.

 Installed Packages is where their Marketing Cloud admin should set up permissions to allow REST authentication. Installed Packages are containers that hold API integrations, components, and permissions in Marketing Cloud. To use the REST API for an external application, the admin needs to create an installed package and configure the API integration settings, such as authentication method, scope, and redirect URI. The admin also needs to assign permissions to the installed package to grant access to specific Marketing Cloud features and data

To ensure only specific Contacts are synced from Sales Cloud, the admin should filter records on a Boolean field1. This allows the admin to select only the Contacts that have a true value for a checkbox field, such as “Sync to Marketing Cloud” or "Email Opt-in"1. Filtering records on a formula field, a date field, or existing records in All Subscribers are not supported options for synchronizing Contacts

Synchronized Data Sources can use two types of filters: attribute filters and relationship filters. Attribute filters are based on the fields of the object being synced, such as email address or opt-out status. Relationship filters are based on the fields of a related object, such as account or campaign. Filtering by email open activity or subscriber status is not possible with Synchronized Data Sources.

 Account Send Summary Report is the email report that NTO’s Marketing Analyst should pull from Marketing Cloud to get this information. Account Send Summary Report provides a summary of email metrics for all business units in an account or for a specific business unit. The report includes the number of sends, delivery rate, overall bounce rate, block bounce rate, open rate, click rate, complaint rate, and unsubscribe rate for each email campaign

The Sender Authentication Package (SAP) allows the image URLs to be wrapped with the appropriate brand URL, which enhances the branding and deliverability of the emails. The SAP does not affect the profile center branding, the click domain, or the IP warming.

The Content Split activity should be used for multivariate content testing within Journey Builder. This activity allows the journey to send different versions of email content to different audience segments and measure their performance based on open or click rates. The other activities are not suitable for multivariate content testing.

To achieve the setup of sharing the same SFTP directory across each of their Marketing Cloud accounts, NTO should copy the parent SFTP user into each child business unit. This will allow each business unit to access the same SFTP directory as the parent business unit and share files among them. The other options are incorrect because:

• Child business unit SFTP user should be created. This will create a separate SFTP user and directory for each child business unit, which will not allow them to share files with the parent business unit or other child business units.
• Each business unit should have multiple SFTP users. This will create unnecessary complexity and confusion for NTO, as they will have to manage multiple SFTP users and directories for each business unit. This will also not allow them to share files among different business units easily.
• All child business units should have an individual SFTP user. This is similar to the first option, as it will create a separate SFTP user and directory for each child business unit, which will not allow them to share files with the parent business unit or other child business units.

IP ramp-up takes four to six weeks to be able to fully send to all 3 million customers and IP ramp-up is important to establish a positive sender reputation. These responses articulate proper IP warming, which is the process of gradually increasing email volume from a new or unused IP address to build trust and credibility with Internet Service Providers (ISPs)

To copy journeys across business units, NTO should use Journey Templates1. Journey Templates are reusable journey structures that can be created and shared across business units. NTO can use Journey Templates to replicate journey structure so it can be easily recreated in another account. The other options are incorrect because:

• Deployment Manager. This is a tool that allows NTO to deploy assets and configurations across business units or accounts. However, this tool does not support journeys as an asset type, so it cannot be used to copy journeys across business units2.
• Journey Extracts. This is a feature that allows NTO to export journey data and metrics for reporting and analysis purposes. However, this feature does not allow NTO to copy or import journeys across business units; it only provides a snapshot of journey performance3.
• Copy activities. This is an option that allows NTO to copy individual activities within a journey and paste them in the same or another journey. However, this option does not allow NTO to copy the entire journey structure across business units; it only copies one activity at a time4.

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 import data into a non-sendable data extension without a primary key, the admin could use the Overwrite import type3. This import type will delete all existing records in the data extension and replace them with the new records from the import file. This import type does not require a primary key because it does not need to match or update any existing records. The other options are incorrect because:

• Add Only. This import type will add new records to the data extension without affecting existing records. However, this import type requires a primary key to prevent duplicate records from being added3.
• Add and Update. This import type will add new records and update existing records in the data extension based on the primary key. However, this import type requires a primary key to match and update the existing records3.
• Update Only. This import type will update existing records in the data extension based on the primary key. However, this import type requires a primary key to match and update the existing records3.

 To link the new data extensions to the existing contact records, the subscriber ID value should be used. Subscriber ID is a unique identifier for each contact in Marketing Cloud and is automatically generated when a contact is created. It can be used to relate data extensions in Data Designer.

Smart Capture is the feature that should be used to create a survey form. Smart Capture is a feature that allows marketers to create and insert forms within landing pages or emails, such as surveys, polls, or feedback requests. Smart Capture can be customized with different fields, labels, buttons, and actions. Smart Capture can capture subscriber responses and store them in a data extension or update existing records in Marketing Cloud.

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

 The correct answer is C because File Drop Automation can be used to trigger an automation when a file is dropped on the SFTP, and Import File Activity and SQL Query Activities can be used to import and separate the data into different data extensions. A is incorrect because Scheduled Automation cannot check if the file is present on time. B is incorrect because Scheduled Automation cannot trigger an alert if the file is not present. D is incorrect because Filter Activity cannot separate the data into different data extensions.

To ensure users have access to Query Studio for Marketing Cloud, the admin should license all appropriate users within the installed package. Query Studio is an app that allows users to write and run SQL queries on data extensions within Marketing Cloud. To use Query Studio, users need to be licensed by the admin within the installed package settings. The admin can select which users or roles can access Query Studio and assign them a license. The other options are incorrect because:

• Choose Public App Integration during the installation. This option will not ensure users have access to Query Studio for Marketing Cloud, as it only affects how Query Studio connects to Marketing Cloud via API. Choosing Public App Integration means that Query Studio will use a single API user for all requests, while choosing Private App Integration means that Query Studio will use each user’s own API credentials for requests. However, this does not affect whether users can access Query Studio or not; they still need to be licensed by the admin within the installed package settings.
• Install App-appropriate business units for expanded access. This option will not ensure users have access to Query Studio for Marketing Cloud, as it only affects which business units can use Query Studio. Installing App-appropriate business units means that Query Studio will be available in all business units within an account, while installing App-specific business units means that Query Studio will be available only in selected business units. However, this does not affect whether users can access Query Studio or not; they still need to be licensed by the admin within the installed package settings.
• Configure the API Integration to allow all users access. This option will not ensure users have access to Query Studio for Marketing Cloud, as it only affects how Query Studio connects to Marketing Cloud via API. Configuring the API Integration means that the admin can set up the API user credentials and permissions for Query Studio. However, this does not affect whether users can access Query Studio or not; they still need to be licensed by the admin within the installed package settings.

To begin troubleshooting the issue of data not being up to date from Sales Cloud, the 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 check the status and settings of their Sales Cloud integration, such as the sync frequency, sync direction, sync filters, and sync errors. The other options are incorrect because:

• 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 troubleshoot their Sales Cloud integration; it only shows the data extensions that are created by the sync process.
• Automation Studio > File Transfers. This is a page that allows NTO to view and manage their file transfer activities in Automation Studio. File transfer activities are activities that move files from one location to another, such as from an FTP site to the Safehouse or from the Safehouse to a data extension. However, this page does not allow NTO to troubleshoot their Sales Cloud integration; it only shows the file transfer activities that are created by NTO.
• Email Studio > Synchronized Data Extensions. This is a page that allows NTO to view and manage their synchronized data extensions in Email Studio. 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 troubleshoot their Sales Cloud integration; it only shows the data extensions that are created by the sync process.

A block bounce is a type of bounce that occurs when an ISP rejects an email because of the sender’s reputation or content. This indicates that the ISP views the sender as a potential spammer or has received complaints from other recipients.

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

Assigning a role to the business unit allows the admin to apply specific permission restrictions to all users in that business unit. The role defines what users can access and do within Marketing Cloud. The other options are not valid ways to accomplish this requirement.

Data extensions allow storing multiple values for an attribute for each subscriber. Profile attributes only store one value per attribute per subscriber.

 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.

To assist in reducing threats from malicious API attacks, NTO should enable IP Whitelisting3. IP Whitelisting is a security feature that allows NTO to specify a list of trusted IP addresses that can access Marketing Cloud via API. Any API requests from IP addresses that are not on the whitelist will be rejected. This way, NTO can prevent unauthorized or malicious API access to their Marketing Cloud account. The other options are incorrect because:

• Field Level Encryption. This is a security feature that encrypts specific fields in data extensions using encryption keys managed by NTO. However, this feature does not prevent malicious API attacks; it only protects data at rest in Marketing Cloud from unauthorized access.
• Advanced Audit Trail. This is a security feature that tracks and logs user activity and changes within Marketing Cloud. However, this feature does not prevent malicious API attacks; it only provides visibility and accountability for user actions in Marketing Cloud.
• Single Sign on Authentication. This is a security feature that allows users to log in to Marketing Cloud using their credentials from an external identity provider. However, this feature does not prevent malicious API attacks; it only simplifies and standardizes user authentication for Marketing Cloud.

To use Einstein to recommend similar items to customers during the checkout process, NTO needs to add two types of code to their website: Collect Code and Conversion/Cart Code2. Collect Code tracks customer behavior and preferences on the website, while Conversion/Cart Code tracks purchases and cart additions2. Recommendation Code is used to display product recommendations on the website, not during the checkout process2. Email Conversion Code is used to track conversions from email campaigns, not from website visits2.

The utm_campaign value should be configured at the email level. This level allows marketers to specify a campaign identifier for each email message that contains links with tracking parameters. The utm_campaign value can be used to group email messages by campaign in Google Analytics or other analytics tools

 To use Sales Cloud data in their queries, the admin should use Synchronized Data Sources. This feature allows Marketing Cloud to automatically import and update data from Sales Cloud objects and fields. The data is stored in data extensions that can be queried using SQL.

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.

Change Character Encoding to UTF-8 and Select Unicode Output are two settings that could solve this issue. Character Encoding is a setting that determines how characters are encoded and decoded when importing or exporting data in Marketing Cloud. UTF-8 is a type of character encoding that supports all characters in the Unicode standard, including accented characters. Unicode Output is a setting that enables the output file to be encoded in UTF-8 format when exporting data from Marketing Cloud. By changing Character Encoding to UTF-8 and selecting Unicode Output, the admin can ensure that accented characters are displayed correctly in the extracted file.

Data Filter, Template-based emails, and Automation Studio are the components that the customer’s solution should include. Data Filter is used to segment a data extension based on specific criteria, such as the customer’s expiration date. Template-based emails are used to create emails with predefined layouts and content blocks that can be easily customized by a general marketing user. Automation Studio is used to automate the email sends based on a schedule or a trigger

To resolve the issue of the encrypted file being decrypted after the File Transfer Activity completes, the decrypted data would be in the original SFTP folder. The File Transfer Activity can be configured to decrypt an encrypted file using a decryption key provided by NTO. The decrypted file will be placed in the same location as the encrypted file on the SFTP site. The other options are incorrect because:

• Selected SFTP folder. This is not where the decrypted data would be after the File Transfer Activity completes, as the File Transfer Activity does not allow NTO to select a different SFTP folder for the decrypted file. The decrypted file will be placed in the same location as the encrypted file on the SFTP site.
• Target Data Extension. This is not where the decrypted data would be after the File Transfer Activity completes, as the File Transfer Activity does not import data into a data extension. The File Transfer Activity only moves files from one location to another, such as from an FTP site to the Safehouse or from the Safehouse to a data extension. To import data into a data extension, NTO needs to use an Import File Activity.
• Safehouse. This is not where the decrypted data would be after the File Transfer Activity completes, as the File Transfer Activity does not move files to the Safehouse when decrypting them. The File Transfer Activity only moves files to the Safehouse when encrypting them or when transferring them from an external FTP site to Marketing Cloud. The Safehouse is a temporary storage location within Marketing Cloud that can be used for staging files before importing them into a data extension.

 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.

List Detective is the error code that the file would contain for this record. List Detective is a feature that filters out invalid, malformed, or problematic email addresses from being imported or sent to in Marketing Cloud. List Detective uses a set of rules and filters to check email addresses for syntax errors, spam traps, role accounts, or blocked domains. If an email address fails the List Detective validation, it will not be imported or sent to and the file will contain an error code of List Detective