Exam4Training

Which two actions should you perform?

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.
A . Open the Advanced Editor.
B . Select Column quality.
C . Enable Column profiling based on entire dataset.
D . Select Column distribution.
E . Select Column profile.

Answer: C,E

Explanation:

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/

Latest PL-300 Dumps Valid Version with 131 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version