Certified Marketing Cloud DeveloperDemo

Question

Northern Trail Outfitters’ account has two child BUs: US and Global. A data extension named MemberData exists in the Shared Data Extensions folder. It contains basic address details and Boolean fields named US and Global that indicate the subscriber’s business unit.

An automation must be created in the US business unit to query every New York record belonging to the US business unit.

SELECT * FROM MemberData WHERE State = 'NY' AND US = 1

What would cause this query to return the following error: “An error occurred while checking the query syntax. Errors: MemberData is not a known data extension or system data view. You can only query existing data extensions or system data views.”?

A Query should check for a US value of 'True'
B MemberData should be prefixed with ENT
C Incorrect syntax; Query Activities are written in SOQL

Explanation

A shared data extension stored at the enterprise level must be referenced from a child business unit with the ENT. prefix, such as ENT.MemberData. Without that enterprise-qualified name, the child business unit cannot resolve MemberData as an available data extension. Salesforce documents the ENT. prefix as the indicator for an enterprise-level data extension.

Learn more

Using AMPscript Language Elements with Enterprise Awareness

Certified Marketing Cloud DeveloperDemo

AstroTutor

Notes

Readiness

QuestionQ60

Community Discussion