nerdexam
Microsoft

PL-100 · Question #318

Drag and Drop Question A commercial bakery uses an inventory system to track ingredients consumed in their production line. The workers use iPads to interact with the system and reserve the…

The correct answer is Install Power BI Desktop and log in.; Use the Power BI service.; Select manual data.; Paste the data.; Select Use first row as headers. To create a Power BI report from a CSV on an iPad, one must log into the Power BI service, select to create a new report, choose to enter data manually, paste the CSV content, and then designate the first row as headers.

Analyze and visualize data

Question

Drag and Drop Question A commercial bakery uses an inventory system to track ingredients consumed in their production line. The workers use iPads to interact with the system and reserve the ingredients for the next batch. Data from the system is extracted as a .csv file. You need to create a Power BI report from the extracted data by using only an iPad. Which five 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. Answer:

Exhibit

PL-100 question #318 exhibit

Answer Area

Drag items

Select manual data.Power Create.Paste the data.Install Power BI Desktop and log in.Use the Power BI service.Select Use first row as headers.

Correct arrangement

  • Install Power BI Desktop and log in.
  • Use the Power BI service.
  • Select manual data.
  • Paste the data.
  • Select Use first row as headers.

Explanation

To create a Power BI report from a CSV on an iPad, one must log into the Power BI service, select to create a new report, choose to enter data manually, paste the CSV content, and then designate the first row as headers.

Approach. The core constraint in the question is to perform the actions 'using only an iPad.' This immediately rules out any actions requiring Power BI Desktop, as it is a Windows-only application. Therefore, the solution must leverage the Power BI service (web-based) accessible via a browser on the iPad. The correct sequence of actions for entering data manually into the Power BI service is:

  1. Log into the Power BI service. - This is the foundational step to access the Power BI web portal from any device.
  2. Select Create. - After logging in, this option is used to initiate the creation of new content, such as a report or dataset.
  3. Select manual data. - For a .csv file where data needs to be brought into a new dataset, 'manual data' (often labeled 'Enter Data') allows pasting content directly into a table editor within the Power BI service.
  4. Paste the data. - Once the manual data entry interface is open, the content from the .csv file would be copied and pasted into the provided grid.
  5. Select Use first row as headers. - When pasting tabular data, especially from a CSV, it's critical to identify whether the first row contains the column names to ensure data is correctly interpreted and modeled. This option is typically presented during the data entry process.

Common mistakes.

  • common_mistake. A common mistake would be to include the action 'Install Power BI Desktop and log in.' This choice is incorrect because Power BI Desktop is a Windows application and cannot be installed or run on an iPad, directly violating the 'only an iPad' constraint. Any solution involving Power BI Desktop would be inappropriate for this scenario.

Concept tested. The question tests the understanding of the distinct capabilities and access methods for Power BI Desktop versus Power BI Service, specifically how to ingest data (manual data entry/pasting CSV content) and initiate report creation within the Power BI web interface, especially when constrained to a mobile device like an iPad.

Topics

#Power BI Mobile#Data Import#Power BI Service#Report Creation

Community Discussion

No community discussion yet for this question.

Full PL-100 Practice