DP-600 · Question #16
You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1. Dataflow1 has a query that returns 2,000 rows. You view the query in Power Query as shown in the following exhibi
The correct answer is A. The column has duplicate values.. Based on the Power Query column quality profile, the pickupLongitude column contains duplicate values.
Question
You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1. Dataflow1 has a query that returns 2,000 rows. You view the query in Power Query as shown in the following exhibit. What can you identify about the pickupLongitude column?
Exhibit
Options
- AThe column has duplicate values.
- BAll the table rows are profiled.
- CThe column has missing values.
- DThere are 935 values that occur only once.
How the community answered
(22 responses)- A91% (20)
- B5% (1)
- C5% (1)
Why each option
Based on the Power Query column quality profile, the `pickupLongitude` column contains duplicate values.
The Power Query Editor's column quality profile explicitly displays a bar or indicator labeled 'Duplicate' when a column contains values that appear more than once within the dataset, directly identifying duplicates.
The exhibit shows column quality metrics but does not confirm that every row of the entire table has been fully profiled for all possible data characteristics.
Concept tested: Power Query Editor column quality profiling
Source: https://learn.microsoft.com/en-us/power-query/data-profiling-tools
Topics
Community Discussion
No community discussion yet for this question.