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
Answer(s): A,C
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:SELECT CASE WHEN ISDATE(birthday) = 1 THEN CONVERT(DATE, birthday) ELSE NULL END AS normalized_birthday FROM StagingDataExtension
Salesforce Marketing Cloud SQL ReferenceSQL CASE and ISDATE Functions
The Contact Delete feature can be used within an Enterprise 2.0 account from which business unit?
Answer(s): B
The Contact Delete feature can be used within an Enterprise 2.0 account from the Parent account (B). This ensures centralized management and compliance with organizational data governance policies.
Salesforce Marketing Cloud Documentation on Contact DeleteEnterprise 2.0 Account Management
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
Answer(s): A,D
When using Server-Side JavaScript (SSJS) in Salesforce Marketing Cloud, the developer can leverage the following features:Wrapping of AMPscript in SSJS code (A) - SSJS can include AMPscript within its code, allowing for dynamic content generation and manipulation.Include Try/Catch blocks within the code (D) - SSJS supports the use of Try/Catch blocks to handle errors and exceptions in the script, providing better control over error management.
Salesforce Marketing Cloud Server-Side JavaScript GuideAMPscript and SSJS Integration
Certification Aid wants to import data from a CSV file into a Data Extension. The CSV filecontains all relevant data. 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.
The "Overwrite" import operation is used when you want to completely replace the contents of a Data Extension with the contents of the import file. This operation adds new records from the file and removes any records that are not present in the file.Overwrite Operation: This will ensure that the Data Extension contains only the records present in the CSV file. Any existing records in the Data Extension that are not in the file will be deleted.: Salesforce Marketing Cloud Import Activity
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.
Answer(s): C,D
To trigger an email send in Marketing Cloud when a purchase is made on a website, you can use either the REST API or the SOAP API. Both APIs provide methods to send triggered emails.REST API: The REST API can be used to trigger emails by making a call to the /messaging/v1/messageDefinitionSends/{key}/send endpoint.SOAP API: The SOAP API can also be used to trigger sends by utilizing the TriggeredSend object.:Salesforce Marketing Cloud REST APISalesforce Marketing Cloud SOAP API
Post your Comments and Discuss Salesforce MCE-Dev-201 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the MCE-Dev-201 content, but please register or login to continue.