nerdexam
Microsoft

DP-500 · Question #14

You need to provide users with a reproducible method to connect to a data source and transform the data by using an AI function. The solution must meet the following requirement: Minimize…

The correct answer is C. PBIT. To provide a reusable template for connecting, transforming data with an AI function, and minimizing development effort without including actual data, a Power BI template (PBIT) file should be created.

Query and transform data

Question

You need to provide users with a reproducible method to connect to a data source and transform the data by using an AI function. The solution must meet the following requirement:
  • Minimize development effort.
  • Avoid including data in the file. Which type of file should you create?

Options

  • APBIDS
  • BPBIX
  • CPBIT

How the community answered

(48 responses)
  • A
    6% (3)
  • B
    10% (5)
  • C
    83% (40)

Why each option

To provide a reusable template for connecting, transforming data with an AI function, and minimizing development effort without including actual data, a Power BI template (PBIT) file should be created.

APBIDS

A PBIDS (Power BI Data Source) file stores only the data source connection information, not the transformations or report definitions.

BPBIX

A PBIX (Power BI Desktop) file contains both the report definition and the actual imported data, which violates the requirement to avoid including data in the file.

CPBITCorrect

A PBIT (Power BI Template) file saves the dataset schema, data source connection information, data transformations (including AI functions), and report definitions, but crucially, it does not save the actual data, making it a reusable blueprint for new reports while minimizing development effort and avoiding data inclusion.

Concept tested: Power BI file types - PBIT

Source: https://learn.microsoft.com/en-us/power-bi/create-reports/service-template-apps-create-template-app

Topics

#Power BI Templates#Data Source Connections#Data Transformation#Power Query

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice