Pass the Salesforce Marketers Marketing-Cloud-Administrator Questions and answers with ValidTests

To manage data retention for inactive data in data extensions, the best approach is to apply a Row Based Retention policy directly to each data extension. This method allows precise control over how long data is retained based on the creation or modification date of each row.

Row Based Retention: Set this on each data extension as it is configured. Specify that data should be cleared after 12 months of inactivity. This approach ensures that only data which has not been engaged with for the specified period is removed, thus optimizing data storage and maintaining compliance with data management policies.

To ensure a notification is received when a scheduled query fails, the Marketing Cloud admin should add their email address in the automation settings under "Runtime Error or Skipped Run Notification Settings." This setup in the automation configuration will alert the admin via email if there is a failure in the query's execution, enabling timely identification and resolution of issues.

To allow the business analyst at Northern Trail Outfitters to import contact lists, the role needed is one that grants permissions for import activities. Among the options:

B. Add Marketing Cloud Security AdministratorThis role would provide the analyst with the necessary permissions to manage data imports. The Marketing Cloud Security Administrator role includes broader permissions that encompass data management and security settings, which are required for importing contact lists.

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.

Following a Contact Delete request, certain data types remain within the account:

B. Contact data in non-sendable data extensions: This data does not directly link to an individual's subscriber key or contact ID, allowing it to persist in the system for reporting and analytical purposes without targeting specific individuals.

C. General tracking data at the job level: This includes aggregated data on email opens, clicks, and other engagement metrics collected at the campaign level, not tied to individual contact identities, thus remaining in the system post-deletion.

To ensure sensitive information is not imported and stored in Marketing Cloud, implement:

Tokenized Sending: This approach uses tokens to represent sensitive data, ensuring that the actual data does not reside within Marketing Cloud. Instead, the tokens are matched with the original data only during the send process, enhancing security by minimizing data exposure.

Setup: Configure Tokenized Sending by defining data relationships in Marketing Cloud Connect or through external token providers to integrate seamlessly with the sending process.

The error in the File Drop Automation is due to the filename pattern not matching exactly because of additional seconds and milliseconds in the filename. To resolve this issue:

Modify the Import File activity to use the %%FILENAME_FROM_TRIGGER%% personalization string. This ensures that the Import File activity dynamically accepts the filename exactly as it is uploaded to the SFTP location.

Update the filename pattern in the automation setup to avoid hardcoding the date format and instead rely on the filename that triggered the automation.

By using %%FILENAME_FROM_TRIGGER%%, the automation becomes flexible and will correctly handle any file name that matches the initial pattern triggering the automation, regardless of additional timestamp details.

The issue where a customer continues to receive emails despite unsubscribing and being deleted from the data extension likely arises because the email address in All Subscribers still exists and is active. In Marketing Cloud, the All Subscribers list acts as a master list overriding subscription statuses in individual data extensions. Thus, even if a customer is removed from a specific data extension, if their status in All Subscribers is not updated to 'Unsubscribed,' they will continue to receive communications.

To address the issue of accented characters appearing jumbled in a Tracking Extract, the correct settings to adjust are related to character encoding and output format.

Change Character Encoding to UTF-8: This setting ensures that the extracted file supports Unicode, which includes accented characters and other non-standard characters used globally. UTF-8 encoding is capable of representing any character in the applicable data set, making it ideal for global applications.

Select Unicode Output: This option should be enabled to ensure the file output correctly formats Unicode characters, preventing them from being displayed incorrectly.

To address the issue of Northern Trail Outfitters' employees not receiving emails due to spam filters, the Marketing Cloud admin should provide the IT team with a list of relevant IP addresses to whitelist in their spam filters. This action will help ensure that emails sent from Marketing Cloud do not get blocked by the company's email security systems, thereby improving deliverability and ensuring that internal communications reach their intended recipients.