Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity.

How should you complete the measure? 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.

You have a Power B1 semantic model.

You need to create a column that will contain year over year (YOY) revenue. The column must contain a ratio of change factor compared to the previous year's monthly revenue.

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

NOTE: Each correct selection is worth one point.

You have a Microsoft Excel spreadsheet that contains the data shown in the following table.

You plan to build a data model for a Power Bl report.

You need to prepare the data so that it is available to the model in the format shown in the following table.

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

You use Power Query Editor to Import three tables named Customers. Address, and Country.

In the source system, not every customer has a related address, but every address has a related country.

You need to merge all the tables into a single query. The solution must optimise query refresh performance.

Which type of join should you use for each merge operation? To answer, drag the appropriate join types to the correct operations. Each join 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 it worth one point.

You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the following format: 2018-12-31 at 08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

What should you do?

You have a report that includes a card visualization.

You need to apply the following conditional formatting to the card while minimizing design effort.

For values that are greater than or equal to 100, the font of the data label must be dark red.

For values that are less than 100, the font of the data label must be dark gray.

Which type of format should you use?

The Sales table contains records of sales by day from the last five years up until today's date.

You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected.

Which DAX expression should you use?

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

You need to make the visual more accessible to users who have color vision deficiency.

What should you do?

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

• Customer_Name

• Customer ID

• Website

The Contacts table contains the following columns:

• Contact ID

• Contact Email

• Contact Name

• 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?

A user creates a Power B1 report named ReportA that uses a custom theme

You create a dashboard named DashboardA.

You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort.

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 BI report that uses a dataset based on an Azure Analysis Services live connection.

You need to ensure that users can use Q&A from the Power BI service for the dataset.

What should you do?

You have a Microsoft Excel file in a Microsoft OneDrive folder.

The file must be imported to a Power Bi dataset

You need to ensure that the dataset can be refreshed in powefbi.com.

Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend. You need to include a visual that identifies which fields have the greatest impact on Spend. Which type of visual should you use?

You hove a folder that contains 50 JSON files.

You need to use Power 81 Desktop to make the metadata ol the files available as a single semantic model. 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 plan to use Power B1 to create sales invoices for customers. The solution must meet the following requirements:

• Sales invoices must be exported in a PDF format

• The PDF exports must show all columns and rows clearly.

What should you create?

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.

You are creating a query to be used as a Country dimension in a star schema.

A snapshot of the source data is shown in the following table.

You need to create the dimension. The dimension must contain a list of unique countries.

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

You maintain a Power Bl workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals.

The dashboard mobile layout is shown in the exhibit. (Click the Exhibit tab.)

You need to modify the dashboard mobile layout to meet the following requirements:

• Only show single-value visuals.

• Minimize scrolling.

What should you do?

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 goat?

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 query that returns the data shown in the following exhibit.

You need to configure the query to display the data as shown in the following exhibit.

Which step should you use in the query?

You plan to embed multiple visualization in a public website.

Your Power BI infrastructure contains the visualizations configured as shown in the following table.

Which two visualizations can you embed into the website? Each correct answer presents a complete the solution.

NOTE: Each correct selection is worth one point.

You have a table named DiMCountries that contains a column named Country as shown in the following table.

You plan to use DiMCountnes as a dimension m a report.

You new to ensure that the Country column in DiMCountnes lists each country only once.

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

NOTE: Each correct answer is worth one point.

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:

The count of classes that occur by period

The count of students in attendance by period by day

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.

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.

The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.

The report is a single page that contains 15 custom visuals and 10 default visuals.

Users say that the report is slow to load the visuals when they access and interact with the report

You need to recommend a solution to improve the performance of the report.

What should you recommend?

NO: 18

You embed a Power BI report in a Microsoft SharePoint Online page.

A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: “This content isn’t available”.

User1 is unable to view the report.

You verify that you can access the SharePoint Online page and that the Power BI report displays as expected.

You need to ensure that User1 can view the report form SharePoint Online.

What should you do?

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

You need to ensure that every row contains the connect 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 connect 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?

You use Power Query Editor to preview customer feedback data.

You need to use Al Insights to add a column of enhanced data based on the customer feedback. The solution must identify the following:

• What the customers most often provide feedback about

• Whether the customers like your company’s product

• The language of the feedback

Which Al Insights service should you use for each output? To answer, drag the appropriate services to the correct outputs. Each service 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 using the key influencers visual to identify which factors affect the quantity of items sold in an order.

You add the following fields to the Explain By field:

* Customer Country

* Product Category

* Supplier Country

* Sales Employee

* Supplier Name

* Product Name

* Customer City

The key influencers visual returns the results shown in the following exhibit.

What can you identify from the visual?

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

You create a report by using Microsoft Power BI Desktop.

The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company’s internal network.

You plan to publish the report to the Power BI Service.

What should you implement ta ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

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

You need to create a measure to count the number of product categories that had products sold during a selected period. How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

You have the Power BI data model 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.

Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.

What should you recommend?

Which DAX expression should you use to get the ending balances in the balance sheet reports?

What is the minimum number of datasets and storage modes required to support the reports?

You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

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

How should you create the visualization? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

You publish the semantic model to powerbi.com.

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 need to create relationships to meet the reporting requirements of the customer service department.

What should you create?

You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?

You need to provide a solution to provide the sales managers with the required access.

What should you include in the solution?

You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection'

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

You publish the dataset to powerbi.com.

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

NOTE: Each correct selection is worth one point.

What should you create to meet the reporting requirements of the sales department?

You need to design the data model to meet the report requirements.

What should you do in Power BI Desktop?

You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?

You need to create the Top Customers report.

Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to create a measure that will return the percentage of late orders.

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

NOTE: Each correct selection is worth one point.