Marketing-Cloud-Developer exam questions for practice in 2022 Updated 143 Questions
Updated Jan-2022 Premium Marketing-Cloud-Developer Exam Engine pdf - Download Free Updated 143 Questions
NEW QUESTION 49
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?
- A. Marketing Cloud Data Views only hold 20 days worth of data. They should narrow scope of DateAdd function.
- B. Marketing Cloud does not allow use of GETDATE function. They should define a specific date.
- C. Marketing Cloud does not allow DateAdd functions in Query Activities. They should define a specific date.
- D. Marketing Cloud _Bounce data view does not contain EmailAddress. They should join on SubscriberlD.
Answer: D
NEW QUESTION 50
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?
- A. LTRIM and RTRJM
- B. FORMAT and SPACE
- C. REPLACE and CHAR
- D. REPLICATE and NCHAR
Answer: C
NEW QUESTION 51
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?
- A. Query status from _ListSusbscribers within the Parent business unit
- B. Query unsubscribers from _Subscribers within the Parent business unit
- C. Create Data Extract of all Subscribers within the Parent Business unit
- D. Create Data Extracts of All Subscribers within each Child business unit
Answer: D
NEW QUESTION 52
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?
- A. The email interaction has beed started
- B. The send permissions have beeen granted for the Client ID and Client Secret within Installed Packages.
- C. The email interaction has been published.
- D. The automation permissions have been granted for the Client ID and Client Secret within Installed Packages.
Answer: B
NEW QUESTION 53
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
- A. Contact
- B. RedirectTo
- C. HTTPGet
- D. 2Lookup
Answer: A,B
NEW QUESTION 54
How many month of data can a developer query from the tracking data views (_Sent, _Open, _Click)?
- A. One Month
- B. Six Months
- C. 12 Months
- D. There is no limit
Answer: B
NEW QUESTION 55
A marketer is troubleshooting why an email send's tracking information is not available in Sales Cloud. The marketer confirms Marketing Cloud Connect is installed properly. What should be confirmed next to continue troubleshooting the send's tracking information?
- A. The tracking destination folder was set to My Tracking
- B. The audience was built using a Triggered Send Data Extension template
- C. The audience was a Salesforce Data Extension containing the appropriate SFID
- D. The email was sent to the All Subscribers list
Answer: C
NEW QUESTION 56
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?
- A. Marketing Cloud automatically handles any error scenario that may occur
- B. Wrapping thecode in a AMPscript HandleError block
- C. Wrapping the code in a Server-Side JavaScript Try/Catch block
- D. Using RaiseError AMPscript function when an error occurs
Answer: C
NEW QUESTION 57
Certification Aid wants to create a file drop automation with a filename pattern. An import file is placed daily on the Marketing Cloud Enhanced FTP server, and the file name always starts with the current month and day (e.g. OCT26). How should the filename pattern be defined? Choose 2.
- A. Begins With operator
- B. Ends With operator
- C. %%Month%%%%Day%%
- D. %%MMDD%%
Answer: A,C
NEW QUESTION 58
In which three ways should a developer optimize a query activity if it is currently timing out? Choose 3
- A. Use intermediate tables to stage data
- B. Only update records that have changed since last execution
- C. Use intrisic functions in the WHERE clause
- D. Use Primary key(s) on fields used in joins
- E. Use SELECT * to include all fields
Answer: A,B,D
NEW QUESTION 59
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 Subscriber Key. How would a developer write the Exclusion Script?
- A. Rowcount (LookupRows('Exclude',SubsciberKey,_SubscriberKey) >0
- B. Rowcount (LookupRows('Exclude','SubscriberKey,_SubscriberKey) >1
- C. Lookup ('Exclude','SubscriberKey', 'EmailAddress', emailddr_)
- D. Lookup ('Exclude','EmailAddress','SubscriberKey',SubscriberKey)
Answer: A
NEW QUESTION 60
A developer wants to include an AMPscript if/else statement in an email to satisfy the condition "if the subscriber's tier is not premier then display heading encouraging them to upgrade." The tier value has already been set as variable named @level. How should the developer write this AMPscript conditional statement?
- A. %%IF(@level == 'premier') THEN 'Upgrade to premier now!' ELSE 'You are a premier member' ENDIF]%%
- B. " ENDIF IF @level == 'premier' THEN SET @message = 'Upgrade to premier now
- C. %%[IF @level == 'premier' THEN SET @message = You are premier member
- D. '" ENDIF]%% %%=v(message)=%%%%=IF(@level IS 'premier', Upgrade to premier now! You are a premier member%%=IIF(@level = 'premier', 'You are a premier member!', Upgrade to premier now!
- E. %%=IIF @level == premier, You are a premier member" Upgrade to premier now!
Answer: D
NEW QUESTION 61
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?
- A. Exclusion Script
- B. Auto-Suppression list
- C. Try/Catch SSJS functions
- D. RaiseError AMPscript function
Answer: A
NEW QUESTION 62
Contact Builder can be used to create a relational model of an organization's data within Marketing Cloud. Which three factors should be taken into consideration when preparing data to be used in Contact Builder? Choose 3 answer
- A. Normalizing data to reduce redunancy
- B. Assigning data relationships and primary keys across all channels
- C. Verifying data address marketing needs
- D. Verifying all data extensions have a sendable value
- E. Verifying each data extension has the required Email Address field populated
Answer: B,C,D
NEW QUESTION 63
Certification Aid wants to include SSJS in an email message. Which code block can be used for this? Choose
2.
- A. <script runat=server></script>
- B. <script language=ssjs></script>
- C. <script runat=serverlanguage=javascript></script>
- D. <script language=javascript></script>
Answer: A,C
NEW QUESTION 64
Northern Trail Outfitters uses a number to uniquely identify contacts across different marketing channels.
Which two actions should the developer take to ensure the contacts relate across channels in Marketing Cloud when working with the data model?
Choose 2 answers
- A. Link the numeric field value to the Contact ID in Attribute Groups in Contact Builder.
- B. Create Attribute Groups linking the unique identifier to the Contact for each channel.
- C. Use a unique identifier spec fie to each channel and automatically connect then-..
- D. store the numeric unique identifier value as a Text data type In data extensions.
Answer: A,D
NEW QUESTION 65
A marketing director at Northern Trail Outfitters wants to analyze the Send, Click, and Open Data Views.
Which activities should the developerbuild to generate the data before transferring it to the SFTP?
- A. Query Activity > Data Extension Extract
- B. Filter Activity > Data Extension Extract
- C. Data Views Extract > Filter Activity
- D. Query Activity > Tracking Extract
Answer: C
NEW QUESTION 66
Which SSJS library can be used in landing pages? Choose 1.
- A. None
- B. Both
- C. Platform
- D. Core
Answer: B
NEW QUESTION 67
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.
- A. Data Extension Import activity
- B. Data Extract activity
- C. File Import activity
- D. File Transfer activity
Answer: D
NEW QUESTION 68
......
Authentic Marketing-Cloud-Developer Dumps With 100% Passing Rate Practice Tests Dumps: https://pass4sure.practicedump.com/Marketing-Cloud-Developer-exam-questions.html