Exam DP-500 topic 1 question 89 discussion

B) Creating a PBIDS file is the best option to provide users with a reproducible method to connect to a data source and transform the data by using an AI function while minimizing development effort and avoiding including data and visualization in the file.

PBIT, because "Avoid including data in the file."

avoid keeping data in the FILE !!!! > so A PBIT since PBIX and PBIDS keep data in file

https://www.youtube.com/watch?v=GJoxzfIQo6o a) wiht template we reduce development effort

Option A Remember, a PBIT (Power BI Template) file can include source connection details and report layout, and can be used to provide users with a reproducible method to connect to a data source and transform the data by using an AI function. A PBIT file is similar to a PBIX file, but it does not include any data. It contains the report layout, data source connection details, and other settings required to create a report. By using a PBIT file, you can provide users with a pre-built report template that they can use to connect to a data source and generate a report. Therefore, both A (PBIT) and B (PBIDS) could be correct answers depending on the exact requirements of the solution. If the solution requires providing a pre-built report template that includes source connection details and report layout, then A (PBIT) would be the correct answer. If the solution only requires providing a data source connection that can be reused across multiple reports or models, then B (PBIDS) would be the correct answer.

As per previous comments, since you need to include AI functions, a PBIDS (which is only a link to the datasource) isn't enough and PBIX includes the data so PBIT is the correct answer.

The "Working with Power BI and PBIDS" section of this link: https://www.mssqltips.com/sqlservertip/6444/power-bi-data-source-pbids-files/ clearly shows that users working with PBIDS get direct access to the data itself. This contradicts the second requisite in the question so it has to be PBIT (in case you weren't convinced so far).

PBIT is correct answer because we are transforming data with an AI function in addition to connecting data source. PBIT are used to store: queries, parameters, data models (schemas, relationships between tables, measures, etc.), report pages, visualizations and other report elements. If you want to save only the link to the data source you will create a PBIDS file. Source: https://excelk.com/en/pbit-and-pbids-files/

The answer should be: B. PBIDS PBIDS files are templates of a connection to data: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources#using-pbids-files-to-get-data

Answer Is B, maek a connection to a data source