Practice Free MCE-Admn-201 Exam Online Questions
A Marketing Cloud admin has been asked to get the last 30 days of Bounce data from their account.
What should the admin use to get granular bounce data in bulk in a pre-defined format?
- A . CSV download of bounce data in My Tracking
- B . Automation Studio Tracking Extract
- C . Automation Studio Query Activity
- D . Discover Deliverability Complaint Rate Report
A customer will provide a single daily file on the Marketing Cloud SFTP at 3 AM and needs an alert if
the file is not present on time. The file needs to be: Imported into a staging data extension.
Separated into two different data extensions.
Which workflow should meet these requirements?
- A . Scheduled Automation: File Transfer Activity > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
- B . Scheduled Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
- C . File Drop Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
- D . File Drop Automation: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1
A Marketing Cloud Admin has noticed a File Drop Automation has been failing on the import File activity. The automation is configured with a filename pattern, so the filename is expected to begin with customer_import_. The import is configured to look for a file named customer_import_%%Year%%%%Month%%%%Day%%.csv, however, the admin notices the filenames include seconds and milliseconds.
How should the admin fix the issue?
- A . Use the exact filename used for the trigger in the import File Activity
- B . Make sure the file is placed on the correct subfolder within the SFTP
- C . Make sure the filename has a date stamp to avoid duplication
- D . Use %%FILENAME_FROM_TRIGGER%% in the import File Activity
Northern Trail Outfitters wants to expand their use of Marketing Cloud to business users who spend their day in Sales Cloud, without granting access to Marketing Cloud directly.
What feature should be used?
- A . Distributed Sending
- B . Distributed Marketing
- C . Marketing Cloud Connect
A Marketing Cloud admin at a bank is asked to avoid storing sensitive data in the cloud. This data will only be sent to Marketing cloud to execute a send.
Which feature would the admin use to meet this requirement?
- A . Tokenized Sending
- B . List Sending
- C . Field Level Encryption.
- D . Distributed Marketing Sends.
Northern Trail Outfitters wants to bring subscriber data from its data warehouse into Marketing Cloud.
Which 2 fields would need minimal consideration, for size/scalability related reasons, when creating a data extension to house the data? Choose 2 answers
- A . Text
- B . Decimal
- C . Number
- D . Boolean
To prevent retention of stagnant data, Northern Trail Outfitters wants any inactive data stored in data extensions to be cleared after 12 months.
What action should be taken?
- A . Configure the business unit data retention setting to 12 months
- B . Configure the Enterprise wide default retention to one year
- C . Set inactive data to be automatically cleared after one year, but is recoverable
- D . Apply a Row Based Retention to each data extension as it is created, set to 12 months
Which two data structures could be configured to appear In the out-of-the-box Subscription Center? Choose 2 answers
- A . Data Extensions
- B . Publication Lists
- C . Lists
- D . Groups
A Marketing Cloud Administrator noticed a File Drop Automation has been falling on the Import File activity. The automation is configured with a filename pattern, so the filename is expected to begin with customer import_. The import is configured to look for a file named Customer import %%Year%%%% Month%%%%Day%%.csv, however, the admin notices the filenames Include seconds and milliseconds
what should the admin do to fix the issue?
- A . use %%FILENAME_FROM_TRIGGER%% in the Import File Activity
- B . Make sure the team has a date stamp to avoid duplication
- C . Make sure the files placed on the correct subfolder within the SFTP
- D . Use the exact file name used for the trigger in the Import File Activity
A marketing manager requests to receive an email, once a week, with high-level metrics in a standardized format. Specifically, the manager wants to know how many emails were sent in the last week.
What location and activity would allow the Marketing Cloud admin to complete this request?
- A . Email Studio: Select the "Account Send Summary*’ in Tracking Reports and schedule a weekly report to be sent.
- B . Analytics Builder: Select the "Account Send Summary" in Reports and schedule a weekly report to be sent.
- C . Automation Studio: Create a Query Activity to query data from the "Sent" Data View, then use an Email activity to automate the sending of the data.