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
Rene
5 days 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
...
Thomasena
9 days ago
But shouldn't we also create a one-to-one relationship between Order_Details and Products for accurate data?
upvoted 0 times
...
Abel
11 days ago
I agree with Walton. It makes sense to link each order with its details.
upvoted 0 times
...
Margery
12 days 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
...
Walton
21 days ago
I think we should create a one-to-one relationship between Orders and Order_Details.
upvoted 0 times
...

Save Cancel