Exam PL-300 topic 1 question 15 discussion

I think the correct flow is Get data then select folder Remove content Colum Expand Attribute Colum

It should be remove Content not combine, since the file data is NOT to be stored.

Everybody agree on the first step to "Get data and select folder". Since "not storing data of the csv filed" is a requisite, second step should be "...remove the content column". Finally, as another requisite is to "...make the file metadata available" we shoud expand the "Attributes" column where these details are hosted

I don't see why we combine the content column if it should not be stored. It should be removed surely

how are is this type of question graded? does the order have to be correct to get the whole points or is it graded per correct selection?

Get data then select folder Remove content Colum Expand Attribute Colum

Not sure about that but in my opinion it is: A - From Power BI Desktop, select Get Data and then select Folder B - From Power Query Editor, expand the Attributes column C - From Power Query Editor, remove the Content column

answer: From Power BI Desktop, select Get Data, and then select Folder. From Power Query Editor, remove the Content column. From Power Query Editor, expand the Attributes column.

The question mentioned do NOT store data of csv files. This means we have to remove Attributes. So the correct order is: 1. Get data, select folder 2. Remove Attribute 3. Combine Content

the solution would be: 1- Get Data from Folder 2- Expand (Priority) the Attributes Column 3- Combine the Content Column

I have the feeling this question is a voluntary trap of Microsoft :-) When you test the conflictual solutions in PBI Desktop you will see that combining content will add a bunch of crap in your semantic model..including the data that we are forbidden to store, it's common sense. It is written in the question itself, metadata only and as metadata is also included in Attributes, you need to expand attributes to get the entire metadata context.

Tricky and Interesting

Its explained here which makes sense Get data then select folder Remove content Colum Expand Attribute Colum

I go with below instead of Combine the Content column for 3) 1) get data from folder 2) expand attribute 3) remove content column Combine Content column will have all data of the csv files

the correct sequence of actions is: From Power BI Desktop, select Get Data, and then select Folder -> From Power Query Editor, remove the Content column -> From Power Query Editor, remove the Attributes column since attributes column contains extra info about files we should remove that and only keep clean meta data.

Only meta data must be shown and NO data must be stored. Try this out practical, following steps work. 1) Get Data from folder 2) Expand Attribute columns 3) Remove Content column

expand the attributes. Expanding the attributes means that you create columns in your dataset to capture the metadata about each file, such as file names, file paths, file sizes, and other relevant attributes. This approach keeps the metadata in your dataset without storing the actual data from the CSV files. By expanding the attributes, you ensure that you have the necessary information to work with the file metadata in your Power BI reports and visualizations while adhering to the requirement of not storing the CSV file data within your Power BI dataset.