Online Questions - Valid Practice To your CRT-550 Exam (Updated 218 Questions)
Practice To CRT-550 - Remarkable Practice On your Salesforce Certified Marketing Cloud Consultant Exam Exam
NEW QUESTION 128
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?
- A. Scheduled Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
- B. Scheduled Starting Source: Data Extract > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
- C. File Drop Starting Source: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1
- D. File Drop Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
Answer: D
NEW QUESTION 129
A customer wants to store financial data related to invoicing in its data extensions.
What field type should be used?
- A. Number
- B. Float
- C. Decimal
- D. Currency
Answer: C
NEW QUESTION 130
Northern Trail Outfitters (NTO) has doubled in size over the last couple of years. Because of this growth they have decided to organize their company into Business Units to better manage operations.
Which statement is correct regarding the Business Unit functionality within Marketing Cloud?
Choose 2 answers
- A. Business Units can share information with other Business Units.
- B. Business Units can mirror an organization's operational structure.
- C. Business Units can have more than one parent Business Unit.
- D. Subscribers can only appear in one Business Unit.
Answer: A,B
NEW QUESTION 131
A customer will provide a single daily file on the Marketing Cloud SFTP at 3 AM and needs an alert if the file is not present on time. The file needs to be: Imported into a staging data extension. Separated into two different data extensions.
Which workflow should meet these requirements?
- A. File Drop Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
- B. Scheduled Automation: File Transfer Activity > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
- C. Scheduled Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
- D. File Drop Automation: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1
Answer: C
NEW QUESTION 132
A customer wants to link web analytics data to subscriber data.
How should this be set up in Data Designer?
- A. Link to the Marketing Cloud API
- B. Link to the Web Analytics Provider API
- C. Link to Marketing Cloud data extensions
- D. Link to the Web Analytics SFTP
Answer: C
NEW QUESTION 133
What statements are correct regarding Attribute Groups?
Choose 2 answers
- A. They link data extensions to contacts.
- B. They link data extensions to other data extensions.
- C. They link subscriber lists to contacts.
- D. They link data extensions to subscriber lists.
Answer: A,B
NEW QUESTION 134
A customer has several values that need to be used in the body of an email send:
* The data would be stored in a reference data extension, related on SubscriberKey.
* There may be one or more records for each subscriber.
* The audience is generally over 1 million subscribers.
* The content is time sensitive and should be sent as quickly as possible.
* The customer is not using "catch and release" sending.
* The reference data extension contains 25 columns.
Which method should be used?
- A. AMPscript a single LookupOrderedRows Function
- B. AMPscript a single Lookup Function
- C. Dynamic content via the Dynamic Content Wizard
- D. Server Side Javascript a single LookupOrderedRows Function
Answer: A
NEW QUESTION 135
Northern Trail Outfitters has purchased a new Marketing Cloud account with two dedicated IP addresses. One IP address will be used for commercial sends, while the other will be reserved for transactional messages.
Their customer base includes 1.5 million email addresses.
What should the consultant recommend?
- A. Send to unengaged subscribers during the first two weeks of IP warming in order to give them the opportunity to interact.
- B. Split marketing campaigns over a number of days while migrating over smaller triggered campaigns during the warming period.
- C. Focus on warming the IP address for commercial sends, because it is not necessary to warm an IP address used only for transactional sends.
- D. Suppress sends to AOL email addresses during the first two weeks of IP warming, then resume sending to them during the third week.
Answer: C
NEW QUESTION 136
Northern Trail Outfitters (NTO) wants its monthly distributor newsletter email to appear to be sent on behalf of the subscriber's account representative without segmenting the audience by sales representative.
How should this distributor-specific sender profile be configured in the Marketing Cloud?
Choose 2 answers
- A. Utilize data extension AMPScript lookups to dynamically populate the from name and from email values.
- B. Pick "Choose from list," selecting the from name and from email values from the list of account users.
- C. Match the external keys of the sender profile and data extension containing account representative details.
- D. Populate substitution strings in the sender profile for the profile attributes containing from name and from email values.
Answer: A,D
NEW QUESTION 137
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:
* CustomerlD
* FirstName
* EmailAddress
* OrderlD
* OrderDate
* ShippedDate
Which SQL statement should the consultant use?
- A. 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
- B. SELECT T1.CustomerID, T1.FirstName, T1. EmailAddress, T2.OrderlD, T2.0rderDate, T2.ShippedDate FROM ' Subscribers OUTER JOIN OrderTable ON Subscribers.CustomerlD=OrderTable.CustomerlD
- C. SELECT CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate FROM Subscribers INNER JOIN OrderTable ON CustomerlD=CustomerlD
- D. SELECT * FROM Subscribers WHERE CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate - JOIN OrderTable On CustomerlD=CustomerlD
Answer: A
NEW QUESTION 138
Northern Trail Outfitters wants to integrate Marketing Cloud with its existing point-of-sale system in order in email purchase receipt to its customers. The point-of-sale data will need to be transformed to be received by the Marketing Cloud triggered send API.
What extension product should be used to accomplish this integration?
- A. Data Studio
- B. Datorama
- C. Data Connector
- D. MuleSoft Anypoint Platform
Answer: A
NEW QUESTION 139
Northern Trail Outfitters has recently configured MobileConnect and wants to perform single send-outs from within MobileConnect using data extensions that contain automatically refreshed segments.
Which two fields would need to be added to enable these data extensions for sending? (Choose 2 answers)
- A. A field of Locale type containing the country code
- B. A field of Phone type containing the mobile number
- C. A field of Text type containing the country code plus mobile number
- D. A field of Locale type containing the locale code
Answer: B,D
NEW QUESTION 140
A customer is interested in designing a solution to ensure that subscribers only receive categories of emails that they want to receive. The built-in subscription center will be used as part of the solution.
Which feature should be utilised to make this happen?
- A. Subscriber Keys
- B. Profile Center
- C. Publication Lists
- D. Send Logging
Answer: C
NEW QUESTION 141
Northern Trail Outfitters receives a nightly encrypted unsub file to their Marketing Cloud SFTP from a third-party email platform. These files are used to unsubscribe existing subscribers. They do not use Email Address as Subscriber Key.
What Automation Studio Activity sequence should be used to ensure the appropriate subscribers are unsubscribed from the All Subscriber List?
- A. Import File > Query > Data Extract > File Transfer > Import File
- B. Import File > Data Extract > File Transfer > Import File
- C. File Transfer > Import File > Query > Data Extract > File Transfer > Import File
- D. File Transfer > Import File > Data Extract > File Transfer > Import File
Answer: C
NEW QUESTION 142
A user in the MC wants to use salesforce custom object data for segmenting and personalization.
How should the consultant approach this requirement?
- A. Sync contact and custom objects with Data Stream and send from Synchronized Data Extension with Salesforce email send. Ensure there is a lookup relationship to a contact or lead record.
- B. Create a custom report type that contains the contact or lead ID, email address, and custom object data, then from the marketing cloud, import into a Salesforce Data extension. Use AMPScript in the email to call data
- C. Export report data from the sales cloud and import into a marketing cloud synchronized data extension.
Use a filter activity to produce a sendable data extension. Create an email send activity in Automation Studio - D. Map the custom objects to the profile center and use the email editor to insert the custom data. Create a user-initiated send to associate the email to the largest audience and return tracking data.
Answer: B
NEW QUESTION 143
Northern Trail Outfitters wants to import their Sales Cloud data into Marketing Cloud to leverage it within Journey Builder. They have approximately 10 million customers and the data needs to be available with a delay of no more than 30 minutes. Only customers where the consent checkbox is selected in Sales Cloud should be imported, which represents approximately half of their customer database What should they implement?
- A. Synchronized Data Extensions with a filter
- B. Import from Salesforce Report in Automation Studio
- C. All Subscribers, since these are synchronized in real time
- D. Event Data from the Entry Event in Journey Builder
Answer: B
NEW QUESTION 144
A publishing company has presented the following:
* A need to send renewal reminders to customers whose subscriptions expire in 15 days and 7 days.
* A campaign needs to be created and managed by a general marketing user who will not have administrative rights and who is not technical.
* The customer's expiration date is included in the data file.
What component should the customer's solution include?
Choose 3 answers
- A. Triggered Send
- B. Data Filter
- C. Template-based emails
- D. Suppression list
- E. Automation Studio
Answer: B,C,E
NEW QUESTION 145
A customer wants to reports on 'Not Sent' contacts in Journey Builder.
Which method should be used?
- A. Create an Analytics Builder Discover report.
- B. Use an automation with Tracking Extract.
- C. Use the standard report 'Subscribers Not Sent to'.
- D. Query the _sent Data View for the contact's send status.
Answer: C
NEW QUESTION 146
......
True CRT-550 Exam Extraordinary Practice For the Exam: https://www.torrentexam.com/CRT-550-exam-latest-torrent.html
Get 100% Passing Success With True CRT-550 Exam: https://drive.google.com/open?id=1BKuyUq0XPJfD8PANNe0_rwKhMApcLRsL
