Exam PL-300 topic 5 question 1 discussion

A. Change the data type of Sales[region_id] to Whole Number. is correct, because the data type is INTEGER in Sales Region, Region_Manager and Targets.

A. So much fluff to this question, so my suggestion is to read the question first, before reading through the case study. 95% of the paragraph is not relevant to the question being asked.

"Sales by Region" report would require relationship between [Sales] and [Sales_Region] tables (additional break down views would require to link also data tables, manager table....) "region_id" field for [Sales] is VARCHAR data type while this field, not only in [Sales_Region] but in other tables, is INTEGER so we would require to change data type in [Sales] to WHOLE NUMBER. In [Weekly_Returns] table, the "sales_region_id" field is also VARCHAR and should be also changed to WHOLE NUMBER in case we would require regional details

The question is about creating a relationship. You cannot create relationships between two different datatypes, (varchar vs integer). Answer is A

How many case study questions will com in the exam?

The data type is varchar in Sales and INTEGER in Sales Region, Region_Manager and Targets

I passed the exam today (948/1000). My answer was: - Change the data type of Sales[region_id] to Whole Number In the case study, the Sales[region_id] is set as VARCHAR.

A should be correct.

region_id should be INTEGER! I am not sure changing to whole number is the same!

A is correct

Correct

I think it is 'D', since these are unique IDs, we can use them as a text.

Answer is correct