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?
Create a text box for each business question and insert a link.
Create a button for each business question and set the action type to Bookmark.
Create a Power Apps visual that contains a drop-down list. The drop-down list will contain the business questions.
Answer is Create a button for each business question and set the action type to Bookmark.
Which of the following is a common use case for scatter charts?
Show changes in values over time
Show patterns in large sets of data
Show comparisons across categories
All of the above
Answer is Show patterns in large sets of data
Common use cases for scatter charts include showing patterns in large sets of data, showing linear & non-linear trends, performing cluser analysis, and identifying outliers.
Question 173
On which of the following chart types can you add a forecast based on a specific number of periods?
Scatter charts
Line charts
Clustered column charts
All of the above
Answer is Line charts
Only line charts have forecast in the chart analytics options.
Question 174
The Q&A visual lets you explore data "in your own words" using what?
DAX
M Code
Natural language queries
SQL
Answer is Natural language queries
Question 175
Which of the following filter options applies only to the specific visual in which it is defined?
Visual level
Page level
Report level
Drill through
Answer is Visual level
Visual level filters apply only to the specific visual in which they are defined.
Question 176
Which filter setting would you use if you wanted to return the top 3 categories by total profit?
Basic
Advanced
Top N
Dynamic
Answer is Top N
Top N options allow you to filter the top "n" amount of items by a specified value or measure.
Question 177
What object could you add to a dashboard if the user would like an interactive way to sort and filter the data using dates?
Categorical Slicer
Date Slicer
Top N Filter
Report Level Filter
Answer is Date Slicer
Slicers provide an interactive way for users to sort and filter a report, and date slicers are exclusively for date fields.
Question 178
What visual could you use if you wanted to understand the factors that drive a specific metric?
Decomposition Tree
Line Chart
Key Influencers
Treemap
Answer is Key Influencers
The key influencers visual helps you understand the factors that drive a specific metric.
Question 179
Which visual allows you to break down a measure across multiple dimensions?
Decomposition Tree
Line Chart
Key Influencers
Treemap
Answer is Decomposition Tree
The decomposition tree visual allows you to perform exploratory analysis by successively breaking down a measure across multiple dimensions.
Question 180
Which of the following filter options applies to all visuals across all pages of the report?
Visual level
Page level
Report level
Drill through
Answer is Report level
Report level filters apply to all visuals across all pages of the report.