PL-300 Readiness

1. You are working with a project management application that is fully hosted within Microsoft Teams. The application was built using Microsoft Power Apps.

You need to create a Power BI report that retrieves data directly from this application. Which Power BI connector should you use?

2. A sales report has already been published in Power BI. The report uses imported data from an Excel file stored in a SharePoint folder, and the model includes multiple existing measures.

You need to build a new Power BI report using the same data and measures, while keeping the work required to a minimum. Which data source should you connect to?

3. You loaded two Excel tables into Power Query: Customer and Address.

Customer includes:
Customer ID
Customer Name
Phone
Email Address
Address ID

Address includes:
Address ID
Address Line 1
Address Line 2
City
State/Region
Country
Postal Code

Each Customer ID is unique in the Customer table, and each Address ID is unique in the Address table.

You need to produce a single query with one record per customer, and each record must include the customer’s City, State/Region, and Country. What should you do?

4. You are developing a Power BI report using data from an Azure SQL database called erp1.

You load the following tables into the model:
Products (product catalog details)
Orders (order-level summary information)
Order Line Items (product ID, quantity, and pricing details per order)

You need the report to support these analyses:
Trend reporting of orders over time, including a measure for total order amount
Analysis of orders by product characteristics

To ensure the report visuals respond as quickly as possible, you want to reduce the work done at query time.

What should you do first?

5. A SharePoint Online site contains multiple document libraries. One of these libraries stores manufacturing reports as Excel workbooks, and every report follows the same table/layout structure.

In Power BI Desktop, you want to load only those manufacturing report files into a single table for analysis.

What should you do?

6. You are working with a CSV file that stores customer complaints. One of the columns, Logged, records the date and time when each complaint was submitted.

The values in the Logged column follow this format:
2018-12-31 at 08:59

You want to analyze complaints by date in Power BI and take advantage of the built-in date hierarchy.

What should you do?

7. An Excel workbook is stored in a OneDrive folder. You need to load the workbook into a Power BI dataset.

The dataset must be able to support scheduled refresh in the Power BI service (powerbi.com).

Which two connectors can you use to connect to the file?
(Select two. Each correct option is a complete solution.)

8. An Azure SQL database stores sales transaction records and is updated on a continuous basis.

You need to build reports that can identify potential fraud, and the reports must reflect new or changed data within five minutes of it being written to the database.

How should you configure the Power BI data connection?

9. A BI developer has built a Power BI dataflow that connects to tables in an on-premises SQL Server using DirectQuery. The Enhanced Dataflows Compute Engine is enabled.

You need to use this dataflow in a Power BI report, and the solution must:
Reduce reliance on online query processing
Provide fast calculations and quick visual rendering
Include only records from the current year, up to and including yesterday

What should you do?

10. You are trying to connect Power BI Desktop to a Cassandra database. When reviewing the available Get Data connectors, you notice that there is no dedicated Cassandra connector.

You need to choose an alternative connector that will allow Power BI to connect to the database.

Which connector should you use?

11. You are preparing a Country dimension table for use in a star schema.
The source data includes two columns: Country and City, with multiple cities listed under the same country.

Your goal is to create a dimension table that contains only one row per country, with no duplicate country values.

Which two actions should you take to achieve this result?

Select two answers. Each correct answer represents part of the solution.

12. While running a query in Power Query Editor, you encounter the following error message:

Datasource.Error: Could not find file

Which two scenarios could cause this error to occur? Select two answers. Each correct option represents a valid cause.

13. An Excel worksheet contains product data with the columns SKU, price, and discount.
Several rows in the discount column display error values (for example, calculation or reference errors).

You need to clean the data using Power Query Editor so that:
Any error in the discount column is replaced with a value of 0.05
No rows are removed from the dataset
The solution requires minimal maintenance and configuration

What should you do in Power Query Editor?

14. You’re working with a CSV that logs customer complaints. One column, Logged, stores both the date and time of each complaint in this format:

2018-12-31 at 08:59

You want to report on complaints by date and use Power BI’s built-in date hierarchy.

What should you do?

15. You load two tables from an Azure SQL database into Power Query: Order Header and Order Details. The two tables are related through a shared column called Order ID.

You want to create one query that combines both tables so that it includes the distinct columns from each table.

Which option should you choose in Power Query Editor?

16. A Power BI Desktop (PBIX) file imports data from an Excel workbook located on a local network file share. You are informed that the Excel file has been moved to a different folder or location.

You need to update the PBIX file so that it connects to the new file location.

Which three actions can you use to update the connection successfully? Select three answers. Each correct answer represents a complete solution.

17. Northwind Traders is a specialty food importer that has recently adopted Power BI to improve reporting and analytics.

Currently, the sales team depends on the IT department to create reports using SQL Server Reporting Services (SSRS). This process is slow and often results in reports that do not fully meet business needs.

Existing Environment

Data is sourced from:
An Azure SQL Database containing sales, product, supplier, category, order, and employee data
A daily-exported Excel file stored in SharePoint Online
Historical data must be retained for the current year and the previous three years

Reporting Requirements

The organization needs the following reports:
Top Customers
Top Products
On-Time Shipping

These reports must support filtering by time period, sales region, and product category, and must provide fast interaction performance for users.

Technical and Security Requirements
A single dataset must support all reports
All reports must be hosted in one Power BI workspace
Data must be refreshed daily and be current by 7:00 AM Pacific Time
The data model should be as small as possible while still meeting reporting needs
Row-level security (RLS) must be applied to restrict sales users to their assigned regions

Access is controlled using Azure AD security groups

Question

You need to design the semantic model for this solution.
Which storage mode should you use for the tables in the semantic model?

18. You want to build a bug tracking dashboard in Power BI Desktop using data from Azure DevOps Analytics.

You need to set up a connector that can:
Authenticate to Azure DevOps
Work with Analytics views
Apply filtering at the source (in the cloud)

Which connector should you choose?

19. Note: This question belongs to a scenario-based question set. Each question proposes a different solution approach. Some questions may have more than one valid solution, while others may not.
Once you submit your answer, you cannot return to this question.

You are working with a DirectQuery Power BI semantic model connected to a data source that includes a case-sensitive column.

After connecting to the model, you notice that the column contains errors and undefined values.

You consider addressing the issue by implicitly converting the column values to the required data type.

Does this approach resolve the problem?

20. Note: This item is part of a multi-question scenario. Each question proposes a different fix for the same situation. After you submit your response, you won’t be able to revisit this question.

You have a DirectQuery Power BI semantic model connected to a data source that includes a case-sensitive column.

After connecting, you notice the model contains errors and unrecognized/undefined values.

Proposed solution: Switch the semantic model to a different mode (change the model mode).

Does this solution resolve the issue?

21. Note: This question is part of a scenario-based series. Each item suggests a different possible fix. Once you answer, you can’t return to it.

A data source includes a column where values are case-sensitive (uppercase/lowercase differences matter).
Your Power BI semantic model uses DirectQuery.

After connecting, you notice the model shows errors and unrecognized/undefined values.

Proposed solution: Standardize the text casing (for example, convert everything to upper or lower case) in the source query or in Power Query Editor.

Does this solution achieve the goal?

22. Note: This question is part of a multi-question scenario. Each question proposes a different potential fix. Once you submit your answer, you cannot return to this question.

You are working with a Power BI semantic model that uses DirectQuery.
The underlying data source includes a column with case-sensitive values.

After connecting to the model, you notice errors and undefined values in the data.

Proposed solution: Add an index column and standardize the text casing (for example, convert all values to upper or lower case) in the data source.

Does this solution resolve the issue?

23. An Excel workbook is stored in a OneDrive location. You need to load this file into a Power BI semantic model.

The semantic model must support scheduled refresh in the Power BI service (powerbi.com).

Which two data connectors can you use to connect to the file and meet this requirement?

Select two answers. Each correct option represents a complete solution.

24. While reviewing data in Power Query Editor, you examine a column named Date that contains full date values (day, month, and year), as shown in the preview.

You want to modify this column so that it contains only the year value.
The solution should require the least possible configuration and maintenance.

What should you do?

25. In Power BI Desktop, you import two tables: Customer and Contacts.

Customer includes:
Customer_Name
Customer ID
Website

Contacts includes:
Contact ID
Contact Email
Contact Name
Customer Name

The Contacts table is populated through an online contact form, and the entries may contain inconsistencies (for example, spelling differences, extra spaces, or variations in formatting) because the input data is not cleaned.

You need to merge the Customer and Contacts tables.

What should you do?

26. You have a Power BI Desktop report named Report1 that connects to an Azure SQL Database.

Another user, User1, wants to create their own Power BI report using the same data source. You want to make it easier for User1 to connect to that data source without recreating the connection details manually.

Which type of file should you create to simplify the data source connection?

27. You are building a Power BI semantic model (Model1) that connects to an Azure SQL database (DB1).
The semantic model must reflect data changes within two minutes after updates occur in the database.

Which connectivity mode should you use?

28. A Power BI report contains a very large Invoice table (12 million rows from the last three months) and several small dimension tables (Product, Sales Person, Calendar, Customer).

For the past three days, dataset refresh has failed with this error:
“You have reached the maximum allowable memory allocation for your tier.”

You must:
Fix the refresh failure caused by memory limits
Keep query response times fast for report users

What is the best solution?

29. You have a table called DIMCountries that includes a column named Country, as shown in the exhibit.
Some country names appear more than once because they use different letter casing (for example, uppercase and lowercase).

You plan to use DIMCountries as a dimension table in a Power BI report.

To ensure that the Country column contains only one unique entry per country, which two actions should you apply to the Country column?

Select two.

30. You are building a report in Power BI Desktop and have loaded a dataset that contains a free-text column called col1.

You want to analyze how often different text lengths occur in col1 (for example, how many values have 5 characters, 10 characters, and so on).
The solution must not increase the size of the data model.

What should you do?

31. You manage several Power BI reports used by the HR department.
The datasets behind these reports use row-level security (RLS) to restrict data by sales region.

Each sales region has an HR manager, and you must ensure that:
HR managers can view and interact only with data from their own region
HR managers cannot modify report layouts (for example, edit visuals or structure)

What is the best way to provide access to the reports for the HR managers?

32. You need to give a user permission to add other users to a Power BI workspace.
At the same time, you must follow the principle of least privilege, meaning the user should receive only the minimum permissions required to perform this task.

Which workspace role should you assign?

33. You have a Power BI query named Sales that loads several columns, including dates and status fields.

Key details:
Users only analyze completed (Finished) sales
Users only need the date portion of the sales date (not the time)
You want to reduce query load times
The solution must not change the analytical results

Which two actions should you take to meet these requirements?

Select two.

34. You are creating a Power BI report to analyze customer transactions.
The source database includes two tables:

Customer – contains one record per customer
Transaction – contains multiple records per customer, representing individual transactions

You import both tables into Power BI.

Which relationship type and direction should you configure between the two tables?

35. You are using a custom connector that retrieves email metadata for the past year, including the following fields:

ID
From
To
Subject
Body
Has Attachments

The dataset contains more than 10 million records.
You create a Power BI report to analyze email communication patterns between employees (who emails whom).

You must ensure that:
Report users cannot read the email contents
The size of the data model is kept as small as possible

What should you do?

36. You have a Power BI semantic model like the one shown in the diagram.
Each manager is responsible for exactly one country.

You need to implement row-level security (RLS) with the following goals:
Managers can view only the data for their own country
The solution should use the fewest possible RLS roles

Which two actions should you take to meet these requirements?

Select two.

37. You have a Power BI report with a PBIX size of 550 MB, published to an App workspace in shared capacity (powerbi.com).
The report uses an Import dataset with a single fact table containing 12 million rows, refreshed twice daily (8:00 AM and 5:00 PM).

The report has one page that includes:
15 AppSource custom visuals
10 built-in visuals

Users report that the page is slow to load and feels laggy when interacting with visuals.

What is the best recommendation to improve report performance?

38. A Power BI data model includes three tables: Orders, Date, and City.
There is a one-to-many relationship from Date → Orders and from City → Orders.

The model has two RLS roles:
Role1 applies this filter:
City[State Province] = “Kentucky”

Role2 applies this filter:
Date[Calendar Year] = 2020

If a user is assigned to both Role1 and Role2, what data will the user be able to see in a report?

39. This question is part of a scenario-based series. Each question proposes a different solution that may or may not meet the stated objective.

You are building a Power BI data model that includes a very large SQL Server table named Order containing over 100 million rows.

During development, you only want to work with a small sample of the data from the Order table.

Proposed solution:
You import the entire table into Power Query Editor and then apply a filter step to limit the rows.

Does this solution meet the goal?

40. This question is part of a scenario-based series. Each question proposes a different solution that may or may not achieve the stated objective.

You are developing a Power BI data model that includes a very large SQL Server table named Order with more than 100 million rows.

During development, you want to import only a sample of the data from the Order table to work more efficiently.

Proposed solution:
You create a DAX expression that uses the FILTER function to limit the data.

Does this solution meet the goal?

41. This question is part of a scenario-based series where each proposed solution must be evaluated independently.

You are developing a Power BI data model that includes a very large SQL Server table named Order with over 100 million rows.

During the development phase, you want to import only a subset (sample) of the data from the Order table to improve performance and speed up development.

Proposed solution:
You modify the SQL query used to retrieve the data by adding a WHERE clause to limit the rows returned.

Does this solution meet the goal?

42. You are working with a Power BI data model similar to the one shown in the exhibit.
The Departments table contains four departments.

You must make sure that each user can view data only for their own department.
What is the correct approach?

43. You are designing a Power BI Desktop report that includes two tables, and row-level security (RLS) is already configured on both of them.

You need to create a relationship between these tables so that:
Bidirectional cross-filtering works correctly, and
RLS rules are fully respected and enforced across both tables.

What should you do?

44. You have several tables, including an Impressions table that grows by about 30 million rows every month.

You need to build an ad analytics model that can:
Show daily impression counts by campaign and site_name
Support reporting for the last 12 months
Keep the data model as small as possible

Which two actions should you take?

45. You import a Power BI dataset that contains the following tables:
Date
Product
Product Inventory

The Product Inventory table is very large, containing 25 million rows.
It is related to:
Date via DateKey
Product via ProductKey

You want to reduce the size of the data model while preserving all analytical value (that is, without losing any meaningful information needed for reporting).

What should you do?

46. This question is part of a scenario-based series. Each question evaluates whether a proposed solution meets a specific goal.

You are building a Power BI data model that includes a very large SQL Server table named Order with more than 100 million rows.

During development, you want to work with only a sample of the data from the Order table to improve performance and speed up modeling.

Proposed solution:
You apply a report-level filter that restricts the data based on the order date.

Does this solution meet the goal?

47. This question is part of a scenario-based series. Each proposed solution must be evaluated independently.

You have a Power BI report that imports data from an Azure SQL database, including:
A Date table
A Sales table

The Sales table contains multiple date foreign keys:
Due Date
Order Date
Delivery Date

You need to enable time-based analysis of sales using all three date columns.

Proposed solution:
You create inactive relationships between the Sales table and the Date table for each date foreign key.

Does this solution meet the goal?

48. This question is part of a scenario-based series. Each question evaluates whether a proposed solution meets the stated requirement.

You have a Power BI report that imports data from an Azure SQL database, including:
A Date table
A Sales table

The Sales table contains multiple date foreign keys:
Due Date
Order Date
Delivery Date

You need to enable time-based analysis of sales using all three date columns.

Proposed solution:
In Power Query Editor, you rename the Date query to Due Date, then reference it twice to create separate queries for Order Date and Delivery Date.

Does this solution meet the goal?

49. This question is part of a scenario-based series. Each question evaluates whether a proposed solution satisfies the stated requirement.

You have a Power BI report that imports data from an Azure SQL database, including:
A Date table
A Sales table

The Sales table contains multiple date foreign keys:
Due Date
Order Date
Delivery Date

You must support time-based sales analysis using all three date columns.

Proposed solution:
From the Fields pane, you rename the Date table to Due Date, then use DAX to create two additional calculated tables for Order Date and Delivery Date.

Does this solution meet the goal?

50. You are building a Power BI data model that includes a table named Store with location-related fields.

You plan to create a map visual that displays store locations and allows users to drill down geographically from:
Country
to State/Province
to City

What should you do to ensure that Power BI correctly interprets and maps these location fields?

51. You’re building a Power BI data model for a report.
Your source data includes a single combined column called Machine-User (formatted as shown in the table).

You need to produce a clustered bar chart like the one in the exhibit, which requires Machine and User to be treated as separate fields.

What should you do?

52. You are working with a Power BI report that imports a date table and a sales table from an Azure SQL database.
The sales table includes the following date fields
Due Date
Order Date
Delivery Date

You need to enable time-based analysis of sales using all three date fields.

Proposed solution:
Create measures that use the USERELATIONSHIP DAX function to filter sales using the active relationship between the sales table and the date table.

Does this solution meet the requirement?

53. You are working with a Power BI report created for the procurement team.
The report uses data from multiple tables, including Suppliers and LineItems, which are linked by a one-to-many relationship using ID and Supplier ID.

Several visuals in the report depend on this data.
You want to reduce the overall dataset size while ensuring that the existing visuals continue to work exactly as they do now.

What action should you take?

54. You are working on a Power BI report for the marketing team that analyzes blog website traffic. The report uses data from two tables: Posts and Traffic.

A one-to-many relationship exists between Posts[URL] and Traffic[URL Visited]. The report includes several visuals based on this data, but the dataset refresh process is taking too long.

You need to update the Posts and Traffic queries to improve refresh performance.

Which two actions should you take to reduce the load time? Each correct answer represents part of the solution.

55. You are working with a Power BI data model like the one shown in the exhibit.

The Sales table stores daily sales records covering the past five years up to the current date.

You want to create a measure that returns total sales for March 2021 when March 2022 is selected in the report.

Which DAX expression should you use?

56. You are using Power BI Desktop to load data from a Microsoft SQL Server database.

While the data is loading, an error message appears indicating a problem with the query execution.

You need to fix the issue so the data can load successfully.

Which two actions can resolve the problem? Each correct answer represents a complete solution.

57. This question is part of a scenario-based series. Each question proposes a different solution that may or may not satisfy the stated requirements.

Once you answer this question, you cannot return to it.

In Power Query Editor, you are reviewing the data profile shown in the exhibit.

The IoT GUID and IoT ID columns contain unique values for every row.

You need to analyze IoT events by hour and by day of the year, while also improving dataset performance.

Proposed solution:
You split the IoT DateTime column into two separate columns: Date and Time.

Does this solution meet the requirement?

58. This question is part of a scenario-based series. Each question suggests a different solution that may or may not satisfy the stated objectives.

After answering this question, you will not be able to revisit it.

In Power Query Editor, you are reviewing the data profile shown in the exhibit.

The IoT GUID and IoT ID columns both contain unique values for every row.

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

Proposed solution:
You remove the IoT GUID column and keep the IoT ID column.

Does this solution meet the requirement?

59. This question belongs to a series based on the same scenario. Each question proposes a different solution that may or may not satisfy the stated objectives.

Once you submit your answer, you cannot return to this question.

In Power Query Editor, you are reviewing the data profile shown in the exhibit.

Both the IoT GUID and IoT ID columns contain unique values for each row.

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

Proposed solution:
You change the IoT DateTime column to use the Date data type.

Does this solution meet the requirement?

60. You are working with a Power BI report that has a PBIX size of 550 MB and is published to an App workspace in shared capacity on PowerBI.com.

The report uses an imported dataset containing a single fact table with 12 million rows. The dataset refreshes twice daily at 8:00 AM and 5:00 PM.

The report consists of one page with 15 AppSource visuals and 10 built-in visuals.
Users report that the visuals load slowly when they open and interact with the report.

You need to recommend a way to improve report performance.

What should you recommend?

61. You have a CSV file that stores user complaints. One of the columns is named Logged, which records the date and time when each complaint was logged.

The Logged column is stored in the following text format:

2018-12-31 at 08:59

You need to analyze complaints by date and use Power BI’s built-in date hierarchy (Year, Quarter, Month, Day).

What should you do?

62. Note: This question is part of a multi-question scenario. Each question suggests a different solution that may or may not meet the requirements. Once you answer, you can’t go back to review it.

In Power Query Editor, you review a dataset (shown in an exhibit). The columns IoT GUID and IoT ID contain values that are unique for every single row.

You need to:
Analyze IoT events by hour and by day of the year
Use a solution that improves dataset performance

Proposed solution:
You add a custom column that combines (concatenates) IoT GUID + IoT ID into one column, then you delete the original IoT GUID and IoT ID columns.

Does this solution meet the goal?

63. You have a Power BI data model with a table named Employee.
Each record represents an employee, and the ParentEmployeeID column identifies that employee’s direct manager.

The organizational structure forms a hierarchy where:

Each employee reports to one manager

All reporting chains eventually lead to the CEO at the top

You need to create a calculated column that returns the number of hierarchy levels from each employee up to the CEO.

Which DAX expression should you use?

64. You have a Microsoft Power BI report with the following characteristics:
The PBIX file size is 550 MB
The report is published to an App workspace in shared capacity on PowerBI.com
The report uses an Import mode dataset
The dataset contains one fact table with 12 million rows
The dataset refreshes twice daily at 08:00 and 17:00

The report has one page with:
15 AppSource visuals
10 built-in (default) visuals

Users report that the visuals load slowly when opening and interacting with the report

You need to recommend a solution that will improve report performance.

What should you recommend?

65. You are using Power Query Editor to preview a query that contains sales order data with the following columns:
Tax Amount
Sales Order ID
Freight Amount
Subtotal Amount
Total Item Quantity

Key details:
Sales Order ID uniquely identifies each order
Subtotal Amount and Total Item Quantity are always populated
Tax Amount and Freight Amount may be null when an order has no associated charge

You need to prepare the data so you can calculate the following monthly metrics:
Average item quantity per order
Average freight amount per order
Maximum item quantity per order

How should you modify the query?

66. You have a Power BI data model with a table named Employees that includes the following columns:
Employee ID (unique identifier)
First Name
Last Name
Department
Salary

You need to create a DAX measure that calculates the average salary of all employees who work in the Sales department.

Which DAX expression should you use?

67. You have a Power BI data model that includes a table named Employees with the following columns:
Employee Name
Email Address
Start Date
Job Title

You are configuring dynamic row-level security (RLS).

The security rules must meet these requirements:
Each user can see only their own employee record
The DAX expression must work correctly in both Power BI Desktop and the Power BI service

Which table filter expression should you use?

68. You have a Power BI data model that imports data from a Microsoft Excel file.
Using Power Query, you load a query that includes renamed columns and custom columns.

Later, when you try to refresh the query, you receive the following error message:
Expression.Error: The column ‘Category’ of the table wasn’t found.

Which two of the following could have caused this error?

69. You have a Power BI data model with a table named Sales that includes the following columns:
Order Line ID
Product ID
Unit Price
Order ID
Quantity

Important details:
Each Order ID represents one order
An order can contain multiple order lines
Each order line within an order has a different Product ID
You need to create a DAX measure that correctly returns the number of orders.

Which DAX expression should you use?

70. In Power Query Editor, you have a query named Sales Data that contains sales-related columns.

You need to create two new queries from this source:
Product Dimension
Sales Fact

The solution must:
Minimize maintenance effort
Minimize the size of the dataset

Which two actions should you perform?

71. You have a Power BI data model with a table named Date that contains the following columns:
Date
Fiscal Year
Fiscal Quarter
Month Name
Calendar Year
Week Number
Month Number
Calendar Quarter

You need to create a calculated table derived from the Date table.

The calculated table must include only unique combinations of the following fields:
Calendar Year
Calendar Quarter
Calendar Month

Which DAX function should you include in the calculated table definition?

72. You are using Power Query Editor to import and preview sales data for the years 2020 and 2021 from a Microsoft Excel file (as shown in the exhibit).

The data is currently structured with years as separate columns.

You need to reshape the data so that the query outputs exactly three columns:
Month
Sales
Year

What should you select in Power Query Editor to achieve this result?

73. Note: This question is part of a scenario-based series. Each question proposes a different solution that may or may not satisfy the stated requirements. Once answered, you cannot return to review this question.

You have a Power BI report that imports data from an Azure SQL Database.
The model includes:
A Date table
A Sales table

The Sales table contains three date foreign key columns:
Due Date
Order Date
Delivery Date

You need to enable sales analysis over time using all three dates simultaneously.

Proposed solution:
Rename the existing Date table to Due Date

Create two calculated date tables using DAX:
Order Date
Delivery Date

Create active relationships between the Sales table and each of the three date tables

Does this solution meet the goal?

74. You have a Power BI data model that includes:

A Date table related to a Sales table by the Date column

An existing measure:
Total Sales = SUM(Sales[Sale])

You need to create another measure named Previous Quarter that returns the total sales for the quarter immediately before the currently selected period.

Which DAX calculation should you use?

75. You have a Power BI data model with two tables:
Sales
Date

The Sales table contains the following measures:
Order Quantity
Product Cost
Sales Amount

You need to create the visual shown in the exhibit, which displays these measures together.

In which section of the Fields well should you place the measures?

76. You are reviewing a Power BI data model that includes a calculated table defined by the following DAX expression:

ProductList = INTERSECT(ProductsGroupA, ProductsGroupB )

You need to determine which rows are returned in the ProductList table.

Which rows will be included?

77. Note: This question is part of a scenario-based series. Each question proposes a different solution that may or may not meet the stated goals. Once you answer, you cannot return to review this question.

You have a Power BI report that imports data from an Azure SQL Database.
The model includes:
A Date table
A Sales table

The Sales table contains three date foreign key columns:
Due Date
Order Date
Delivery Date

You need to enable analysis of sales over time using all three date columns.

Proposed solution:
You create measures that use the USERELATIONSHIP() DAX function to activate the inactive relationships between the Sales table and the Date table when required.

Does this solution meet the goal?

78. Note: This question is part of a scenario-based series. Each question presents a different solution that may or may not meet the stated requirement. Once answered, you cannot return to review this question.

You have a Power BI report that imports data from an Azure SQL Database.
The model includes:
A Date table
A Sales table

The Sales table contains three date foreign key columns:
Due Date
Order Date
Delivery Date

You need to enable analysis of sales over time using all three date columns.

Proposed solution:
Rename the existing Date table to Due Date

Create two additional calculated date tables using DAX:
Order Date
Delivery Date

Create active relationships between the Sales table and each date table

Does this solution meet the goal?

79. You have a Power BI semantic model that includes data for:
Item
Price
Country

The data is displayed in a report that already uses filters (for example, slicers by country or item).

You need to calculate the average item price for a selected country, and the calculation must respect all existing filters in the report.

Which type of Quick Measure should you use?

80. You have a Power BI semantic model that includes four queries:
Query1
Query2
Query3
Query4

Query1 loads customer data into the model and is referenced by the other three queries.

You notice that data refresh is slow, and you need to improve refresh performance while minimizing costs.

What should you do?

81. You have a Power BI semantic model that connects to a streaming data source which updates very frequently.

You need to build a Power BI report that satisfies all of the following requirements:

Supports real-time analytics

Minimizes performance impact on the source system

Shows the most recent data instantly, without requiring a dataset refresh

Which connectivity mode should you use for the dataset?

82. You have a Power BI report named Summary1 and notice that it is slow to load or interact with.

To investigate, you run Performance Analyzer in Power BI Desktop to review performance metrics for the report.

Which two metrics in Performance Analyzer show the execution duration (time taken)?

NOTE: Each correct answer is worth one point.

83. You have a Microsoft 365 subscription that includes several resources (as shown in an exhibit).

You create a new Power BI dashboard that uses row-level security (RLS) and define a new security role named Consultants.

You need to assign the Consultants role to an appropriate resource.

To which resource can you assign the Consultants role?

84. You have a Power BI data model with two tables:
Sales
Date

The Sales table is related to the Date table using a many-to-one relationship and contains the following columns:
Date
Product
SalesAmount

You need to create a DAX measure that calculates a rolling 31-day total of sales, meaning:
It returns the total SalesAmount for the selected date

Plus the previous 30 days

Which DAX expression should you use?

85. You publish a Power BI semantic model to the Power BI service.
The model connects to the following data sources:

Source1: A Microsoft Excel file stored in Microsoft OneDrive for Business

Source2: An Azure SQL Database hosted on a virtual network (VNet)

Source3: A public website

You need to determine which data source requires an on-premises data gateway.

Which option is correct?

86. You have a Power BI semantic model built with two queries.
A report that uses this model is experiencing performance issues.

You plan to optimize performance by reducing the amount of data loaded into the model using Power Query.

Which two actions should you perform?

NOTE: Each correct answer is worth one point.

87. Note: This question is part of a scenario-based series. Each question proposes a different solution that may or may not meet the stated goal. Once answered, you cannot return to review it.

You have an on-premises data gateway.
You want to reduce the amount of data sent through the gateway for semantic models that use Import storage mode.

Proposed solution:
Create aggregations to summarize results.
Does this solution meet the goal?

88. Note: This question is part of a scenario-based series. Each question proposes a different solution that may or may not meet the stated goal. Once answered, you cannot return to review it.

You have an on-premises data gateway.
You need to reduce the amount of data sent through the gateway by semantic models running in Import storage mode.

Proposed solution:
Increase Automatic page refresh intervals.
Does this solution meet the goal?

89. Note: This question is part of a scenario-based series. Each question proposes a different solution that may or may not meet the stated goal. Once answered, you cannot return to review it.

You have an on-premises data gateway.
You need to reduce the amount of data sent through the gateway for semantic models that use Import storage mode.

Proposed solution:
Configure incremental refresh.
Does this solution meet the goal?

90. Note: This question is part of a scenario-based series. Each question proposes a different solution that may or may not meet the stated goal. Once answered, you cannot return to review it.

You have an on-premises data gateway.
You need to reduce the amount of data sent through the gateway for semantic models that use Import storage mode.

Proposed solution:
Decrease the dashboard cache update frequency.
Does this solution meet the goal?

91. You have a Power BI semantic model named Model1 that uses Import storage mode.
You need to reduce the size of Model1, and the solution must not increase report query response times.
What should you do?

92. You have a Power BI semantic model named Model1 that uses Import storage mode.
You need to reduce the size of Model1.
Which two actions should you perform?

93. You have a Power BI semantic model with transaction data.
You need to design a solution that meets all of these requirements:
Shows monthly total transaction amounts for the current year and previous year
Uses a star schema modeling approach
Minimizes the size of the data model

Which three actions should you perform?

94. You have a Power BI semantic model named Model1 with two tables:
DimDate (marked as the Date table)
FactSales
There is an active relationship between DimDate and FactSales.
The FactSales table contains sales data (as shown in the exhibit).
The model includes the following measure:

Previous Year Sales =CALCULATE( [Sales Amount],PREVIOUSYEAR(‘Date'[Date]))

You create a report that uses Model1.
The report contains one page, and a page-level filter is set to:
May 9, 2024

The Previous Year Sales measure is displayed in a card visual.
What value will appear in the card?

95. You have a Power BI query named Expenses that imports expense data.
The table includes a TransactionDate column that contains both date and time values.

Users perform analysis using only the date portion of TransactionDate.
You need to reduce the model size while ensuring that analysis results remain unchanged.

Which two actions should you take?

96. You have a Power BI semantic model with two tables:
DimCustomer (dimension table)
Primary key: CustomerID
FactOrderDetails (fact table)
Contains CustomerID
Multiple rows can share the same CustomerID

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

What should you create?

97. You have a Power BI data model with a table named Expenses that includes the following columns:
Date
Amount
Category
Expense ID
Employee ID
Each expense is recorded by an employee, and each expense has a unique Expense ID.

You need to create a DAX measure that calculates the total amount of expenses.
Which DAX expression should you use?

98. You are working in Power Query Editor with a query that contains a column named Classes.
Each cell in the Classes column contains multiple values separated by a delimiter.

You need to transform the data so that:
Each class appears on its own row
The resulting table matches the structure shown in the exhibit
What should you do?

99. You have a Microsoft Fabric Eventhouse named Eventhouse1 that stores high-velocity, high-volume IoT data.
Eventhouse1 supports near-real-time (NRT) querying for reports.
You want to use Power BI Desktop to build a report that shows both historical data and live data.
The solution must minimize development effort.

What should you do?

100. You have a Power BI semantic model with a fact table (FactSales) and a dimension table (DimProduct).
You need to create a relationship from FactSales to DimProduct.
The solution must ensure the fastest DAX query performance.

Which cardinality should you use?

101. You have a Power BI semantic model that contains a table named Table1.
Table1 currently uses Import storage mode.

You need to change the storage mode of Table1 to DirectQuery.
What should you do?

102. You have a Power BI semantic model with tables and relationships as shown in the exhibit.
Based on the model design, what type of dimension does Dim Address represent?

103. You have a Power BI report with two visuals:
A bar chart that shows customer count by customer segment
A column chart that shows sales by month

You want the following behavior:
When a customer segment is selected in the bar chart
The column chart should show which portion of each month’s total sales belongs to that selected segment

How should the visual interaction be configured for the column chart when the bar chart is selected?

104. A user creates a Power BI report named ReportA that uses a custom theme.
You then create a dashboard named DashboardA.

You need to ensure that DashboardA uses the same custom theme as ReportA, while minimizing development effort.
Which two actions should you perform?

105. You need to create a visualization that compares revenue and cost over time.
Which type of visualization should you use?

106. You are building a Power BI report to help the sales team understand:
Overall sales performance
The drivers (factors) that influence sales success
The team wants a single visualization that clearly identifies which factors affect success.

Which type of visualization should you use?

107. You use a Key influencers visual to analyze which factors affect the quantity of items sold per order.
Several fields (Customer Country, Product Category, Supplier info, Product info, Customer City, etc.) are placed in Explain by.

Based on the results shown in the visual, what can you identify?

108. You have a Power BI report with four pages.
Each page contains slicers for the same four fields.
Users report that when they make a selection on one page, the selection does not carry over to the other pages.
You need a solution so users can select a value once and have it filter all pages.

Which two recommendations will achieve this?

109. You have a Power BI report with a card visual.
You need to apply conditional formatting to the data label font color, with minimal design effort:
≥ 100 → Dark red
< 100 → Dark gray

Which type of conditional formatting should you use?

110. You are creating a dashboard in the Power BI service.
You already have a report page that contains three charts with interactive behavior (for example, cross-filtering and highlighting between charts).
You need to add these charts to a dashboard while preserving the interactivity between them.

What should you do?

111. You want to create the chart shown in the exhibit, which includes a dashed horizontal line indicating the 40th percentile of daily sales for the displayed period.

How should you create the dashed horizontal line?

112. You are designing a Power BI report that will be viewed on mobile devices.
The report must display data dynamically based on each user’s geographic location.

Which two actions are required to ensure the report correctly recognizes and uses location-based data?
Each correct answer represents part of the solution.

113. A Power BI report includes a donut chart and a clustered column chart.
The interactions between the visuals are currently set to the default behavior.
You want the donut chart to update (redraw) and display data only for the selected column when a user clicks a column in the clustered column chart.

What action should you take?

114. You are building a report in Power BI Desktop and need to add a visual that:
Automatically generates insights such as trends and key observations
Dynamically updates based on selections made in other visuals on the report page

Which type of visual should you use?

115. In Power BI Desktop, you have a dataset containing a table with a column named Plant Image that stores image URLs.
You added a table visual to a report page (as shown in the exhibit).
Right now, the table shows the URL text.
You want the table visual to display the actual image (render the picture) instead of showing the URL.

What should you do?

116. Note: This question is part of a multi-question scenario. Each question proposes a different solution that may or may not satisfy the stated requirement.

You have a clustered bar chart with:
A measure called Salary used as the value
A field called Employee used as the axis
The Salary values represent actual monetary amounts in US dollars.
You want to add a reference line that indicates which employees earn more than the median salary.

Proposed solution:
Add a constant line and set its value to 0.5.

Does this solution meet the requirement?

117. Note: This question is part of a scenario-based series. Each question suggests a different approach that may or may not satisfy the requirement. Once answered, you can’t return to it.

You have a clustered bar chart where:
Salary (a measure) is used as the Values
Employee is used as the Axis
Salary values are numeric amounts in US dollars
You need to add a reference line that helps identify which employees earn above the median salary.

Proposed solution:
Add an Average line using the Salary measure.

Does this solution achieve the goal?

118. Note: This question belongs to a series where each question proposes a different solution that may or may not meet the requirement. Once you answer, you cannot return to this question.

You have a clustered bar chart with:
A measure named Salary used as the Values
A field named Employee used as the Axis
Salary values stored as numeric US dollar amounts
You need to add a reference line that indicates which employees earn above the median salary.

Proposed solution:
Add a Percentile line using the Salary measure and set the percentile value to 50%.

Does this solution satisfy the requirement?

119. You have a Power BI report published to powerbi.com that shows department expenses for department managers.
The report currently includes a line chart displaying expenses by month.

You want users to be able to switch between a line chart and a column chart when viewing the report.
The solution must require minimal development and ongoing maintenance.

What should you do?

120. You have two Microsoft Power BI reports, ReportA and ReportB, each using a different color palette.
You are building a Power BI dashboard that will include two visuals from each report.
You want the dashboard to use a consistent dark theme, while retaining the original colors of the visuals from both reports.

Which two actions should you take?
Each correct answer represents part of the solution.

121. You have a line chart that displays the number of employees in a department over time.
You want to view the total salary cost for those employees when hovering over a data point on the chart.

What should you do?

122. You have a visual displayed as shown in the Original exhibit.

You need to modify the visual so that it matches the Modified exhibit.

What should you add to the visual to achieve this result?

123. You need to build a visual that allows users to interactively and ad-hoc explore data, as illustrated in the exhibit.

Which type of visual should you use?

124. Your organization operates in 10 different states.
Management has recently classified each state into one of three regions: East, West, or North.
Your existing data model contains employee information by state only and does not include a region field.
A report currently displays employees grouped by state.
You need to quickly view the employees grouped by region.

What should you do?

125. You manage a set of Power BI reports for your company’s HR department.
You need to create a visual that:
Displays historical employee counts, and
Forecasts trends for the next six months.

Which type of visualization should you use?

126. You have a Microsoft Power BI dashboard created from a report that uses an imported dataset sourced from Microsoft SQL Server.
The dashboard activity timeline is shown in the exhibit.

What event took place at 12:03:06 PM?

127. You have a visual displayed as shown in the exhibit.
You want to visualize the relationship between Total Cost and Total Sales over time.

What should you do?

128. You are creating a Power BI report to analyze customer segments.
You want to dynamically break down and explore customer segments based on Bounce Rate, across multiple dimensions such as traffic source, geography, and demographics.
The solution should require minimal analysis effort from the user.

Which type of visual should you use?

129. You have a table that contains sales data with approximately 1,000 rows.
You want to identify outliers in the data.

Which type of visualization should you use?

130. You have a Power BI report with three pages.
One of the pages includes a KPI visual.
You need to apply a filter that affects all visuals across the report, except for the KPI visual.

Which two actions should you take to meet this requirement?

131. You are building a Power BI report to analyze consumer purchasing behavior using a table named Transactions.
The table includes a numeric field called Spend.
You need a visual that can identify which factors or fields most strongly influence Spend.

Which type of visual should you use?

132. You have a Power BI dashboard that contains tiles pinned from a single report, as shown in the Original Dashboard exhibit.

You need to change the dashboard so that it appears like the Modified Dashboard exhibit.

What should you do?

133. You have a Power BI report with a visual that displays gross sales by date.
Anomaly detection is enabled on the visual, but no anomalies are currently detected.
You want to increase the chance that anomalies are identified in the report.

What should you do?

134. You manage a Power BI workspace that includes a supplier quality dashboard. The dashboard has:
10 card visuals
2 map visuals
5 bar chart visuals
The mobile layout of the dashboard is shown in the exhibit.

You need to adjust the mobile layout to meet these requirements:
Show only single-value visuals
Reduce scrolling as much as possible

What should you do?

135. You are working with a Power BI report that uses a table named Data1 containing 10 million rows.

The table is used in these visuals:
A card showing the total number of records
A bar chart showing total transaction amount by territory
A scatter plot showing transaction amount vs. profit, with points colored by territory

You want to improve the scatter plot so users can more easily spot meaningful patterns, without changing the accuracy of the other visuals.

What should you do?

136. You have a Power BI workspace named Inventory that includes a dataset, a report, and a dashboard.
You need to add a new dashboard tile that displays inventory by location.
This information is not currently shown in the report, and you want to minimize any changes to the report.

Which two actions should you take to meet this requirement?

137. You have a Power BI report with three pages: Page1, Page2, and Page3.
Each page contains the same slicers.
You need to make sure that any filters applied on Page1 also apply to Page3, but do not affect Page2.

What should you do?

138. You have a Power BI report with five pages:
Pages 1–4 are visible
Page 5 is hidden
You want users to be able to quickly navigate from Page 1 to all other visible pages.
The solution must require minimal development and ongoing maintenance, especially as new pages are added to the report.

What should you do first?

139. You have created a Power BI report that displays IoT temperature data streaming from a refrigerator.
The report has been published to the Power BI service.
You need to receive a notification when the temperature exceeds 4°C.

What should you do?

140. You have a Power BI dashboard displayed as shown in the original exhibit.

You need to modify the dashboard so that it appears as shown in the updated exhibit.

What should you do?

141. You need to create a Power BI theme that can be reused across multiple reports.
The theme must include corporate branding, such as:
Font sizes
Color schemes
Bar chart formatting

What should you do?

142. You have a Power BI report with a single page that includes:
Two line charts
One bar chart

You want users to be able to perform the following actions on all three visuals:
Change the measures used in the visuals
Switch the visualization type
Add or modify a legend
The solution must require minimal development effort.

What should you do?

143. Note: This question is part of a scenario-based series. Each question proposes a different solution that may or may not satisfy the requirement. Once answered, you cannot return to this question.

You have a clustered bar chart where:
Salary (a measure) is used as the Values
Employee is used as the Axis
Salary values are numeric amounts in US dollars
You need to add a reference line that indicates which employees earn above the median salary.

Proposed solution:
Add a Median line using the Salary measure.

Does this solution meet the requirement?

144. You have a Power BI report with four pages, and each page includes a slicer for a field named Country.
You need to ensure that:
A country selected on Page 1 is also applied to Page 2 and Page 3, and
Page 4 is not affected by selections made on the other pages.

What should you do?

145. You want to use Power BI to generate sales invoices for customers.
The solution must meet these requirements:
Invoices must be exported as PDF files
The exported PDFs must clearly display all rows and columns without truncation

What should you create?

146. You have a Power BI report page that includes:
A shape named Shape1
A card visual named Sales Summary
A clustered bar chart named Sales by Region
You want to make sure that the Sales Summary card appears on top of (in front of) Shape1.

What should you modify?

147. You have a Power BI report named Report1 and a dashboard named Dashboard1.
Report1 includes a visual called Sales by month, which is initially a line chart and has been pinned to Dashboard1.
Later, in Report1, you change the Sales by month visual from a line chart to a bar chart.
You want the bar chart version to appear on Dashboard1.

What should you do?

148. In Power BI Desktop, you are building a report that will include three pages.
You need to create a custom tooltip page and ensure it is properly configured for use as a tooltip.

Which three actions should you perform to prepare the tooltip page?

149. You have a Microsoft Power BI report named ReportA.
Your Power BI tenant allows users to export data.
You need to make sure that report consumers cannot export data from any visuals in ReportA.

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

150. You have a Power BI report that will be displayed on a vertical screen.
You want to maximize the usable screen space so the report fits the vertical layout as effectively as possible.

What should you do?

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

Which type of visual is best suited to achieve this goal?

152. You have a Power BI dataset named Finance that is stored in a Power BI workspace.
The finance team is not currently assigned to any workspace roles.
You need to allow the finance team to analyze the Finance dataset using Microsoft Excel.

What should you do?

153. You have a Power BI report with a visual that displays a measure.
You must ensure that:
All values show two decimal places
Negative values appear in red and are enclosed in parentheses

Which two actions should you take to meet these requirements?

154. You have a Microsoft Power BI data model with two tables: Population and Date.

Population includes:
PopulationAmount
DateKey (a date representing the first day of a year)
DateKey is related to the Date table in a many-to-one relationship.

You define the following measures:
Total Population = SUM(‘Population'[PopulationAmount])
2023 Population = CALCULATE([Total Population], ‘Date'[Year] = 2023)
You then create a table visual that shows Date[Year] and [2023 Population].

What will the table display?

155. You have a Power BI dataset that contains quarterly sales performance data.
You need to provide managers with a way to review the data that:
Is optimized for printing, and
Can be rendered in Microsoft Excel, Word, PowerPoint, and PDF formats.

What should you create?

156. You have a Power BI report that includes several visuals, as shown in the table.

You need to change where each visual is placed on the report canvas.

What setting should you modify for each visual?

157. You have a Microsoft Power BI report that includes a line chart showing sales data across multiple regions.
You want to add an element that allows users to filter the sales data to a selected region.

Which two elements can be used to meet this requirement?
Each correct answer represents a complete solution.

158. You have a CSV file structured as shown in the table.

You open the file in Power Query Editor to preview the data.

You need to transform the data so that:
The first column contains the month
The second column contains the year
The third column contains the order amount for the corresponding month and year

Which transformation should you apply first?

159. You are designing a single-page Power BI report.
Some users will navigate the report using a keyboard, while others will use a screen reader.
You need to make sure that the content on the report page is read and navigated in a logical, accessible order.

What should you configure on the report page?

160. You are configuring a Microsoft Power BI report to improve accessibility.
The report contains three visuals, and you need to adjust their default colors so the report is more usable for people with color vision deficiency.

Which two settings should you configure in the Customize theme window to achieve this?

161. You want to use Power BI to create a visual that allows users to compare sales performance across five sales regions for the current month.

Which type of visual should you use?

162. You have a Power BI report that includes a table with conditional formatting icons.
The icons indicate whether each store is above, near, or below the monthly return quota.
You need to make sure the table is accessible to users with color vision deficiency.

What should you do?

163. You have a Power BI report that contains a single visual.
You want users to be able to change the visual type for their own view without impacting what other users see.

What should you do?

164. You have a Power BI report with a card visual that shows year-to-date revenue.
You need to make sure that screen reader users can hear the value as soon as they interact with the card, and that the value automatically updates whenever the dataset refreshes.

What should you do?

165. You have a Power BI report that includes a table visual with a column of whole numbers ranging from 1 to 20.
You need to apply conditional formatting that meets the following requirements:
Allow users to visually compare values without reading the numeric text
Display a distinct visual representation for each value
Hide the numeric value in the column
Require minimal development effort

Which type of conditional formatting should you use?

166. You have a Power BI report that includes a table visual, as shown in the exhibit.

You want to make the visual more accessible for users with color vision deficiency.

What should you do?

167. You have a Power BI app that includes a report named Report1.
You add a new page to Report1 and want to make sure that users can access the new page.
The solution should require minimal administrative effort.

What should you do?

168. You have a Power BI semantic model with a table named Table1 that includes the following columns:
WebsiteName
URL

You need to create a report (Report1) that contains a table visual which:
Displays the website name, and
Allows users to open the corresponding website by selecting the website name.

What should you use to meet these requirements?

169. You have a Power BI semantic model named Model1 with two fields:
Sales
Quarter
The model includes a DAX measure that calculates the total of Sales.
You need to create a report that displays a visual matching the exhibit shown.

The solution must not require creating any additional DAX measures.

Which type of visual should you use?

170. You have a Power BI report with a bar chart that shows sales by country.
You need to make sure that a summary of the chart’s data can be read by screen reader users.

What should you configure on the bar chart?

171. You want to create a line chart that compares sales data for the last six months across two departments.
You need to improve the accessibility of the visual.

What should you do?

172. You have a Power BI report with a single report page that uses the default theme.
You need to adjust the page so that its appearance matches the formatting shown in the exhibit.

What should you modify on the report page?

173. You are creating a visual in a Microsoft Power BI report.
The underlying semantic model includes four years of sales data for three products.
You need to show total sales by quarter, broken down by product, and the visual must clearly present trends over time for both:
Overall (total) sales, and
Individual product sales.

Which type of visual should you use?

174. You have a Power BI report with a clustered bar chart where:
Sales is on the X-axis
Year is on the Y-axis
The chart shows data from 2020 to 2024
You need to create a visual calculation that displays a cumulative total of sales, defined as the current year’s sales plus all sales from the previous years.

Which DAX expression should you use?

175. You are building a Power BI report that includes multiple visuals.
You need to make sure the report is accessible to users who rely on screen readers.

Which two configurations should you apply?

176. You have a Power BI report with a stacked bar chart.
You need to add a new field to the legend. This field must combine values from multiple columns into a single label.

What should you create?

177. You manage a Power BI tenant with reports that use financial datasets and are exported as PDF files.
You need to ensure that these exported reports are encrypted.

What should you implement?

178. You have a Microsoft Excel file stored on a file server.
You import a table from the Excel file into Power BI, create a report, and then publish the report.
You need to make sure the data refreshes every four hours.

What should you do first?

179. You have a dataset in Microsoft Power BI that is rarely used and is scheduled to refresh every hour.
You receive a notification indicating that scheduled refresh was disabled due to inactivity.

Which two actions will cause the scheduled refresh to resume?
Each correct answer represents a complete solution.