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?
PL-300 Exam QuestionsBrowse all questions from this exam
PL-300 Exam - Question 37
Show AnswerHide Answer
Correct Answer: D
The relationship between the Customer and Transaction tables should be a one-to-many relationship from Customer to Transaction. This is because each customer (represented by CustomerID) can have multiple transactions, but each transaction is associated with only one customer. Therefore, the primary key (CustomerID) in the Customer table will relate to multiple entries in the Transaction table, making it a one-to-many relationship.
Discussion
17 commentsRickyAndOption: D
Sep 14, 2022Correct
GPerez73
Sep 8, 2022It is correct for me
SamuComqiOption: D
Jul 20, 2023I passed the exam today (948/1000). My answer was: - one-to-many from Customer to Transaction
AyoJose
Aug 19, 2023How many questions was it please?
IgetmyroleOption: D
Sep 5, 2023D is the correct answer. Each customer can have multiple transactions (one-to-many relationship), as a customer can make multiple transactions over time.
hungry85Option: D
Mar 21, 2023D is correct because a single customer can have many transactions and this transactions have their transactions id.
Cyprien_BOption: D
Jul 26, 2023Correct
AZFabioOption: D
Mar 12, 2024Please, MS, send questions like that in the exam... :-)
rb_pbOption: D
Mar 20, 2023a 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
brunoquintelaOption: D
Apr 7, 2023Correto
inejoOption: D
Jun 8, 2023D es la ideal
nick0651Option: D
Oct 17, 2023D is the correct answer
edbf978Option: D
Jan 16, 2024Correct
28485e1
Feb 24, 2024This was on my exam, 2/2024.
benni_aleOption: D
Mar 10, 2024Per me è la cipolla
RedRossOption: D
Mar 12, 2024OBVIOUS!!
GiudittaOption: D
Mar 15, 2024this was on exam on 14/03/2024 i scored 948 my answer was D
Kiran37
Jul 21, 2024correct answer