MARKETING-CLOUD-CONSULTANT Online Practice Questions and Answers

A customer wants to store financial data related to invoicing in its data extensions. What field type should be used?

A. Number

B. Currency

C. Float

D. Decimal

Northern Trail Outfitters (NTO) is launching a new campaign, driving it to redesign its data structure. NTO needs to change the cardinality between two data extensions inside Contact Builder.

What are two consequences of this change? Choose 2 answers

A. All filters created before will adapt automatically to the new cardinality.

B. All scheduled sends using a filter based on one of the data extensions should be reviewed.

C. A contact may NOT show up in the filter based on one of the data extensions.

D. One of the data extensions must be deleted from the attribute group in order to change the cardinality.

A marketer wants to create and edit email content, as well as generate reports and manage subscriber data.

Using the principle of least privilege, which two pre-defined roles should be assigned? Choose 2 answers

A. Analyst

B. Administrator

C. Data Manager

D. Content Creator

Northern Trail Outfitters assigns a 15-digit integer as their Order ID which will be used as the primary key of a data extension. The import file contains leading zeros, but they will NOT be included in the final values.

Which data type should they use for the Order ID field?

A. Number

B. Text (15)

C. Decimal (15,0)

D. Decimal (15,2)

Which two statements about a database of record are correct? Choose 2 answers

A. It is a centralized storage repository of data about objects or people.

B. It is any database containing subscriber data.

C. It is any data structure in which multiple opt-in statuses can be stored for a subscriber.

D. It is a system in which a subscriber's status is maintained.

Northern Trail Outfitters is expanding globally into 16 new countries and wants to start localizing their email content to speak to subscribers in their own language. They want to do this as efficiently as possible and are anticipating growth into other locales in the near future.

Which two options could be recommended? (Choose 2 answers)

A. Leverage Content Builder to create email templates for each language and populate the templates via the UI.

B. Leverage enhanced dynamic content blocks within Content Builder to create language- specific emails.

C. Leverage personalization strings within the email template to pull in language-specific content.

D. Leverage AMPscript within an email template to lookup subscriber language and personalize the email based on the value.

In which two ways can Contact Builder be used to affect data stored on a data extension? Choose 2 answers

A. Reconcile contact data on multiple Contact IDs

B. Add a single record to a data extension

C. Export data from a data extension to any SFTP location

D. Clear the data from a data extension

Northern Trail Outfitters (NTO) has been storing web behavior to a data extension for several years. They have indicated with several hundred millions of rows there has been an impact on performance. NTO indicates they only need to store data from the previous twelve months which will not exceed eighty million rows.

Which two methods would allow them to utilize a Retention Policy? (Choose 2 answers)

A. Clear data from the current data extension completely, then reconfigure a Retention Period via Email Studio.

B. Delete data from the data extension prior to twelve months ago, then configure a Retention Period via Contact Builder.

C. Reconfigure the current data extension as-is with a Retention Period via Contact Builder.

D. Replace the current data extension with a new data extension configured with a Retention Period.

Northern Trail Outfitters (NTO) wants to implement a cross-channel automated marketing solution that provides real-time messaging on a customer by customer basis. They have limited resources to manage this on their own once the initial implementation has been completed. Which three details should be verified to properly guide a solution they can manage after the initial implementation? (Choose three.)

A. Does NTO have personnel to configure the (sub)domain for sending emails?

B. Is the necessary data currently stored in a centralized location?

C. Does NTO have people with Marketing Cloud skills and/or certifications within the team?

D. Does NTO need a declarative-only approach?

E. What size should the team responsible for the implementation after go-live be?

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