Free Marketing-Cloud-Developer Practice Exam Questions

A developer is troubleshooting why an API client Jd and chent_secret are authenticating yet failing to access data from a child business unit. What should be checked to validate the installed package can access the child business unit data?

A. The Installed Package has full Enterprise access to all available child business units

B. The Installed Package has access to the selected child business unit

C. The account id and parent MIDare included in the authorization call

B. The Installed Package has access to the selected child business unit

Explanation:

To ensure that an installed package can access data from a child business unit, verify that the package has been granted access to the specific child business unit. This is configured during the package setup and permissions assignment.

Reference: [:Salesforce Installed Packages and Business Unit Access, , ]

A developer needs to determine why a Query Activity in an Automation has failed. Which three scenarios could have caused this? Choose 3 answers

A. The query takes more than 60 minutes to run.

B. The query is returning more than one million rows.

C. The query results in duplicate rows not allowed by the primary key.

D. The query is not returning a value for a non-nullable field.

E. The query is inserting a value that is larger than the size of a field.

A.   The query takes more than 60 minutes to run.

D.   The query is not returning a value for a non-nullable field.

E.   The query is inserting a value that is larger than the size of a field.

Northern Trail Outfitters uses a number to uniquely identify contacts across different marketing channels. Which two actions should the developertake to ensure the contacts relate across channels in Marketing Cloud when working with the data model? Choose 2 answers

A. store the numeric unique identifier value as a Text data type In data extensions.

B. Link the numeric field value to the Contact IDin Attribute Groups in Contact Builder.

C. Use a unique identifier spec fie to each channel and automatically connect then-..

D. Create Attribute Groups linking the unique identifier to the Contact for each channel.

B. Link the numeric field value to the Contact IDin Attribute Groups in Contact Builder.

D. Create Attribute Groups linking the unique identifier to the Contact for each channel.

Explanation:

To ensure that contacts relate across different channels in Marketing Cloud, you need to link the unique identifier used across channels to the Contact ID in Contact Builder. This involves creating Attribute Groups and establishing the relationships between the unique identifier and the Contact ID.

Link the Numeric Field Value: By linking the numeric unique identifier to the Contact ID in Attribute Groups, you ensure that each contact is uniquely identified across channels. Create Attribute Groups: Attribute Groups in Contact Builder allow you to map the relationships between different data sources and the Contact object, ensuring that the unique identifier is connected correctly for each channel.

Reference: [:Salesforce Contact Builder Documentation, , ]

Northtrn Trail Outfitters mistakenly synced the User_Salesforce object which added to their billable contact count. What should be recommended to remove these contacts'

A. Update the sync to remove these contacts from the All Contacts table.

B. Use the REST API to delete the contacts from the All Subscribers table.

C. Put the synced records into a sendable data extension and use Contact Delete.

D. Use the SOAP API to delete the contacts from theAll Contacts table.

C. Put the synced records into a sendable data extension and use Contact Delete.

Explanation:

To remove contacts mistakenly synced from the User_Salesforce object, the recommended approach is toput the synced records into a sendable data extension and use Contact Delete (C). This method allows for the systematic deletion of these contacts from the All Contacts table without affecting other data.

References:

Salesforce Marketing Cloud Contact Delete

Managing Contacts in Marketing Cloud

A developer wants to retrieve all recordsin the OrderDetails data extension which are associated with a particular customer.

Which two AMPscript functions would return a suitable rowset? Choose 2 answers

A. LookupRows

B. LookupOrderedRows

C. Row

D. Lookup

A. LookupRows

B. LookupOrderedRows

Explanation:

To retrieve multiple records associated with a particular customer from theOrderDetailsdata extension, theLookupRowsandLookupOrderedRowsfunctions are suitable. These functions return a rowset containing the records that match the specified criteria.

LookupRows: Retrieves a rowset of records based on specified criteria. ampscript

Copy code

SET @rows = LookupRows('OrderDetails', 'CustomerID', @customerID)

LookupOrderedRows: Retrieves a rowset of records based on specified criteria and allows for sorting.

SET @rows = LookupOrderedRows('OrderDetails', 0, 'OrderDate DESC', 'CustomerID', @customerID)

Reference: [:Salesforce AMPscript LookupRows, Reference:Salesforce AMPscript LookupOrderedRows, , ]

Marketing-Cloud-Developer Practice Test