Free Access Microsoft.PL-300.v2023-03-22.q84 Practice Test (Page 9)

Question 36

You have a collection of reports for the HR department of your company.
You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months.
Which type of visualization should you use?

A.scatter chart

B.ribbon chart

C.line chart

D.key influences

Question 37

You are building a Power BI report to analyze customer segments.
You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort.
Which type of visualization should you use?

A.decomposition tree

B.funnel chart

C.Q&A

D.key influencers

Question 38

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.
What should you recommend?

A.For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.

B.For every report, create and use a single shared dataset that contains the standardized data.

C.Create a shared dataset for each standardized entity.

D.Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.

Question 39

You are profiling data by using Power Query Editor.
The AddressLine2 column in a table named Address is 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.