What is the minimum number of datasets and storage modes required to support the reports?
You are creating a quick measure as shown in the following exhibit.
You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a Power B1 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 import a large dataset to Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point
You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.
You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)
The related dimension tables are imported into the model.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
You have a source that contains a comumn. The column contains case sensitive date. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue.
Solution: You Normalize casing in the source query or Power Query Editor.
Does this meet the goal?
You need to create a visual that compares profit across 10 product categories for a selected quarter.
What is the best visual to use to achieve the goal? More than one answer choice may achieve the goal Select the BEST answer.
You are creating a dashboard by using the Power Bl service.
You have an existing report page that contains three charts.
You need to add the charts to the dashboard while maintaining the interactivity between the charts.
What should you do?
You have a Power BI report. The report contains visualizations that have interactions. You need to identify which visualizations take the longest to complete. What should you use?
You are developing a sales report that will have multiple pages. Each page will answer a different business question.
You plan to have a menu page that will show all the business questions.
You need to ensure that users can click each business question and be directed to the page where the
question is answered. The solution must ensure that the menu page will work when deployed to any
workspace.
What should you include on the menu page?
