You build a report to analyze customer transactions from a database that contains the tables shown in the following table. You import the tables. Which relationship should you use to link the tables?
Let's say that the ER is many to one from transaction to customer (Customer (1,N) -> (1,1) Transaction). When we build the tables we need the customerId foreing key to the transaction table. In PBI there is many relationship where there is the key (from the fact to the dimension).
So, one to many from customer to transaction is the correct one!
D is the correct answer. Each customer can have multiple transactions (one-to-many relationship), as a customer can make multiple transactions over time.
a customer is unique in the `Customer` table. However, a unique customer can possess multiple transactions in the `Transactions` table. Hence 1-MANY relationship is obvious answer. So, option D
This section is not available anymore. Please use the main Exam Page.PL-300 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
RickyAnd
Highly Voted 2 years, 9 months agoGPerez73
Highly Voted 2 years, 9 months agoSrilatha_B
Most Recent 5 months, 3 weeks agokenyJen
9 months, 2 weeks agorcaliandro
10 months, 1 week agoKiran37
11 months agoAZFabio
1 year, 3 months agoRedRoss
1 year, 3 months agobenni_ale
1 year, 3 months agoedbf978
1 year, 5 months agonick0651
1 year, 8 months agoIgetmyrole
1 year, 9 months agoCyprien_B
1 year, 10 months agoinejo
2 years agobrunoquintela
2 years, 2 months agohungry85
2 years, 3 months agorb_pb
2 years, 3 months ago