1. Power BI Flashcards

PL-900 questions on Power BI

1
Q

You edit a Power BI report.

You need to add a calculated column.

Which two actions should you perform?

A

Open the report using Power BI Desktop.

; Select the Data tab and then select New column.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

You need to identify the capabilities of the Power BI service compared to Power BI Desktop.

Which two features are only available in the Power BI service?

A

Dashboards

; Workspaces

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

A company plans to hold a meeting with investors to discuss customers.

The company needs to present last year’s revenue and customer acquisitions in this meeting.

You need to create a Power BI report.

Would a map visualisation be appropriate?

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

A company plans to hold a meeting with investors to discuss customers.

The company needs to present last year’s revenue and customer acquisitions in this meeting.

You need to create a Power BI report.

Would a line chart be an appropriate visualisation to use?

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

A company plans to hold a meeting with investors to discuss customers.

The company needs to present last year’s revenue and customer acquisitions in this meeting.

You need to create a Power BI report.

Which two visualizations should you use?

A

Map

; Line chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

A company uses Power BI.

You need to aggregate a text field by adding it to a visual in a Power BI report.

Which aggregation should you use?

A

Count

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

You create Power BI reports by using Power BI Desktop.

You need to create a relationship between the two tables in Power BI Desktop.

Which view would you use? (Give both possible answers).

A

Model view and Table view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

You need to create a Power BI dashboard for Power BI mobile apps.

What should you do in order to see how the dashboard would look on a mobile?

A

Click on ‘mobile view’.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

A company uses Power BI.

You need to collaborate with others to build visualizations.

What should you use?

A

Workspace

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

You plan to build a Power BI report for a sales team.

You need to display the sales revenue for the top fifteen product categories.

Which chart type should you use?

A

Bar

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

A company uses Power BI. You create a Power BI report and publish it to the Power BI service.

You need to create a dashboard containing tiles for individual visualizations.

What are two possible ways to achieve this goal?

A

Pin a visualization.

; Use the Q&A question box.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which two components are available in Power BI Destop but not in Power BI Service?

A

Shaping and modeling data

; Calculated columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

You plan to create a Power BI report to display a company’s sales data.

The sales team has prebuilt reports in Power BI that contain sales data.

You need to recommend a solution that allows users to reuse the same dataset to build their own reports and dashboards.

What should you recommend?

A

Share the dataset containing sales data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

You have a table in a Power BI dataset. You add a clustered column chart visual to the report page.

You need to show the count of rows in the table as columns for each category in the table.

Which field well should you add to the row count measure?

A

Y-axis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

You need to create a Power BI visualization that displays month-by-month revenue comparisons for the current and previous years.

Which chart type should you use?

A

Bar

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

A tire manufacturer stores manufacturing data in SQL Server and sales data in Microsoft Dataverse tables.

An operations manager needs to view a single page of information each day that shows the following:

The number of defects in the manufacturing process.

The sales by geographic region from the prior day.

You need to configure Power BI.

Which action should you perform?

A

Create a Power BI Dashboard by using the Power BI service.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

You need to use Power BI to build a report for a sales manager.

The report must meet the following requirements:

A single-entry point to view data.

A way to drill down into data from a single table, named Sales, in your company’s SQL Server database.

One page that shows sales by date and another page that shows sales by region. Each page should allow users to view the raw data from the Sales table as well as view a bar graph representing the information.

Which two actions should you perform?

A

Create a Power BI report tied to the Sales table.

; Create one report with two pages for sales by date and sales by region.

18
Q

A company manufactures car parts. Some parts are defective.

You create a Power BI report to visually represent defect information.

You need to add a single visualization to the report to show the percentage of defects per part.

Which two visualizations should you use?

A

Donut chart

; Column combo chart

19
Q

A company uses GitHub repositories for source code control.

The company plans to create visualizations in Power BI to analyze repository usage including commits and pull requests.

You need to create reports for repository usage.

What should you do?

A

Install a template app in the Power BI service.

20
Q

You create a Power BI report.

You need to share the report with internal users.

Which two actions should you perform?

A

Embed the report in a secure portal.

; Use the Power BI mobile app.

21
Q

You build a Power BI report by using Power BI Desktop. The data is based on a complex set of data that includes multiple data tables that have many-to-one relationships with each other.

You need to visually represent the tables and their relationships so that you can understand the data you are working with before you build the report.

What should you do?

A

Click on the Modeling view and examine the diagram of available tables and their relationships with each other.

22
Q

You create a Power BI report to display information about product sales using Power BI Desktop. You have two Excel spreadsheets named Data1.xlsx and Data2.xlsx.

Data1.xlsx has a table called Table 1. Table 1 has two columns of information:

Product name

Units sold

Data2.xlsx has a table called Table 2. Table 2 has two columns of information:

Toy name

Number sold

You need to combine the data into a single dataset that can be used in the report by using Power Query Editor. The data set must contain the headers Product name and Units sold.

Which two actions should you take?

A

Rename the columns in Table 2 to Product name and Units sold.

; Append the data from Table 1 to the data in Table 2.

23
Q

A company stores data in different systems: SQL Server, csv file, Excel workbook.

You need to show the data by using Power BI.

Which of the three data sources can Power BI connect to?

A

SQL Server

; CSV file

; Excel workbook

24
Q

You need to install and configure prebuilt Power BI dashboards and reports.

Which two actions should you perform?

A

Find a Power BI template app in the Power BI Apps marketplace and install it.

; Connect the app to the data.

25
Q

What is the correct order of operations that a Power BI user will take to use the service effectively?

A
  1. Get data 2. Create report 3. Create dashboard 4. Create app 5. Share
26
Q

What is the appropriate Power BI Service feature for the following task.
Task
Display data from an Excel workbook with multiple worksheets

A

Report

27
Q

What is the appropriate Power BI Service feature for the following task.
Task
Display top departmental goal metrics and alert users when certain thresholds are crossed

A

Dashboard

28
Q

Name three components of Power BI

A

Power BI Desktop, Power BI Service, Power BI Mobile

29
Q

Where can comments be added in Power BI?

A

Power BI visuals, reports, dashboards; on the Power BI Service or on the mobile app

30
Q

Which of the following is NOT a valid Power BI Aggregate function? Count, Median, Rank

A

Rank

31
Q

Name 5 Power BI Aggregate functions

A

Count, Count (distinct), Sum, Average, Median

32
Q

Name four capabilities that are available on Power BI Mobile

A

View a Power BI Report
View a Power BI Dashboard
Comment on a Power BI visualisation
Review other users’ comments on a Power BI visualisation

33
Q

You are analysing data from multiple different data sources in Power BI. You want to combine data in order to create a unified visualisation. What Power BI component would you use to accomplish your task?

A

Query Editor

34
Q

You create and publish a report in Power BI. The report connects to several databases in your organisation. You share the report with some colleagues in your organisation. What permissions will be needed regarding the security of the data?

A

You will need read permissions to the data; Your colleagues will not need any permissions to the data

35
Q

A manufacturing company uses Internet of Things (IOT) devices to monitor the temperature in different parts of their warehouse.

You need to view near real time information from the IoT devices in Power BI service dashboards.

Which tool should you use?

A

Streaming dataset

36
Q

You need to display sales orders greater than a specific threshold in a Power BI report.

What should you use?

A

Filter

37
Q

You are a sales representative. You create a Power BI report to visualize data from a Microsoft Excel workbook.

Users need to be able to view and share the report

Which 2 actions should you perform?

A

Pin the report to a dashboard; Share the dashboard

38
Q

Select the appropriate Power BI component for the task: “Create a report”

A

Power BI Desktop & Power BI Service

39
Q

Select the appropriate Power BI component for the task at hand: “Configure sharing”

A

Power BI Service

40
Q

Select the appropriate Power BI component for the task at hand: “Create calculated columns”

A

Power BI Desktop