ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 50 discussion

Actual exam question from Microsoft's PL-300
Question #: 50
Topic #: 2
[All PL-300 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 section, 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 split the IoT DateTime column into a column named Date and a column named Time.

Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by GuerreiroJunior at Jan. 10, 2023, 7:46 p.m.

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
Submit Cancel
HemantGorle
Highly Voted 2 years, 3 months ago
Selected Answer: A
The correct answer is A. Splitting datetime column will improve the perfomance even if it generates one more column, having less unique values in separated date and time columns will achieve better compression.
upvoted 66 times
iamSophie
1 year, 1 month ago
Not after the data is loaded into Power BI. Splitting the date time BEFORE loading to PBI will improve performance
upvoted 5 times
...
...
GuerreiroJunior
Highly Voted 2 years, 3 months ago
Selected Answer: A
The correct answern is A. Bcause Split a datetime column improve the perfomance even if you will have one more column.
upvoted 16 times
GabryPL
2 years, 3 months ago
Agree. A is the correct answer
upvoted 5 times
...
...
desibaby09
Most Recent 5 months ago
Selected Answer: A
yes it meets the goal
upvoted 1 times
...
jaume
5 months, 1 week ago
Selected Answer: A
To anlyze IoT event by the hour AND day of the year, we need those details available and originally they are merged into a single "IoT Date Time" field, we need to split date and time to separate them to turn them "usable" for our analysis.
upvoted 1 times
...
ab97776
1 year ago
If the analysis only requires the date part and the time part results in high cardinality without being used in the analysis, splitting will improve performance. If both date and time are necessary and are used together frequently in the analysis, splitting them might not provide a performance benefit and could even complicate measures and calculations.
upvoted 2 times
...
Rhugved
1 year, 1 month ago
Selected Answer: B
B is Right
upvoted 3 times
...
iamSophie
1 year, 1 month ago
B is correct plitting date/time BEFORE loading to Power BI will increase the performance and not AFTER: Source: https://learn.microsoft.com/en-us/training/modules/get-data/8-performance-issues?ns-enrollment-type=learningpath&ns-enrollment-id=learn-bizapps.data-preparation-in-power-bi If any of your tables have columns that combine date and time, make sure that you separate them into distinct columns before importing them into Power BI.
upvoted 2 times
...
BennyBenz
1 year, 3 months ago
But A is not a solution because you have to analyze IoT events by the hour and day of the year. When splitting the datetime you will get multiple equal values for time... Which should be aggregated right?
upvoted 4 times
...
worachac
1 year, 3 months ago
Selected Answer: B
Splitting datetime column will improve but it's not enough. We can remove either IoT GUID or IoT ID column in addition.
upvoted 1 times
...
ElieG
1 year, 4 months ago
Yes, it will improve the performance, because splitting date-time will increase compression abilities. Reference: https://learn.microsoft.com/en-us/training/modules/get-data/8-performance-issues?ns-enrollment-type=learningpath&ns-enrollment-id=learn-bizapps.data-preparation-in-power-bi Reference 2: https://www.algorhythmblog.be/2022/08/02/time-to-split-are-datetimes-bogging-down-your-model/
upvoted 5 times
phantomghost
1 year, 2 months ago
I checked the your first Reference, your right. Here is what it said "Separate date and time, if bound together. If any of your tables have columns that combine date and time, make sure that you separate them into distinct columns before importing them into Power BI. This approach will increase compression abilities."
upvoted 3 times
...
...
Jayvee14
1 year, 5 months ago
I am pretty sure that it should be A and not B, because according to many experts, splitting date and time will make the performance even better.
upvoted 1 times
...
WRTopics
1 year, 6 months ago
Selected Answer: B
I think the answer is B beacuse we need improve the dataseet performance, splitting or make a new column will make it slower.
upvoted 1 times
55884
1 year, 1 month ago
No. Splitting the column will reduces the amount of result. Hence, increase the query performance.
upvoted 1 times
55884
1 year, 1 month ago
And the question requires an analyzation of both HOUR and DATE. In able to do that, we need split the column into both to allow a separate analyzation.
upvoted 1 times
...
...
elsuizo_88
1 year, 6 months ago
in this case nop
upvoted 3 times
...
...
IMntimande6
1 year, 7 months ago
There is an error guys "A" is 85% correct
upvoted 1 times
...
Ibritics
1 year, 7 months ago
Selected Answer: A
It actually will decrease a cardinality by improving the performance so answer is A
upvoted 2 times
...
Igetmyrole
1 year, 7 months ago
B is correct. It is because the proposed solution does not improve dataset performance in this context, it focuses on splitting the DateTime column into Date and Time without addressing the desired analysis.
upvoted 5 times
...
taod
1 year, 8 months ago
Selected Answer: A
A is correct and here's a technical answer to it: https://www.algorhythmblog.be/2022/08/02/time-to-split-are-datetimes-bogging-down-your-model/
upvoted 4 times
...
Ravisha27
1 year, 9 months ago
Selected Answer: B
why is everyone's focus only on improving the dataset. the question is in 2 parts. - analyze the IoT events based on DAY & HOURS. - solution must improve dataset performance. the IoT date time column doesn't have DAY values. so by just splitting date& time, it wont meet our solution. hence correct answer is B.No
upvoted 9 times
Dani_eL
1 year, 2 months ago
wrong; IoTdate time column is expressed in dd/mm/yyyy hh:mm:ss format. Furthermore when you split that field PBI automatically builds a date hierarchy thus improving performances as you can directly use the DAY part of the hierarchy. You can even categorize your columns yourself if needed
upvoted 3 times
...
...
Load full discussion...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago