ExamGecko
Search Search Login
Home Home / Salesforce / Certified Marketing Cloud Developer
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

Northern Trail Outfitters (NTO) wants to determine the best identifier for subscribers across all channels. What should be recommended5
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 these requirements? Choose 3
A developer is building a landing page in Marketing Cloud and an email with a Call-To page will display personal information about the subscriber. In which way could the developer create the CTA link?
A developer created an email using the fasubjectLine variable as the subject line. Due to revisions, the developer declared <>subjectLine in multiple locations throughout the email, including: Which subject line will be used at the time of deployment?
A developer is working on cross-channel campaign functions for the email team at Northern Trail Outfitters. They are reviewing available APIs for the different Marketing Cloud applications to determine the most appropriate solution for each. Which application utilizes the REST API?
A developer wants to create a data model in Contact Builder. Which two applications will be able to use this newly-created data model for segmentation? Choose 2 answers
A developer is experiencing timeouts when testing a SQL Query Activity in Automation Studio. How should the developer optimize the query?
A developer wants to write a query to compile data originating from an HTML form so it can be exported in CSV format. However, the source data extension may contain line breaks within the Comments field, which makes it difficult to read and sort the resulting CSV. Which SQL functions could be used to change each line break to a single space?
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?
A developer is troubleshooting why an API client Jd and chent_secret are authenticating yet failing to access data from a child business unit. What should be checked to validate the installed package can access the child business unit data?

Question 78 - Certified Marketing Cloud Developer discussion

Report
Export

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?

A.
%%[ SET @address = field(Lookcup("Building_Locations"/ "Address", "Id",@Id), "Address") ]%%
Answers
A.
%%[ SET @address = field(Lookcup("Building_Locations"/ "Address", "Id",@Id), "Address") ]%%
B.
%% [ SET @address - field(Row(LookupRows("Building_Locations", "Address","Id"), 1),"Address") ]%%
Answers
B.
%% [ SET @address - field(Row(LookupRows("Building_Locations", "Address","Id"), 1),"Address") ]%%
C.
%%; SET @address = LookupRows(Building_Locations", "Address", "Id") ]%%
Answers
C.
%%; SET @address = LookupRows(Building_Locations", "Address", "Id") ]%%
D.
%: SET @address = Lookup(''Building_locations'', Address'', ''id''@id) ] %%
Answers
D.
%: SET @address = Lookup(''Building_locations'', Address'', ''id''@id) ] %%
Suggested answer: A
Show Answer
asked 23/09/2024
Christopher Fiotes
35 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms