🌍 All Study Guides 📊 Dashboard 📰 Blog 💡 About

Coursera Microsoft Power BI Data Analyst • STUDY MODE

PL-300 MOCK EXAM

QUESTION 1 OF 147

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?

OneDrive for business

SharePoint folderCorrect Answer

Excel workbook

SharePoint list

QUESTION 2 OF 147

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?

Data view

Report view

Page view

Model viewCorrect Answer

QUESTION 3 OF 147

Which tool should you use to create a custom connector to access data from a third-party API?

Power BI

Power QueryCorrect Answer

Power Automate

Power Apps

QUESTION 4 OF 147

You have created a Power BI data source that uses SQL SELECT statements. The SQL statement queries multiple tables in a SQL Server database and includes subqueries. When you import the data to Power BI, you receive the error message “Timeout expired”. You have checked the SQL connection and confirmed the Server has sufficient bandwidth and low latency. To minimize the timeout occurrence issue, what should you do?

Replace subqueries with nested queries.

Break down the SQL statement into separate data sources.Correct Answer

Implement aggregations in SQL statement.

Implement groupings in SQL statement.

QUESTION 5 OF 147

Your data model contains a sales table with an OrderDate column. You want to analyze and visualize the sales data grouped by month. What transformation command of the Power query editor lets you create a month column without using DAX expression?

Group By

Extract

Trim

DateCorrect Answer

QUESTION 6 OF 147

For a query append in the query editor, you want to know the percentage of empty cells in each column. Which of the data preview options should you select?

Column profile

Show whitespaces

Column distribution

Column qualityCorrect Answer

QUESTION 7 OF 147

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?

Right inner join

Left inner joinCorrect Answer

Left outer join

Right outer join

QUESTION 8 OF 147

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

Utilize the Sort option.

Use Filter rows and specify the conditions.Correct Answer

Apply the Exclude values transformation.

Apply the remove rows transformation operation.

QUESTION 9 OF 147

You want to add a new column to the Power BI table that categorizes customers as high value if their total sales are above $10,000. Which transformation in the query editor allows you to create such a column without using the DAX expression?

Custom columnCorrect Answer

Conditional split

Group by

Extract

QUESTION 10 OF 147

You have an HR Power BI data model containing a fact table with information about employee performance reviews and dimension tables for employees and departments. What type of data is likely stored in the dimension tables?

Detailed performance review data

Aggregated metric for employee performance

Transactional data about employees

Descriptive information about employees and departmentsCorrect Answer

QUESTION 11 OF 147

Which Power BI interface do you need to use to identify the data anomalies present within your imported dataset from an Excel workbook?

The Model view of Power BI desktop.

The Power query editorCorrect Answer

The Data view of Power BI desktop.

Advanced editor of Power query editor.

QUESTION 12 OF 147

In the Power query editor, the column statistics show a count of 1000 rows, but your query is retrieving data from a data source that contains 5000 rows. What should you do for the column statistics to show the statistics based on entire data rows?

Add a Table.Buffer applied step using M in the query.

Create a Top N row count parameter for the query.

Change the query load from Import to DirectQuery.

From the query window, select Column profiling on the entire dataset.Correct Answer

QUESTION 13 OF 147

You connect the Power query editor to a database table. You need to remove the Row ID column. You need to make sure that the new columns do not display in the table model during a scheduled data refresh in the future. What transformation should you use?

Use the Transpose command, then filter the rows to remove Row ID.

Use the Remove Column command on the Row ID column.

Use the Select columns command to select the columns to keep.Correct Answer

Select Row ID and use the Remove Other Columns command.

QUESTION 14 OF 147

Which statement is true about reference queries in Power BI?

Reference queries enable faster data load.

Reference queries allow you to integrate data efficiently.

Reference queries allow you to combine tables with similar structures.

Reference queries allow you to reuse query logic and transformation.Correct Answer

QUESTION 15 OF 147

You have a Power BI data model containing two tables Sales and Employees. The tables are related via a one-to-many relationship based on the EmployeeID column. You want to analyze the sales performance for each employee. Which cross-filter direction will you choose?

None

SingleCorrect Answer

Both

QUESTION 16 OF 147

You have a Power BI data model where the fact table is related to the Calendar table via multiple inactive relationships based on OrderDate, DeliveryDate, and ShipDate. How can you use the inactive relationship while defining DAX measures?

Managing the relationship from the Manage relationship window

Using the CROSSFILTER function.

Using the USERRELATIONSHIP function.Correct Answer

Using the KEEPFILTERS function.

QUESTION 17 OF 147

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?

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

=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,0,0))Correct Answer

QUESTION 18 OF 147

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

General and Advanced.

Formatting and Advanced.

General, Formatting, and Advanced.Correct Answer

General and Formatting.

QUESTION 19 OF 147

Which function allows you to know the username of the person who is signed into Power BI service?

LOOKUPVALUE( )

USERPRINCIPALNAME( )Correct Answer

USEROBJECTID( )

QUESTION 20 OF 147

You have a Power BI data model containing a Sales table. The Sales table has Quantity and Unit price columns. You want to create a Total sales measure instead of a calculated column by optimizing the data model for storage. Which aggregation function will you use to compute the measure?

CALCULATE and SUM

SUMXCorrect Answer

CALCULATE

SUM

QUESTION 21 OF 147

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

FieldsCorrect Answer

DAX

Power query M functions

CalculationsCorrect Answer

Conditional columns

QUESTION 22 OF 147

Profit margin is a non-additive measure, which DAX function should you use to handle this?

DIVIDECorrect Answer

SUMX

FIRSTNONBLANK

AVERAGE

QUESTION 23 OF 147

You have a hospital emergency Power BI data model, and you want to know the emergency visits for the last 30 days. Which of the two DAX functions can you use to compute this measure? Select all that apply.

SAMEPERIODLASTMONTH

DATESBETWEENCorrect Answer

DATESINPERIODCorrect Answer

TOTALYTD

QUESTION 24 OF 147

You are working on a Power BI data model that contains three data tables. A Salestable containing sales transactions, a Date table, and a Producttable.You want to create a summary table to display the following:

The total sales by each product category per year.

Total quantity of each product within the category.

CALCULATECorrect Answer

FILTER

TOPN

CALCULATETABLE

QUESTION 25 OF 147

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.

True

FalseCorrect Answer

QUESTION 26 OF 147

What Power BI feature can you use to store pre-aggregated data for improved query performance when working with DirectQuery sourced dataset?

DAX calculated columns

DAX calculated tables

Aggregated tablesCorrect Answer

DAX measures

QUESTION 27 OF 147

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.

Create aggregations based on DirectQuerysourced tables.Correct Answer

Query the original data source for all analytical requirements

Connect Power BI via DirectQuery mode.Correct Answer

Import the data to Power BI memory.Reduce the data volume by importing only necessary columns.Correct Answer

QUESTION 28 OF 147

Which of the following Data types offers an optimal performance for the currency field of your data model?

Text

Decimal number

Fixed decimal numberCorrect Answer

Whole number

QUESTION 29 OF 147

You need to visualize the running total of a company by fulfilling the following criteria.

The initial and final value columns must start on the horizontal axis.

The intermediate values must be floating columns.

Waterfall chartCorrect Answer

Combo chart

Scatter plot

Funnel chart

QUESTION 30 OF 147

What are the ways you can use Python in Power BI? Select all that apply.

To create a functional data model

To retrieve data from data sourcesCorrect Answer

To create custom visualizationsCorrect Answer

To perform report optimization

To perform complex data transformationsCorrect Answer

QUESTION 31 OF 147

Your company provides you with a color scheme that they want to use throughout their reporting and analysis. How can you implement the color scheme into your Power BI workflow?

Create a color scheme in Power BI desktop and save it as a template for later use.

Save the color scheme as CSS and upload it to Power BI as a Customtheme.

Replace the report colors with the company’s color scheme from the Theme panel.

Save the color scheme as JSON (JavaScript Object Notation) and upload it to Power BI as a Custom themeCorrect Answer

QUESTION 32 OF 147

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

Filled mapCorrect Answer

Heat maps

Azure mapsCorrect Answer

Shape maps

QUESTION 33 OF 147

You are using Power BI desktop to configure a Stacked column chart that displays gross sales data with Date hierarchy. The hierarchy levels are Year, Quarter, Month, and Day. You need to prevent users from viewing the hierarchy based on the Year. What should you do?

In the Visualizations pane, remove the Year from the Date hierarchy field in the horizontal axisCorrect Answer

In the Format pane, modify the maximum range settings.

In the Filters pane, add a filter based on the Quarter, Month, and Day.

In the Filters pane, add a filter based on the Year.

QUESTION 34 OF 147

True or False: Power BI allows you to add visual elements and images to your report tooltip.

TrueCorrect Answer

False

QUESTION 35 OF 147

How is drill-through different from drill-down functionality in Power BI?

Drill-through provides a more detailed view while drill-down is used to expand hierarchies.Correct Answer

A drill down and drill through can be used interchangeably.

A drill-down is used for visuals, while a drill-through is used for tabular data.

Drill-through is used to expand hierarchies while drill-down provides detailed navigation.

QUESTION 36 OF 147

True or False: When you create page navigation in Power BI desktop reports, you also need to manually sync the page navigator with your report pages?

True

FalseCorrect Answer

QUESTION 37 OF 147

You have a Power BI dataset where each employee is reporting to multiple managers in the organizational hierarchy. How does a PATH function of DAX handle such a situation?

It chooses the shortest path for each employee.

It creates a separate path for each employee-manager relationship.Correct Answer

The PATH function cannot handle multiple reporting relationships.

It concatenates all paths for each manager.

QUESTION 38 OF 147

True or False: You have a Power BI report with a live connection. One of the managers of the company is more comfortable using Excel for analyzing data. Power BI allows you to utilize the Analyze in Excel feature with a live-data connection to export the refreshable data from Power BI to Microsoft Excel.

TrueCorrect Answer

False

QUESTION 39 OF 147

A Power BI desktop report needs to be optimized for cellular devices. Which Power BI component can you use to optimize the report for mobile devices? Select all that apply.

Power BI desktopCorrect Answer

Power BI report builder

Power BI mobile appPower BI serviceCorrect Answer

QUESTION 40 OF 147

You have a Waterfall chart showing the increase and decrease of Sales by States in Power BI report in Power BI service and want to analyze the data using the Analyze feature of Power BI. You selected the first data point of the Waterfall chart and the Analyze option is not available in the context menu. What could be the probable reason?

The Waterfall chart does not support the Analyze feature.

The Analyze feature cannot be used for the first data point of the visual.Correct Answer

The Analyze feature can only be used in Power BI desktop.

QUESTION 41 OF 147

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.

A List group type

A Bin group typeCorrect Answer

A Date/time columnA numerical columnCorrect Answer

QUESTION 42 OF 147

In Power BI where can you find time series charts?

In the Filter pane of Power BI Desktop.

You need to import time series charts from AppSource.Correct Answer

Time series charts are in the Visualizations pane.

The Fields pane contains the time series charts.

QUESTION 43 OF 147

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?

Admin

MemberCorrect Answer

Viewer

Contributor

QUESTION 44 OF 147

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

Creation of multiple pagesCorrect Answer

Use of slicers and filtersCorrect Answer

Setup of data Alerts

Natural language queries

QUESTION 45 OF 147

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.

TrueCorrect Answer

False

QUESTION 46 OF 147

Sensitivity labels are a way to classify critical content and protect your sensitive data without losing productivity. Which of the following components can you apply Sensitivity labels to in Power BI Service? Select all that apply:

Paginated reportsCorrect Answer

DataflowsCorrect Answer

Semantic models (Datasets)Correct Answer

Workbooks

QUESTION 47 OF 147

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

Quick insights

Usage metrics report

Query cachingLineage viewCorrect Answer

QUESTION 48 OF 147

You are creating and managing dataflows for your organization. The company’s data is hosted in on-premises SQL Server.

True

FalseCorrect Answer

QUESTION 49 OF 147

You have a Power BI data model that imports data from an on-premises SQL Server. You have implemented a scheduled refresh of the dataset. What happens to the Power BI report after each scheduled refresh? Select all that apply.

Query caches are refreshed

Schema refresh that is change in data source table structure is shownCorrect Answer

Report visuals are refreshed

Data is refreshed from the data source Queries used to populate visuals are refreshedCorrect Answer

QUESTION 50 OF 147

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

Mail-enabled group

Azure Active Directory Security Group

Microsoft 365 GroupCorrect Answer

Distribution group

QUESTION 51 OF 147

You need to create a data source that can be used offline. Which type of data source should you use?

SharePoint

Microsoft OneDriveCorrect Answer

SQL Server

Common data services

QUESTION 52 OF 147

You have a CSV file that contains user complaints. The table contains a column called Logged, which has data and the time of each complaint. The data is logged in the following format: 2022-12-21 at 08:35. You want to analyze the complaints by the logged date and utilize Power BI’s built-in date hierarchy. What should you do?

Change the data type of the logged column to Date.Correct Answer

Apply transformation to extract the column’s first characters that only contain the date.

Split the logged column using ‘at’ as a delimiter.

You can use the same column as the date hierarchy.

QUESTION 53 OF 147

Your Power BI dataset has a table where each row represents a city, and there are columns for the population in different years like Population_2019, Population_2020, and so on. You want to display the data with a single column for the year and another column for the population. What transformation step can you achieve in Power BI?

Pivot column

Unpivot columnsCorrect Answer

Merge queries

Split columns

QUESTION 54 OF 147

You want to make changes to your data sources. What are the changes you can apply to the data source from the Data source settings of the Power query editor? Select all that apply.

Adding a column

Renaming a column

Clearing permissionsCorrect Answer

Modifying the file pathCorrect Answer

Editing permissionsCorrect Answer

QUESTION 55 OF 147

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?

In Power BI, add a template app.

In Power BI, add an organizational app.

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

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

QUESTION 56 OF 147

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?

Group by column from the query editor.

Sort by column from the query editor.

Sort by column from the Power BI desktop.Correct Answer

Group by column from the Power BI desktop.

QUESTION 57 OF 147

You developed a query in Power BI desktop that retrieves data from an Excel spreadsheet. During the data analysis, you identify the need to view and modify multiple steps of data transformation in the entire M code. Which Power BI interface allows you to accomplish that?

The Model view of Power BI desktop.

The Power query editor.

Advanced editor of Power query editorCorrect Answer

The Formula bar of the query editor.

QUESTION 58 OF 147

You want to create a common date table within your Power BI data model. The start and end of the date table must match the date range available in the fact table of the data model. How can you create this table?

Use CALENDARAUTO and specify the dates.

Use the CALENDAR function and specify the dates.

Use CALENDAR with MIN and MAX to specify the dates.Correct Answer

Use CALENDARAUTO with MIN and MAX to specify the dates.

QUESTION 59 OF 147

Which of the following Power BI components can you use to configure the column and table properties of your data model? Select all that apply.

Visualizations pane of Power BI desktop.

Advanced editor.

The Power query editor.Correct Answer

The Model view of Power BI desktop.Correct Answer

QUESTION 60 OF 147

Which of the following statements about Measures in Power BI is true? Select all that apply.

Measures can only be created using DAX in Power BI.

Measures are dynamic calculations that do not take space in the data modelCorrect Answer

Measures can reference columns directly.

Measures can reference other measures during calculations.Correct Answer

QUESTION 61 OF 147

You are working on a complex data model that requires various DAX measures to define a range of business metrics. You decided to use variables while creating DAX formulas. What are the benefits of using variables in DAX expressions over using original expressions? Select all that apply.

Variables allow users to change the data source connection in the DAX measure.

Variables improve the overall performance of the resulting DAX measure.Correct Answer

Variables improve the overall readability of the resulting DAX measure.Correct Answer

Variables have additional functions that can be used in the DAX measure.

QUESTION 62 OF 147

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?

Power BI desktop table view

Power query editorCorrect Answer

Power BI desktop model view

Power BI desktop report view

QUESTION 63 OF 147

True or False: You have imported a Power BI data model from a huge Excel spreadsheet. You need to create aggregations to improve model performance but creating and managing aggregations is limited to DirectQuery sourced datasets.

True

FalseCorrect Answer

QUESTION 64 OF 147

You have developed a Power BI report for the sales team of your company. The salespeople are frequently interacting with the report and complain that the report elements are taking too long to display upon each interaction. You have recorded the report performance from the performance analyzer. How do the results assist you in improving the report’s performance?

The results recommend reducing the data size.

The results suggest you replace the visual elements.

The results show you the impact of user interaction on report elements so you can optimize.Correct Answer

The results recommend the data fresh frequency.

QUESTION 65 OF 147

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?

Clustered bar chart

Ribbon chartCorrect Answer

Treemap

Scatter plot

QUESTION 66 OF 147

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?

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

Change the background color with Conditional formattingCorrect Answer

Selectively change the background color from the Theme panel

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

QUESTION 67 OF 147

You are developing a Power BI desktop report to visualize the sales performance of salespeople. The sales team is comprised of over 20 salespeople. You also need to make sure the sales values are visualized monthly. What should you do?

Create a Column chart displaying Date hierarchy on the X-axis and create a Slicer drop-down for salespersons.Correct Answer

Create a Bar chart displaying the salesperson on the Y-axis.

Create a Column chart displaying salespersons on the X-axis and create a Slicer for data hierarchy.

Create a Column chart displaying the month on the X-axis.

QUESTION 68 OF 147

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.

Text

Binary

Boolean

NumericCorrect Answer

Date/timeCorrect Answer

QUESTION 69 OF 147

In Power BI desktop, what types of fields can you use to create a data hierarchy enabling users to drill down to granular details of analysis?

Only numerical values

Hierarchies can only be created with Data/time data fields

Both categorical and numerical data fields can be usedCorrect Answer

Only text-based data

QUESTION 70 OF 147

You have a Power BI desktop report containing three pages: Main, Delayed Response, and On-time Response. You have added a Button to the Main page for navigation.You need to implement a solution that meets the following criteria:

The navigation destination must change based on the output of a DAX measure name [Delayed Response].

If [Delayed Response] is greater than 5%, the Button must display the text “Delayed Response” and navigate to the Delayed Response page.

Otherwise, the Button displays the text “On-time Response” and navigates to the On-time Response page.

Set the button type to Bookmark and then use Conditional formatting to specify the destination.

Use Conditional formatting to set the Button text.Correct Answer

Create a DAX measure that outputs the correct page name based on the value of [Delayed response].Correct Answer

Set the Button type to page navigation and then use Conditional formatting to specify the destination.Correct Answer

QUESTION 71 OF 147

You have a Power BI report displaying a Column chart of Sales on the Y-axis and Countries on the X-axis. When users hover the cursor on any data point the tooltip displays the sales values along with the name of the country. How can you display the sales breakdown by each category within the same country?

Add a separate visual displaying sales breakdown by product category.

Create a separate report page for each product category.

Add a Category slicer where users can select a category.

Add a visual for sales breakdown by category on a Tooltip.Correct Answer

QUESTION 72 OF 147

You need to add an analytical line to a visual within your report. The value for the line must be equal to the result of a DAX measure that always returns a consistent single value. The DAX measure must only be used to populate the analytics line. Which type of analytics line should you use?

Max line

Min line

Average line

Constant lineCorrect Answer

QUESTION 73 OF 147

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?

Decomposition treeCorrect Answer

Waterfall chart

Q&A visual

Key influencer visual

QUESTION 74 OF 147

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

Member

Viewer

ContributorCorrect Answer

Admin

QUESTION 75 OF 147

You are creating a workspace in Power BI service. You must ensure you can configure a Microsoft 365 group whose SharePoint online document library is available to workspace users after it is created. Which setting should you configure when creating a workspace?

Allow contributors to update the app

Workspace OneDriveCorrect Answer

Develop a template app

License mode

QUESTION 76 OF 147

You want to create Alerts to notify users if the data on the dashboard changes above or below a certain threshold. Which Power BI visual allows you to set and manage Alerts in Power BI service? Select all that apply:

Custom visuals

KPICorrect Answer

GaugeCorrect Answer

Card visualCorrect Answer

Python visual

QUESTION 77 OF 147

True or False: You can only subscribe to external users to a Power BI report or dashboard if your report or dashboard is hosted in a Premium capacity.

TrueCorrect Answer

False

QUESTION 78 OF 147

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

Less manual work and fewer errors.Correct Answer

Enhanced user access to BI report source data.

Reports can be published from multiple workspace environments.

Semantic model (dataset) creation is streamlined.

QUESTION 79 OF 147

Your company has a SharePoint server located in a data center in Toronto. You are creating a report in Power BI service that uses Microsoft Excel files stored on the SharePoint server. You need to recommend a solution to ensure that the dataset for the report can automatically refresh daily. What should you include in the recommendation?

Azure Data box

A virtual private network (VPN)

An on-premises data gatewayCorrect Answer

QUESTION 80 OF 147

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.

TrueCorrect Answer

False

QUESTION 81 OF 147

Row-level security is commonly applied to which type of tables in Power BI?

Dimension tables

Fact tables

Lookup tablesCorrect Answer

Data tables

QUESTION 82 OF 147

For the sales department of your organization, you publish a report that imports data from Microsoft Excel located in a Microsoft SharePoint folder. The data model contains several DAX measures. You must create a Power BI report from the existing data with minimal development efforts. Which type of data source should you use?

An Excel workbook

A Power BI dataset

A SharePoint folderCorrect Answer

Power BI dataflows

QUESTION 83 OF 147

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.

Import mode supports the Q&A feature.Correct Answer

Import mode has minimal need for data refresh.

Importmode supports per-table configuration.

Import mode minimizes disk space usage.Import mode supports Quick insights.Correct Answer

QUESTION 84 OF 147

What is the best way to organize related datasets?

Use naming conventions to identify datasets.

Use a separate workspace for each dataset.

Use folders to group related datasets.Correct Answer

Use tags to categorize datasets.

QUESTION 85 OF 147

How can you ensure data accuracy before analysis?

Using data profiling toolsCorrect Answer

Use data modeling tools

Use data visualization tools

Use data transformation tools

QUESTION 86 OF 147

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

Power query editor.Correct Answer

Data modeler.

Data view of Power BI desktop.

Advanced editor.

QUESTION 87 OF 147

You have two Excel sheets with data from separate reporting units. Both spreadsheets contain the same column names and structure. What Power query editor feature will you use to create a unified dataset?

Merge 

Group

Manage

AppendCorrect Answer

QUESTION 88 OF 147

You are designing a data model for hospital emergency visits. You want to capture patient information like name, address, insurance details, email, and phone number. Which type of table should you store this information?

Measure table

Fact table

Dimension tableCorrect Answer

Look up table

QUESTION 89 OF 147

You have a dataset representing each month (January, February, March) as individual columns. What transformation in the query editor can you use to rearrange the data, making months appear as rows instead of columns?

Extract

TransposeCorrect Answer

Pivot

Reverse rows

QUESTION 90 OF 147

Which Power BI component allows you to create and manage dataflows?

Power BI ServiceCorrect Answer

Power BI desktop interface

Power BI data modeler

Power query from Power BI desktop

QUESTION 91 OF 147

You have a Power BI data model that contains three data tables: Sales, Products, and Date. Both the Product and Date table are related to the Sales table via one-to-many relationships. You want to analyze products sold by year. What should you do to analyze annual product sales? Select all that apply.

Use USERRELATIONSHIP to handle the cross-filter direction.Correct Answer

Set up a many-to-many relationship between the Date and the Sales tables.

Set up cross filter direction to Both between Date and Sales tables.

Set up a Both cross-filter direction between the Product and Sales tables.Correct Answer

Set up a many-to-many relationship between the Product and the Sales tables.

QUESTION 92 OF 147

You imported a data model to Power BI. The mode does not have a date dimension table that is needed to create complex time intelligence calculations. Which of the following tools can you use to create a date dimension table? Select all that apply:

PythonCorrect Answer

DAX in the query editor.

M language in the query editor.Correct Answer

SQL 

DAX in the Power BI desktop.Correct Answer

QUESTION 93 OF 147

What is the default summarization of a numerical column in Power BI?

SUMCorrect Answer

Average

Count

MIN

QUESTION 94 OF 147

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

Both Power BI desktop and Service.Correct Answer

Power BI mobile app.

Power BI desktop.

Power BI service.

QUESTION 95 OF 147

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?

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

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

Implicit measures can be used with Field parameters.

Implicit measures can be used to create Quick measures.

QUESTION 96 OF 147

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: 

LASTDATECorrect Answer

CALENDAR

CALENDARAUTO

DISTINCTCOUNT

QUESTION 97 OF 147

True or False: You cannot create quick measures in Power BI service because only Power BI desktop supports the creation of quick measures.

TrueCorrect Answer

False

QUESTION 98 OF 147

You have imported a large data model to Power BI desktop, and you want to reduce the model size. Which technique should you use to reduce the model size

Configure the Query reduction option filter settings.

Set the storage mode property of tables to import.

Set the storage mode property of tables to DirectQuery.Correct Answer

Configure the Query reduction option Slicer settings.

QUESTION 99 OF 147

You are planning to create a report in Power BI desktop to visualize the relationship between the number of orders received and the number of orders shipped by product category. You must identify the visual that will clearly identify the outliers in the dataset by displaying them away from the cluster of data. Which visual should you choose?

Scatter plotCorrect Answer

Gauge

Treemap

Card

QUESTION 100 OF 147

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?

Card visual

A Waterfall chart

A Scatter plotCorrect Answer

A KPI

QUESTION 101 OF 147

Power BI desktop supports many accessibility tools. Which keyboard keys let you access the accessibility features?

Tab

Alt + A

AltCorrect Answer

Tab + A

QUESTION 102 OF 147

A fundamental principle of data storytelling is a cohesive report page and visuals should be placed in a logical order. Which Power BI element allows you to visualize the order of visuals in the report page and configure them according to the narrative of your data story?

Visualizations pane of Power BI desktop.

Selection pane from the query editor.

Page navigator from Power BI desktop.

Selection pane from Power BI desktop.Correct Answer

QUESTION 103 OF 147

How can you group layers of visual elements in your Power BI desktop report? Select all that apply.

Select all visuals to be grouped, navigate to the Format ribbon, and select Group.Correct Answer

Drag and drop the visual elements.

Select all visuals to be grouped, right-click on any visual, and select Group from the context menu.Correct Answer

Right-click on any visual and select Group from the context menu

QUESTION 104 OF 147

A Power BI dashboard needs to be optimized for cellular devices. Which Power BI component can you use to optimize the report for mobile devices?

Power BI Desktop

Power BI report builder

Power BI mobile app

Power BI serviceCorrect Answer

QUESTION 105 OF 147

True or False: In Power BI desktop, you can convert a Q&A visual to a fully formatted visual element to display on your report canvas.

True

FalseCorrect Answer

QUESTION 106 OF 147

You need to assign an app workspace role to users who consume reports. Users should only have permission to examine the report. Which role should you assign to users?

Contributor role

Admin role

Member role

Viewer roleCorrect Answer

QUESTION 107 OF 147

You are applying sensitivity labels to your Power BI reports, which of the following are sensitivity labels in Power BI? Select all that apply.

Certified

Highly confidentialCorrect Answer

Personal ConfidentialCorrect Answer

QUESTION 108 OF 147

You have developed a query named Customers in Power BI desktop to append the rows from three external tables having customer data into a single customer table. You want to ensure each row in the new customer table has a unique ID value. What is the best way to add an ID column to the customer table?

Modify the data model by adding a counter column.

Change the data model by extending the Customers table with a counter column.

Change the data model by extending the Customers table with an index column.

Modify the data model by adding an index column.Correct Answer

QUESTION 109 OF 147

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?

Power query editorCorrect Answer

Data view of Power BI desktop

Model view of Power BI desktop

Page view of Power BI desktop

QUESTION 110 OF 147

What happens when you make changes to the source query of a referenced query in Power BI?

The reference queries do not change.

The changes are automatically applied to all referencing queriesCorrect Answer

The changes only affect the current report.

The referencing queries become read-only.

QUESTION 111 OF 147

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?

Import two separate datasets for maintenance and installation.

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

Create two separate Machine dimension tables for installation and maintenance.

Use Calculated columns to distinguish between installation and maintenance dates.

QUESTION 112 OF 147

You have implemented role-based security that restricts access to a Power BI desktop dataset for users who are assigned the role named Salespersons. You need to validate that the implementation works properly. What should you do?

In Power query editor, add a conditional column to the Salesperson table.

In the Report view, activate the view as a feature.Correct Answer

In the Report view, add a DAX expression filter to the Salesperson table. 

In the Report view, create a what-if parameter.

QUESTION 113 OF 147

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?

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

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

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

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

QUESTION 114 OF 147

A Power BI data model has measures and calculated columns. What is the benefit of using measures over calculated columns?

Measures can be used for data transformation operations.

Measures can be used in the calculated columns to create complex calculations.

Measures are dynamic calculations and are not stored in the data model.Correct Answer

Measures can assist in data load operations.

QUESTION 115 OF 147

What are the potential performance benefits of removing unnecessary columns from the data model? Select all that apply.

Increasing the refresh speed.Correct Answer

Increasing DAX performance.

Decreasing report page load times.

Reducing the size of data model.Correct Answer

QUESTION 116 OF 147

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?

Visualizationpane.

Power query profiling tool.

Performance analyzer.Correct Answer

Power BI data Modeler.

QUESTION 117 OF 147

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.

Expand

HighlightCorrect Answer

Drill through

FilterCorrect Answer

QUESTION 118 OF 147

In Power BI you can add symmetry shading along with x- and y-axis Constant lines to which of the following visuals?

Area chart

Scatter chartCorrect Answer

Line chart

Waterfall chart

QUESTION 119 OF 147

What features can you configure in the Q&A feature of Power BI desktop? Select all that apply.

Review QuestionsCorrect Answer

SynonymsCorrect Answer

Visual formatting

ModelingRelationshipsCorrect Answer

QUESTION 120 OF 147

Anomaly detection is a powerful feature of Power BI where you can detect anomalies within your time series data. Which of the following features are not supported by anomaly detection? Select all that apply.

You cannot use drill down with anomaly detection.Correct Answer

DirectQuery connectivity is not supported.Correct Answer

Line charts are not supported.

Live connection to the dataset is not supported.Correct Answer

QUESTION 121 OF 147

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

True

FalseCorrect Answer

QUESTION 122 OF 147

You have an Azure SQL database that contains sales transactions. The database is updated frequently. You are asked to create a report from the data to detect fraudulent transactions. The data must be visible within five minutes of any update. How will you configure the data connection?

By adding a SQL statement.

By setting data connectivity to DirectQuery.Correct Answer

By setting data connectivity to import mode.

By setting a command timeout in minutes.

QUESTION 123 OF 147

You have a Power BI model with the following fact tables and corresponding storage modes:

FactStoreSales (Import mode)

FactInternetSales (DirectQuery mode)

DualCorrect Answer

DirectQuery

Import

None

QUESTION 124 OF 147

You are importing data from a SQL Server database that contains two tables named SalesOrderDetails (left table) and SalesOrders (right table). You load both tables to Power BI desktop and the tables have a relationship based on theSalesOrderID column. You need to combine two tables into one and you must meet the following requirements:

There is a row for every SalesOrderDetails row in the resulting table, even if there is no corresponding SalesOrder row.

For every SalesOrderDetails row, the row in the resulting table includes the corresponding SalesOrder row data if the SalesOrder exists.

Any SalesOrder row data that does not have a corresponding SalesOrderDetailsrow is not included in the resulting table.

Merge the tables using full outer join kind based on the SalesOrderID.

Merge the tables using left outer join kind based on the SalesOrderID.Correct Answer

Append the tables.

Merge the tables using inner join based on the SalesOrderID.

QUESTION 125 OF 147

You have a Power BI desktop model that contains a Sales fact table and Product dimension table. You want to compute the total sales by product category by implementing the condition: “Only products that have a total sale of over $20K should be displayed.” What combination of DAX functions should you use to compute the measure?

FILTER and SUM.

FILTER and CALCULATE.Correct Answer

SUM and CALCULATE.

FILTER and SUMX.

QUESTION 126 OF 147

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.

CALENDARAUTO

DISTINCTCOUNT

LASTDATE

LASTNONBLANK  Correct Answer

QUESTION 127 OF 147

You have created a data model in Power BI desktop that contains DAX-calculated columns and measures. You want to create a report from the model. Where can you use DAX-calculated columns, without being able to use measures? Select all that apply.

As an item in the Fields well of a slicer.Correct Answer

As a filter in the Filters on this Page well of the Filters pane.Correct Answer

As an item in the Add drill-through fields here well of the Visualizationpane.

As a filter in the Filters on this visual well of the Filters pane.

QUESTION 128 OF 147

You have developed a CustomTheme in Power BI desktop and created reports based on this theme. When you publish your reports to Power BI service and create dashboards out of the reports, will Power BI service alter the theme and adapt your reports to the dashboard default theme?

True

FalseCorrect Answer

QUESTION 129 OF 147

You have a Power BI report that uses a dataset imported from the database. The report contains a Slicer that you need to sync so that it can be used on other report pages. What is required to sync the slicers between report pages?

Each Slicer must be the same slicer type.

Each Slicer must have the same title.

Each Slicer must use the same columnCorrect Answer

Each Slicer must be visible.

QUESTION 130 OF 147

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

When you need to print the report in tabular formatCorrect Answer

For real-time data analysis.

When designing for mobile devices.

For ad-hoc queries.

QUESTION 131 OF 147

You have created a Bookmark for your Power BI report. After creating a Bookmark, you added a new page to your report and reordered the pages. What should you do to update the Bookmark?

You don’t need any formatting because any additional page and reorder of pages automatically synced with the Bookmark.Correct Answer

You need to update the order of buttons in Bookmark, but the new page was automatically added to Bookmark.  

Navigate to the format Bookmark and update the settings.

You need to add the new page to the Bookmark manually, but the order of pages automatically syncs with the Bookmark.

QUESTION 132 OF 147

You are working on a Power BI report that contains multiple Slicers. A new user of the report might not be able to visualize the entire data because of the active selection of Slicers. What should you do to enhance the user experience?

Add a Bookmark

Duplicate the report page and remove the Slicers from the duplicated page

Add a Button to clear all the SlicersCorrect Answer

QUESTION 133 OF 147

The Analyze in Excel feature allows you to summarize data in Excel with a live connection. What is the maximum row limit of summarized data with a live connection?

You cannot analyze data in Excel as summarization with a live connection.

Five hundred thousandCorrect Answer

The same as the source dataset.

Three hundred thousand

QUESTION 134 OF 147

Which content type can be endorsed in Power BI? Select all that apply.

ReportsCorrect Answer

Semantic modelCorrect Answer

Excel workbook

DataflowsCorrect Answer

Live streaming dataset

QUESTION 135 OF 147

One of your columns in the data model contains information about the mailing address’s city, state, and postal code. You must separate the fields to access the geospatial elements for map visualization. What transformation should you apply?

Replace values

Modify data type

Split columnCorrect Answer

Modify data category

QUESTION 136 OF 147

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

CROSSFILTERCorrect Answer

FILTERS

KEEPFILTERSCorrect Answer

EARLIERUSERRELATIONSHIPCorrect Answer

QUESTION 137 OF 147

You have a Power BI data model from which you need to create reports and dashboards. In which scenario do you need a dashboard for a report in Power BI?

You need to add filters.

You need to display visuals that use different datasets.Correct Answer

You need to display visuals from multiple pages.

You need to add slicers.

QUESTION 138 OF 147

Which of the following statements regarding publishing reports from Power BI desktop to Power BI service is true?

Only reports are published to Power BI service.

Both reports and datasets are published to Power BI service.Correct Answer

Only datasets are published to Power BI service.

QUESTION 139 OF 147

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?

Both gateways provide the same features

The physical location of the data centers

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

The number of users and the need for centralized managementCorrect Answer

QUESTION 140 OF 147

Which Power BI refresh options require you to set parameters?

Incremental refreshCorrect Answer

On-demand refresh

Scheduled refresh

QUESTION 141 OF 147

You need to create a data source that external users can access. Which type of data source should you use?

Common data servicesCorrect Answer

OneDrive

SharePoint

SQL Server

QUESTION 142 OF 147

You have a Power BI file that imports several tables from Azure SQL database. The data will be migrated to another Azure SQL database. You need to change the connections in the Power BI file. The solution must minimize the administrative efforts. What should you do?

Create new queries from the Power query editor.

Create a Power BI file, open the file, and change the data source when prompted.

Modify the source of each query in the Power query editor.

Modify the data source settings.Correct Answer

QUESTION 143 OF 147

You have a Power BI project with a large dataset. You have applied an extensive set of transformation operations to the dataset for analysis and visualization. You need to duplicate the data table for some additional analytical tasks. What transformation can you do to avoid repeating the transformation steps you already performed on the query?

Duplicate query from the query editor.

Duplicate the data model.

Reference query from the query editorCorrect Answer

Duplicate and save Power BI file with a different name.

QUESTION 144 OF 147

You have a Power BI dataset where each employee is reporting to multiple managers in the organizational hierarchy. How can you handle such a situation?

Create a separate report for each employee-manager relationship.

Utilize the PATH DAX function to handle the organizational hierarchy.Correct Answer

Implement only the most important employee-manager relationship in your report.

Utilize the PATHLENGTH DAX function to handle the organizational hierarchy.

QUESTION 145 OF 147

What was the primary benefit of using Microsoft Copilot in Bing for troubleshooting DAX formulas in Power BI?

To provide insights on data trends

To quickly identify and correct errorsCorrect Answer

To increase the scalability of DAX formulas across multiple reports

To automate report generation

QUESTION 146 OF 147

What step did you take first when using Copilot in Bing to troubleshoot the CALCULATE formula?

Adjust the report’s parameters to match expected outcomes

Cross-verify the formula with similar ones used in other reports

Copy the formula to be refinedCorrect Answer

Update the dataset to ensure data integrity

QUESTION 147 OF 147

What actions did you perform after receiving the revised CALCULATE formula from Microsoft Copilot? Select all that apply.

Apply the updated formula to the SalesCalculation column.Correct Answer

Implement filters to the dataset to enhance the formula’s performance.

Prompt with a follow-up question about the cause of the issue.Correct Answer

Archive the previous version of the report as a backup.

Ready to test your recall?

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?

OneDrive for business

SharePoint folder

Excel workbook

SharePoint list

How confident are you in this answer?

PL-300 MOCK EXAM

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?

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?

Which tool should you use to create a custom connector to access data from a third-party API?

Your data model contains a sales table with an OrderDate column. You want to analyze and visualize the sales data grouped by month. What transformation command of the Power query editor lets you create a month column without using DAX expression?

For a query append in the query editor, you want to know the percentage of empty cells in each column. Which of the data preview options should you select?

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?

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

You want to add a new column to the Power BI table that categorizes customers as high value if their total sales are above $10,000. Which transformation in the query editor allows you to create such a column without using the DAX expression?

You have an HR Power BI data model containing a fact table with information about employee performance reviews and dimension tables for employees and departments. What type of data is likely stored in the dimension tables?

Which Power BI interface do you need to use to identify the data anomalies present within your imported dataset from an Excel workbook?

In the Power query editor, the column statistics show a count of 1000 rows, but your query is retrieving data from a data source that contains 5000 rows. What should you do for the column statistics to show the statistics based on entire data rows?

You connect the Power query editor to a database table. You need to remove the Row ID column. You need to make sure that the new columns do not display in the table model during a scheduled data refresh in the future. What transformation should you use?

Which statement is true about reference queries in Power BI?

You have a Power BI data model containing two tables Sales and Employees. The tables are related via a one-to-many relationship based on the EmployeeID column. You want to analyze the sales performance for each employee. Which cross-filter direction will you choose?

You have a Power BI data model where the fact table is related to the Calendar table via multiple inactive relationships based on OrderDate, DeliveryDate, and ShipDate. How can you use the inactive relationship while defining DAX measures?

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?

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

Which function allows you to know the username of the person who is signed into Power BI service?

You have a Power BI data model containing a Sales table. The Sales table has Quantity and Unit price columns. You want to create a Total sales measure instead of a calculated column by optimizing the data model for storage. Which aggregation function will you use to compute the measure?

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

Profit margin is a non-additive measure, which DAX function should you use to handle this?

You have a hospital emergency Power BI data model, and you want to know the emergency visits for the last 30 days. Which of the two DAX functions can you use to compute this measure? Select all that apply.

You are working on a Power BI data model that contains three data tables. A Salestable containing sales transactions, a Date table, and a Producttable.You want to create a summary table to display the following:

What Power BI feature can you use to store pre-aggregated data for improved query performance when working with DirectQuery sourced dataset?

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.

Which of the following Data types offers an optimal performance for the currency field of your data model?

You need to visualize the running total of a company by fulfilling the following criteria.

What are the ways you can use Python in Power BI? Select all that apply.

Your company provides you with a color scheme that they want to use throughout their reporting and analysis. How can you implement the color scheme into your Power BI workflow?

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

You are using Power BI desktop to configure a Stacked column chart that displays gross sales data with Date hierarchy. The hierarchy levels are Year, Quarter, Month, and Day. You need to prevent users from viewing the hierarchy based on the Year. What should you do?

True or False: Power BI allows you to add visual elements and images to your report tooltip.

How is drill-through different from drill-down functionality in Power BI?

True or False: When you create page navigation in Power BI desktop reports, you also need to manually sync the page navigator with your report pages?

You have a Power BI dataset where each employee is reporting to multiple managers in the organizational hierarchy. How does a PATH function of DAX handle such a situation?

A Power BI desktop report needs to be optimized for cellular devices. Which Power BI component can you use to optimize the report for mobile devices? Select all that apply.

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.

In Power BI where can you find time series charts?

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?

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

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.

Sensitivity labels are a way to classify critical content and protect your sensitive data without losing productivity. Which of the following components can you apply Sensitivity labels to in Power BI Service? Select all that apply:

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

You are creating and managing dataflows for your organization. The company’s data is hosted in on-premises SQL Server.

You have a Power BI data model that imports data from an on-premises SQL Server. You have implemented a scheduled refresh of the dataset. What happens to the Power BI report after each scheduled refresh? Select all that apply.

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

You need to create a data source that can be used offline. Which type of data source should you use?

You want to make changes to your data sources. What are the changes you can apply to the data source from the Data source settings of the Power query editor? Select all that apply.

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

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?

You developed a query in Power BI desktop that retrieves data from an Excel spreadsheet. During the data analysis, you identify the need to view and modify multiple steps of data transformation in the entire M code. Which Power BI interface allows you to accomplish that?

You want to create a common date table within your Power BI data model. The start and end of the date table must match the date range available in the fact table of the data model. How can you create this table?

Which of the following Power BI components can you use to configure the column and table properties of your data model? Select all that apply.

Which of the following statements about Measures in Power BI is true? Select all that apply.

You are working on a complex data model that requires various DAX measures to define a range of business metrics. You decided to use variables while creating DAX formulas. What are the benefits of using variables in DAX expressions over using original expressions? Select all that apply.

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?

True or False: You have imported a Power BI data model from a huge Excel spreadsheet. You need to create aggregations to improve model performance but creating and managing aggregations is limited to DirectQuery sourced datasets.

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?

You are developing a Power BI desktop report to visualize the sales performance of salespeople. The sales team is comprised of over 20 salespeople. You also need to make sure the sales values are visualized monthly. What should you do?

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.

In Power BI desktop, what types of fields can you use to create a data hierarchy enabling users to drill down to granular details of analysis?

You have a Power BI desktop report containing three pages: Main, Delayed Response, and On-time Response. You have added a Button to the Main page for navigation.You need to implement a solution that meets the following criteria:

You need to add an analytical line to a visual within your report. The value for the line must be equal to the result of a DAX measure that always returns a consistent single value. The DAX measure must only be used to populate the analytics line. Which type of analytics line should you use?

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

You are creating a workspace in Power BI service. You must ensure you can configure a Microsoft 365 group whose SharePoint online document library is available to workspace users after it is created. Which setting should you configure when creating a workspace?

You want to create Alerts to notify users if the data on the dashboard changes above or below a certain threshold. Which Power BI visual allows you to set and manage Alerts in Power BI service? Select all that apply:

True or False: You can only subscribe to external users to a Power BI report or dashboard if your report or dashboard is hosted in a Premium capacity.

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

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.

Row-level security is commonly applied to which type of tables in Power BI?

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.

What is the best way to organize related datasets?

How can you ensure data accuracy before analysis?

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

You have two Excel sheets with data from separate reporting units. Both spreadsheets contain the same column names and structure. What Power query editor feature will you use to create a unified dataset?

You are designing a data model for hospital emergency visits. You want to capture patient information like name, address, insurance details, email, and phone number. Which type of table should you store this information?

You have a dataset representing each month (January, February, March) as individual columns. What transformation in the query editor can you use to rearrange the data, making months appear as rows instead of columns?

Which Power BI component allows you to create and manage dataflows?

You imported a data model to Power BI. The mode does not have a date dimension table that is needed to create complex time intelligence calculations. Which of the following tools can you use to create a date dimension table? Select all that apply:

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?

True or False: In Power BI desktop, you can convert a Q&A visual to a fully formatted visual element to display on your report canvas.

What features can you configure in the Q&A feature of Power BI desktop? Select all that apply.

One of your columns in the data model contains information about the mailing address’s city, state, and postal code. You must separate the fields to access the geospatial elements for map visualization. What transformation should you apply?