Marketing-Cloud-Administrator Exam Dumps - Salesforce Certified Marketing Cloud Administrator (SP23)

Publication lists are used to allow subscribers to opt-down/out of specific types of communications instead of unsubscribing from all. This helps to retain subscribers and maintain their preferences1

To assign users to the business units, the admin should search for the individual user, select their name, and click Manage Business Units. This will allow the admin to select which business units the user can access and what role they have in each business unit. The Edit Business Units option is not available for users

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.

To append an Urchin Tracking Module (UTM) variable string to links in emails, NTO should use Web Analytics Connector. Web Analytics Connector is a feature that allows NTO to append UTM variables or other custom parameters to the links in their emails. Web Analytics Connector can be configured at the account, business unit, or send level, and can support up to four parameters per link. The other options are incorrect because:

• Advertising Studio. This is a product that allows NTO to create and manage advertising campaigns across various channels, such as Facebook, Google, or Twitter. However, this product does not allow NTO to append UTM variables to links in emails; it only allows NTO to use their Marketing Cloud data for audience segmentation and targeting.
• Personalization Builder. This is a product that allows NTO to create and deliver personalized content and recommendations to their subscribers based on their behavior and preferences. However, this product does not allow NTO to append UTM variables to links in emails; it only allows NTO to use predictive intelligence and machine learning to optimize their content and offers.
• Web and Mobile Analytics. This is a product that allows NTO to collect and analyze web and mobile data from their subscribers, such as page views, visits, conversions, and revenue. However, this product does not allow NTO to append UTM variables to links in emails; it only allows NTO to use web tracking code and mobile SDKs to capture and report on their web and mobile activity.

 Send classifications require defining a sender profile and a delivery profile. A sender profile defines the From Name, From Email, and Reply Email for an email send. A delivery profile defines the IP address, domain, and header and footer information for an email send. Defining a subscriber-specific From Name and custom Reply Mail Management are not necessary for creating send classifications.

Removing Marketing Cloud Viewer role from the user would allow the analyst to import contact lists. The Marketing Cloud Viewer role is a read-only role that prevents users from performing any actions on data or content. The Marketing Cloud Channel Manager role already grants the user permission to import contact lists. The other options would not solve the problem or are unnecessary.

 To create a new user to fill in for a campaign manager who is out on parental leave, NTO should disable the campaign manager’s user and create a new user. Disabling a user means that NTO can temporarily deactivate a user’s access to Marketing Cloud without deleting their user information or settings. Creating a new user means that NTO can add a new user with their own user information and settings. This way, NTO can reuse an existing license without losing any data or configurations from the campaign manager’s user. The other options are incorrect because:

• Delete the campaign manager’s user and create a new user. This option will create a new user to fill in for a campaign manager who is out on parental leave, but it will also delete the campaign manager’s user information and settings permanently. This means that NTO will lose any data or configurations associated with the campaign manager’s user, such as roles, permissions, preferences, reports, or dashboards.
• Transfer the campaign manager’s permissions to a new user. This option will create a new user to fill in for a campaign manager who is out on parental leave, but it will also transfer the campaign manager’s permissions to the new user. This means that NTO will change the access level of both users, which may cause security or compliance issues.
• Deactivate the campaign manager’s license and assign it to the new user. This option will create a new user to fill in for a campaign manager who is out on parental leave, but it will also deactivate the campaign manager’s license permanently. This means that NTO will reduce their number of available licenses by one, which may affect their future user management.

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.

From Address Management is where a Marketing Cloud admin can view all verified email addresses. This feature allows you to manage sender authentication for your email sends by verifying your from addresses and domains.

Using %%FILENAME_FROM_TRIGGER%% in the Import File Activity allows the automation to import any file that matches the filename pattern, regardless of the date and time stamp. This is the recommended solution for File Drop Automations

Segment by domain to limit number of sends to each email provider is the option for segmentation that aligns with the IP Warming process. IP Warming 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). Segmenting by domain means dividing the email list into smaller groups based on the email domain, such as gmail.com or yahoo.com. By segmenting by domain, marketers can limit the number of sends to each email provider and avoid being flagged as spam or blocked by the ISPs.

Synchronized Data Sources is the feature that would allow this functionality. Synchronized Data Sources are data sources that allow marketers to import and synchronize data from Salesforce CRM objects into Marketing Cloud data extensions. Synchronized Data Sources can be configured with different settings, such as sync frequency, field mapping, and filter criteria. Synchronized Data Sources enable marketers to use Sales Cloud data in their queries and other Marketing Cloud activities.

One-to-One Relationship is the type of relationship that should be used to link demographic information to its contact model in Contact Builder. This type of relationship indicates that each record in the source data extension matches one and only one record in the target data extension based on a common attribute

 To drive their mobile adoption strategy, NTO could use the following two report types from the Discover Reporting Tool:

• Email Performance by Device1. This report shows the number and percentage of email opens and clicks by device type, such as desktop, mobile, or tablet. This report can help NTO understand how their subscribers are engaging with their emails on different devices and optimize their email design and content accordingly.
• Time Between Send and Engagement2. This report shows the time elapsed between when an email was sent and when a subscriber opened or clicked it. This report can help NTO identify the best time to send emails to their subscribers based on their device preferences and behavior patterns.

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 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.

Apply a Row Based Retention to each data extension as it is created, set to 12 months is the action that should be taken. Row Based Retention is a setting that allows marketers to specify how long records in a data extension should be retained based on their creation or modification date. By applying a Row Based Retention of 12 months to each data extension, any inactive data that is older than 12 months will be automatically deleted from the data extension

The Email Send Report in Analytics Builder is the best place to view the total number of emails sent across all business units in the last calendar year. This report provides a summary of email performance metrics such as sends, opens, clicks, bounces, and unsubscribes for a specified time period.

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

The out-of-the-box Subscription center can display Publication Lists and Lists as options for subscribers to opt in or out of. Data Extensions and Groups are not supported by the default Subscription center.

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 create an audience based on complex criteria such as engagement and location, NTO should use SQL Queries5. SQL Queries allow NTO to write custom queries that can join data from different data extensions and filter based on various conditions5. Measures are used to define engagement metrics such as opens and clicks, but they cannot be used to filter by location or combine with other criteria5. Data Filters are used to filter data based on simple criteria such as attributes or measures, but they cannot be used to join data from different sources or filter by location5. Journey is used to create personalized customer journeys based on triggers and activities, but it is not a tool for creating audiences5.

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

The admin should create separate business units for each of NTO’s brands when brand-specific private domains need to be leveraged when wrapping images and links in email campaigns. A private domain is a domain name that NTO owns and uses for their email sends, such as email.nto.com. A private domain can be used to wrap images and links in emails to improve deliverability and branding. However, a private domain can only be associated with one business unit in Marketing Cloud, so NTO needs to create separate business units for each brand that requires a different private domain2. The other options are incorrect because:

• NTO requires SSL certificate configurations for Content Builder and Portfolio images. This is not a reason to create separate business units for each brand, as SSL certificate configurations can be applied at the account level or the business unit level. SSL certificates are used to secure the connection between NTO’s web server and their subscribers’ browsers, and can be applied to Content Builder or Portfolio images to ensure they are delivered over HTTPS3.
• Multiple brand logos must be accommodated in an email header. This is not a reason to create separate business units for each brand, as multiple brand logos can be accommodated in an email header using dynamic content or AMPscript. Dynamic content or AMPscript are features that allow NTO to display different content in their emails based on subscriber attributes or data extension fields4.
• A new sender profile needs to be leveraged for sending transactional emails. This is not a reason to create separate business units for each brand, as a new sender profile can be created and leveraged within the same business unit. A sender profile is a configuration that defines the sender information for an email, such as the from name, from address, reply address, and sender classification5.

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.

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.

 The Collect Tracking code is a JavaScript code that is added to a website to capture and send user behavior data to Marketing Cloud. This data is stored in data extensions and can be used for Einstein Recommendations1

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

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.

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.

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.

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

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.

 To ensure Journey Builder directs the subscribers correctly, contact data should be used for the decision split. Contact data is the data that is stored in the contact model and is available for all journeys. Journey data is the data that is captured at the point of entry and is specific to each journey.

 To clear inactive data stored in data extensions after 12 months, NTO should apply a row-based retention to each data extension as it is created, set to 12 months. This will delete any records that have not been modified in the last 12 months. Row-based retention can be applied to individual data extensions or data extension templates

 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 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.

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

 Setup Assistant is a prioritized account configuration checklist that guides you through the essential steps to set up your Marketing Cloud account. It provides links to relevant documentation and resources to help you complete each task

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

 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.

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.

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.

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.