Microsoft PL-300 Power BI

Question 1

Which data role enables advanced analytics capabilities specifically through reports and visualizations?

A. Data scientist
B. Data engineer
C. Data analyst

Answer 1

C. Data analyst

A data analyst uses appropriate visuals to help business decision makers gain deep and meaningful insights from data.

Question 2

Which data analyst task has a critical performance impact on reporting and data analysis?

A. Model
B. Analyze
C. Visualize

Answer 2

A. Model

An optimized and tuned semantic model performs better and provides a better data analysis experience.

Question 3

Which one of the following options is the most important key benefit of data analysis?

A. Decisive analytics
B. Informed business decisions
C. Complex reports

Answer 3

B. Informed business decisions

A key benefit of data analysis is the ability to gain valuable insights from a business’s data assets to make timely and optimal business decisions.

Question 4

What is the common flow of activity in Power BI?

A. Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop.
B. Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile.
C. Bring data into Power BI mobile, create a report, then share it to Power BI Desktop.

Answer 4

B. Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile.

The Power BI service lets you view and interact with reports and dashboards, but doesn’t let you shape data.

Question 5

Which of the following are building blocks of Power BI?

A. Tiles, dashboards, databases, mobile devices.
B. Visualizations, semantic models, reports, dashboards, tiles.
C. Visual Studio, C#, and JSON files.

Answer 5

B. Visualizations, semantic models, reports, dashboards, tiles.

Question 6

What is a collection of reports and dashboards called in Power BI?

A. The canvas.
B. Scheduled refresh.
C. An app.

Answer 6

C. An app.

An app is a collection of ready-made visuals, pre-arranged in dashboards and reports. You can get apps that connect to many online services from the AppSource.

Question 7

When connecting to a SQL Server database to get data, what language should you use to extract data?

A. DAX
B. T-SQL
C. MDX

Answer 7

B. T-SQL

T-SQL is the query language that you would use for SQL Server.

Question 8

You’re creating a Power BI report with data from an Azure Analysis Services MDX Cube. When the data refreshes in the cube, you would like to see it immediately in the Power BI report. How should you connect?

A. Import
B. T-SQL
C. Live connection

Answer 8

C. Live connection

This will reflect cube changes immediately.

Question 9

What can you do to improve performance when you’re getting data in Power BI?

A. Remove unnecessary columns and rows
B. Export database files to CSV to load
C. Combine date and time columns into a single column

Answer 9

A. Remove unnecessary columns and rows

Always use the least amount of data needed for your project.

Question 10

What is a risk of having null values in a numeric column?

A. That function SUM of data are incorrect.
B. That function MAX of data will be incorrect.
C. That function AVERAGE of data will be incorrect.

Answer 10

C. That function AVERAGE of data will be incorrect.

AVERAGE takes the total and divides by the number of non-null values. If NULL is synonymous with zero in the data, the average will be different from the accurate average.

Question 11

If you have two queries that have different data but the same column headers, and you want to combine both tables into one query with all the combined rows, which operation should you perform?

A. Append
B. Merge
C. Combine Column

Answer 11

A. Append

Append will take two tables and combine it into one query. The combined query will have more rows while keeping the same number of columns.

Question 12

Which of the following selections aren’t best practices for naming conventions in Power BI?

A. Rename columns to have spaces in them.
B. Abbreviate column names.
C. Replace values that have integers with human readable results.

Answer 12

B. Abbreviate column names.

Abbreviations lead to confusion because they’re often overused or not universally agreed on.

Question 13

What does data granularity mean?

A. The amount of data that you have, meaning that higher granularity means more data to work with.
B. The level of detail in your data, meaning that higher granularity means more detailed data.
C. Data granularity is a type of schema design.

Answer 13

B. The level of detail in your data, meaning that higher granularity means more detailed data.

Data granularity refers to how finely or coarsely your data is divided or aggregated.

Question 14

What is the difference between a fact table and a dimension table?

A. Fact tables contain observational data while dimension tables contain information about specific entities within the data.
B. Fact tables contain information about specific entities while dimension tables contain information about observational data.
C. There is no difference.

Answer 14

A. Fact tables contain observational data while dimension tables contain information about specific entities within the data.

Fact tables contain observational data such as sales orders, employees, shipping dates, and so on, while dimension tables contain information about specific entities such as product IDs and dates.

Question 15

Choose the best answer to explain relationship cardinality?

A. Cardinality is the measure of unique values in a table.
B. Cardinality is the granularity of the data.
C. Cardinality is how long it takes for the data to load.

Answer 15

A. Cardinality is the measure of unique values in a table.

An example of high cardinality would be a Sales table as it has a high number of unique values.

Question 16

What benefit do you get from analyzing the metadata?

A. The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your semantic model.
B. The benefit of analyzing the metadata is to get familiar with your data.
C. The benefit of analyzing the metadata is to know the number of rows, columns and tables being loaded into your model.

Answer 16

A. The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your semantic model.

Question 17

What can be achieved by removing unnecessary rows and columns?

A. It is not necessary to delete unnecessary rows and columns and it is a good practice to keep all metadata intact.
B. Deleting unnecessary rows and columns will reduce a semantic model size and it’s good practice to load only necessary data into your semantic model.
C. Deleting unnecessary rows and columns can damage the structure of the semantic model.

Answer 17

B. Deleting unnecessary rows and columns will reduce a semantic model size and it’s good practice to load only necessary data into your semantic model.

Question 18

Which of the following statements about relationships in Power BI Desktop is true?

A. Relationships can only be created between columns that contain the same data type.
B. Relationships can only be created between tables that contain the same number of rows.
C. Relationships can be created between tables that contain different types of data.

Answer 18

C. Relationships can be created between tables that contain different types of data.

A working relationship can be created as long as there is at least one common column between them.

Question 19

In a Power BI Desktop model design, which type of object do you create to connect multiple tables?

A. Relationship
B. Column
C. Measure

Answer 19

A. Relationship

A relationship connects two tables together to allow filtering and further analysis.

Question 20

Which of the following statements is correct regarding a star schema design?

A. Fact tables store accumulations of business events.
B. Fact tables store accumulations of business entities.
C. Fact tables must have a unique column.

Answer 20

A. Fact tables store accumulations of business events.

Fact tables store accumulations of business events, like sales orders or currency exchange rates.

Question 21

In what order does an analytic query implement its phases?

A. Filter, Group, Summarize
B. Group, Filter, Summarize
C. Summarize, Filter, Group

Answer 21

A. Filter, Group, Summarize

Filter is used to first restrict the data to query. Group then divides the query result into groups. Summarize then produces single value aggregations for each group.

Question 22

You’re using Power BI Desktop to develop a model. It has a table named Sales, which includes a column named CustomerKey. In reports, you need a calculation to show the number of different customers who have placed orders. What type of DAX calculation will you add to the model?

A. Calculated table
B. Calculated column
C. Computed column
D. Measure

Answer 22

D. Measure

You can add a measure to the Sales table by using the DISTINCTCOUNT DAX function.

Question 23

You’re using Power BI Desktop to develop a model. It has a table named Customer, which includes a column named DateOfBirth. In reports, you need to group customers by current age. What type of DAX calculation will you add to the Customer table?

A. Calculated table
B. Calculated column
C. Computed column
D. Measure

Answer 23

B. Calculated column

A calculated column can store the current age for each customer. This column could then be used in reports to group customers by age.

Question 24

You’re using Power BI Desktop to develop a model. It has a table named Geography, which has two relationships to the Sales table. One relationship filters by customer region and the other filters by sales region. You need to create a role-playing dimension so that both filters are possible. What type of DAX calculation will you add to the model?

A. Calculated table
B. Calculated column
C. Computed column
D. Measure

Answer 24

A. Calculated table

A calculated table could create a table that duplicates the Geography table data. It could then have an active relationship to the Sales table. Both geography tables would have active relationships to allow report users to filter by customer region or sales region.

Question 25

You write a DAX formula that adds BLANK to the number 20. What will be the result?
A. The result will be zero (0).
B. The result will be 20.
C. The result will be BLANK.
D. The result will be NULL.

Answer 25

B. The result will be 20.

BLANK is converted to zero when added to a number.

Question 26

Which statement about calculated tables is true?

A. Calculated tables increase the size of the semantic model.
B. Calculated tables are evaluated by using row context.
C. Calculated tables are created in Power Query.
D. Calculated tables cannot include calculated columns.

Answer 26

A. Calculated tables increase the size of the semantic model.

Question 27

Which statement about calculated columns is true?

A. Calculated columns are created in the Power Query Editor window.
B. Calculated column formulas are evaluated by using row context.
C. Calculated column formulas can only reference columns from within their table.
D. Calculated columns can’t be related to non-calculated columns.

Answer 27

B. Calculated column formulas are evaluated by using row context.

Question 28

You’re developing a Power BI desktop model that sources data from an Excel workbook. The workbook has an employee table that stores one row for each employee. Each row has a reference to the employee’s manager, which is also a row in the employee table. You need to add several columns to the Employee table in your model to analyze payroll data within the organization hierarchy (like, executive level, manager level, and so on). Which technique will you use to add the columns?

A. Add persisted columns to a table by using T-SQL.
B. Add column expressions in a view by using T-SQL.
C. Add computed columns by using M.
D. Add calculated columns by using DAX.

Answer 28

D. Add calculated columns by using DAX.

You can use the DAX parent-child functions to naturalize the recursive (employee-manager) relationship into columns.

Question 29

Which statement about measures is correct?

A. Measures store values in the semantic model.
B. Measures must be added to the semantic model to achieve summarization.
C. Measures can reference columns directly.
D. Measures can reference other measures directly.

Answer 29

D. Measures can reference other measures directly.

Measures can reference other measures. It’s known as a compound measure.

Question 30

Which DAX function can summarize a table?

A. SUM
B. AVERAGE
C. COUNTROWS
D. DISTINCTCOUNT

Answer 30

C. COUNTROWS

The COUNTROWS function summarizes a table by returning the number of rows.

Question 31

Which of the following statements describing similarity of measures and calculated columns in an Import model is true?

A. They can achieve summarization of model data.
B. They store values in the semantic model.
C. They’re evaluated during data refresh.
D. They can be created by using quick calculations.

Answer 31

A. They can achieve summarization of model data.

A calculated column can be summarized (implicit measure) and a measure always achieves summarization.

Question 32

An iterator function always includes at least two arguments. What are they?

A. Column and expression
B. Table and expression
C. Measure and expression

Answer 32

B. Table and expression

An iterator function iterates over a table and evaluates an expression for each row of the table.

Question 33

Which statement about DAX iterator functions is true?

A. When used to add values of the same column, the SUMX function performs better than the SUM function.
B. Iterator functions iterate over tables and evaluate an expression for each table row.
C. Iterator functions iterate over expressions and evaluate tables for each row.

Answer 33

B. Iterator functions iterate over tables and evaluate an expression for each table row.

Question 34

You’re developing a Power BI Desktop model. You need to create a measure formula by using the RANKX DAX function to rank students by their test results. The lowest rank should be assigned to the highest test result. Also, if multiple students achieve the same rank, the next student rank should follow on from the tied rank number. Which order and ties arguments should you pass to the RANKX function?

A. Order Ascending | Ties Skip
B. Order Ascending | Ties Dense
C. Order Descending | Ties Dense

Answer 34

C. Order Descending | Ties Dense

The highest test result should be assigned the lowest rank. Therefore, the order argument must be Descending. Because no missing rank numbers should exist, the ties argument must be Dense.

Question 35

Which type of model object is evaluated within a filter context?

A. Calculated column
B. Calculated table
C. Measure
D. Security role rule

Answer 35

C. Measure

Measures (or measure expressions) are always evaluated in filter context.

Question 36

Which one of the following DAX functions allows you to use an inactive relationship when evaluating a measure expression?

A. USERELATIONSHIP
B. CROSSFILTER
C. REMOVEFILTERS
D. ISCROSSFILTERED

Answer 36

A. USERELATIONSHIP

The USERELATIONSHIP function is a filter modifier function that can be passed in to the CALCULATE function. Its purpose is to engage an inactive relationship.

Question 37

Which one of the following statements about the CALCULATE function is true?

A. You must pass in at least one filter argument.
B. It modifies filter context to evaluate a given expression.
C. It modifies row context to evaluate a given expression.
D. It can’t be used by a calculated column formula.

Answer 37

B. It modifies filter context to evaluate a given expression.

The CALCULATE function modifies filter context by adding or removing filters or by modifying standard filter behavior.

Question 38

In the context of semantic model calculations, which statement best describes time intelligence?

A. Snapshot balance reporting
B. Filter context modifications involving a date table
C. Complex calculations involving time
D. Calculations involving hours, minutes, or seconds

Answer 38

B. Filter context modifications involving a date table

Time intelligence calculations modify date filter contexts.

Question 39

You’re developing a semantic model in Power BI Desktop. You’ve just added a date table by using the CALENDARAUTO function. You’ve extended it with calculated columns, and you’ve related it to other model tables. What else should you do to ensure that DAX time intelligence calculations work correctly?

A. Add time intelligence measures to the date table.
B. Mark as a Date table.
C. Add a fiscal hierarchy.
D. Add a date column.

Answer 39

B. Mark as a Date table.

You must mark the date table so that Power BI can correctly filter its dates.

Question 40

You have a table that stores account balance snapshots for each date, excluding weekends. You need to ensure that your measure formula only filters by a single date. Also, if no record is on the last date of a time period, it should use the latest account balance. Which DAX time intelligence function should you use?

A. FIRST
B. FIRSTNONBLANK
C. LAST
D. LASTNONBLANK

Answer 40

D. LASTNONBLANK

The LASTNONBLANK function will return the last date in the filter context where a snapshot record exists. This option will help you achieve the objective.

Question 41

What is a dashboard?

A. A canvas of report elements that can be built in Power BI Desktop.
B. A canvas of report elements that can be built in Power BI service.
C. The canvas in which you can view the semantic model of a report

Answer 41

B. A canvas of report elements that can be built in Power BI service.

Question 42

What is one way that reports and dashboards differ?

A. They are the same.
B. In reports, you can have multiple pages; in dashboards, you can have only one page.
C. You can only build reports and dashboards in Power BI service.

Answer 42

B. In reports, you can have multiple pages; in dashboards, you can have only one page.

Question 43

Where can you configure and set data alerts?

A. Data alerts can be set only in Power BI service on specific visuals such as KPI cards, gauges, and cards.
B. Data alerts can be set in both Power BI service and Power BI Desktop on any kind of visual.
C. Data alerts can be set in Power BI service on any kind of visual.

Answer 43

A. Data alerts can be set only in Power BI service on specific visuals such as KPI cards, gauges, and cards.

Question 44

Why are parameters important in Power BI paginated reports?

A. They allow the report developer to control the refresh interval of the report.
B. They allow the user to control aspects of how the report is rendered when the report is run.
C. They are required so that Power BI can call the paginated report.

Answer 44

B. They allow the user to control aspects of how the report is rendered when the report is run.

Parameters can be used in the report dataset, the report design surface, and other places. Users insert values into the available parameters, and the report author uses those values in the appropriate location in the report.

Question 45

Power BI paginated reports are created by using which tool?

A. Power BI Desktop
B. Power BI service
C. Power BI Report Builder

Answer 45

C. Power BI Report Builder

Question 46

Power BI paginated reports is an evolved technology that was built from which original tool?

A. SQL Server Analysis Services
B. SQL Server Reporting Services
C. Microsoft SharePoint

Answer 46

B. SQL Server Reporting Services

Question 47

What Power BI feature can give an in-depth analysis of the distribution of data?

A. The Next Level of Hierarchy feature can give in-depth analysis because it will allow you to drill down for all subcategories and is not used to analyze the distribution.
B. The Analyze feature allows a user to understand why the distribution looks the way that it does.
C. Only time series analysis can provide in-depth analysis on the data.

Answer 47

B. The Analyze feature allows a user to understand why the distribution looks the way that it does.

Question 48

How can you access the time series chart visual?

A. The filter pane is where all filters on visuals and pages are located.
B. Time series charts can be imported from AppSource.
C. The data pane is where all charts are located.

Answer 48

B. Time series charts can be imported from AppSource.

Question 49

What visual should be used to display outliers?

A. The line chart is best to display outliers.
B. The scatter chart is best to display outliers.
C. The clustered column chart is best to display outliers.

Answer 49

B. The scatter chart is best to display outliers.

Question 50

At the Contoso Skateboard Company, Sally is responsible for managing staff rosters to determine when the inventory employees are required to work. Sally relies on a report that forecasts sales order demand to determine the number of employees that are required at any time. It also includes a button to open a Human Resources app to assign employees to rosters. What type of report audience does Sally represent?

A. Executive
B. Analyst
C. Information worker
D. Report designer

Answer 50

C. Information worker

An information worker is someone who uses data to help them make decisions or to take actions. Typically, information workers make operational decisions that are made on a daily basis.

Question 51

At the Contoso Skateboard Company, Sally is responsible for managing staff rosters to determine when the inventory employees are required to work. Sally relies on a report that forecasts sales order demand to determine the number of employees that are required at any time. It also includes a button to open a Human Resources app to assign employees to rosters. What type of report does Sally use?

A. Dashboard
B. Analytical
C. Operational
D. Educational

Answer 51

C. Operational

An operational report is designed to give the report consumer the ability to monitor current or real-time data, make decisions, and act on those decisions.

Question 52

Which user interface requirement is an example of an accessibility requirement?

A. Augmented reality
B. Contrasting colors
C. Organizational colors
D. Portrait orientation

Answer 52

B. Contrasting colors

Contrasting colors is an accessibility requirement and helps report consumers with low or no vision to distinguish different colors.

Question 53

At the Contoso Skateboard Company, Brandon is designing a dashboard report to show inventory stock levels over time. What type of report visual should Brandon choose to effectively show the stock levels?

A. Bar chart
B. Pie chart
C. Line chart
D. Scatter chart

Answer 53

C. Line chart

A line chart is probably the most effective way to visualize a time series, such as stock inventory levels over time.

Question 54

At the Contoso Skateboard Company, Sakura is designing an analytical report. It must include a visual that allows report consumers to explore and discover detailed sales values over time and by store. What type of report visual should Sakura choose to support the report consumer requirement?

A. Matrix
B. Table
C. Treemap
D. Scatter chart

Answer 54

A. Matrix

A matrix visual allows the report consumer to drill down on the columns and rows to reveal detailed values.

Question 55

At the Contoso Skateboard Company, James is designing a dashboard report. It must prominently show values of sales revenue, units sold, cost of goods sold, and profit, and each value should be compared to a target value. What type of report visual should James choose to support the report consumer requirement?

A. Card
B. KPI
C. Ribbon chart
D. Stacked bar chart

Answer 55

B. KPI

The answer is correct. A KPI visual can show and compare actual and target values.

Question 56

Which of the following capabilities is unique to the Filters pane?

A. Relative date filtering
B. Single selection
C. Top N filtering

Answer 56

C. Top N filtering

Top N filtering can only be achieved in the Filters pane.

Question 57

Which of the following capabilities is unique to slicers?

A. Horizontal orientation
B. Relative date filtering
C. Top N filtering

Answer 57

A. Horizontal orientation

Horizontal orientation can only be achieved with slicers.

Question 58

At the Contoso Skateboard Company, John is responsible for developing a report for the sales director. One report page includes a date slicer and many visuals. When the sales director uses the slicer, all but one of the visuals, a Decomposition Tree visual, should receive the slicer filters. How should John configure the requirement?

A. Add a bookmark that doesn’t capture the state of the Decomposition Tree visual.
B. Add a visual-level filter to all but the Decomposition Tree visual.
C. Edit visual interactions.

Answer 58

C. Edit visual interactions.

By editing visual interactions, John can restrict the slicer from filtering the Decomposition Tree visual.

Question 59

At the Contoso Skateboard Company, Sally is creating a report to show sales over time. Sally is aware that occasional spikes occur in sales revenue that could be attributed to many different reasons, such as a marketing campaign. Sally needs to ensure that supporting visuals provide explanation for the spikes. What type of visual should Sally use?

A. Line chart visual with a trend line
B. Line chart visual with anomaly detection
C. Q&A visual

Answer 59

B. Line chart visual with anomaly detection

Adding anomaly detection to a line chart visual will highlight anomalies and provide accompanying explanations as data visuals.

Question 60

At the Contoso Skateboard Company, Sanjay is authoring a report that will be distributed to sales managers. The report contains some sensitive data that shouldn’t be exported. Which report design feature can Sanjay configure to ensure that data isn’t exported?

A. Drillthrough page
B. Page tooltip
C. Visual header

Answer 60

C. Visual header

By disabling the More options (…) icon, report consumers can’t export data.

Question 61

What is the purpose of the Display state in bookmarks?

A. Capture the visibility of report objects
B. Capture the slicer values of visuals
C. Capture the current page of the report

Answer 61

A. Capture the visibility of report objects

The Display state captures the visibility of report objects, such as shapes, images, buttons, and text boxes.

Question 62

How is the Admin workspace role different from other types of workspace roles?

A. Admin is the only role that can remove any users.
B. Admin is the only role that can publish or update apps.
C. Admin is the only role that can create, edit, or delete content in a workspace.
D. Admin is the only role that can publish content to a workspace.

Answer 62

A. Admin is the only role that can remove any users.

Question 63

Which one of the following options is the best description of a workspace?

A. A workspace is a feature in Power BI service that allows you to view reports only.
B. A workspace is a feature of Power BI Desktop that allows you to build reports only.
C. A workspace is a centralized location or repository that allows you to collaborate with colleagues and teams to create collections of reports, dashboards, and so on.
D. A workspace is a feature that allows you to view and edit the semantic model, build visualizations, and transform the data.

Answer 63

C. A workspace is a centralized location or repository that allows you to collaborate with colleagues and teams to create collections of reports, dashboards, and so on.

Question 64

What feature in Power BI service can you use to troubleshoot the flow of data from its source to its destination?

A. Usage Metrics report
B. Query Caching
C. Quick Insights
D. Lineage view

Answer 64

D. Lineage view

Lineage view allows you to view and troubleshoot the data flow from source to destination.

Question 65

Where are semantic model-scheduled refreshes configured?

A. Power BI service
B. Power BI Desktop
C. AppSource

Answer 65

A. Power BI service

semantic model-scheduled refreshes are configured in Power BI service.

Question 66

What reserved parameters configure the start and end of where Incremental refresh should occur?

A. Start and End parameters
B. StartRange and EndRange
C. RangeStart and RangeEnd

Answer 66

C. RangeStart and RangeEnd

Question 67

What is the difference between Promotion and Certification when you are endorsing a semantic model?

A. Promotion requires write access while Certification requires permission from the semantic model owner to access to the semantic model.
B. Promotion is for broad usage while Certification needs permission granted on the Admin Tenant settings.
C. Promotion is for specific users while Certification needs permission granted on the Admin Tenant settings.

Answer 67

B. Promotion is for broad usage while Certification needs permission granted on the Admin Tenant settings.

Promotion does not need specific permissions while Certification requires permission from the semantic model owner to access to the semantic model.

Question 68

Which function will tell you the username of the person who is signed in to Power BI service?

A. USERPRINCIPALNAME()
B. LOOKUPVALUE()
C. USEROBJECTID()

Answer 68

A. USERPRINCIPALNAME()

The USERPRINCIPALNAME() function will tell you which user is signed in to view a report.

Question 69

Where can you test RLS by using different security roles?

A. Power BI Desktop only
B. Power BI service only
C. Both Power BI Desktop and Power BI service

Answer 69

C. Both Power BI Desktop and Power BI service