MENU
A customer has an eCommerce site and imports data into three data extensions daily: Orders, Order_Details, and 'Products.
The data extensions contain the following information:
- Orders: OrderId, CustomerID, OrderNumber, OrderDate, OrderTotal, GrandTotal
- Order_Details: ProductId, OrderID, Qty, UnitPrice, ExtendedPrice, Discount
- Products: ProductId, SKU, Name, Description, Cost, Price
Which two actions should be taken in Data Designer?
Choose 2 answers
Suggested Answer: D
Get Premium Salesforce Certified Marketing Cloud Engagement Administrator (MCE-Admn-201) Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
36 comments · newest first
GA
Garry
12 months ago
Are we sure about D? I thought it was more complex than that.
KA
Kathrine
12 months ago
B is a must! One-to-many is how orders usually work.
JE
Jess
12 months ago
Wait, why would you create a one-to-one for Order_Details and Products? That seems off.
EL
Elvis
1 year ago
I think C is a better choice than B. One-to-one sounds cleaner.
CE
Celestine
1 year ago
Definitely B and D! Makes sense for the relationships.
AM
Ammie
1 year ago
I feel like we might also need to connect Order_Details to Products, but I can't recall if it's one-to-one or one-to-many.
FR
Francis
1 year ago
I practiced a similar question, and I believe we definitely need the one-to-many relationship for Orders and Order_Details.
MA
Marta
1 year ago
I'm not entirely sure, but I remember something about one-to-one relationships. Should we really create one between Orders and Order_Details?
BO
Bobbie
1 year ago
I think we need to create a one-to-many relationship between Orders and Order_Details since one order can have multiple details.
LE
Leota
1 year ago
Okay, let me think this through step-by-step. I'll go through each option and consider the potential exceptions that could be raised.
AL
Aliza
1 year ago
This seems like a straightforward question about file permissions. I'll need to carefully review the underlined text and think about which permissions would take precedence.
EA
Earnestine
1 year ago
D, definitely D. CASBs are the third-party providers that handle IAM in the cloud. I remember learning about them in class. This seems like a straightforward question.
NA
Nakita
1 year ago
Wait, what if the 'Products' table is actually a dimension table and not directly related to the Order_Details? In that case, B and C might be the right answers.
DO
Domingo
1 year ago
Wait, what if the 'Products' table is actually a dimension table and not directly related to the Order_Details? In that case, B and C might be the right answers.
BO
Bok
1 year ago
D) Create a one-to-one relationship between Order_Details and Products.
CE
Cecily
1 year ago
A) Create a one-to-one relationship between the contact record and Order Details.
EV
Evan
1 year ago
Haha, I bet the exam writers are trying to trick us with those one-to-one options. Nice try, but I'm sticking with B and D!
SH
Shayne
1 year ago
I'm going with B and D. The one-to-one relationship between Order_Details and Products also makes sense to capture the product information for each order detail.
LE
Lenny
1 year ago
That sounds like a good choice. It will help link the orders with their details and products efficiently.
SH
Shenika
1 year ago
D) Create a one-to-one relationship between Order_Details and Products.
TA
Tarra
1 year ago
B) Create a one -to -many relationship between Orders and Order_Details.
RE
Rene
2 years ago
I agree with Margery. Creating a one-to-one relationship between Orders and Order_Details doesn't seem right, since one order can have multiple details.
WI
Willard
1 year ago
D) Create a one-to-one relationship between Order_Details and Products.
JE
Jerlene
1 year ago
I agree with Margery. Creating a one-to-one relationship between Orders and Order_Details doesn't seem right, since one order can have multiple details.
EM
Emily
1 year ago
B) Create a one -to -many relationship between Orders and Order_Details.
PA
Paola
1 year ago
A) Create a one-to-one relationship between the contact record and Order Details.
PU
Pura
1 year ago
That makes sense, a one-to-many relationship between Orders and Order_Details is the way to go.
GR
Gracia
1 year ago
I agree, a one-to-one relationship between Orders and Order_Details wouldn't work for multiple details.
LE
Leota
1 year ago
D) Create a one-to-one relationship between Order_Details and Products.
CA
Carolann
1 year ago
B) Create a one -to -many relationship between Orders and Order_Details.
TH
Thomasena
2 years ago
But shouldn't we also create a one-to-one relationship between Order_Details and Products for accurate data?
AB
Abel
2 years ago
I agree with Walton. It makes sense to link each order with its details.
MA
Margery
2 years ago
Hmm, I think the answer is B. A one-to-many relationship between Orders and Order_Details makes the most sense since an order can have multiple order details.
PE
Pearly
1 year ago
Yes, B is the right choice. It allows for a one-to-many relationship between Orders and Order_Details.
JA
Janna
1 year ago
I agree, B is the correct answer. Each order can have multiple order details.
WA
Walton
2 years ago
I think we should create a one-to-one relationship between Orders and Order_Details.