- (Exam Topic 4)
You have a Power Bl report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables.

There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns. The report contains the visuals shown in the following table.

The dataset takes a long time to refresh.
You need to modify Posts and Traffic queries to reduce toad times.
Which two actions will reduce the toad times? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

1. A. Remove the rows m Traffic in which Traffic [Referring URL] does not start with "/"
2. B. Remove the rows in Posts in which Post [Publish Date] is in the last seven days.
3. C. Remove Traffic [IP Address], Traffic (Browser Agent], and Traffic [Referring URL).
4. D. Remove Posts [Full Text] and Posts [Summary].
5. E. Remove the rows in Traffic in which Traffic [URL visited] does not contain "blog''

Correct Answer: DE

- (Exam Topic 4)
You have a Power BI workspace named BI Data that contains a dataset named BI Finance.
You have the Build permission for the 81 Finance dataset but you do NOT have permissions for the workspace,
You need to connect to BI Finance and create a report.
Which actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

1. A. From the Power BI service, create a dataflow to the dataset by using DirectQuery.
2. B. From Power BI Desktop, connect to a Dataverse data source.
3. C. From the Power BI service, create a new report and select a published dataset
4. D. From Power Bl Desktop, connect to a shared dataset

Correct Answer: BC

- (Exam Topic 4)
You have the data lineage shown in the following exhibit.

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:
Text, table Description automatically generated with medium confidence
Box 1: CONTOSO BIKES report Box 2: three datasets
Images, tweets and the Contoso datasets.

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 4)
You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

1. A. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
2. B. Publish the reports to a different workspace other than the one hosting the datasets.
3. C. Publish the reports in an app and grant the HR managers access permission.
4. D. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

Correct Answer: C
Note: Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

- (Exam Topic 4)
You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields: First name
Last name
Email address
State/Region
Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

1. A. Open the Advanced Editor.
2. B. Select Column quality.
3. C. Enable Column profiling based on entire dataset.
4. D. Select Column distribution.
5. E. Select Column profile.

Correct Answer: CE
In Power query, the load preview by default is 1000 row. By default, the column quality also only looks at the first 1000 row. You can verify this by the status bar at the bottom of the Power query window. To change the profiling so it analyses the entire column of data, select the profiling status in the status bar. Then select Column profiling based on the entire data set.
https://theexcelclub.com/data-profiling-views-in-power-query-excel-and-power-bi/