Expand my Community achievements bar.

SOLVED

RTCDP developer exam question - Schema creation

Avatar

Level 4

Hi, 

 

Why is also last question marked as correct? 

Could you explain? 

Michael_Soprano_0-1708367657332.png

 

Thanks 

Mike 

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hello @Michael_Soprano ,

Our goal is to exclude customers who have already applied for a credit card. To achieve this, we must devise a method to identify all customers who have submitted an application with a specific offer ID. The most effective strategy for managing offers as a lookup schema and linking it to the application submission event is to establish a relationship between the two datasets. This approach is detailed in option 4.

 

Its important here to know that normalization can be achieved when you are link a profile schema with a lookup schema to avoid data redundancy. But in this case de-normalization makes more sense because a same person can have multiple credit card orders which can be easily maintained in experience event schema.

 

Thanks,

Arpan

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hello @Michael_Soprano ,

Our goal is to exclude customers who have already applied for a credit card. To achieve this, we must devise a method to identify all customers who have submitted an application with a specific offer ID. The most effective strategy for managing offers as a lookup schema and linking it to the application submission event is to establish a relationship between the two datasets. This approach is detailed in option 4.

 

Its important here to know that normalization can be achieved when you are link a profile schema with a lookup schema to avoid data redundancy. But in this case de-normalization makes more sense because a same person can have multiple credit card orders which can be easily maintained in experience event schema.

 

Thanks,

Arpan