DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

By Microsoft · Question Mode

QuestionQ83

Prepare data

You have a Fabric tenant that contains a warehouse.

You use a dataflow to load a new dataset from OneLake to the warehouse.

You need to add a Power Query step to identify the maximum values for the numeric columns.

Which function should you include in the step?

  • A Table.Range
  • B Table.MaxN
  • C Table.Profile
Explanation

Table.Profile() returns profiling statistics for each column in a table, including minimum, maximum, distinct count, null count, and data type. Table.Range and Table.MaxN do not provide this comprehensive profiling functionality.

Community Discussion

No comments yet. Be the first to start the discussion!