Salesforce Marketing Cloud Developer 問題練習

Question No : 1
NTO had an Enterprise 2.0 account; subscribers unsubscribes 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 for subscribers of each business unit?

• A.Create Data Extract of all Subscribers within the Parent Business unit
• B.Create Data Extracts of All Subscribers within each Child business unit
• C.Query unsubscriber from _Subscribers within the Parent business unit
• D.Query status from _ListSusbscribers within the Parent business unit

答えを確認する

正解:

Question No : 2
An email requires custom AMP script 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 AMP script functions should be used in the setup? Choose

• A.2Lookup
• B.Contact
• C.RedirectTo
• D.HTTPGet

答えを確認する

正解:

Question No : 3
A developer, who is new to Marketing Cloud, needs to design a landing page for a new customer. They choose to use Server-Side JavaScript (SSJS) due to their extensive knowledge of JavaScript from previous projects.
Which two features would the developer be able to leverage in their Server-Side code? Choose 2 answers

• A.Wrapping of AMP script in SSJS code
• B.Direct modification of the DOM
• C.External Libraries to extend functionality
• D.Include Try/Catch blocks within the code

答えを確認する

正解:

Question No : 4
Landing pages can use which SSJS library? 1. Core LibraryZ. Platform Library 3. SSJS Library

• A.Onlyl1 and 3
• B.Only1 ard2
• C.Only 2 and 3
• D.All 1,2 and 3
• E.None of these

答えを確認する

正解:

Question No : 5
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 AMP script to generate the total?

• A.SET @total - (@jan - 3fet - @mar @apr>
• B.SET @total = AZD((@jan @feb) @mar) @apr)
• C.SET @total - ADD(@jan,ADD(@feb,ADD(@mar,@apr)))
• D.SET @total = (ADD(@jan,@feb), ADD(@mar, @apr))

答えを確認する

正解:

Question No : 6
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 does not allow DateAdd functions in Query Activities. They should define a specific date.
• B.Marketing Cloud _Bounce data view does not contain EmailAddress. They should join on Subscriberl
• C.Marketing Cloud Data Views only hold 20 days worth of data. They should narrow scope of DateAdd function.
• D.Marketing Cloud does not allow use of GETDATE function. They should define a specific date.

答えを確認する

正解:

Question No : 7
A developer is experiencing timeouts when testing a SQL Query Activity in Automation Studio.
How should the developer optimize the query?

• A.Configure a longer timeout period within Administration in Automation Studio.
• B.Use intermediate tables to break queries into smaller parts.
• C.Ensure all SQL Query Activities are in the same step in the automation.
• D.Limit joins to the INNER JOIN within all SQL Query Activities.

答えを確認する

正解:

Question No : 8
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.

• A.To decrypt the import file on the Enhanced FTP server.
• B.To move the import file from the Safehouse to Marketing Cloud.
• C.To decrypt the import file on the Safehouse.
• D.To move the import file from the Enhanced FTP server to the Safehouse

答えを確認する

正解:

Question No : 9
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

• A.The data in the data extensions used at the time of send was overwritten.
• B.The email used at the time of send was deleted, updated, or moved.
• C.The sender profile used at the time of send was overwritten.
• D.The data extension used at the time of send was moved to another folder.

答えを確認する

正解:

Question No : 10
A developer wants to include an AMP script 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 AMP script conditional statement?

• A.%%[IF @level == 'premier' THEN SET @message = You are premier member
• B." ENDIF IF @level == 'premier' THEN SET @message = 'Upgrade to premier now
• C.'" 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!
• D.%%=IIF @level == premier, You are a premier member" Upgrade to premier now!
• E.%%IF(@level == 'premier') THEN 'Upgrade to premier now!' ELSE 'You are a premier member' ENDIF]%%

答えを確認する

正解:

Question No : 11
Customer data has been imported into a staging data extension and needs to be normalized before adding into the master data extension. A text field named 'birthday' contains date values in various formats. Some of the values are valid dates, but some are not.
Which SQL keywords and functions could be used to write the query'' Choose 2 answers

• A.CASE, ISDATE, CONVERT
• B.WHERE, ISDATE, CONVERT
• C.CASE, ISDATE, CAST
• D.UPDATE, ISDATE, CONVERT

答えを確認する

正解:

Question No : 12
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

• A.Up to one million records can be deleted in each batch.
• B.To more quickly remove contact information, use the suppression period length of 14.
• C.The deletion process supersedes other automated account activities.
• D.The suppression status does not show for individual contacts until the entire batch processes.

答えを確認する

正解:

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

• A.Use intrisic functions in the WHERE clause
• B.Use SELECT * to include all fields
• C.Use Primary key(s) on fields used in joins
• D.Use intermediate tables to stage data
• E.Only update records that have changed since last execution

答えを確認する

正解:

Question No : 14
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?

• A.Encrypted Data Sending
• B.Field-Level Encryption
• C.Tokenized Sending
• D.Transparent Data Encryption

答えを確認する

正解:

Question No : 15
Clock Kicks would like to encrypt and store form data submitted from a CloudPage in a data extension using AMPscript.
Which three encryption options could be used when creating a new key in Key Management? Choose 3

• A.SAML
• B.Asymmetric
• C.RSA
• D.Salt
• E.Symmetric

答えを確認する

正解: