Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 1 question 15 discussion

Actual exam question from Microsoft's PL-300

Question #: 15
Topic #: 1

DRAG DROP -
You have a folder that contains 100 CSV files.
You need to make the file metadata available as a single dataset by using Power BI. The solution must NOT store the data of the CSV files.
Which three actions should you perform in sequence. To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Show Suggested Answer

Suggested Answer:

by emmanuelkech at Sept. 6, 2022, 11:53 a.m.

Comments

Submit Cancel

emmanuelkech

Highly Voted 2 years, 9 months ago

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

upvoted 244 times

GabryPL

2 years, 5 months ago

what about: 1) get data from folder 2) expand attribute 3) remove content column why should this order be wrong?

upvoted 27 times

5767542

5 months, 3 weeks ago

your answer is wrong. It should be in this order Get Data from the folder: This is the first step where you connect to the folder that contains your CSV files. Power BI will recognize all the CSV files in the folder and generate a dataset with both file metadata and content. Remove Content Column: After you load the data from the folder, Power BI typically presents two columns: Content (which contains the actual data of the CSV files) and Attributes (which contains the metadata). In this step, you would remove the Content column to ensure you're only working with the metadata (e.g., file names, paths, creation dates). Expand Attributes: The Attributes column contains a record with metadata for each file. To make the metadata more accessible and usable in your report, you'll need to expand this column. Expanding will break the record down into individual metadata fields (e.g., file name, file path, etc.), so that you can work with these attributes as separate columns in Power Query.

upvoted 5 times

...

HN_3532

2 years, 4 months ago

It's not wrong, but the rule of thumb is "Filter left. Format right.". Removing columns is vertical filtering, so it should be on top.

upvoted 19 times

Nemesizz

2 years, 4 months ago

What do u mean with vertical filtering?

upvoted 1 times

itenginerd

1 year, 9 months ago

Horizontal filtering = removing rows we don't want. Vertical filtering = removing columns we don't want.

upvoted 6 times

...

33148b2

4 months, 2 weeks ago

Am I the only one who thinks that "The solution should NOT store data from CSV files" is trick part in the question?

upvoted 2 times

...

Pitxunet

4 months, 2 weeks ago

But after these three steps, the metadata is not combined in a single dataset as requested, is it?

upvoted 1 times

...

pnb11

2 years, 9 months ago

These are right answer 1.Get data the select folder 2.Remove attribute column (because this column contain information about file which not needed). 3.Combine Content column (which contain actual data which needed for us)

upvoted 39 times

BIFakeGuru

5 months, 4 weeks ago

pnb11 is wrong, Emmanuelkech is right We want the metadata which is the "attributes column", not the data aka "content"

upvoted 3 times

...

moleskin

8 months, 1 week ago

emmanuelkech has the right answer here, content column is not required, so it should be removed. Attritbutes column is to be expanded.

upvoted 4 times

...

Hoeishetmogelijk

2 years, 6 months ago

See the requirement "The solution must NOT store the data of the CSV files." So the content column must be removed.

upvoted 25 times

...

Load full discussion...

...

Load full discussion...

...

Guru1337

Highly Voted 2 years, 9 months ago

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

upvoted 52 times

GPerez73

2 years, 9 months ago

I agree

upvoted 7 times

...

Churato

2 years, 7 months ago

Tested here and it works. Thankyou!

upvoted 3 times

...

BhavnishM

Most Recent 2 months, 2 weeks ago

I just tested this on my end. The correct order is : get the data from the folder in Power query editor expand the attributes column (this fulfils the objective of storing metadata) remove the content columns (this would not store the actual data)

upvoted 2 times

...

Fatima300

4 months, 2 weeks ago

1- Get Data and Select Folder → Loads all file metadata, including Content and Attributes. 2- Expand the Attributes Column → Extracts details like file size, date modified, and type. 3- Remove the Content Column → Deletes the actual CSV data, keeping only metadata. Why This Order? If you remove Content before expanding Attributes, you might lose important metadata.

upvoted 1 times

...

jaume

7 months ago

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

upvoted 1 times

...

JPShields

8 months, 1 week ago

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

upvoted 1 times

...

hassan899

8 months, 2 weeks ago

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?

upvoted 1 times

...

SidneyHod

8 months, 3 weeks ago

Get data then select folder Remove content Colum Expand Attribute Colum

upvoted 1 times

...

rcaliandro

10 months, 1 week ago

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

upvoted 1 times

...

janssen135

10 months, 3 weeks ago

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.

upvoted 3 times

...

AP0409

10 months, 3 weeks ago

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

upvoted 1 times

...

soheil.dabooyeh29

1 year, 3 months ago

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

upvoted 1 times

...

Dani_eL

1 year, 4 months ago

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.

upvoted 1 times

...

KKPanda77

1 year, 4 months ago

Tricky and Interesting

upvoted 1 times

...

nattomi

1 year, 4 months ago

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

upvoted 20 times

JudT

1 year, 2 months ago

Thank you!

upvoted 2 times

Inesd

1 year ago

Totally agree

upvoted 1 times

...

JohnChung

1 year, 5 months ago

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

upvoted 3 times

...

Ditendra

1 year, 7 months ago

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.

upvoted 2 times

...

Load full discussion...