You plan to create several datasets by using the Power BI service. You have the files configured as shown in the following table.<>>
Correct Answer:
AE
References: https://docs.microsoft.com/en-us/power-bi/service-get-data
You plan to join a fact table named ActivityLog to a Date dimension named ActivityDate. The date value in ActivityLog is a datetime column named ActivityStart The date value in AdivityDate is a number column named DatelD. DatelD is in the YYYYMMDD format.
What should you do in the model before you create the relationship?
Correct Answer:
D
Note: This question is a part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains two columns named Date and Time.
The tables have the following relationships:
Sales [DueDate] and Date [Date]
Sales [ShipDate] and Date [Date]
Sales [OrderDate] and Date [Date]
The active relationship is on Sales [DueDate].
You need to create measures to count the number of orders by [ShipDate] and orders by [OrderDate]. You must meet the goal without loading any additional data.
Solution: You create two copies of the Date table named ShipDate and OrderDateGet. You create a measure that uses the new tables.
Does this meet the goal?
Correct Answer:
B
You are configuring the relationships between the following tables.
< ><>>>>>< >
Solution:
References:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
Does this meet the goal?
Correct Answer:
A
Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:
Access a published Power BI app
Modify reports in an app workspace
Share dashboards created in My Workspace
You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.
Which license should you identify for each task? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Solution:
References:
https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps https://docs.microsoft.com/en-us/power-bi/service-collaborate-power-bi-workspace
Does this meet the goal?
Correct Answer:
A