What is confusing here is the fact that there is a date_id defined in the format yyyymmdd. Therefore, some people would tend to select C. However, I do not quite understand why this info is even given to us. I would have expected this field ID to be... an ID, not a date?
[date_id] is an INTEGER and cannot be formatted as a date data type (we should first convert it to date data type using the DATE DAX function) and this discards options B and C.
We want a result as "Feb 2020" and this is "MMM YYYY" not "M YY" --> option A
Feb 2020---> month has 3 character, therefore the format should be MMMYYYY and also date_id column data type is int and we cannot use in Format function! we need a date type column.
This section is not available anymore. Please use the main Exam Page.PL-300 Exam Questions
Log in to ExamTopics
Sign in:
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.
fdsdfgxcvbdsfhshfg
Highly Voted 2 years, 7 months agoNuriaIzard
Highly Voted 2 years, 4 months agojaume
Most Recent 5 months, 1 week agoDani_eL
1 year, 1 month ago[Removed]
1 year, 8 months agoShalaleh
2 years agoNemesizz
2 years, 2 months agododoinparis
1 year, 10 months agoJJMC5544
1 year, 10 months agolukelin08
2 years, 5 months agoBooster21
2 years, 6 months ago