Loading questions...
Updated
Want a break from the ads?
Become a Supporter and enjoy a completely ad-free experience, plus unlock Learn Mode, Exam Mode, AstroTutor AI, and more.
You have two Microsoft Excel workbooks in a Microsoft OneDrive folder.
Each workbook contains a table named Sales. The tables have the same data structure in both workbooks.
You plan to use Power BI to combine both Sales tables into a single table and create visuals based on the data in the table. The solution must ensure that you can publish a separate report and dataset.
Which storage mode should you use for the report file and the dataset file? To answer, drag the appropriate modes to the correct files. Each mode 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.

You have a Power BI model that contains two tables named Population and Date.
The Population table contains two columns named PopulationAmount and DateKey.
DateKey contains date values that represent the first day of a year and are used to create a many-to-one relationship with the Date table.
The Power BI model contains two measures that have the following definitions.
Total Population = Sum(‘Population’[PopulationAmount])
2023 Population = CALCULATE([Total Population], ‘Date'[Year] = 2023)
You create a table visual that displays Date[Year] and [2023 Population].
What will the table visual show?
You publish a dataset to the Power BI service. The dataset contains a connection to an on-premises Microsoft SQL Server database.
You attempt to configure a scheduled refresh but cannot select the appropriate on-premises data gateway.
You confirm the following with the administrator of the gateway:
• You have the appropriate permissions to use the gateway.
• The data source was created on the gateway.
• The gateway has a status of Running.
What is the most likely reason the gateway is unavailable?
You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.
You need to combine the tables into a single query that contains the unique columns of each table.
What should you select in Power Query Editor?
You are creating a Power BI report that will show the number of current employees over time. The report will use Import storage mode for all tables.
The employment data will be imported from Azure SQL Database in a monthly snapshot. The data will be stored in a table named Headcount and will contain the following:
• One row per employee for each month the employee is employed
• In each row, a date key that shows the first day of the month of each snapshot
You have a related date table that contains dates for the years 2020 to 2030.
You need to create a semi-additive DAX measure that will return the count of employees for the last available date in a year, quarter, or month.
How should you complete the measure? To answer, select the appropriate options in the answer area.

You have a Power BI model that contains the following data.

The Date table relates to the Sales table by using the Date columns.
The model contains the following DAX measure.
Total Sales = SUM(Sales[Sale])
You need to create another measure named Previous Quarter to display the sales one quarter before the selected period.
Which DAX calculation should you use?
You have a query named All Sales that imports sales data into a Power BI model.
You plan to create a star schema by separating columns into separate queries and performing further transformations. The solution must meet the following requirements:
• Use All Sales as the source for three other queries named Sales Fact, Product Dimension, and Customer Dimension.
• Minimize maintenance effort.
What should you do to create the Sales Fact query, and for which query should you clear Enable load? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

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

You need to modify the location of each visual.
What should you modify for each visual?
You are reviewing a Power BI data model.
You have a calculated table that has the following definition.
ProductList = INTERSECT ( ProductsGroupA, ProductsGroupB )
You need to identify the results of the DAX expression.
Which rows will be returned in ProductList?
You have a Power BI data model that contains two tables named Sales and Date. The Sales table contains three measures named Order Quantity, Product Cost, and Sales Amount.
You need to create the visual shown in the following exhibit.

In which section of the Fields well should you place the measures?
HOTSPOT -
You have Power BI 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 Power BI model that contains a table named Employees. The table contains the following columns:
• Employee ID
• First Name
• Last Name
• Department
• Salary
Each employee is uniquely identified by using Employee ID.
You need to create a DAX measure that will calculate the average salary of all the employees in the sales department.
Which DAX expression should you use?
You have a Power BI dataset that contains quarterly sales performance data.
You need to enable managers to review the data in a format that meets the following requirements:
• Is optimized for printing.
• Renders data in Microsoft Excel, Word, PowerPoint, and PDF formats.
What should you create?
You have a Power BI report. The report contains a line chart that displays sales data for several regions.
You need to add an element to the report that will enable users to filter the sales data to include only a selected region.
Which two elements achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
You have the CSV file shown in the following table.

You use Power Query Editor to preview the data in the file.
You need to transform the data to meet the following requirements:
• The first column must contain the month.
• The second column must contain the year.
• The third column must contain the order amount for the month and year.
Which transformation should you use first?
You have a PBIX file that imports data from a Microsoft Excel data source stored in a file share on a local network.
You are notified that the Excel data source was moved to a new location.
You need to update the PBIX file to use the new location.
What are three ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
You have a folder that contains 50 JSON files.
You need to use Power BI Desktop to make the metadata of the files available as a single dataset. The solution must NOT store the data of the JSON files.
Which type of data source should you use, and which transformation should you perform? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You use Power Query Editor to preview a query that contains sales order data in the following columns:
• Tax Amount
• Sales Order ID
• Freight Amount
• Subtotal Amount
• Total Item Quantity
The Sales Order ID column uniquely identifies each sales order. The Subtotal Amount and Total Item Quantity columns are always populated, but the Tax Amount and Freight Amount columns are sometimes null when an order has no associated amount.
You need to query the data to identify the following metrics by month:
• The average item quantity per order
• The average freight amount per order
• The maximum item quantity per order
How should you modify the query?
You plan to use Power BI to create a quarterly profit report that meets the following requirements:
• Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage
• Compares profit margins across sales regions
Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual 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.

You have a Power BI semantic model that contains item, price, and country data. The data is displayed in a report that uses filters.
You need to calculate the average item price for a given country. The solution must support the existing filters.
Which type of quick measure should you use?
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 tenant that contains a workspace. The workspace contains a dataset named datasetA.
You need to build a pivot table report in Microsoft Excel. The report must use datasetA as the data source. The solution must meet the following requirements:
• Ensure that the report can be refreshed to get the latest available data from the Power BI service.
• Ensure that all the visible data in datasetA is available for use in Excel.
What should you do to connect Excel to datasetA, and which element in datasetA will be incompatible with the Excel connection? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

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 use Power Query Editor to load two queries named Query1 and Query2.
Query1 results in the following error.

Query2 results in the following error.

Which type of error occurred for each query? To answer, drag the appropriate error types to the correct queries. Each error 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.

You are creating a Power BI single-page report.
Some users will navigate the report by using a keyboard, and some users will navigate the report by using a screen reader.
You need to ensure that the users can consume content on a report page in a logical order.
What should you configure on the report page?