Free PL-300 Exam Dumps Preview

HOTSPOT

You are profiling data by using Power Query Editor.

The AddressLine2 column in a table named Address is shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

HOTSPOT

You have a Power BI semantic model that contains the following tables.

All the tables use the same data source.

You need to reduce the number of limited relationships in the model by changing the storage mode of certain tables. The solution must NOT affect the latency of the data.

Which storage mode should you select for the Customer and Geography tables? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a Power 81 semantic model that contains a table named Table1. Table1 runs in Import storage mode.

You need to update the model to change the storage mode of Table1 to DirectQuery.

What should you do?

HOTSPOT

You have a Power B1 report that contains the fields shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the

information presented in the graphic.

NOTE: Each correct selection is worth one point.

You have a semantic model named Model1.

You need to ensure that users can verify that the data in Model1 meets corporate standards.

What should you do?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.

You need to create a reference line to show which employees are above the median salary.

Solution: You create a percentile line by using the Salary measure and set the percentile to 50%.

Does this meet the goal?

You have a Power BI model that contains two tables named Sales and Date. The Sales table relates to the Date table by using a many-to-one relationship.

The Sales table contains the following columns:
1. Date
2. Product
3. SalesAmount

You need to create a DAX measure for a rolling 31-day sales total that will return the total sales amount for a selected date and the previous 30 days.

Which DAX expression should you use?

You create a Power BI report named RPT1 that contains sales data. The data contains 10 million rows.
RPT1 contains 15 different visuals.

Users state that RPT1 is slow to load.

You need to investigate the cause of the issue.

What should you use?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have an on-premises data gateway.

You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.

Solution: You decrease the dashboard cache update frequency.

Does this meet the goal?

You use Power BI Desktop to import two tables named Customer and Contacts. The Customer table contains the following columns:

1. Customer_Name
2. Customer ID
3. Website

The Contacts table contains the following columns:
1. Contact ID
2. Contact Email
3. Contact Name
4. Customer Name

A web-based contact form is used to fill the Contacts table. The data is not sanitized.

You need to create a merge for the Customer and Contacts tables.

What should you do?

You have a Power BI semantic model that contains two tables named DimCustomer and FactOrderDetails.

The primary key of DimCustomer is CustomerID.

FactOrderDetails contains a column named CustomerID that can be used to relate to DimCustomer.
Multiple rows in FactOrderDetails possibly have the same CustomerID value.

You need to create a relationship from FactOrderDetails to DimCustomer. The solution must optimize query performance.

What should you create?

DRAG DROP

You create a data model in Power BI.

Report developers and users provide feedback that the data model is too complex.

The model contains the following tables.

The model has the following relationships:

1. There is a one-to-one relationship between Sales_Region and Region_Manager.
2. There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager.
3. There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager.

You need to denormalize the model into a single table. Only managers who are associated to a sales region must be included in the reports.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

HOTSPOT

You import a Microsoft Excel spreadsheet into Power Query Editor and name the query Sales_Spreadsheet.

Sales_Spreadsheet contains the following columns:
1. Customer ID
2. Customer Name
3. Date
4. Total Sales Amount

You plan to use the Sales Spreadsheet query to load two tables named Customer and Sales into the associated semantic model. The tables relate to each other on the Customer ID column of each query. The solution must meet the following requirements:
1. The Customer query must contain the Customer ID and Customer Name columns.
2. The Sales query must contain the Customer ID, Date, and Total Sales Amount columns.
3. Power Query logic must be consolidated to avoid the duplication of logic across the queries and ensure

that only one location is used to update the logic.

You need to identify how to create the Sales query, and what to do to the Sales_Spreadsheet query before loading the model.
What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions

will not appear in the review screen.

You have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains
several Power View sheets.

You need to recreate the Power View sheets as reports in the Power Bl service.

Solution: From the Power Bl service, get the data from SharePoint Online, and then click Connect Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have an on-premises data gateway.

You need to reduce the amount of data sent through the gateway by semantic models that run in import storage mode.

Solution: You increase Automatic page refresh intervals.

Does this meet the goal?

HOTSPOT

You have a Power BI semantic model.

You discover that he semantic model contains values that display as errors.

You need to use data profiling feature in Power Query to preview the date and identify the issues.

What should you select to gain into the number of errors in the model, and what should you select to resolve the errors? To answer, select the appropriate options in the answer area.

NOTE: Each correct answer is worth one point.

You have a Power BI report named Report1. You plan to share Report1 with multiple users.

You need to add the users to a group.

Which two types of groups can you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A business intelligence (Bl) developer creates a dataflow in Power Bl that uses DirectQuery to access tables from an on premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow.

You need to use the dataflow in a report. The solution must meet the following requirements:

1. Minimize online processing operations.
2. Minimize calculation times and render times for visuals.
3. include data from the current year, up to and including the previous day.

What should you do?

HOTSPOT

You are creating a Microsoft Power BI imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.

You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

The related dimension tables are imported into the model.

Sales contains the data shown in the following table.

You are evaluating how to optimize the model.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1.

A user wants to create a report by using the data In DS1 and publish the report to another workspace.

You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user.

What should you do?

You have a Power B1 report that contains one visual You need to provide users with the ability to change the visual type without affecting the view for other users.

What should you do?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the
location within each query definition.

Solution: You modify the source step of the queries to use DataSourceExcel as the file path.

Does this meet the goal?

DRAG DROP

You have a Microsoft Exert spreadsheet named Excel1 that contains survey results.

You have a Power Bl dashboard named DashboardA that has Q&A enabled.

You need to ensure that users who can access DashboardA can ask Questions based on the contents of Excel 1 and pm visuals based on their queries to DashboardA. The solution must minimize development time.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

HOTSPOT

You have an API that returns more than 100 columns. The following is a sample of column names.

1. client_notified_timestamp
2. client_notified_source
3. client_notified_sourceid
4. client_notified_value
5. client_responded_timestamp
6. client_responded_source
7. client_responded_sourceid
8. client_responded_value

You plan to include only a subset of the returned columns. You need to remove any columns that have a suffix of sourceid.

How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a Power BI report named ReportA.

You have a Power BI tenant that allows users to export data.

You need to ensure that consumers of ReportA cannot export any data from visuals.

Which two actions should you perform? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You need to create a visual that compares profit across 10 product categories for a selected quarter.

What is the best visual to use to achieve the goal? More than one answer choice may achieve the goal Select the BEST answer.

HOTSPOT

You need to create a solution to meet the notification requirements of the warehouse shipping department.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct select is worth one point:

HOTSPOT

You are profiling data by using Power Query Editor.

You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

DRAG DROP

In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.

Every Product has a ProductSubCategory.

Not every ProductsubCategory has a parent ProductCategory.

You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.

How should you merge the tables? To answer, drag the appropriate merge types to the correct queries.
Each merge type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

HOTSPOT

You use Power Query Editor to pull data from a Microsoft SharePoint Online list.

You plan to use Advanced Editor to build a Power Query M formula language query.

You need to create a query that loads the data, expands a column named location, and hides a column named CountryOrRegion from the dataset.

How should you complete the query? To answer, select the appropriate options in the answer area.

NOTE: Each correct answer is worth one point.

You have a Power BI report. The report contains a single report page that uses the default theme.

You need to configure the report page to match the formatting shown in the following exhibit.

What should you change on the report page?

You have a Power BI model that contains a table named Expenses. The table contains the following columns:
1. Date
2. Amount
3. Category
4. Expense ID
5. Employee ID

Expenses are recorded by employees, and each expense has a unique expense ID.

You need to create a DAX measure that will calculate the total amount of expenses.

Which DAX expression should you use?

HOTSPOT

You plan to create a Power Bl dataset to analyze attendance at a school. Data will come from two separate views named View1 and View? in an Azure SQL database. View1 contains the columns shown in the following table.

View2 contains the columns shown in the following table.

The views can be related based on the Class ID column.

Class ID is the unique identifier for the specified class, period, teacher, and school year. For example, the

same class can be taught by the same teacher during two different periods, but the class will have a different class ID.

You need to design a star schema data model by using the data in both views. The solution must facilitate the following analysis:

1. The count of classes that occur by period
2. The count of students in attendance by period by day
3. The average number of students attending a class each month

In which table should you include the Teacher First Name and Period Number fields? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

HOTSPOT

You use Power Query Editor to review the query shown in the following exhibit.

Each Region value appears only on the row where it first occurred. Each subsequent occurrence of the Region value is blank.

You need to ensure that every row contains the correct non-blank value. The solution must minimize development effort.

Which column should you select, and which action should you perform on the column? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

HOTSPOT

You are building a financial report by using Power BI.

You have a table named financials that contains a column named Date and a column named Sales.

You need to create a measure that calculates the relative change in sales as compared to the previous quarter.

How should you complete the measure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a Power BI semantic model that connects to a streaming data source. The data source is updated frequently.

You need to create a Power BI report that meets the following requirements:
1. Supports real-time analytics
2. Minimizes performance impact on the data source
3. Displays the most recent data without performing a data refresh

Which connectivity mode should you use for the dataset?

HOTSPOT

You have a semantic model that contains a table named Sales.

The table contains the following columns:

1. Order ID
2. Product ID
3. Sales Dote
4. Sales Amount

You need to create a DAX measure that will return the total sales amount for the same dates from the previous year. How should you complete the measure? To answer, select the appropriate options m the answer area.

NOTE: Each correct selection is worth one point.

You plan to use Power Bl Desktop to create a bog tracking dashboard that will pull data from Analytics in Azure DevOps.

From Power Bl Desktop, you need to configure a data connector to authenticate to Azure DevOps. The solution must meet the following requirements:

1. Use Analytics views.
2. Filter data from the cloud.

Which connector should you use?

You have the tables shown in the following table.

The Impressions table contains approximately 30 million records per month.

You need to create an ad analytics system to meet the following requirements:

1. Present ad impression counts for the day, campaign, and Site_name.
2. The analytics for the last year are required.
3. Minimize the data model size.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You have a Power Bl report hosted on powerbi.com that displays expenses by department for department managers.

The report contains a line chart that shows expenses by month.

You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort.

What should you do?

What is the minimum number of datasets and storage modes required to support the reports?
(What is the minimum number of Power BI datasets needed to support the reports?
)

You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique.

In powerbi.com, when users load the visual, they only see some of the customers.

What is the cause of the issue?

You plan to generate a line chart to visualize and compare the last six months of sales data for two departments.

You need to increase the accessibility of the visual.

What should you do?

You need to configure access for the sales department users.

The solution must me meet the security requirements.

What should you do?

You have a Power BI semantic model named Model1 that runs in Import storage mode.

You need to reduce the size of Model1. The solution must NOT increase report query response times.

What should you do?

HOTSPOT

You have a Fabric workspace that contains the items shown in the following table.

You need to make content available to the management department and the accounting department at your company.

The solution must meet the following requirements:

1. The management department must have view access to the Headcount and Department Expenses reports.
2. The management department must NOT be able to view any other current or future reports.
3. The management department must NOT be able to build new reports by using the semantic models.
4. The accounting department must only be able to view the Company Expenses report.
5. The accounting department must be able to build new reports by using the Expenses semantic model.

The solution must follow the principle of least privilege and minimize administrative effort.

How should you make the content available to the users in each department? To answer, select the appropriate options in the answer area.

NOTE: Each collect selection is worth one point.

HOTSPOT

You have a Power BI semantic model named ModelA that contains the following columns:

All of the columns use the Text data type.

Based on the model, you create a report named ReportA that contains the following columns:
1. OrderID
2. OrderDate
3. CustomerID
4. ShippingAddress

ReportA is the only report connected to ModelA.
You discover that ReportA has performance issues caused by the size of ModelA.

What should you do to optimize and reduce the size of ModelA? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

HOTSPOT

You have a report in Power BI Desktop.

You add a key influencers visual as shown in the exhibit. (Click the Exhibit tab.)

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a Microsoft Power BI dashboard.

Which type of tile should you add?

HOTSPOT

You need to create a measure that returns the percent of revenue by product category.

How should you complete the measure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

HOTSPOT

You are creating an analytics report that will consume data from the tables shown in the following table.

There is a relationship between the tables.

There are no reporting requirements on employee_id and employee_photo.

You need to optimize the data model.

What should you configure for employee_id and employee_photo? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You plan to create the chart shown in the following exhibit.

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

HOTSPOT

You have a column named UnitsInStock as shown in the following exhibit.

UnitsInStock has 75 non-null values, of which 51 are unique.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

You have a Power Bl semantic model named Model! that contains two fields named Sales and Quarter.
Model 1 contains a DAX measure that sums the Sales column.

You need to create a report that will contain the visual shown in the following exhibit.

The solution must NOT require additional DAX measures.

Which type of visual should you use?

HOTSPOT

You have a semantic model that has the relationships shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

You are creating a dashboard by using the Power Bl service.

You have an existing report page that contains three charts.

You need to add the charts to the dashboard while maintaining the interactivity between the charts.

What should you do?

You have a Power BI report that contains a card. The card displays the value for year-to-date revenue.

You need to ensure that screen reader users can read the value when initially interacting with the card.
The value must stay updated as the dataset is refreshed.

What should you do?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table.

Solution: You add a WHERE clause to the SQL statement.

Does this meet the goal?

HOTSPOT

You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.
You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

The related dimension tables are imported into the model.

Sales contains the data shown in the following table.

HOTSPOT

You use Power Query Editor to review a query that contains a column named Country.

You need to view the following information in the Data preview view for the Country column:
1. The percentage of values that contain errors.
2. The count of empty values.

What should you enable? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

HOTSPOT

You have a Power BI semantic model that contains three tables named Products, OrderHistory, and Date.
The Products table is a dimension table that contains the following columns:
1. ProductID
2. ProductName

The OrderHistory table is a fact table that contains the following columns:
1. OrderID
2. ProductID
3. OrderDate

The Date table is a dimension table that contains the following columns:
1. Year
2. Date
3. Week
4. Month

You need to define a relationship from Products to OrderHistory and from OrderHistory to Date.

Which cardinality should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct answer is worth one point.

HOTSPOT

You use Power Query Editor to preview the data shown in the following exhibit.

You confirm that the data will always start on row 3, and row 3 will always contain the column names.

How should you shape the query? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a Power Bl workspace named Inventory that contains a dataset a report and a dashboard.
You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report.
Which of following two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

HOTSPOT

You have a Fabric workspace that contains the items shown in the following table.

You need to make content available to the management department and the accounting department at your company. The solution must meet the following requirements:
1. The management department must have view access to the Headcount and Department Expenses reports.
2. The management department must NOT be able to view any other current or future reports.
3. The management department must NOT be able to build new reports by using the semantic models.
4. The accounting department must only be able to view the Company Expenses report.
5. The accounting department must be able to build new reports by using the Expenses semantic model.

The solution must follow the principle of least privilege and minimize administrative effort.

How should you make the content available to the users in each department? To answer, select the appropriate options in the answer area.

NOTE: Each collect selection is worth one point.

DRAG DROP

You have the Power Bl data model shown in the following exhibit.

You create two row-level security (RlS) roles named Manager and CFO.

You plan to publish the dataset to the Power Bl service.

You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:

1. Each manager must see only the data in the Sales and Human Resources tables for their own country.
2. The CFO must be prevented from seeing the data in the Human Resources table.
3. The CFO must see the sales data of all countries.

How should you complete the DAX expressions to meet the requirements? To answer, drag the

appropriate expressions to the correct targets. Each expression may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

The Country table contains the following data.

You plan to publish the dataset to the Power Bl service.

You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:

1. Each manager must see only the data in the Sales and Human Resources tables for their own country.
2. The CFO must be prevented from seeing the data in the Human Resources table.
3. The CFO must see the sales data of all countries.

How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

HOTSPOT

You need to create a visualization to meet the reporting requirements of the sales managers.

How should create the Visualization? TO answer, select the appropriate options in the answer area.

DRAG DROP

You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.

The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.

You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.

How should you complete the calculation? To answer, drag the appropriate values to the correct targets.
Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

DRAG DROP

You have a Power BI semantic model.

You need to configure row-level security (RLS) to restrict data access for users that have the Viewer permissions.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

You need to create a Power BI theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting.

What should you do?

You have the visual shown in the exhibit. (Click the Exhibit tab.)

You need to show the relationship between Total Cost and Total Sales over time.

What should you do?

You have a PBiX file that imports several tables from an Azure SQL database.

The data will be migrated to another Azure SQL database.

You need to change the connections in the PBIX file. The solution must minimize administrative effort.

What should you do?

You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success.

Which type of visualization should you use?

HOTSPOT

You create a Power Bl dataset that contains the table shown in the following exhibit.

You need to make the table available as an organizational data type In Microsoft Excel.

How should you configure the properties of the table? To answer select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DRAG DROP

You build a report about warehouse inventory data. The dataset has more than 10 million product records from 200 warehouses worldwide.

You have a table named Products that contains the columns shown in the following table.

Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.

You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.

You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.

What should you recommend?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.

During the development process, you need to import a sample of the data from the Order table.

Solution: From Power Query Editor, you import the table and then add a filter step to the query.

Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

From Power Query Editor, you profile the data shown in the following exhibit.

The IoT GUID and IoT ID columns are unique to each row in query.

You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.

Solution: You remove the loT GUID column and retain the loT ID column.

Does this meet the goal?

HOTSPOT

You have a Power BI report that contains the table visual shown in the following exhibit.

You need to modify the visual to display as shown in the following exhibit.

How should you configure the visual? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You plan to use Power B1 to create sales invoices for customers. The solution must meet the following requirements:

1. Sales invoices must be exported in a PDF format
2. The PDF exports must show all columns and rows clearly.

What should you create?

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.

You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.

What should you do?

HOTSPOT

You have a Power BI report that contains the visual shown in the following exhibit.

You plan to modify the visual by changing the column spacing and adding percent change labels as shown in the following exhibit.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DRAG DROP

You plan to create a report that will display sales data from the last year for multiple regions

You need to restrict access to individual rows of the data on a per region-basis by using roles.

Which four actions should you perform in sequence?

To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.