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: DE
Explanation:
Data Profiling, Quality & Distribution in Power BI / Power Query features
To enable these features, you need to go to the View tab à Data Preview Group à Check the following:
– Column quality
– Column profile
– Column distribution
– Column profile
Turn on the Column Profiling feature.
– Column distribution
Can use it to visually realize that your query is missing some data because of distinct and uniqueness counts.
Reference:
https://www.poweredsolutions.co/2019/08/13/data-profiling-quality-distribution-in-power-bi-power-query/
https://www.altentertraining.com/microsoft/power-bi/column-profiling-is-good/
Latest DA-100 Dumps Valid Version with 114 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund