nerdexam
Microsoft

PL-300 · Question #101

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…

The correct answer is C. Enable Column profiling based on entire dataset. E. Select Column profile. The dataset have 1500 rows, if you don't enable the column profiling for the entire dataset, the column profiling will be only based on top 1000 rows. So first enable for entire dataset and after that run column profiling for the entire dataset.

Submitted by mike_84· Apr 18, 2026Prepare the data

Question

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.

Options

  • AOpen the Advanced Editor.
  • BSelect Column quality.
  • CEnable Column profiling based on entire dataset.
  • DSelect Column distribution.
  • ESelect Column profile.

How the community answered

(26 responses)
  • A
    12% (3)
  • B
    4% (1)
  • C
    77% (20)
  • D
    8% (2)

Explanation

The dataset have 1500 rows, if you don't enable the column profiling for the entire dataset, the column profiling will be only based on top 1000 rows. So first enable for entire dataset and after that run column profiling for the entire dataset.

Topics

#Power Query Editor#Data Profiling#Column Analysis#Data Quality

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PL-300 Practice