exam questions

Exam DP-500 All Questions

View all questions & answers for the DP-500 exam

Exam DP-500 topic 1 question 126 discussion

Actual exam question from Microsoft's DP-500
Question #: 126
Topic #: 1
[All DP-500 Questions]

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this question, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

From Power Query Editor, you profile the data shown in the following exhibit.



The IoT GUID and IoT ID columns are unique to each row in the query.

You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.

Solution: You remove the IoT ID column and retain the IoT GUID column.

Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
nikolgerson
1 year, 1 month ago
Selected Answer: B
you want to split IoT Date/Time by date and hour
upvoted 1 times
...
rjramyyyy
1 year, 4 months ago
Remove the GUID because it is a string column and in any power bi model the numeric columns query faster than string columns
upvoted 1 times
...
MaryemSB
1 year, 6 months ago
A is correct. agree with Deloro : even though removing GUID is a better solution, removing ID also improves performance
upvoted 1 times
...
Deloro
1 year, 8 months ago
Selected Answer: A
check below why
upvoted 1 times
...
KBelh
1 year, 9 months ago
It is better to keep ID (whole number) than GuID. So correct answer is No
upvoted 2 times
...
Deloro
1 year, 9 months ago
guess not, rather remove GUID's than ID's since its better to use surrogates
upvoted 2 times
Deloro
1 year, 8 months ago
actually, i would say yes since you're removing data so it will be improving however i would remove the guid
upvoted 2 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...