The query uses a custom function to load file data. Select Yes if the statement is true. Otherwise, select No.

The correct answer is A. Yes. Based on the correct answer, the query utilizes a custom function, likely to standardize and repeatedly apply a data loading transformation across multiple files or sources.

Query and transform data

Question

The query uses a custom function to load file data. Select Yes if the statement is true. Otherwise, select No.

Options

AYes
BNo

How the community answered

(28 responses)

A
89% (25)
B
11% (3)

Why each option

Based on the correct answer, the query utilizes a custom function, likely to standardize and repeatedly apply a data loading transformation across multiple files or sources.

AYesCorrect

Power Query allows users to define custom functions to encapsulate reusable logic, implying such a function has been created and invoked to handle the file loading process, possibly for multiple files.

BNo

Without a custom function, file data would be loaded directly using built-in Power Query functions or source connectors without abstracting the loading logic.

Concept tested: Power Query M custom functions

Source: https://learn.microsoft.com/en-us/power-query/custom-functions

Topics

#Power Query#Custom Functions#Data Transformation#Loading File Data

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice