Microsoft Exam DA-100 Topic 2 Question 16 Discussion

Actual exam question for Microsoft's DA-100 exam

Question #: 16
Topic #: 2

You open a query in Power Query Editor.

You need to identify the percentage of empty values in each column as quickly as possible.

Which Data Preview option should you select?

AShow whitespace

BColumn profile

CColumn distribution

DColumn quality

Show Suggested Answer

Suggested Answer: D

Column quality: In this section, we can easily see valid, Error and Empty percentage of data values associated with the Selected table.

Note: In Power Query Editor, Under View tab in Data Preview Section we can see the following data profiling functionalities:

Column quality

Column distribution

Column profile

by Lashaunda at May 05, 2022, 07:20 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!