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:
Step 1: From Power BI Desktop, Select Get Data, and then Select Folder.
Open Power BI Desktop and then select Get Data\Moreג€¦ and choose Folder from the All options on the left.

Enter the folder path, select OK, and then select Transform data to see the folder's files in Power Query Editor.
Step 2: From Power Query Editor, expand the Attributes column.
Step 3: From Power Query Editor, combine the Content column.


Combine files behavior -
To combine binary files in Power Query Editor, select Content (the first column label) and select Home > Combine Files. Or you can just select the Combine Files icon next to Content.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-combine-binaries
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, 3 months ago
I think the correct flow is Get data then select folder Remove content Colum Expand Attribute Colum
upvoted 232 times
pnb11
2 years, 3 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 37 times
BIFakeGuru
1 week, 4 days ago
pnb11 is wrong, Emmanuelkech is right We want the metadata which is the "attributes column", not the data aka "content"
upvoted 1 times
...
moleskin
2 months, 3 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, 1 month 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 ago
what about: 1) get data from folder 2) expand attribute 3) remove content column why should this order be wrong?
upvoted 23 times
5767542
5 days, 18 hours 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 1 times
...
HN_3532
1 year, 11 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
1 year, 10 months ago
What do u mean with vertical filtering?
upvoted 1 times
itenginerd
1 year, 3 months ago
Horizontal filtering = removing rows we don't want. Vertical filtering = removing columns we don't want.
upvoted 5 times
...
...
...
...
fellipeao
1 year, 8 months ago
I have tested and works. Some ppl said to "combine attribute", but its not possible.The options is not avaliable.
upvoted 4 times
...
NevilleV
2 years, 2 months ago
I agree that this is the requirement. The thing that bothers me is WHY? Why would you want to create a dataset with only the metadata?
upvoted 7 times
cnmc
2 years ago
audit purpose. Not everything is about the business results, for big corps you'd care about how it's run too
upvoted 12 times
...
...
...
Guru1337
Highly Voted 2 years, 3 months ago
It should be remove Content not combine, since the file data is NOT to be stored.
upvoted 52 times
GPerez73
2 years, 3 months ago
I agree
upvoted 7 times
...
Churato
2 years, 2 months ago
Tested here and it works. Thankyou!
upvoted 3 times
...
...
jaume
Most Recent 1 month, 2 weeks 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
2 months, 3 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
3 months 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
3 months, 1 week ago
Get data then select folder Remove content Colum Expand Attribute Colum
upvoted 1 times
...
rcaliandro
4 months, 2 weeks 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
5 months 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
5 months, 1 week 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
10 months, 2 weeks 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
10 months, 2 weeks 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
10 months, 3 weeks ago
Tricky and Interesting
upvoted 1 times
...
nattomi
11 months ago
Its explained here which makes sense Get data then select folder Remove content Colum Expand Attribute Colum
upvoted 20 times
JudT
9 months, 2 weeks ago
Thank you!
upvoted 2 times
Inesd
6 months, 4 weeks ago
Totally agree
upvoted 1 times
...
...
...
JohnChung
11 months, 3 weeks 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, 1 month 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
...
TigerTienie
1 year, 3 months ago
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
upvoted 4 times
...
Fisher
1 year, 3 months ago
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.
upvoted 3 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