Exam PL-300 topic 9 question 1 discussion

Answer should be No - Yes - No. According to the sample data the CustomerID in Customer Details is a number (1 through 10 is shown in the example data) and the CustomerID in the Orders table has an example value of VINET, which looks like it corresponds to the value of CustomerCRMID instead of CustomerID from the Customer Details worksheet so the first answer should be No. The second answer should be Yes, the CustomerID from Orders has example value VINET, which is text.

1/ NO : the relationship is between CustomerCRMID from Customer Details and CustomerID from Orders 2/ YES: the relationship is between CustomerCRMID from Customer Details and CustomerID(NCHAR) from Orders --> CustomerCRMID have to be text too. 3/ NO: from Customer Details

How do you know CustomerCRMID in Customer Details Sheets is Text ? I meant, it seems a text value but is it because we are getting it from Excel so thats why Text ? Kindly confirm

Passed with 917/1000 Question and answers were exactly the same but different order with the options! Answer given: - No - Yes - No

According to the sample data I will go for: No No No

1: NO : link should be on customer CRMID as it is the same datatype as 'orders'[customerID] 2. YES : both are string based 3. NO : Top customers = The one with most sales, worksheet alone does not provide the needed info

Full access with commentaries is totally worth it!

Where is the damn example data??

1 NO - You can't join 02 tables using columns that are not the same type. In this scenario, if we assume that we are going to change the column type before joining them, we won't have any results. Because the values in those columns (The value of customer id in the table Customer is not the same as customer Id in the table Orders) are different. (in the customer table, we have 1,2,3,.. and in the the orders, we have VINET as exemple 2 NO - Even if we change the type of column to TEXT it won't work because the values in those columns (The value of customer id in the table Customer is not the same as customer Id in the table Orders) are different. (in the customer table, we have 1,2,3,.. and in the the orders, we have VINET as exemple 3 No - Region is not relevant to filter according to the requirement

I don't get the logic of many of you: First the questions asks , if there must be a relation in Customer ID column. The answer is yes, of course there must be a relation in that column as is the only comon table. Next question is if there must be changed to text data type. The answer is no, it doesn't have to be of a text data type, it can be also an integer data type. Is true that to create a relationship you need the same data type in both columns but doesn't have to be of a text data type. And third, the region doesn't have to come from the Order table to work correctly. Furthermore, it isn't even there, it comes from Customer details table. So Y/N/N I think are the answers. It can get tricky but I would say I followed the correct logic here.

NO (Relationship should be based on CustomerDetails.CustomerCRMID = Orders.CustomerID YES technically, if it's not so already in the CustomerDetails table NO Region field in this case is associated to customer and should come from CustomerDetails Table.

1) NO - CustomerID in Orders is text ("VINET") while CustomerID in Customer Details is number ("1"). 2) YES - Relationship between Orders and Customer Details will be via column CustomerCRMID in Customer Details and CustomerID in Orders, which are both text. 3) NO - the Orders table only contains shipping address, which is different from the billing address which should be used for sales region. Thus, it should come from Customer Details table.

1) Y 2) N 3) N Guys, please consider the 3 questions as connected process. For 1), we must build relationship for these two tables. CustomerID is the only common filed in both tables; 2) is to achieve 1), we will set the Data Type of CustomerID to Integer rather than Text. 3) The Region field also exists in Customer Details table, not only in Orders table.

No-yes-no

no - no - no 1. no, because Customer Details CustomerID is int and Order CustomerID is text - not the same content 2. no, because there is no common column where we could join on. Furthermore, it should be avoided to join via text columns, because integer fields in relations are faster 3. no, because sales region is nowhere defined as the ship-to country or the sold-to country. So it can't be said, that it MUST come from the Orders.

According to the example value in the CustomerID column of the ORDERS table, this table contains strings such as "VINET" which can't be converted to an integer. Therefore, in my opinion, the primary and foreign keys of the relationship must be TEXT and not INTEGER. As a consequence, I believe the second statement is TRUE