別格で売上ナンバーワンMarketing-Cloud-Developer試験にはは2024年最新のSalesforce練習問試験合格させます
Salesforce Developers問題集でMarketing-Cloud-Developer試験完全版問題で試験学習ガイド
質問 # 62
A developer wants to create a Synchronized Data Extension containing Lead data from Sales Cloud. They only want to include record which contain a phone number. Each of the following flied contains this information per these rules: -Phone is not black (Data Type = Phone) -PhoneExist is true (Data Type = Boolean) -ValidPhone is 'true' (Data Type = Formula(Boolean)) -ContactType equals 'Phone' (Data Type = Text). Which field could be used to select a subset of records in the synchronization configuration?
- A. ValidPhone
- B. PhoneExists
- C. ContactType
- D. Phone
正解：D
質問 # 63
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. File drop to the SFTP Root directory
- B. Import definition to the necessary data extension
- C. File transfer activity to the Safehouse for decryption
- D. File drop to the SFTP Import directory
- E. File transfer activity to the Import directory for decryption
正解：B、C、D
質問 # 64
Certification Aid wants to encrypt data stored in Marketing Cloud. It is fine if unencrypted fields arevisible to Marketing Cloud and Salesforce users, but the underlying data should be encrypted at rest to prevent physical data theft. Which encryption method should be chosen? Choose 1.
- A. Field-Level Encryption
- B. Transparent Data Encryption
- C. Tokenized Sending
- D. Asymmetric Encryption
正解：B
解説：
Transparent Data Encryption (TDE) is designed to protect data at rest by encrypting the underlying storage of the database. This method ensures that data is encrypted on disk to prevent physical data theft while allowing it to remain accessible to authorized users within the system.
質問 # 65
Certification Aid wants to encrypt data stored in Marketing Cloud. It is fine if unencrypted fields are visible to Marketing Cloud and Salesforce users, but the underlying data should be encrypted at rest to prevent physical data theft. Which encryption method should be chosen? Choose 1.
- A. Field-Level Encryption
- B. Asymmetric Encryption
- C. Transparent Data Encryption
- D. Tokenized Sending
正解：B
質問 # 66
A developer needs to write AMPscript to ensure the expiration date on a coupon is the last day of the month.
What would produce the desired result?
- A. Find the first day of next month and subtract one day
- B. Use the date format stringfor last day of month within FormatDate
- C. Add one month using DateAdd to now
- D. Add 30 days using DateAdd to now
正解：A
解説：
To ensure the expiration date on a coupon is the last day of the month, the developer shouldfind the first day of the next month and subtract one day (A). This approach guarantees that the expiration date is set to the last day of the current month.
Example AMPscript:
SET @firstDayNextMonth = DateAdd(DatePart(Now(), "MM"), 1, "M") SET @lastDayCurrentMonth = DateAdd(@firstDayNextMonth, -1, "D") References:
* Salesforce Marketing Cloud AMPscript Guide
* Salesforce Marketing Cloud Documentation
質問 # 67
New subscribers at Northern Trail Outfitters (NTO) are added to a data extension. NTO would like to send these subscribers a welcome series with Journey Builder.
What would allow the data extension to be selected for journey entry'
- A. At least one Campaign must be associated to the data extension.
- B. The Triggered Send Template must be used to create the data extension.
- C. The data extension must contain a field of the EmailAddress data type.
- D. The data extension must be configured for sending.
正解：D
質問 # 68
Certification Aid wants to encrypt data stored in Marketing Cloud. It is fine if unencrypted fields are visible to Marketing Cloud and Salesforce users, but the underlying data should be encrypted at rest to prevent physical data theft. Which encryption method should be chosen? Choose 1.
- A. Field-Level Encryption
- B. Transparent Data Encryption
- C. Tokenized Sending
- D. Asymmetric Encryption
正解：B
質問 # 69
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'?
- A. 0
- B. 1
- C. 2
- D. 3
正解：A
質問 # 70
A developer wants to delete a batch of subscribers from Marketing Cloud. The developer performs a Contact Delete on a batch of records in a data extension in Contact Builder. Which scenario would cause subscriber records to remain in the data extension?
- A. Contact Delete process does not delete rows from data extensions
- B. Non-sendable data extension with SubscriberKey field
- C. Sendable data extension with SubscriberKey and EmailAddress fields
- D. Sendable data extension with SubsciberKey field
正解：B
質問 # 71
A developer wants a link to be dynamic based on subscriber attributes. Rather than create numerous links, the developer uses AMPscript to set the link's value as a variable. The variable will be used within the <a> tag.
What should thedeveloper do within the <a> tag to ensure clicks are tracked for the variable? Choose 2
- A. Ensure the Conversion attribute is 'true'
- B. Wrap the variable in a v function
- C. Wrap the variable in a RedirectTo function
- D. Include a variable for the Alias attribute
正解：C、D
解説：
To ensure that clicks are tracked for a dynamic link created using AMPscript, the developer should wrap the link variable in aRedirectTofunction and include an alias attribute for tracking purposes.
* RedirectTo Function: This function helps ensure that the link click is properly tracked by Salesforce Marketing Cloud (SFMC). The function takes a URL and ensures that tracking parameters are appended correctly.
%%[
SET @dynamicLink = "http://example.com/?id=" + AttributeValue("SubscriberID") ]%%
<a href="%%=RedirectTo(@dynamicLink)=%%">Click Here</a>
質問 # 72
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. File drop to the SFTP Root directory
- B. Import definition to the necessary data extension
- C. File transfer activity to the Safehouse for decryption
- D. File drop to the SFTP Import directory
- E. File transfer activity to the Import directory for decryption
正解：B、C、D
解説：
To automate the process of importing encrypted files from an external CRM, the following actions should be included:
* File drop to the SFTP Import directory: Place the encrypted files in the SFTP Import directory to trigger the automation.
* File transfer activity to the Safehouse for decryption: Move the encrypted files to the Safehouse for decryption, ensuring the data is securely handled.
* Import definition to the necessary data extension: After decryption, import the data into the relevant Data Extension for use in marketing sends.
質問 # 73
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?
- A. SELECT * FROM _Job INNER JOIN _Sent on JobID = JobID WHERE EmailName LIKE 'TEST%'
- B. SELECT * FROM _Job J INNER JOIN _Sent S on J.JobID = JobID = S.JobID WHERE J.EmailName
= 'TEST%' - C. SELECT * FROM _Job J INNER JOIN _Sent S on J.EmailName LIKE 'TEST%'
- D. SELECT * FROM _Job J INNER JOIN _Sent S ON.JobID = S.JobID WHERE J.EmailName LIKE
'TEST%'
正解：D
質問 # 74
A developerwants 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?
- A. Platform.Function.HTTPGet(); Platform.Function.ParseJSON(); Platform.Function.UpsertData();
- B. Platform.Function.InvokeRetrieve(); Platform.Function.ParseJSON(); Platform.Function.UpsertData();
- C. Platform.Function.HTTPGe(); Platform.Function.Stringify(); Platform.Response.Write();
- D. Platform.Function.InvokeRetrievef); Platform.Function.Stringify(); Platform.Function.UpsertDE();
正解：D
解説：
To retrieve daily JSON data from a customer's API and write it to a data extension, the developer should use the following set of Server-Side JavaScript activities:
* Platform.Function.HTTPGet();- To make the HTTP GET request to the customer's API and retrieve the JSON data.
* Platform.Function.ParseJSON();- To parse the retrieved JSON data.
* Platform.Function.UpsertData();- To upsert the parsed data into a data extension.
Example code snippet:
varresponse =Platform.Function.HTTPGet("https://api.customer.com/data");varjsonData
=Platform.Function.ParseJSON(response);Platform.Function.UpsertData("DataExtensionName",
["PrimaryKeyField"], jsonData);
References:
* Salesforce Marketing Cloud SSJS HTTP Functions
* Salesforce Marketing Cloud SSJS Data Functions
質問 # 75
A new record is appendedto 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?
- A. SELECT DISTINCT SubscriberKey FROM Orders
- B. SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*)>1
- C. SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey
- D. SELECT TOP 1 SubscriberKey FROM Orders
正解：B
解説：
To select a unique list of subscribers who have made multiple purchases, the developer should use the following SQL statement:
SELECTSubscriberKeyFROMOrdersGROUPBYSubscriberKeyHAVINGCOUNT(*)>1
This query groups the records by SubscriberKey and selects only those groups where the count of records is greater than one, indicating multiple purchases.
References:
* SQL GROUP BY Statement
* SQL HAVING Clause
質問 # 76
A developer wants to populate a data extension with the date of the most recent click for each subscriber. Which query would accomplish this?
- A. SELECT c.SubscriberKey, c.eventDate FROM _Click c WHERE c.IsUnique = 1
- B. SELECT c.SubscriberKey, MAX(c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey
- C. SELECT c.SubscriberKey, MIN (c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey
- D. SELECT TOP 1 c.SubscriberKey, c.eventDate FROM _Click c ORDER BY c.eventDate DESC
正解：B
質問 # 77
A developer identified a use case where atriggered 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 been published.
- B. The automation permissions have been granted for the Client ID and ClientSecret within Installed Packages.
- C. The send permissions have been granted for the Client ID and Client Secret within Installed Packages.
- D. The email interaction has been started
正解：C
質問 # 78
From which business unit could the Contact Delete feature be used within an Enterprise 2.0 account?
- A. The Parent account
- B. Only in Agency accounts
- C. The business unit where the contact was introduced
- D. Any business unit
正解：B
質問 # 79
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 been published.
- B. The email interaction has beed started
- C. The send permissions have beeen granted for the Client ID and Client Secret within Installed Packages.
- D. The automation permissions have been granted for the Client ID and Client Secret within Installed Packages.
正解：C
質問 # 80
Customer data has been imported into a staging data extension andneeds 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, CAST
- B. CASE, ISDATE, CONVERT
- C. UPDATE, ISDATE, CONVERT
- D. WHERE, ISDATE, CONVERT
正解：A、B
解説：
To normalize customer data in a staging data extension where a text field named 'birthday' contains date values in various formats, the developer can use the following SQL keywords and functions:
* CASE, ISDATE, CONVERT (A)- These functions can be used to handle different date formats and convert them into a consistent format.
* CASE, ISDATE, CAST (C)- Similar to the above, CAST can be used to convert text to date format if ISDATE returns true.
Example SQL query:
SELECTCASEWHENISDATE(birthday)=1THENCONVERT(DATE,
birthday)ELSENULLENDASnormalized_birthdayFROMStagingDataExtension
References:
* Salesforce Marketing Cloud SQL Reference
* SQL CASE and ISDATE Functions
質問 # 81
A developer wants to set a variable to use a field from a Sendable Data Extension.
Which two options could be used in an AMPscript block to set the variable as a 'First Name" field from a Sendable Data Extension used to send the email? Choose 2 answers
- A. SET @firstName = %%First Name%%
- B. SET @firstName = attributeValue (''First Name'')
- C. SET @firstName = [First Name]
- D. SET @firstName = ''First Name'']
正解：A、C
質問 # 82
A developer receives Error Code 5 when performing a SOAP API call. The error states: "Cannot Perform
'Post' on objects of type 'SentEvent'".
What could be the issue?
- A. The authentication token has expired.
- B. SOAP does not supportPOST; use REST
- C. 'SentEvent' is not able to be updated using SOAP.
- D. It may be a temporary network issue.
正解：A
質問 # 83
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 tosuccessfully create a TriggerSend object? Choose 2
- A. Subscribers
- B. TriggerSendDefinition
- C. Contact
- D. Attribute
正解：A、B
解説：
To successfully create aTriggerSendobject using AMPscript's API functions, the following objects are required:
* TriggerSendDefinition (B)- Defines the parameters of the triggered send, including the email to be sent and the associated attributes.
* Subscribers (D)- Represents the individual recipients who will receive the email.
These objects ensure that the correct email is sent to the specified subscribers when the TriggerSend is executed.
References:
* Salesforce Marketing Cloud API
* AMPscript API Functions
質問 # 84
When do synchronous REST API calls to Marketing Cloud time out? Choose 2.
- A. 240 seconds for non-tracking operations.
- B. 120 seconds for non-tracking operations.
- C. 300 seconds for tracking and data retrieve operations.
- D. 240 seconds for tracking and data retrieve operations.
正解：B、C
質問 # 85
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.
- A. GET /eventDefinitions/key:{key}
- B. POST /interaction/v1/events
- C. POST/eventDefinitions/key:{key} or /eventDefinitions/{id}
- D. POST /interaction/v1/interactions/contactentry
正解：B、D
質問 # 86
......
Salesforce Marketing-Cloud-Developer試験の受験資格には、Marketing Cloudプラットフォームでの作業経験が必要であり、プラットフォームのさまざまな機能や機能の堅固な理解が求められます。また、HTML、CSS、JavaScriptなどのプログラミング言語の理解、およびPHPやPythonなどのサーバーサイドスクリプト言語の経験も必要です。
最適な道は練習テストSalesforce Marketing-Cloud-Developer問題集：https://jp.fast2test.com/Marketing-Cloud-Developer-premium-file.html
Marketing-Cloud-Developer問題集が待ってます試験問題解答：https://drive.google.com/open?id=1RAiEYyIUUV64UfqgnH1KSrWrqMBtGQeN