Exam DP-500 topic 1 question 39 discussion

Actual exam question from Microsoft's DP-500

Question #: 39
Topic #: 1

You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibit. (Click the Tables tab.)

The table relationships for the dataset are shown in the Relationships exhibit. (Click the Relationships tab.)

You need to reduce the model size by eliminating invalid relationships.
Which column should you remove?

A. Sales[Sales Amount]
B. Sales[Row ID]
C. Sales[Sales ID]
D. Plan[Row ID]

Show Suggested Answer

Suggested Answer: B 🗳️

by nbagchi at Dec. 13, 2022, 2:56 p.m.

Comments

Submit Cancel

nbagchi

Highly Voted 2 years, 6 months ago

Selected Answer: B

Correct, Row ID has 858,786 missing keys

upvoted 8 times

...

MaryemSB

Most Recent 1 year, 6 months ago

Selected Answer: B

agree with ivanb94

upvoted 1 times

...

Eltooth

2 years, 1 month ago

Selected Answer: B

B is correct answer - 858,756 missing keys!

upvoted 1 times

...

DarioReymago

2 years, 3 months ago

Selected Answer: B

B is the only one listed in 2° table

upvoted 1 times

...

ivanb94

2 years, 5 months ago

To be precise RowID from the Sales table, so answer B, not the other provided potential answer with Plan table. P.S. Plan table seems to be made up considering that it is not mentioned in either of the pictures --> only Plan Header Details is. Another Microsoft confusion device -.-

upvoted 3 times

...

MrXBasit

2 years, 6 months ago

Selected Answer: B

858,786

upvoted 2 times

...