Exam DP-600 topic 1 question 17 discussion

A - often the Microsoft learn pages give you the exact answer: Under tips on the link I posted: In some cases, you might not want automatic grouping to occur, or you might want all rows to appear, including duplicates. In those cases, you can add an index field to your dataset that causes all rows to be considered unique and prevents grouping. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals There are always multiple approaches in application but if you do the MS exam give the MS answer.

The right answer is D: By setting the "Summarize By" property to "None" for all columns, you disable automatic aggregation and ensure all rows, including duplicates, are displayed in the Python visual.

Add a unique field to each row.

Modify the Summarize By property for all columns: By default, Power BI may summarize data in visuals, which can lead to grouping and aggregation of rows. Modifying the "Summarize By" property for all columns to "Do Not Summarize" will prevent this automatic grouping and ensure that all rows, including duplicates, are displayed in the visual.

I think it's C. Add a unique field to each row.

Add a unique field to each row

A Quoted from https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals: "In some cases, you might not want automatic grouping to occur, or you might want all rows to appear, including duplicates. In those cases, you can add an index field to your dataset that causes all rows to be considered unique and prevents grouping."

"In some cases, you might not want automatic grouping to occur, or you might want all rows to appear, including duplicates. In those cases, you can add an index field to your dataset that causes all rows to be considered unique and prevents grouping." I was leaning towards A because of the word 'index', and usually if a specific term is mentioned, Microsoft wants to hear you use that term. But option A talks about REFERENCING the index in the CODE. The quote above is not about how you write your code (like cgroven mentioned, e.g. df["streetName"] vs. df[1] for example), but it is about how you should modify your data structure and visual to handle the results. If you read the above statement with this distinction in mind, then it clearly reads C.

D. By setting the "Summarize By" property to "None" for all columns, you disable automatic aggregation and ensure all rows, including duplicates, are displayed in the Python visual.

A: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals In some cases, you might not want automatic grouping to occur, or you might want all rows to appear, including duplicates. In those cases, you can add an index field to your dataset that causes all rows to be considered unique and prevents grouping.

MS ANSWER. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals

As much as C is tempting, let's focus on the wording. "Add a unique field to each row". You simply say, "Add another column for unique id" or something like that. In terms of Microsoft ways of asking, it's A.

Power BI tends to automatically summarize data in visuals, which can cause rows to be grouped and duplicates to be hidden. The "Summarize By" property controls how data is aggregated in a visual. By setting it to "Do Not Summarize," you prevent the automatic grouping of data, ensuring that all rows, including duplicates, are displayed. None of the other options directly address the issue of rows being grouped and duplicates being hidden in a Power BI visual. So, D is the right choice.

It seems not everyone can read and understand documentation. The following Python script is execute EVERY TIME you use a Python visual: dataset = pandas.DataFrame(column1, column2, ...) dataset = dataset.drop_duplicates() So the ONLY way to prevent the duplicates from being dropped is to have a unique identifier. Ergo, option C is the only possible answer here.

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals --- Respostas "A"... da MS... Em alguns casos, talvez você não queira que o agrupamento automático ocorra ou queira que todas as linhas apareçam, inclusive as duplicadas. Nesses casos, você pode adicionar um campo de índice ao seu conjunto de dados que faz com que todas as linhas sejam consideradas exclusivas e evita o agrupamento.

ANSWER IS C: In some cases, you might not want automatic grouping to occur, or you might want all rows to appear, including duplicates. In those cases, you can add an index field to your dataset that causes all rows to be considered unique and prevents grouping. This means you need to add an index field column in which case each row will have a unique index value per row

C- ADIONAR UMA COLUA INDICE