What is a capability of a data relationship? - ProProfs Discuss
Topics
Products
Follow Us:

What is a capability of a data relationship?



A. Join a list and a data extension to filter the combined data
B. Join three or more data extensions together to create a filtered data extension
C. Join data extensions to filter or segment the fields from data extensions
D. Join data extensions together to create one combined data extension

This question is part of Certified Marketing Cloud Email Specialist - PART 3
Asked by Catherine halcombe, Last updated: Aug 04, 2020

+ Answer
Request

2 Answers

Perez D.Scarlett

Perez D.Scarlett

Answered May 03, 2018

A data relationship is a bound situation that exists between two relational database tables when one table has a foreign key that references the primary key of the other table. Relationships allow relational databases to split and store data in different tables, while linking disparate data items and also automatically access correction on both side.

A bank database for example, a CUSTOMER_MASTER table stores the customer data with a primary key column named CUSTOMER_ID; it also stores the customer data in an ACCOUNTS_MASTER table, which contains different information about various bank accounts and associated customers. So as to link these two tables together and to determine the customer and bank account information, a corresponding CUSTOMER_ID column must be inserted in the ACCOUNTS_MASTER table, referencing existing customer IDs from the CUSTOMER_MASTER table. Which makes the ACCOUNTS_MASTER table’s CUSTOMER_ID column a foreign key that references a column with the same name in the CUSTOMER_MASTER table.

 

John Smith

John Smith

Answered Feb 22, 2017

Join data extensions to filter or segment the fields from data extensions
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.