<< Prev Question Next Question >>

Question 2/58

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?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (58q)
Question 1: You have a power BI model that contains the following tables...
Question 2: Note: This question is a part of a series of questions that ...
Question 3: In the Power BI service, you create an app workplace that co...
Question 4: You have the following two queries in Power BI Desktop: A qu...
Question 5: You have a Power BI report that displays a bar chart and a d...
Question 6: You have a Power BI dashboard that displays different visual...
Question 7: Note: This question is a part of a series of questions that ...
Question 8: Note: This question is a part of a series of questions that ...
Question 9: HOTSPOT Your company plans to use Power BI for 20 users in t...
Question 10: You have an on-premises Power BI Report Server. You plan to ...
Question 11: You have a Microsoft SharePoint Online site named Sales. You...
Question 12: You embed a Power BI report in a Microsoft SharePoint Online...
Question 13: DRAG DROP Note: This question is a part of a series of quest...
Question 14: Note: This question is a part of a series of questions that ...
Question 15: You plan to use Power BI Embedded to deliver reports in a we...
Question 16: Note: This question is a part of a series of questions that ...
Question 17: You have a Power BI model for sales data. You need to create...
Question 18: Note: This question is a part of a series of questions that ...
Question 19: DRAG DROP You have the following two tables: Subscriber (Sub...
Question 20: You have an app workspace named Retail Analysis in the Power...
Question 21: You plan to create a dashboard in the Power BI service that ...
Question 22: You have a workspace that contains 10 dashboards. A dashboar...
Question 23: DRAG DROP You have a Microsoft Excel workbook that contains ...
Question 24: Note: This question is a part of a series of questions that ...
Question 25: You plan to create a Power BI report. You have the schema mo...
Question 26: You manage a Power BI model has a table named Sales. You nee...
Question 27: DRAG DROP You have a column named phone_number. The values i...
Question 28: HOTSPOT You open powerbi.com as shown in the following exhib...
Question 29: Note: This question is a part of a series of questions that ...
Question 30: Note: This question is a part of a series of questions that ...
Question 31: You have an app workspace that contains a dashboard and four...
Question 32: DRAG DROP Note: This question is a part of a series of quest...
Question 33: You have two tables named CustomerVisits and Date in a Power...
Question 34: You plan to create several datasets by using the Power BI se...
Question 35: Note: This question is a part of a series of questions that ...
Question 36: DRAG DROP You have a Power BI model that contains a table na...
Question 37: You plan to use Power BI Desktop optimized for Power BI Repo...
Question 38: Your organization has a team of power users who recently cre...
Question 39: DRAG DROP Note: This question is a part of a series of quest...
Question 40: You have a Power BI model that contains the following tables...
Question 41: You plan to embed multiple visualization in a public website...
Question 42: From Power BI Desktop, you create a query that imports the f...
Question 43: Note: This question is a part of a series of questions that ...
Question 44: You have a table in Power BI Desktop as shown in the followi...
Question 45: You have a Microsoft Excel 2016 workbook that has a Power Pi...
Question 46: Note: This question is a part of a series of questions that ...
Question 47: DRAG DROP From Power BI Desktop, you publish an app that con...
Question 48: You have a Power BI report in an app workspace. You plan to ...
Question 49: HOTSPOT You have the following tables. (Exhibit) You need to...
Question 50: HOTSPOT You have a query that retrieves data from a Microsof...
Question 51: Note: This question is a part of a series of questions that ...
Question 52: HOTSPOT You have a Power BI model that has the following tab...
Question 53: You have a Power BI app named App1. The privacy for the App1...
Question 54: Note: This question is a part of a series of questions that ...
Question 55: You have a table named Sales. A sample of the data in Sales ...
Question 56: You plan to use Power BI Desktop to create a report. The rep...
Question 57: HOTSPOT You have the following tables. (Exhibit) You need to...
Question 58: You have a Power BI report that is configured to use row-lev...