Salesforce MARKETING-CLOUD-CONSULTANT Online Practice Questions and Exam Preparation

Salesforce MARKETING-CLOUD-CONSULTANT Online Questions & Answers

• Question 91:

  Northern Trail Outfitters has a file that drops intermittently to their SFTP account. Once this file drops, they want to be able to have it immediately imported and then segmented to enter a specific journey depending on the data inside the file. Which two options would meet these requirements? Choose 2 answers

  A. Scheduled Automation
  B. File Drop Automation
  C. SQL Query
  D. Decision Split
  B. File Drop Automation
  C. SQL Query

• Question 92:

  A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions--Subscribers and OrderTable, and the customer would like to include key information from both tables, such as:

  1.

  CustomerlD

  2.

  FirstName

  3.

  EmailAddress

  4.

  OrderlD

  5.

  OrderDate

  6.

  ShippedDate

  Which SQL statement should the consultant use?

  A. SELECT T1.CustomerID, T1.FirstName, T1. EmailAddress, T2.OrderlD, T2.0rderDate, T2.ShippedDate FROM ' Subscribers OUTER JOIN OrderTable ON Subscribers.CustomerlD=OrderTable.CustomerlD
  B. SELECT * FROM Subscribers WHERE CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate - JOIN OrderTable On CustomerlD=CustomerlD
  C. SELECT CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate FROM Subscribers INNER JOIN OrderTable ON CustomerlD=CustomerlD
  D. SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderlD, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN OrderTable T2 ON T1.CustomerID=T2.CustomerID
  D. SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderlD, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN OrderTable T2 ON T1.CustomerID=T2.CustomerID

• Question 93:

  Every day at 3 a.m., Northern Trail Outfitter' (NTO) data lake instance starts generating a file that contains all records that should be sent one email or another for the next day's marketing campaigns. The size of the file varies depending on the previous day's tracking activity. As soon as the file is generated, NTO wants to import the data, segment the data, and then execute the daily sends.

  What end-to-end process should deliver this efficiently?

  A. Scheduled Automation > File Transfer > Import > Series of Query Activities
  B. Triggered Automation > Import Activity > Series of Query Activities > Series of Sends
  C. Scheduled Automation > Import Activity > Series of Query Activities > Series of Sends
  D. Triggered Automation> Import > Data Extension Extract > Marketing Journey
  B. Triggered Automation > Import Activity > Series of Query Activities > Series of Sends

• Question 94:

  An analytics team wants to get hourly updates on email metrics (send, open, click) to provide timely next best actions to the sales team. What method should the team use?

  A. Send Logs
  B. Data views
  C. Tracking Extracts
  D. Scheduled Reports
  D. Scheduled Reports

• Question 95:

  An analytics team wants to get real-time updates on transactional email metrics, specifically Sent and NotSent, to ensure they are fulfilling a legal obligation due to the nature of their messages. What method should be suggested in this scenario?

  A. Platform Events API
  B. Data View Export with every send
  C. Data Retrieves on the Send Object
  D. Event Notification Service
  D. Event Notification Service

• Question 96:

  A financial company wans to use Marketing Cloud to send late payment notices to accounts whose payment due date lapsed the previous week. The company has shared the following:

  1.

  Payment.csv will arrive on the Enhanced SFTP each Monday at 1 a.m.

  2.

  Payments.csv will be encrypted.

  3.

  Payments.csv will contain data from the previous week.

  4.

  Late payment notices will be sent each Monday at noon.

  5.

  They need to receive a file containing customers who opened or clicked on the late payment notice email within five days after send. Which automation sequence represents a viable solution?

  A. File Transfer > Import File > Filter > Wait > Send Email > SQL Query > Wait > Data Extract > File Transfer
  B. Import File > File Transfer > SQL Query > Wait > Send Email > Wait > SQL Query > Data Extract > File Transfer
  C. File Transfer > File Transfer > Import File > SQL Query > Wait > Send Email > SQL Query > File Transfer
  D. File Transfer > Import File > Filter > Wait > Send Email > Wait > SQL Query > Data Extract > File Transfer
  B. Import File > File Transfer > SQL Query > Wait > Send Email > Wait > SQL Query > Data Extract > File Transfer

• Question 97:

  Northern Trail Outfitters (NTO) wants to send an email to all Contacts who have signed up for its newsletter, but have not joined its loyalty program. NTO has created a report in Sales Cloud which it will select using a Send Flow in Content Builder.

  Which field name should be included in the report in addition to email address?

  A. Individual ID
  B. Contact ID
  C. CampaignMember ID
  D. External ID
  B. Contact ID

• Question 98:

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

  1.

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

  2.

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

  3.

  All the activity must be provided via SFTP in one file. Which automation workflow meets the customer requirements?

  A. Data Extract Activity of Tracking Extracts that combines data into required file > File Transfer Activity
  B. Report activity that generates Recent Send Summary report > Report delivered directly to SFTP
  C. SQL Query Activity to pull data view information > Data Extract Activity of data extension > File Transfer Activity
  D. Data Extract Activity of data view tables > SQL Query Activity to create the required file > File Transfer Activity
  C. SQL Query Activity to pull data view information > Data Extract Activity of data extension > File Transfer Activity

• Question 99:

  A customer wants to integrate a new dataset with pre-existing contacts. This data will be updated via separate data feeds from the main contact information. What data model configuration should be recommended?

  A. Create additional attribute fields in the main contact data extension.
  B. Create new Salesforce data extension and link it to the other data extensions.
  C. Create a new data extension and link it to the other data extensions.
  D. Create a new data extension and link It as a new population.
  C. Create a new data extension and link it to the other data extensions.

• Question 100:

  Northern Trail Outfitters (NTO) uses Marketing Cloud to connect with its individual consumers, retailers and wholesale buyers, and its corporate apparel customers. Marketing Cloud is currently configured with data extensions containing Store, Order, Product, and Contact information. NTO is in the process of implementing Data Designer and linking its data extensions.

  How should consumers, retailers, and wholesale buyers be defined in Data Designer?

  A. One-to-Many Relationship
  B. Many-to-Many Relationship
  C. One-to-One Relationship
  D. Population
  C. One-to-One Relationship