Loading demo links...
Showing 4–6 of 10 questions
HOTSPOT
You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.
You need to add a new column that contains the data in the format of nnn-nnn-nnnn.
How should you complete the Query Editor formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer is in the explanation below.
Your company has several developers who plan to create custom solutions that will interact with the API for the Power BI service.
Which three operations can the developers achieve by using the API? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Select all that apply, then click Submit answer.
Retrieve rows from a dataset
Create a dataset
Add rows to a dataset
Refresh an imported dataset
Add a member to a row-level security role
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.
Start of repeated scenario.
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.
End of repeated scenario.
You are modeling the data in Power BI.
You need to import only a sample of the data from the Order table.
What are two possible ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Select all that apply, then click Submit answer.
From Query Editor, create a custom column that uses a custom column formula.
From Query Editor, add a SELECT statement that uses a WHERE clause to the source definition.
In the Power BI model, create a calculated table.
From Query Editor, filter the table by Order_date.
From Query Editor, create a column by using Column From Examples.
