Ques 1: When you are creating reports using Power BI to share data with other users, what are you ultimately doing?
(a) You are creating reports for users to then use to create their own dashboards containing visualizations.
(b) You are creating a dashboard for users to access the information in the visuals you place in the report.
(c) You are creating reports in a format that can be shared via Excel or a cloud storage service, such as OneDrive.
(d) You are translating raw data into visuals that make it easier for you to understand the data contained in the report.
Feedback
You are sharing your data by means of dashboards with visuals.
Ques 2: You would like a hierarchical visualization that shows total sales in Canada, then sales by province. Which visualization will provide this?
(a) a combo chart
(b) a filled map
(c) an area chart
(d) a treemap
Answer: Option(D): a treemap
Feedback
A treemap consists of a rectangle, in this case Canada, with smaller nested rectangles showing data by province.
Ques 3: You want a visualization that shows the contribution of each of your 12 sales regions to total sales for the quarter. Why is a tree map a better choice than a pie chart?
(a) Pie charts do not show the contribution of each segment.
(b) Only tree maps have colored segments.
(c) The contribution of each segment is easier to see and understand.
(d) Pie charts do not have labels for the slices.
Answer: Option(C): The contribution of each segment is easier to see and understand.
Feedback
The size of the rectangles in tree maps makes it easier to identify the contribution of each segment.
Ques 4: Your visualization is a table. How can you add alt text?
(a) by selecting it from the icons in the Visualizations page
(b) by selecting it from the Values options in the Visualizations pane
(c) by selecting it from the Formatting options in the Visualizations pane.
(d) by selecting it from the Analytics options in the Visualizations pane
Answer: Option(C): by selecting it from the Formatting options in the Visualizations pane.
Feedback
Alt text resides in the Formatting options in the Visualizations pane, along with styles, fonts, positions, and other formatting choices.
Ques 5: The visualization you are creating has four tiles. How can you rearrange them so a particular tile is at the upper left?
(a) Drag and drop the visualization to the desired location.
(b) Change the order of the selections you made in the Fields pane.
(c) Copy and paste the visualization to the desired location.
(d) Grab any of the handles on the visualization, and move it to the desired location.
Answer: Option(A): Drag and drop the visualization to the desired location.
Feedback
This is the easiest way to move visualizations around.
Ques 6: You are creating a new report and your first step is to select the Districts checkbox in the Fields pane. What will happen?
(a) Power BI will immediately display a list of your report selections.
(b) Power BI will take you to Power BI Desktop to create the report.
(c) Power BI will immediately generate a visualization.
(d) Power BI will create a Districts heading for your report.
Answer: Option(C): Power BI will immediately generate a visualization.
Ques 7: Your report has four visualizations, including a filled map and a column chart for your four sales regions. How can you quickly filter the report to display data only from the Northwest Region?
(a) Select the Northwest Region of the column chart.
(b) Open the column chart tile in Focus Mode.
(c) Use the Pin function to pin the data you want to your workspace.
(d) Apply a filter from the right-hand side of the workspace.
Answer: Option(A): Select the Northwest Region of the column chart.
Feedback
This will filter everything on your workspace to display only the visualizations and data from the Northwest Region.
Ques 8: You are creating a visualization. The first item you selected from the Fields list has a calculator icon next to it. The next item selected does not have an icon next to it. In which type of visualization will the second item appear?
(a) as a chart
(b) as text
(c) as a table
(d) as a map
Answer: Option(A): as a chart
Feedback
When you initially select data that will display as a chart, subsequent data you add does not change the fact that it is a chart.
Ques 9: You would like a visualization that shows how much of your third quarter sales goal has been reached. Which visualization will you choose?
(a) a waterfall
(b) a tree map
(c) a gauge
(d) a filled map
Answer: Option(C): a gauge
Feedback
Similar to a gas gauge in an automobile, this is a very clear way to understand progress toward a goal.
Ques 10: None of the visualizations you have will be useful to illustrate your data, so you go to Power BI Visuals. What will you find there?
(a) third-party visuals available for a one-time charge, as well as visuals anyone in your organization has selected
(b) third-party visuals, some of which are free, as well as visuals anyone in your organization has viewed
(c) third-party visuals, all of which are free, as well as visuals your organization has already selected
(d) third-party visuals, some of which are free, as well as visuals your organization has already selected
Answer: Option(D): third-party visuals, some of which are free, as well as visuals your organization has already selected
Feedback
This provides a wealth of visuals in the Marketplace, as well as visuals you might not be aware your organization previously selected.
Comments
Post a Comment