Exam PL-300 topic 5 question 1 discussion

Actual exam question from Microsoft's PL-300

Question #: 1
Topic #: 6

You need to create the required relationship for the executive's visual.
What should you do before you can create the relationship?

A. Change the data type of Sales[region_id] to Whole Number.
B. Change the data type of Sales[region_id] to Decimal Number.
C. In the Sales table, add a measure for Sum(sales_amount).
D. Change the data type of Sales[sales_id] to Text.

Show Suggested Answer

Suggested Answer: A 🗳️

by fred92 at Oct. 24, 2022, 6:43 p.m.

Comments

Submit Cancel

Booster21

Highly Voted 2 years, 9 months ago

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.

upvoted 28 times

...

cs3122

Highly Voted 1 year, 6 months ago

Selected Answer: A

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.

upvoted 24 times

...

jaume

Most Recent 8 months, 3 weeks ago

Selected Answer: A

"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

upvoted 1 times

...

Dani_eL

1 year, 5 months ago

Selected Answer: A

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

upvoted 4 times

...

vvijaya86

1 year, 6 months ago

How many case study questions will com in the exam?

upvoted 5 times

...

lmrod

1 year, 11 months ago

Selected Answer: A

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

upvoted 1 times

...

SamuComqi

2 years ago

Selected Answer: A

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.

upvoted 9 times