Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Salesforce Exam Marketing Cloud Administrator Topic 1 Question 70 Discussion

Actual exam question for Salesforce's Marketing Cloud Administrator exam
Question #: 70
Topic #: 1
[All Marketing Cloud Administrator 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

Show Suggested Answer Hide Answer
Suggested Answer: D

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

Limited Time Offer

25%

Off

Get Premium Marketing Cloud Administrator Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Nakita
23 days 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
9 days 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
9 days ago
D) Create a one-to-one relationship between Order_Details and Products.
upvoted 0 times
...
Cecily
13 days ago
A) Create a one-to-one relationship between the contact record and Order Details.
upvoted 0 times
...
...
Evan
1 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
1 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
Shenika
9 days ago
D) Create a one-to-one relationship between Order_Details and Products.
upvoted 0 times
...
Tarra
10 days ago
B) Create a one -to -many relationship between Orders and Order_Details.
upvoted 0 times
...
...
Rene
2 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
Gracia
3 days ago
I agree, a one-to-one relationship between Orders and Order_Details wouldn't work for multiple details.
upvoted 0 times
...
Leota
8 days ago
D) Create a one-to-one relationship between Order_Details and Products.
upvoted 0 times
...
Carolann
9 days ago
B) Create a one -to -many relationship between Orders and Order_Details.
upvoted 0 times
...
...
Thomasena
2 months ago
But shouldn't we also create a one-to-one relationship between Order_Details and Products for accurate data?
upvoted 0 times
...
Abel
2 months ago
I agree with Walton. It makes sense to link each order with its details.
upvoted 0 times
...
Margery
2 months 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
Pearly
1 months ago
Yes, B is the right choice. It allows for a one-to-many relationship between Orders and Order_Details.
upvoted 0 times
...
Janna
1 months ago
I agree, B is the correct answer. Each order can have multiple order details.
upvoted 0 times
...
...
Walton
2 months ago
I think we should create a one-to-one relationship between Orders and Order_Details.
upvoted 0 times
...

Save Cancel