MCE-Dev-201 無料問題集「Salesforce Certified Marketing Cloud Engagement Developer」
Northern Trail Outfitters has an Enterprise 2.0 account with 15 business units. Each business unit can access a Shared Data Extension named 'Inventory', which contains the details for each product. A Boolean field named
'InStock' indicates whether the item is available.
Which snippet of AMPscript would return all products which are currently available?
'InStock' indicates whether the item is available.
Which snippet of AMPscript would return all products which are currently available?
正解:A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
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 containline 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?
Which SQL functions could be used to change each line break to a single space?
正解:B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
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 specificdata; 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?

What updates should be made to ensure this SQL statement returns the desired results?
正解:B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)