You have a Power B1 data model that contains two tables named Products and Sales.
A one-to-many relationship exists between the tables.
You have a report that contains a report-level filter for Products.
You need to create a measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total.
How should you complete the DAX measure? To answer drag the appropriate DAX functions to the correct targets- Each function may be used once, more than once, or not at all the spirt bar between panes or scroll to view content NOTE: Each correct selection is worth one point
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 need to create a semantic model in Power 81 Desktop. The solution must meet the following requirements:
* The model must contain a table named Orders that has one row per order. Each row will contain the total amount per order.
* The orders must be filtered to the selected CustomerlD value.
* Users must select the CustomerlD value from a list.
* The list of customers must come from an OData source.
Which three objects should you create in Power Query Editor? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI.
You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets.
What should you recommend?
You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:
The report will facilitate the following analysis:
* The count of orders and the sum of total sales by Order Date
* The count of customers who placed an order
* The average quantity per order
You need to reduce data refresh times and report query times.
Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.
