exam questions

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 121 discussion

Actual exam question from Microsoft's 70-778
Question #: 121
Topic #: 1
[All 70-778 Questions]

DRAG DROP -
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.

The following columns contain date information:
- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You need to display the month as a three-letter abbreviation, followed by the year, such as jan2017.
You add a calculated column in Power BI.
Which DAX formula should you use for the calculated column? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
References:
https://docs.microsoft.com/en-us/dax/concatenate-function-dax#example-concatenation-of-columns-with-different-data-types https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function

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
kyliek7
4 years, 6 months ago
by the way it will be anyway Jan2020, with first capital letter at the beginning. no still wrong answer, but the best :D
upvoted 1 times
...
Gmaxnero
5 years ago
Should be 'MMM'?
upvoted 1 times
123
4 years, 11 months ago
"....You need to display the month as a three-letter abbreviation..."
upvoted 1 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 ...