Salesforce Certified Marketing Cloud Engagement Administrator (MCE-Admn-201) Exam - Topic 1 Question 70 Discussion

Actual exam question for Salesforce's Salesforce Certified Marketing Cloud Engagement Administrator (MCE-Admn-201) exam

Question #: 70
Topic #: 1

[All Salesforce Certified Marketing Cloud Engagement Administrator (MCE-Admn-201) Questions]

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

ACreate a one-to-one relationship between the contact record and Order Details.

BCreate a one -to -many relationship between Orders and Order_Details.

CCreate a one-to-one relationship between Orders and Order_Details.

DCreate a one-to-one relationship between Order_Details and Products.

Show Suggested Answer

Suggested Answer: D

by Danica at Apr 03, 2023, 11:48 AM

Limited Time Offer

25%

Off

Get Premium Salesforce Certified Marketing Cloud Engagement Administrator (MCE-Admn-201) Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Garry

5 months ago

Are we sure about D? I thought it was more complex than that.

upvoted 0 times

...

Kathrine

6 months ago

B is a must! One-to-many is how orders usually work.

upvoted 0 times

...

Jess

6 months ago

Wait, why would you create a one-to-one for Order_Details and Products? That seems off.

upvoted 0 times

...

Elvis

6 months ago

I think C is a better choice than B. One-to-one sounds cleaner.

upvoted 0 times

...

Celestine

6 months ago

Definitely B and D! Makes sense for the relationships.

upvoted 0 times

...

Ammie

6 months 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.

upvoted 0 times

...

Francis

6 months ago

I practiced a similar question, and I believe we definitely need the one-to-many relationship for Orders and Order_Details.

upvoted 0 times

...

Marta

6 months 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?

upvoted 0 times

...

Bobbie

7 months ago

I think we need to create a one-to-many relationship between Orders and Order_Details since one order can have multiple details.

upvoted 0 times

...

Leota

7 months 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.

upvoted 0 times

...

Aliza

7 months 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.

upvoted 0 times

...

Earnestine

7 months 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.

upvoted 0 times

...

Nakita

11 months 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.

upvoted 0 times

Domingo

11 months 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.

upvoted 0 times

...

Bok

11 months ago

D) Create a one-to-one relationship between Order_Details and Products.

upvoted 0 times

...

Cecily

11 months ago

A) Create a one-to-one relationship between the contact record and Order Details.

upvoted 0 times

...

Evan

11 months 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!

upvoted 0 times

...

Shayne

11 months 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.

upvoted 0 times

Lenny

10 months ago

That sounds like a good choice. It will help link the orders with their details and products efficiently.

upvoted 0 times

...

Shenika

11 months ago

D) Create a one-to-one relationship between Order_Details and Products.

upvoted 0 times

...

Tarra

11 months ago

B) Create a one -to -many relationship between Orders and Order_Details.

upvoted 0 times

...

Rene

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.

upvoted 0 times

Willard

10 months ago

D) Create a one-to-one relationship between Order_Details and Products.

upvoted 0 times

...

Jerlene

10 months 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.

upvoted 0 times

...

Emily

10 months ago

B) Create a one -to -many relationship between Orders and Order_Details.

upvoted 0 times

...

Paola

10 months ago

A) Create a one-to-one relationship between the contact record and Order Details.

upvoted 0 times

...

Pura

10 months ago

That makes sense, a one-to-many relationship between Orders and Order_Details is the way to go.

upvoted 0 times

...

Gracia

10 months ago

I agree, a one-to-one relationship between Orders and Order_Details wouldn't work for multiple details.

upvoted 0 times

...

Leota

11 months ago

D) Create a one-to-one relationship between Order_Details and Products.

upvoted 0 times

...

Carolann

11 months ago

B) Create a one -to -many relationship between Orders and Order_Details.

upvoted 0 times

...

Thomasena

1 year ago

But shouldn't we also create a one-to-one relationship between Order_Details and Products for accurate data?

upvoted 0 times

...

Abel

1 year ago

I agree with Walton. It makes sense to link each order with its details.

upvoted 0 times

...

Margery

1 year 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.

upvoted 0 times