EMT Practice Test

1. Question Content...

---

Question1: * Certification Aid uses Marketing Cloud Connect and wants to create a lead capture form on a landing page. When a customer submits the form, a Lead record should be created in Salesforce. Which scripting language can be used for this? Choose 2.

Question2: Northern Trail Outfitters (NTO) wants to prevent competitors from receiving a coupon email. They also want to capture email addresses of competitors who are included in the targeted audience.
Which feature could NTO use to prevent the coupon from being sent and report the email addresses skipped?

Question3: A developer wants to build an email that dynamically populates the physical address of a company's locations using the variable ©address. The deployment goes to millions of subscribers and the developer wants the fastest possible performance.
Which AMPscript solution should be recommended?

Question4: A developer identified a use case where a triggered send of an email is needed. The developer already successfully set up authentication with a Client ID and Client Secret has used them in several REST calls. When the REST call is made, a "401 Unauthorized" error is returned. What is the first thing the developer should check?

Question5: Northtrn Trail Outfitters mistakenly synced the User_Salesforce object which added to their billable contact count.
What should be recommended to remove these contacts'

Question6: A developer needs to import a file nightly that will be used for multiple SQL Query Activities. The file could arrive any time between 2 a.m. and 5 a.m., and one of the requirements is that there is a unique file name for each import, rather than overwriting the file on the FTP site.
Which action should be configured?

Question7: A developer wants to build out a series of CloudPages that will interact with several REST APIs.
Which Marketing Cloud supported scripting tool should be used?

Question8: A marketing director at Northern Trail Outfitters wants to analyze the Send, Click, and Open Data Views. Which activities should the developer build to generate the data before transferring it to the SFTP?

Question9: Which activity is required before a compressed file can be imported?

Question10: A developer is configuring a File Drop Automation and wants to use a Filename Pattern to allow for timestamps on the file. The file name will always start with the month and day (e.g. MAY15) the file is dropped onto the SFTP site.
Which two configurations should be used for the automation to successfully start? Choose 2 answers

Question11: A developer started a Contact Delete process that is now complete.
In which two places would the Contact Delete process remove data? Choose 2 answers

Question12: A developer receives a 401 Unathorized HTTP status message from a REST API request. What is the reason for this error?

Question13: From which business unit could the Contact Delete feature be used within an Enterprise 2.0 account?

Question14: A developer uses the messageDefinitionSends REST API endpoint to send a triggered send email. This method returns a 202 (success) response code. How could the developer validate if the email was successfully sent?

Question15: A developer wants to create an HTML table where rows will alternate background colors between white and red. The developer does not know how many rows will be sent within each email, and decides to use a loop and assigns the RowCount() of the table rows to the variable @numerator. What is the recommended AMPscript logic to determine the background color of each table row within the loop?

Question16: A developer wants to create a JavaScript Web Token using a key from Key Management.
What function should the developer use?

Question17: A developer wants to trigger an SMS message to a subscriber using a form published on CloudPages. How should the SMS message be triggered once the subsceriber submits the form?

Question18: A marketer is troubleshooting why an email send's tracking information is not available in Sales Cloud. The marketer confirms Marketing Cloud Connect is installedproperly. What should be confirmed next to continue troubleshooting the send's tracking information?

Question19: A developer wants to extract tracking data from the Market Activity in the user interface.
Which option would be available to extract the data"?

Question20: In which three ways should a developer optimize a query activity if it is currently timing out? Choose 3

Question21: A developer initiated a batch delete of Contacts in Contact Builder due to an import error during implementation. There are over two million records that need to be deleted.
Which two factors should be considered when batch deleting large volumes of contacts?Choose 2 answers

Question22: A developer wants to upload a base64-encoded file to Content Builder using an API Installed Package but receives an insufficient Privileges error. What should the developer check to trobuleshoot the error?

Question23: A developer is notified the View Email As Web Page (VAWP) link, when clicked, displays the message, The system is temporarily unavailable. We apologize for any inconvenience. Please try again later.
What could be a possible cause for the error

Question24: Certification Aid wants to import data from a CSV file into a Data Extension. The CSV file contains all relevant dat a. New records should be added to the Data Extension, and records which are not in the file should be removed from the Data Extension. Which import operation should be chosen for this? Choose 1.

Question25: Northern Trails Outfitters is using REST API to send emails to customers after a purchase.
Which considerations should be taken regarding the token used in the API Call?

Question26: A developer wants to aggregate monthly energy usage data over a four month period for each subscriber within an email. The monthly usage values are stored in variables for each month in the following way:
How should the developer use AMPscript to generate the total?

Question27: A developer wants to create a CloudPage which is linked from an email. %%[SET @point = RequestParameter(x) SET @value = 5 IF Length(@point) > 1 THEN SET @value = 1 ELSEIF Length(@point)>2 THEN SET @value = 2 ELSEIF Length(@point) >3 THEN SET@value = 3 ELSEIF Length(@point) >4 THEN SET @value = 4 ENDIF]%% Which is the expected value of @value if x = 'Tacos'?

Question28: Certification Aid created a journey and event definition in Marketing Cloud. Which of the following resources are relevant to inject Contacts into the journey using the REST API? Choose 2.

Question29: What parameter should a developer include to ensure the MobileConnect Contact is tied to the Email Contact when making a QueueMO call for an existing email subscriber?

Question30: A developer wants to add an image to Content Builder via the API and retrieve the image's published URL.
Which method should the developer use?

Question31: An email requires custom AMPscript to append the subscriber's zip code to a link in the email. A field name zipcode already exist in the sending data extension. Its important Marketing Cloud tracks subscribers who click on the link. Which two AMPscript functions should be used in the setup? Choose

Question32: A developer is using the legacy endpoint www.exacttargetapis.com and has been asked to switch to Tenant Specific Endpoints (TSEs). What is a benefit of switching to TSEs?

Question33: How many month of data can a developer query from the tracking data views (_Sent, _Open, _Click)?

Question34: A developer wants to personalize a welcome email with the recipient's first name from the Customers data extension, which is different from the targeted sending data extension named NewSubscribers. Both data extensions contain the unique identifier in a field named CustomerKey. Which AMPscript Syntax would populate the first name personalization as requested?

Question35: A developer wants to use the Marketing Cloud SOAP API to retrieve which subscribers were sent a particular email. Which SOAP API object should be used?

Question36: A developer initiated a batch delete of Contacts in Contact Builder due to an import error during implementation. There are over two million records that need to be deleted.
Which two factors should be considered when batch deleting large volumes of contacts?Choose 2 answers

Question37: A developer used LookupRows to retrieve data when building a dynamic email.
What should be the next step before using this rowset within a FOR loop?

Question38: A developer identified duplicate contacts and initiated a Contact Delete process for 10 million subscribers. How could the process be expedited?

Question39: NTO wants to trigger a receipt email via the SOAP API whenever a customer makes a purchase. Their developer wrote the call using the TriggerSendDefinition object and the Create method, but no emails have been sent during his initial testing. Which object and method should the developer use?

Question40: A developer identified duplicate contacts and initiated a Contact Delete process for 10 milion subscribers. How could the process be expedited?

Question41: A particular data extension need to be configured to store six months of data.
How should data retention be added to the data extension in Email Studio?

Question42: A developer is leveraging the SOAP API to dynamically display Profile and Preference Attributes in a custom profile center. Which method could be used to support the dynamic functionality?

Question43: A particular data extension need to be configured to store six months of dat a. How should data retention be added to the data extension in Email Studio?

Question44: Northern Trail Outfitters (NTO) uses a numeric identifier for Subscriber Key. Customer data is stored in a data extension with the Subscriber Key set as a Primary Key.
Which step is required for NTO when creating relationships for this data extension in Data Designer'

Question45: How often should a developer request a new token when making multiple API calls in v1?

Question46: Certification Aid wants to import an encrypted CSV file from the Marketing Cloud Enhanced FTP server.
Which two File Transfer activities are needed to achieve this? Choose 2.

Question47: A developer wants to expand their knowledge of Query Activities. They want to identify email addresses that have bounced in the last 30 days, along with the Bounce Reason and some additional subscriber specific data; however, the SQL they have written does not return any records. Below is the SQL statement:

What updates should be made to ensure this SQL statement returns the desired results?

Question48: Certification Aid wants to automate the import of zipped files into a Data Extension. The zip files are placed on the Marketing Cloud Enhanced FTP server every night. Which activity is needed before those files can be imported? Choose 1.

Question49: A developer wants to build an audience by identifying subscribers who opened a specific email. Which query should the developer use?

Question50: NTO is using an asyncrhonous SOAP API call to the TriggerSend object to send order confirmation email to their customers. Which API object and attribute should be used to retrieve the status of the API call?

Question51: A developer created an email with AMPscript variable as the subject line. The subject line variable was recently updated, but when testing the email, the wrong subject line continues to appear in the inbox. The developer thinks another, outdated, subject line variable is declared within the email. Where could the outdated variable be located?

Question52: Northern Trail Outfitters (NTO) wants to determine the best identifier for subscribers across all channels.
What should be recommended5

Question53: Which programming language should be used in email messages? Choose 1.

Question54: Which action could the RaiseError AMPscript function be configured to perform?

Question55: A developer wants to create an AMPscript FOR loop that populates HTML table rows based on the number of rows and data in a target DE. Where should the developer place the FOR keyword to begin the loop?

Question56: A sendable data extension with a text field named 'Balance' contains the value S6.96 for a particular record. The following AMPscript statement is included in an email:
IF (Balance > 6.00) THEN
SET @Result = 'Balance is more than $6.00
ENDIF
Why would this IF statement yield unintended results?

Question57: A developer wants to configure performance tracking of the content dynamically created via AMPscript in an email. Which two steps should be performed to achieve this objective? Choose 2

Question58: A developer wants to create an HTML table where rows will alternate background colors between white and red.The developer does not know how many rows will be sent within each email, and decides to use a loop and assigns the RowCount() of the table rows to the variable @numerator. What is the recommended AMPscript logic to determine the background color of each table row within the loop?

Question59: A new record is appended to the Orders data extension each time a customer makes a purchase. Which SQL statement would select a unique list of subscribers who have made multiple purchases?

Question60: A developer is writing a query to select unique subscribers who opened any emails sent since the beginning of the previous day.
Which query would provide that result?
A)

B)

C)

Question61: Adeveloper wants to retrieve daily JSON data from a customer's API and write it to a data extension for consumption in Marketing Cloud at a later time.
What set of Server-Side JavaScript activities should the developer use?

Question62: NTO wants to exclude sending an email at send time to those with a record on the 'Exclude' Data Extension. The primary key on this data extension is SubsciberKey. How would a developer write the Exclusion Script?

Question63: NTO puts the word TEST at the beginning of the name for each testemai. Which query would return the subs who were sent those emails?

Question64: A company needs to retrieve a large number of rows from a data extension via the API.
Which two solutions would optimize the performance?
Choose 2 answers

Question65: NTO uses an external CRM which only exports encrypted files. NTO's marketing manager team wants to use some of the subscriber data found in the CRM for future marketing sends. Which three actions should be included in an automation given thse requirements? Choose 3

Question66: NTO had an Enterprise 2.0 account; subscribers unsubscribers from the business unit only. A developer is identifying subscribers who unsubscribed from any of the NTO child business units. Which method would identify the most accurate status fro subscribers of each business unit?

Question67: A developer needs to identify all subscribers who were sent Job ID 420 but did not click any links. Which SQL statement would produce the desired results?

Question68: A developer wants to build an email that dynamically populates the physical address of a company's locations using the variable address. The deployment goes to millions of subscribers and the developer wants the fastestpossible performance.
Which AMPscript solution should be recommended?

Question69: A developer wants to retrieve a row of data from a data extension using the SOAP API. Which API Object should be used for this call?

Question70: A developer created a landing page in CloudPages which return unique content when subscriber data is located on a related data extension. The developer does not know if all subscribers have rows in the related data extension, and want default content to render if no subscriber data is found on the related data extension.
Which best practice should the developer follow to control the unique and default content?

Question71: What is the purpose of the IF statement below?

Question72: A developer wants to include a comment within an AMPscript code block for the benefit of other developers who will be reviewing the code.
Which syntax should the developer use?

Question73: A developer needs to process a payload from an external system in a CloudPage.
What Marketing Cloud Server-Side JavaScript Platform function should be used for converting a string payload in JSON format to a JavaScript object?

Question74: A developer is making an API REST call to trigger an email send. An access token is used to authenticate the call.
How long are Marketing Cloud v1 access tokens valid?

Question75: When do synchronous REST API calls to Marketing Cloud time out? Choose 2.

Question76: A developer identified duplicate contacts and wants to delete roughly 10 million subscribers using Contact Delete. How could the process be expedited?

Question77: Which action could the RaiseError AMPscript function be configured to perform?

Question78: A developer wants to populate a data extension with the date of the most recent click for each subscriber.
Which query would accomplish this?

Question79: A sendable data extension with a text field named 'Balance' contains the value S6.96 for a particular record. The following AMPscript statement is included in an email:
IF (Balance > 6.00) THEN
SET @Result = 'Balance is more than $6.00
ENDIF
Why would this IF statement yield unintended results?

Question80: From which business unit could the Contact Delete feature be used within an Enterprise 2.0 account?

Question81: Certification Aid wants to trigger and email send in Marketing Cloud when a purchase is made on their website. Which API should be used for this? Choose 2.

Question82: Which of the following is a valid comment within an AMPscript code block? Choose 1.

Question83: A developer wants to populate a data extension with the date of the most recent click for each subscriber. Which query would accomplish this?

Question84: A developer wants to design a custom subscription center in CloudPages.The developer prefers to code in AMPscript, but is also skilled in Server-Side JavaScript. While the developer is confident their code is of high quality, they would still like to handle unexprected errors gracefully to ensure the best user experience. Which feature should handle this scenario?

Question85: A developer needs to know how many records are contained in a particular data extension. This will dictate what is displayed on a landing page.
Which AMPscript function returns the number of rows in a specified data extension?

Question86: A developer is troubleshooting why a parent-level data extension cannot be accessed by a child business unit.
What should the developer check to validate the data available can be accessed for child business unit queries?

Question87: A developer wants to upload a base64-encoded file to Content Builder using an API Installed Package but receives an insufficient Privileges error. What should the developer check to troubleshoot the error?

Question88: A developer created an email with AMPscript variable as the subject line. The subject line variable was recently updated, but when testing the email, the wrong subject line continues to appear in the inbox. The developer thinks another, oudated, subject line variable is declared within the email. Where could the outdated variable be located?

Question89: A developer is managing the data model programmatically and needs to access Attribute Group schema via the API. Which API should the developer use?

Question90: A developer wants to expand their knowledge of Query Activities. They want to identify email addresses that have bounced in the last 30 days, along with the Bounce Reason and some additional subscriber specific data; however, the SQL they have written does not return any records. Below is the SQL statement:

What updates should be made to ensure this SQL statement returns the desired results?

Question91: A developer wants to configure an automation to import files placed on the SFTP shared by a customer's data vendor. The automation will start when a file matching a specific naming pattern is encountered in the Import folder. The first step of the automation is a File Import Activity referencing a substion string for the matching file. Which substituon string represents the name of the file?

Question92: A doctor's office creates Populations for staff, patients and vendors. What is the maximum number of Populations that should be created to ensure performance?

Question93: A developer is creating a custom preference center and wants to log unsubscribeevents from the CloudPage.
Which set of parameters should be captured and provided to the LongUnsubEvent Execute Call to ensure accurate unsubscribe information?

Question94: Certification Aid wants to add new customers to a cross-channel welcome campaign when they register on the company website. Which API should be used for this? Choose 1.

Question95: NTO wants use Personally Identifiable Information (PII) data to personalize email communications, but does not want to store PII data in Marketing Cloud. Which feature could they use to personalize emails from an external data source?

Question96: NTO is using a mobile campaign to collect an email addresses of interested subscribers. Using AMPscript's API functions they will send a confirmation email when an email is texted into their short code. Which two objects are required to successfully create a TriggerSend object? Choose 2

Question97: A developer needs to configure an Email Send Logging Data Extension for a new business unit. Which option should be used?

Question98: NTO puts the word TEST at the beginning of the name for each test email. Which query would return the subs who were sent those emails?

Question99: A developer has a text field in a data extension they want to format using the FormatCurrency AMPscript function. Which two values would return $6.96? Choose 2

Question100: A developer receives a request to integrate Marketing Cloud with a lead capture tool. The lead capture tool will call the Marketing Cloud API to create a data extension every time a new lead form is published. The created data extension's name should match the name of the form exactly.
Which API feature could the developer use to dynamically create these data extensions?

Question101: Northern Trail Outfitters (NTO) stores most of their customer data in Marketing Cloud. They do not mind their data being viewed in clear text within SFMC to users who have access, but they want to ensure the underlying database files are encrypted at rest in case the physical media is stolen.
Which encryption method should NTO use?

Question102: A developer wants to design a custom subscription center in CloudPages. The developer prefers to code in AMPscript, but is also skilled in Server-Side JavaScript. While the developer is confident their code is of high quality, they would still like to handle unexprected errors gracefully to ensure the best user experience. Which feature should handle this scenario?

Question103: NTO puts the word TEST at the beginning of the name for each test emai. Which query would return the subs who were sent those emails?