- (Exam Topic 4)
You create a report by using Microsoft Power BI Desktop.
The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company’s internal network.
You plan to publish the report to the Power BI Service.
What should you implement ta ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

1. A. a subscription
2. B. a scheduled refresh of the dataset
3. C. an OData feed
4. D. an On-premises data gateway

Correct Answer: D
When you’ve created dynamic reports in Power BI Desktop, you can share them by publishing to your Power BI site. When you publish a Power BI Desktop file with a live connection to a tabular model to your Power BI site, an on-premises data gateway must be installed and configured by an administrator.

- (Exam Topic 4)
You have a Power Bl query named Sates that imports the columns shown in the following table.

Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis. You need to reduce the load times of the query without affecting the analysis.
Which two actions achieve this goal? Each correct answer presents a complete solution.
NOTL Each correct selection is worth one pant.

1. A. Remove the rows in which sales [status] has a value of Canceled.
2. B. Change the data type of sale [Delivery_Time] to Integer
3. C. Removes (Canceled Date).
4. D. Split Sales [Sale_Date] into separate date and time columns.
5. E. Remove sales [Sales_Date].

Correct Answer: AD

- (Exam Topic 4)
You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power Bi dataset
You need to ensure that the dataset can be refreshed in powefbi.com.
Which two connectors can you use to connect to the file? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

1. A. Text/CSV
2. B. Folder
3. C. Excel Workbook
4. D. SharePoint folder
5. E. Web

Correct Answer: DE
- Copy and edit Path of the Excel file then use "Web" Connector: Option E
- Copy and edit Path of the OneDrive folder then use "Sharepoint Folder" connector: Option D Source: https://www.youtube.com/watch?v=GGHbbg6yi-A

- (Exam Topic 4)
You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that the users can consume the content on a report page in a logical order. What should you configure in Microsoft Power Bl Desktop?

1. A. the bookmark order
2. B. the layer order
3. C. the tab order
4. D. the X position

Correct Answer: C
If you find yourself unable to navigate to an object or visual while using a keyboard, it may be because the report author has decided to hide that object from the tab order. Report authors commonly hide decorative objects from the tab order. If you find that you cannot tab through a report in a logical manner, you should contact the report author. Report authors can set the tab order for objects and visuals.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-consuming-tools

- (Exam Topic 1)
You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

1. A. Change the data type of Sales[region_id] to Whole Number.
2. B. In the Sales table, add a measure for sum(sales_amount).
3. C. Change the data type of sales[sales_id] to Text.
4. D. Change the data type of sales [region_id] to Decimal Number.

Correct Answer: A
Scenario: Executives require a visual that shows sales by region.
Need to change the sales_id column from Varchar to Whole Number (Integer).