Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Drag & Drop Scenario
Read the scenario requirements and decide your answer. Click Check Answer below to see the marked solution.
Hotspot Solution:
Sequence of Actions - Use Folder as Data Source - Connect to the folder containing your 100 CSV files. - This imports metadata like file name, date modified, and file path—not the contents. - Remove the "Content" Column - The "Content" column contains the actual file binary data. - Removing this ensures the CSV content isn’t loaded or stored in the dataset—keeping the model lightweight. - Expand the Attributes Column - This column holds metadata like file size, creation time, last modified, etc. - Expanding it enriches your dataset with relevant info for analysis without loading the actual file contents.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Get Data from the Power Bi desktop with a folder and then remove the content column from Power Query Editor, and then remove the attributes column from Power Query Editor
✅ Correct Sequence Get Data → Folder Remove the Content column Expand the Attributes column
I tested on my Power BI desktop with a folder path and the following flow also works. Think the last two steps do not have to follow a particular order? 1. Get data then select folder 2. Expand Attribute Column 3. Remove content Column