exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 52 discussion

Actual exam question from Microsoft's PL-300
Question #: 52
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 change the IoT DateTime column to the Date data type.

Does this meet the goal?

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

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
GuerreiroJunior
Highly Voted 2 years, 3 months ago
Selected Answer: B
Agreeded. Bcause, if you just transform the data type you will not be able to analyse the information by time, as requested.
upvoted 22 times
Richdata23
1 year, 4 months ago
agreed
upvoted 2 times
...
...
Underthesea92
Highly Voted 1 year, 10 months ago
Selected Answer: B
You need to analyse by hour. If you change to date you remove the time
upvoted 5 times
...
jaume
Most Recent 5 months, 1 week ago
Selected Answer: B
Data type for this field is currently set to "Date/Time", setting data type to just "Date" would result in losing the "Time" part of the information which is required in the analysis
upvoted 1 times
...
rcaliandro
8 months, 1 week ago
Selected Answer: B
No, we need the time in the analysis
upvoted 1 times
...
Dsbuff
1 year, 4 months ago
Selected Answer: B
If you change data type to Date only, you will lose the data (time).
upvoted 3 times
...
walexis
1 year, 5 months ago
I believe wthout splitting datatime to date and time, you can still be able to analyse IoT events by the hour and day of the year
upvoted 1 times
...
Igetmyrole
1 year, 7 months ago
B is correct. Converting it to the date data type would only allow you to work with dates, but it wouldn't provide the necessary granularity to analyze events by the hour or day of the year.
upvoted 2 times
...
rania
1 year, 11 months ago
Selected Answer: B
il you change the data type you will not be able to analyse by hour
upvoted 1 times
...
RazaTheLegend
2 years ago
Selected Answer: B
The answer is B because the instruction says to analyze based on date and time. Changing the IoT date column to the date data type takes out the time needed for the analyses.
upvoted 2 times
...
Sushvij
2 years, 3 months ago
B is correct
upvoted 1 times
...
jsking
2 years, 3 months ago
Selected Answer: B
B is correct because changing the IoT DateTime column to the Date data type alone will not meet the goal of analyzing IoT events by the hour and day of the year in power query.
upvoted 4 times
...
Nuli
2 years, 3 months ago
The answer is B because the instruction says to analyze based on date and time. Changing the IoT date column to the date data type takes out the time needed for the analyses.
upvoted 2 times
...
reyn007
2 years, 3 months ago
Selected Answer: B
B. because the column has both data and time values
upvoted 3 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago