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?

QuestionsCategory: PL-300You 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?
Admin Staff asked 7 months ago
You build a report to analyze customer transactions from a database that contains the tables shown in the following table.
 Image
You import the tables.
Which relationship should you use to link the tables?

A. one-to-many from Transaction to Customer

B. one-to-one between Customer and Transaction

C. many-to-many between Customer and Transaction

D. one-to-many from Customer to Transaction








 

Suggested Answer: D

One on the primary Key side (customer table), many on the foreign key side (Transaction table) of the relation.

This question is in PL-300 Exam
For getting Microsoft Power BI Data Analyst Associate Certificate

Next Post

Recommended

Welcome Back!

Login to your account below

Create New Account!

Fill the forms below to register

Retrieve your password

Please enter your username or email address to reset your password.