Microsoft Power BI Data Analyst Professional Certificate (PL-300) : Sample Questions (Part-5)

Part-4

1.

Question 1

Multiple Microsoft Excel files are saved in a folder and synced with Microsoft’s OneDrive for Business. You need to import data from files without using the data gateway. Which type of Power BI data connector should you use?

1 / 1 point

SharePoint folder

Excel workbook

SharePoint list

OneDrive for business

Correct

That’s correct! A SharePoint folder is the only connector that allows you to import multiple Excel files stored in a OneDrive for Business folder without using a data gateway.

2.

Question 2

You are importing your Power BI project data from a SQL Server database. Which Power BI desktop view can you use to change the storage mode of the tables?

1 / 1 point

Page view

Data view

Model view

Report view

Correct

That’s correct! You need to navigate to the Model view of Power BI desktop and use the Properties pane to change the storage mode of tables.

3.

Question 3

You need to decide between DirectQuery mode and Import mode for your dataset’s import mode. What are the benefits of Import storage mode versus DirectQuery storage mode? Select all that apply.

1 / 1 point

Import mode supports Quick insights.

Correct

That’s correct! You can use Quick insights from Power BI service with Import storage mode.

Import mode has minimal need for data refresh.

Import mode supports the Q&A feature.

Correct

That’s correct! Import storage mode is fully supported with the Q&A feature in Power BI service.

Importmode supports per-table configuration.

Import mode minimizes disk space usage.

4.

Question 4

What is the best way to organize related datasets?

0 / 1 point

Use a separate workspace for each dataset.

Use folders to group related datasets.

Use naming conventions to identify datasets.

Use tags to categorize datasets.

Incorrect

Not quite. Please review the reading Managing data sources..

5.

Question 5

How can you ensure data accuracy before analysis?

1 / 1 point

Use data modeling tools

Use data visualization tools

Using data profiling tools

Use data transformation tools

Correct

That’s correct! Data profiling tools are designed to analyze and assess the data quality and help identify any data inconsistencies, errors, and missing data in the datasets.

6.

Question 6

Your data model contains a huge dataset that you want to reduce. Which Power BI interface can you use to reduce the data?

1 / 1 point

Data view of Power BI desktop.

Data modeler.

Advanced editor.

Power query editor.

Correct

That’s correct! In the Power query editor, you can remove unnecessary columns and rows, duplicates, and enact other transformation steps to reduce the size and volume of the dataset before loading it to the Power BI model.

7.

Question 7

You want to merge two queries in the Power query editor where you want to keep the entire data from the first table while only matching rows from the second table. Which type of join should you choose?

1 / 1 point

Right inner join

Left outer join

Right outer join

Left inner join

Correct

That’s correct! Left inner join lets you keep all rows from the first table and only match rows from the second table while using merge queries in the query editor.

8.

Question 8

How can you filter rows in Power BI based on specified conditions during data transformation?

1 / 1 point

Apply the Exclude values transformation.

Use Filter rows and specify the conditions.

Utilize the Sort option.

Apply the remove rows transformation operation.

Correct

That’s correct! In the power query editor, you can use Filter rows and define the conditions to filter rows based on your required conditions.

9.

Question 9

You have accessed the data from a SQL Server as DirectQuery. The dataset contains millions of rows. The objective of the analysis is to group data by year and region. Creating aggregated tables has the capacity to reduce the dataset sourced through DirectQuery. Which Power BI element allows you to create aggregations?

1 / 1 point

Page view of Power BI desktop

Power query editor

Data view of Power BI desktop

Model view of Power BI desktop

Correct

That’s correct! You can create aggregated tables from the DirectQuery sourced datasets from the Power Query editor and group by defined columns.

10.

Question 10

You imported an Excel workbook in Power BI, and during import, you received the following message: "We could not find any data formatted as a table." What should you do to resolve this error?

1 / 1 point

In the Excel workbook, select the data you want to import, create a table, and save the changes.

In Power BI, add an organizational app.

In Power BI, add a template app.

In the Excel workbook, select the data you want to import, select the Data validation button, and save the change.

Correct

That’s correct! The error message indicates the Excel workbook does not contain a table. To create a table in the Excel workbook you can select the data you want to import and press “Ctrl + T or choose the Table button from the Insert ribbon of Excel and save the changes.

11.

Question 11

You have a Power BI report displaying a column chart of monthly sales. In the column chart, the months are displayed alphabetically. Which transformation step should you apply to visualize sales data by month in the correct chronological order?

0 / 1 point

Group by column from the Power BI desktop.

Group by column from the query editor.

Sort by column from the query editor.

Sort by column from the Power BI desktop.

Incorrect

Question 15

You have a Power BI project containing two data tables. The tables are related via many-to-many relationships. How many possible cross-filter directions could exist between the tables?

1 / 1 point

Correct

That’s correct! In many-to-many relationships, there could be three possibilities of cross-filter direction: Single where table a filters table b, Single where table b filters table a, and both.

16.

Question 16

A manufacturing company data model contains a Machine dimension table related to the fact table. The team wants to analyze machine performance based on the installation date and maintenance date. How can you implement the role-playing dimension?

0 / 1 point

Import two separate datasets for maintenance and installation.

Use a single-machine table and create multiple relationships for installation and maintenance.

Use Calculated columns to distinguish between installation and maintenance dates.

Create two separate Machine dimension tables for installation and maintenance.

Incorrect

Not quite. Please review the video Introduction to USERRELATIONSHIP function.

17.

Question 17

You want to create a date table starting from May 31, 2021, and ending one year later. What M code will you use to create this table?

1 / 1 point

=List.Dates(#date(2021,05,31), 365, #duration(0,0,0,1))

=List.Dates(#date(2021,05,31), 1, #duration(1,0,0,0))

=List.Dates(#date(2021,05,31), 365, #duration(1,0,1,0))

=List.Dates(#date(2021,05,31), 365, #duration(1,0,0,0))

Correct

That’s correct! The #date designates the starting date, 365 designates the duration and #duration(1,0,0,0) designates the duration interval in days. Therefore, the formula results in listing days starting on May 31, 2021 and ending 365 days later.

18.

Question 18

In the model view of Power BI desktop, what are the categories to configure column properties?

0 / 1 point

Formatting and Advanced.

General and Advanced.

General, Formatting, and Advanced.

General and Formatting.

Incorrect

Not quite. Please review the activity Configuring the table and column properties.

19.

Question 19

Which Power BI component lets you test the row-level security using different security roles?

1 / 1 point

Power BI mobile app.

Power BI desktop.

Power BI service.

Both Power BI desktop and Service.

Correct

That’s correct! You can test row-level security in both Power BI Service and desktop.

20.

Question 20

You have a Power BI model where you need to decide when to use implicit measures over explicit measures. What is the feature of implicit measures that explicit measures do not have?

0 / 1 point

Implicit measures can be used with Field parameters.

Implicit measures can be used as a drill-through field.

Implicit measures can be used to create Quick measures.

End users can change the aggregation type of implicit measures from the Values well of the visual.

Incorrect

Not quite. Please review the activity Replacing implicit measure.

21.

Question 21

Which of the following elements can you use to develop a quick measure in Power BI desktop? Select all that apply.

0 / 1 point

Conditional columns

DAX

This should not be selected

Not quite. Please review the video Creating quick measures.

Power query M functions

Fields

Calculations

Correct

That’s correct! When you create quick measures in Power BI desktop, you apply calculations that are available as six categories of calculations to be used for quick measures.

22.

Question 22

You have a warehouse Power BI data model that contains a table named Warehouse. The table has a column named Inventory count, which contains the current number of items for each row of a particular product type on a given day.

The model has a DAX measure that calculates the sum of all values in the Inventory count column of the Warehouse table:

Current Inventory =

CALCULATE ( SUM ( 'Warehouse'[Inventory Count] ) )

You must ensure that the Current Inventory returns only the current total number of inventory items, rather than the sum of all inventory items. You also need to make sure the state holidays and weekends should be excluded from the calculation. What additional DAX function should you include in the query?

1 / 1 point

LASTNONBLANK

CALENDARAUTO

LASTDATE

DISTINCTCOUNT

Correct

That’s correct! LASTNONBLANK functions will retrieve data only from the last date from the period where there is a value available eliminating any non-blank rows from the dataset.

23.

Question 23

You have a Power BI model of a marketing company. The data model contains two tables: Socials and Calendar. The Socials table has a column recording website visits and the Calendar table has a Date column.

You want to compute the total number of visits during the last month. Which DAX expression can you use to compute this value?

1 / 1 point

= CALCULATE ( SUM ( Socials[Website Visits] ), PREVIOUSMONTH ( Calendar[Date] ) )

= CALCULATE ( Socials[Website Visits] ), LASTMONTH ( Calendar[Date] )

= CALCULATE ( Socials[Website Visits] ), PREVIOUSMONTH ( Calendar[Date] )

= CALCULATE ( SUM ( Socials[Website Visits] ), LASTMONTH ( Calendar[Date] ) )

Correct

That’s correct! CALCULATE and SUM computes the total number of website visits and PREVIOUSMONTH compares the dates to the previous month.

24.

Question 24

Which of the following DAX functions can be used as filter modification functions within CALCULATE? Select all that apply.

0 / 1 point

FILTER

FILTERS

USERRELATIONSHIP

Correct

That’s correct! This function engages the inactive relationship between the two related tables of the data mode and must be used within the CALCULATE function when defining a DAX measure.

KEEPFILTERS

CROSSFILTER

You didn't select all the correct answers

25.

Question 25

True or False: You have imported a data model to Power BI desktop. You need to create a number of time intelligence calculations using DAX. The data model does not have a dedicated date table. To create the time intelligence measures, the first step is to create a common date table within your data model.

1 / 1 point

True

False

Correct

That’s correct! In Power BI when you import a data model, Power BI has an auto Date/time hierarchy that you can use to compute time intelligence measures to fulfill your analytical needs.

26.

Question 26

You need to create aggregations to improve model performance of a DirectQuery sourced dataset in Power BI. Which Power BI component allows you to create aggregations?

1 / 1 point

Power BI desktop report view

Power BI desktop table view

Power BI desktop model view

Power query editor

Correct

That’s correct! You can only create aggregations in the Power Query editor from a DirectQuery sourced dataset. Remember you need to manage the aggregations after you create them. You can manage aggregations in Power BI desktop model view.

27.

Question 27

You are working on an on-premises SQL Server dataset to develop a real-time analytical solution. In addition to providing real-time analysis, you need to optimize the query performance. What actions should you take to optimize the query performance? Select all that apply.

1 / 1 point

Import the data to Power BI memory.

Query the original data source for all analytical requirements

Create aggregations based on DirectQuerysourced tables.

Correct

That’s correct! Aggregations on the DirectQuerysourced tables improve the performance and efficiency of query.

Reduce the data volume by importing only necessary columns.

Correct

That’s correct! Reducing the data by importing only the columns needed for analysis will reduce the model size thereby improving the query performance.

Connect Power BI via DirectQuery mode.

Correct

That’s correct! Creating DirectQuery connection allows you to access real-time data from SQL Server.

28.

Question 28

You have a Power BI data model with a bunch of complex DAX measures. The report is responding very slowly. You need to optimize the report performance for which you want to know the performance of DAX measures. Which Power BI tool can you use to inspect the performance of DAX calculations?

1 / 1 point

Performance analyzer.

Power BI data Modeler.

Visualizationpane.

Power query profiling tool.

Correct

That’s correct! In the performance analyzer, you can inspect the execution time of each DAX measure which helps you to identify the slow performing measures and optimize them.

29.

Question 29

You are creating a report to visualize sales by salespersons, trending over months. The visual must clearly show how salespersons are performing against each other and have a ranking for each period.

Which visual from Power BI core visualization should you choose?

1 / 1 point

Scatter plot

Clustered bar chart

Ribbon chart

Treemap

Correct

That’s correct! A Ribbon chart places the highest value at the top of the stacked column each month and shows those ranked changed over time, so it’s the best option to fulfill the requirements.

30.

Question 30

You need to create a Power BI report visualizing the sales data of a company so that customers of similar age will be grouped together. Which type of visual should you use from the visualization pane of Power BI desktop?

1 / 1 point

A Scatter plot

A KPI

A Waterfall chart

Card visual

Correct

That’s correct! A Scatter plot is the first step of applying the clustering technique that groups data into clusters.

31.

Question 31

You developed a Table visual in a Power BI report and you want to highlight the valuable information about the profit margin in one of the columns of the table. You are asked to change the background color of the column displaying the red color if the profit margin is below a certain limit. How can you achieve this with minimal developmental efforts?

1 / 1 point

Selectively change the background color from the Theme panel

Format the background color from the Format visual of Power BI desktop

Change the background color with Conditional formatting

Define DAX measures for various colors to display in the Table visual

Correct

That’s correct! In the Conditional formatting window, you can format the background color of the cells conditionally displaying red when the profit margin falls below a certain limit.

32.

Question 32

Which Power BI Map visuals allow you to create a geographical hierarchy in your report page? Select all that apply.

1 / 1 point

Filled map

Correct

That’s correct! You can create a geographical hierarchy by using a Filled map visual from the Power BI Visualizations pane.

Shape maps

Heat maps

Azure maps

Correct

That’s correct! Azure maps also let you create geo-hierarchy for your analytical work in Power BI desktop.

33.

Question 33

When might you choose to use a Paginated report over an interactive report in Power BI?

1 / 1 point

For real-time data analysis.

When you need to print the report in tabular format

When designing for mobile devices.

For ad-hoc queries.

Correct

That’s correct! The major advantage of paginated reports is you can print all the data in a table, no matter how long it is.

34.

Question 34

You are analyzing the sales of your company in a Power BI desktop report. You need to identify the types of data you will be able to use to create Bins that group sales data. Which Data types should you identify? Select all that apply.

1 / 1 point

Text

Boolean

Binary

Date/time

Correct

That’s correct! The date/time data type supports bin-based grouping.

Numeric

Correct

That’s correct! The NumericData type is also used for grouping in Bins.

35.

Question 35

Your task is to edit a Power BI report by adjusting the behavior of report interactions. What type of interaction behavior can you change between visuals? Select all that apply.

1 / 1 point

Filter

Correct

That’s correct! A Filter changes the behavior by showing you the filtered data in the visual.

Drill through

Expand

Highlight

Correct

That’s correct! Highlight is the default interaction between the visual which shows you both unfiltered and filtered values in the visual.

Question 41

You need to create a Histogram in your report that displays ranges of integers in groups. What resource do you need to create the Histogram? Select all that apply.

1 / 1 point

A numerical column

Correct

That’s correct! The group is created against a numerical column using Bins.

A Date/time column

A Bin group type

Correct

That’s correct! The Bin group type is an auto-grouping of items into Bins (groups). It will display well as a Histogram.

A List group type

42.

Question 42

AI visuals are Power BI components designed to provide advanced analytics and insights by leveraging machine learning models and techniques. You are a sales manager of the company and want to analyze the revenue by region, category, and sales channel. Which of the following AI visuals is used to break down a specific value (revenue in this case) into its components?

1 / 1 point

Decomposition tree

Q&A visual

Waterfall chart

Key influencer visual

Correct

That’s correct! With the Decomposition tree, AI visual of Power BI, you can break down a single value into its components like Sales revenue into regions, categories, and sales channels which can reveal the strengths and weaknesses of your business operation.

43.

Question 43

You manage a Power BI workspace. You need to delegate the task to update workspace metadata. The solution must use the principle of least privilege. Which role should you use?

0 / 1 point

Admin

Member

Contributor

Viewer

Incorrect

Not quite. Please review the video Workspaces and workspace roles.

44.

Question 44

Which of the following features are not supported in Power BI dashboards? Select all that apply.

0 / 1 point

Setup of data Alerts

This should not be selected

Not quite. Please review the video What is a dashboard?

Creation of multiple pages

Natural language queries

This should not be selected

Not quite. Please review the video What is a dashboard?

Use of slicers and filters

45.

Question 45

True or False: You have a Power BI dashboard where you added a Custom tile. The Tile is taking data from a Live-streaming dataset. Power BI does not allow you to set and manage Alerts on the live-streaming dataset dashboard tiles.

1 / 1 point

True

False

Correct

That’s correct! You cannot set Alerts in streaming tiles of your dashboard that are created by adding a custom streaming tile.

46.

Question 46

True or False: Only Power BI administrators can promote content in Power BI service.

1 / 1 point

True

False

Correct

That’s correct! Any content owner or user with the Write permission can promote the content in Power BI Service.

47.

Question 47

What is the primary advantage of deployment pipelines in Power BI?

1 / 1 point

Semantic model (dataset) creation is streamlined.

Reports can be published from multiple workspace environments.

Less manual work and fewer errors.

Enhanced user access to BI report source data.

Correct

That’s correct! Implementation of deployment pipelines reduces manual work and errors.

48.

Question 48

You are setting a data gateway for your organization, and you need to decide between a personal and enterprise gateway. What factors influence your decision?

0 / 1 point

The physical location of the data centers

The number of users and the need for centralized management

The type of data sources, for example, SQL and SharePoint

Both gateways provide the same features

Incorrect

Not quite. Please review the video Data gateways.

49.

Question 49

You have applied changes in the data source structure including renaming, remove, and add columns.

True or False: The refresh can only be applied to Power BI desktop.

1 / 1 point

True

False

Correct

That’s correct! If you delete, add, or rename a column in the table structure of schema, the changes only can be applied to Power BI desktop upon data refresh.

50.

Question 50

Which of the following security groups cannot add to row-level security in Power BI?

0 / 1 point

Mail-enabled group

Azure Active Directory Security Group

Distribution group

Microsoft 365 Group

Incorrect

Not quite. Please review the video Row level security.

Microsoft Power BI Data Analyst Professional Certificate (PL-300) : Sample Questions (Part-5)

1.

2.

3.

4.

5.

6.

7.

8.

9.

10.

11.

12.

13.

14.

15.

16.

17.

18.

19.

20.

21.

22.

23.

24.

25.

26.

27.

28.

29.

30.

31.

32.

33.

34.

35.

36.

37.

38.

39.

40.

41.

42.

43.

44.

45.

46.

47.

48.

49.

50.

0 comments: