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.

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.

First step: From Power BI desktop, select get data, and then select folder. This is the first step to access the files within the folder. Second Step: From Power Query Editor, expand the attributes column. This step is necessary to access the file metadata. Third Step: From Power BI Query Editor, remove the content column. This step is crucial to exclude the actual file data and keep only the metadata. Are the correct steps. Others will not work because of the following reasons : Removing the "attributes" column would prevent us from accessing the file metadata. Selecting "text/csv" from the "Get Data" menu would be necessary if we want to import the data from the CSV files themeselves, but our requirement is to extract metadata only, so this step in not needed. Combining the "Content" column is not necessary because we want to remove it to avoid storing the data, not combine it.