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

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam
Go to Exam

Exam 70-778 topic 1 question 35 discussion

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

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 exactly the same in each question in this series.
Start of repeated scenario.
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit button.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit button.)

You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory[Subcategory] contains NULL values.
End of Repeated Scenario.
You implement the Power BI model.
You need to add a new column to the Product Subcategory table that uses the following formula.
=if [Subcategory]=null then "NA" else [Subcategory]
Which command should you use in Query Editor?

  • A. Conditional Column
  • B. Column From Examples
  • C. Invoke Custom Function
  • D. Custom Column
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
References:
http://community.powerbi.com/t5/Desktop/if-then-else/td-p/117999
by TiaanR at July 9, 2019, 8:02 a.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
k3rz0rg
Highly Voted 5 years, 5 months ago
Even today I worked on such and it's A. Conditional column which is explicitly serve this purpose. If the option is there, select that for such scenario even if you are blindfolded.
upvoted 10 times
...
TiaanR
Highly Voted 5 years, 9 months ago
If you want to add a formula, then add a custom column. A conditional column is just a custom column with a form that creates the formula for you. So I'd go with D.
upvoted 10 times
SteveKarr
5 years, 9 months ago
Condition Column is specifically designed for this use. Whenever there is a specific answer compared to a more generic option, it is better to go with specific option..
upvoted 29 times
...
...
Jew0598
Most Recent 1 year, 11 months ago
It is a Custom column as the Conditional column will result in a null value for subcategory rows that are not null. Tested!
upvoted 1 times
...
IGDR
3 years, 10 months ago
D as we need to use the formula provided
upvoted 2 times
...
Xmael
3 years, 11 months ago
Ans is D
upvoted 1 times
...
Robc79
4 years, 4 months ago
Answer is D - Custom Column
upvoted 2 times
...
Lhouss
4 years, 4 months ago
Should be D. We need to add a formula, only custom column allow to add code specified in the question.
upvoted 1 times
...
CristianoMoraes
4 years, 4 months ago
A (Power Query Wizard creates the condition) and D (Explict write the 'M' condition)
upvoted 1 times
...
ay2008
4 years, 4 months ago
Conditional columns let you create a new column using IF/ELSE logic
upvoted 1 times
...
slalithp
4 years, 5 months ago
Answer should be both Conditional and Custom Column
upvoted 1 times
...
CDL
4 years, 5 months ago
A, tested.
upvoted 1 times
...
cromastro
4 years, 8 months ago
It's conditional column. Here is the M that is generated by the GUI: Table.AddColumn(_Customers, "AddressLine3", each if [AddressLine2] = null then [AddressLine1] else [AddressLine2]) for an arbitrary example.
upvoted 1 times
...
shahatul
4 years, 8 months ago
Answer A is correct. I test checked the answer in Power BI Desktop and formula works in conditional column.
upvoted 1 times
...
Satyapn9
4 years, 8 months ago
Answer is D (Custom Column). This question is tricky. Below is my explanation from the exercise done. #1. You cannot put the formula directly into conditional column, there you have to select options explicitly to accomplish the desired result. #2. You cannot use NULL in the conditional column.
upvoted 1 times
...
Waltmas
4 years, 9 months ago
Conditional column will do, you are not explicitly told to put a formula but the column will use tht formula.
upvoted 1 times
...
123
4 years, 9 months ago
Here's my insight: yes, "formula...." indicates custom. It LOOKS like a Custom column, and you can add a custom column with these details. But it's a trick question b/c when you accept this as a "custom" and go back in to edit, PBI sees it as a "conditional". Per Udemy's explanation, if we had "or", "and", "not", "greater than/less than"....then it's custom Vent here: arrrrrrrrrrrrrrrggggh!!! On ALL these questions!!
upvoted 1 times
123
4 years, 9 months ago
I guess I'll go with conditional as this is what the answer seems to be per the study guide and what PBI interprets it as. But anybody who says "custom", I totally see your point. :)
upvoted 1 times
...
...
Onkar26
4 years, 10 months ago
Correct Answer is D. Custom Column Explanation: In Conditional Column, you need to fill the form to implement this if/else condition. You cannot provide the given DAX. Its true that requirement can be achieved with conditional columns but without implementing given DAX. You can provide the given DAX in custom columns.
upvoted 5 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