Microsoft
70-778 · Question #10
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and…
The correct answer is D. Conditional Column. See the full explanation below for the reasoning.
Question
Note: This question is a part of a series of questions that present 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.) You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit). 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?
Exhibits
Options
- AColumn From Examples
- BCustom Column
- CInvoke Custom Function
- DConditional Column
How the community answered
(34 responses)- A9% (3)
- B3% (1)
- C15% (5)
- D74% (25)
Community Discussion
No community discussion yet for this question.

