- (Exam Topic 4)
You are creating a column chart visualization.
You configure groups as shown in the Groups exhibit. {Click the Groups tab.)
The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Solution:
Does this meet the goal?
Correct Answer:A
- (Exam Topic 4)
You have a report in Power BI Desktop.
You add a key influencers visual as shown in the exhibit. (Click the Exhibit tab.)
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Solution:
- adding more fields to Explain By
- 3
Does this meet the goal?
Correct Answer:A
- (Exam Topic 4)
You have a folder that contains 100 CSV files.
You need to make the file metadata available as a single dataset by using Power Bi The solution must NOT store the data of the CSV files.
Which three actions should you perform in sequence. To answer, mow the appropriate actions from the list of actions to the answer area and arrange them m the correct order.
NOTE; More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Solution:
From Power BI Desktop, select Get Data, and then select Folder. From Power Query Editor, remove the Content column.
From Power Query Editor, expand the Attributes column.
Does this meet the goal?
Correct Answer:A
- (Exam Topic 4)
You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:
The report will facilitate the following analysis:
• The count of orders and the sum of total sales by Order Date
• The count of customers who placed an order
• The average quantity per order
You need to reduce data refresh times and report query times.
Which two actions should you perform? Each correct answer presents part of the solution
NOTE: Each correct selection is worth one point.
Correct Answer:AC
- (Exam Topic 4)
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.
The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Solution:
User 1 = Member User 2 = Contributor
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces
Does this meet the goal?
Correct Answer:A