ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 1 question 15 discussion

Actual exam question from Microsoft's PL-300
Question #: 15
Topic #: 1
[All PL-300 Questions]

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 Hide Answer
Suggested Answer:
by emmanuelkech at Sept. 6, 2022, 11:53 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
emmanuelkech
Highly Voted 2 years, 7 months ago
I think the correct flow is Get data then select folder Remove content Colum Expand Attribute Colum
upvoted 243 times
33148b2
2 months, 3 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 1 times
...
Pitxunet
2 months, 3 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, 7 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
4 months ago
pnb11 is wrong, Emmanuelkech is right We want the metadata which is the "attributes column", not the data aka "content"
upvoted 2 times
...
moleskin
6 months, 2 weeks ago
emmanuelkech has the right answer here, content column is not required, so it should be removed. Attritbutes column is to be expanded.
upvoted 3 times
...
Hoeishetmogelijk
2 years, 4 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...
...
GabryPL
2 years, 3 months ago
what about: 1) get data from folder 2) expand attribute 3) remove content column why should this order be wrong?
upvoted 26 times
5767542
3 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 4 times
...
HN_3532
2 years, 2 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, 2 months ago
What do u mean with vertical filtering?
upvoted 1 times
itenginerd
1 year, 7 months ago
Horizontal filtering = removing rows we don't want. Vertical filtering = removing columns we don't want.
upvoted 5 times
...
...
...
...
Load full discussion...
...
Guru1337
Highly Voted 2 years, 7 months ago
It should be remove Content not combine, since the file data is NOT to be stored.
upvoted 52 times
GPerez73
2 years, 7 months ago
I agree
upvoted 7 times
...
Churato
2 years, 6 months ago
Tested here and it works. Thankyou!
upvoted 3 times
...
...
BhavnishM
Most Recent 3 weeks, 2 days 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 1 times
...
Fatima300
2 months, 3 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
5 months, 1 week 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
6 months, 2 weeks 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
6 months, 3 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
7 months ago
Get data then select folder Remove content Colum Expand Attribute Colum
upvoted 1 times
...
rcaliandro
8 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
8 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
9 months 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, 2 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, 2 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, 2 months ago
Tricky and Interesting
upvoted 1 times
...
nattomi
1 year, 2 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, 1 month ago
Thank you!
upvoted 2 times
Inesd
10 months, 3 weeks ago
Totally agree
upvoted 1 times
...
...
...
JohnChung
1 year, 3 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, 5 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...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago