Data Modeling Query | Community
Skip to main content
Adobe Employee
June 2, 2024
Solved

Data Modeling Query

  • June 2, 2024
  • 3 replies
  • 991 views

I need help with one of the questions from AEP certification! I will try to recollect the question along with the options given.

Q: 'Order' and 'Item' tables are given. Here are the table details:
Order Table (Id, Date, Customers, etc)
Item Table (Order Id, Item Id)
What is the best way to model it?

a) Model Order table as an XDM Experience Event class-based schema and Item table as Custom class
OR
b) Model as an XDM Experience Event class-based schema

Best answer by Manoj_Kumar

@shaunakj18  The question is missing some context around how this data model will be used for segmentation or in an use case. Depending on this information the answer can change.

 

But I would pick A as answer. Order Table will be create as a XDM Experience Event Class Schema and item table will be a look up customer class.

 

Here is a screenshot of similar setup

 
 

 

 

 

3 replies

NimashaJain
Adobe Employee
Adobe Employee
June 4, 2024
Manoj_Kumar
Community Advisor
Manoj_KumarCommunity AdvisorAccepted solution
Community Advisor
June 5, 2024

@shaunakj18  The question is missing some context around how this data model will be used for segmentation or in an use case. Depending on this information the answer can change.

 

But I would pick A as answer. Order Table will be create as a XDM Experience Event Class Schema and item table will be a look up customer class.

 

Here is a screenshot of similar setup

 
 

 

 

 

Manoj     Find me on LinkedIn
Adobe Employee
June 9, 2024

Thanks @_manoj_kumar_ that helps!

Indra-2
Community Advisor
Community Advisor
June 20, 2024

I think its A is the answer, I also face the same question in exam