Salesforce CRT-550 Quiz 21 Topic 5 Questions 101-105

Question: 1

A consulting has a data extension that contains all current product information. The customer wants to refresh data each morning by importing a CSV containing today's product catalog. The product catalog is never the same; products can be added and removed.

Which import type should be used?

AOverwrite

BAdd Only

CAdd/Update

DUpdate Only

Show Answer

Question: 2

Which two statements are correct about Send Logging? Choose 2 answers

ASend Log data extensions are archived automatically based on retention settings.

BAMPscript can be used to pull data from Send Logs for use within emails.

CA business unit can support up to three Send Logs.

DSQL Query Activities can reference Send Logs in combination with system data views.

Show Answer

Question: 3

The customer has the following requirements for storing engagement data in their data warehouse:

*All email open and click activity must be pulled daily from Marketing Cloud.

*Output files must meet the specific requirements for the data warehouse.

*All the activity must be provided via SFTP in one file.

Which automation workflow meets the customer requirements?

AData Extract Activity of Tracking Extracts that combines data into required file > File Transfer Activity

BReport activity that generates Recent Send Summary report > Report delivered directly to SFTP

CSQL Query Activity to pull data view information > Data Extract Activity of data extension > File Transfer Activity

DData Extract Activity of data view tables > SQL Query Activity to create the required file > File Transfer Activity

Show Answer

Question: 4

A restaurant supply company captures email subscribers and leads through trade shows. This has always been a manual process with booth visitors leaving contact information in a fishbowl. The restaurant supply company is updating their process to an online sweepstakes entry that allows entrants to confirm opt-in for a monthly newsletter.

Which two components are appropriate for this solution? Choose 2 answers

ACloudPage with Web Collect to add entrants in to a data extension

BSend Email Activity with a link to a subscription center

CCloudPage with Smart Capture to add entrants in to a data extension

DData extension with double opt-in status defined

Show Answer

Question: 5

A customer will provide a single daily file on the Marketing Cloud SFTP at 3 a.m. and needs an alert if the file is NOT present on time. The file needs to be:

*Imported iota a staging data extension.

*Separated into two different data extensions.

Which automation should meet these requirements?

AScheduled Starting Source: Data Extract > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

BFile Drop Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

CScheduled Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

DFile Drop Starting Source: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1

Show Answer

Salesforce CRT-550 Quiz:21 Topic:5 Questions:101-105