Power bi

Question 1 of 27

Your visualization is in the form of a column chart showing annual sales by salesperson. How can you add
an additional visualization to the chart to show your company's sales goal for the year?

Modify the X-Axis from the Formatting tab.

o Modify the Y-Axis from the Analytics tab.

o Add a Constant Line in the Formatting tab.

Add a Constant Line from the Analytics tab.

 Question 2 of 27

In which situation would you have a higher-value visualization in terms of performing data analysis with
a treemap rather than with a pie chart?

o You want your legend to wrap in the content area.

o You want to distill your data into categories.

o You prefer to have the data displayed in the form of a table.

You want to look at a higher level of detail in a category.

 Question 3 of 27

How will a gauge visualization provide impressive one-glance information on your company's sales for
the year?

o It can show the salespeople who have the highest sales for the year.

o It can show how each salesperson is "gauged" against the other salespeople.

o It can show what percent of salespeople are on track to reach the sales goal.

It can show how close your sales are to your sales goal.

 Question 4 of 27

Why would you add a slicer in a table visualization?

o so the data in each slice of a pie chart will show the underlying data when clicked on

o
so your users can filter the particular data they are interested in

o so your users can slice-out data they are not interested in

o so the slices in a pie chart can be compared to a particular goal

 Question 5 of 27

What data file type can you access only with Power BI Desktop and not Power BI service?

o Excel

SQL

XML

o CSV

 Question 6 of 27

When would you save and modify a sample report rather than create a new report from scratch?

o when you do not have the information you want in the Fields list

when the sample report contains most of the visuals you want

o when you do not have Power BI Desktop installed

o when you do not have access to the sample report

 Question 7 of 27

You have three tables relating to sales information in various states and various products. Why would
you create relationships in Power BI?

o to identify customers with more than one location

o to merge the three tables into a single table

o to quickly navigate between the multiple tables

to work in one table and not the three separate tables

 Question 8 of 27

If you create an app workspace, how do the collaborators you selected create their own reports and
dashboards?
 o They are created in an offline version of My Workspace.

o They are created by emails sent to you for approval.

o They are created as drafts posted to your workspace for approval.

They are created the same way you created them in My Workspace.

 Question 9 of 27

You found a thermometer in the Marketplace that you think will add more value to your visualizations
than the gauge you are using. Which values will you have when you add the thermometer?

o The values that were in the gauge you used before you downloaded the thermometer.

The values that are included in the thermometer you add from the Marketplace.

All the values contained in the Visualizations pane in Power BI.

o All the values in the Fields list generated from the dataset you used.

 Question 10 of 27

When you edit interactions, you choose to not have the data filtered. Once you stop editing the
interactions, what happens when a user selects an item?

o The charts change, but the tables do not change.

o The tables change, but the charts do not change.

o The inability to filter is displayed as an error message.

The tables and charts redisplay, but nothing changes.

 Question 11 of 27

What feature does Power BI for Mobile have to make sharing Power BI dashboards easier than sharing
other types of information with a mobile device?

Power BI for Mobile can share dashboards via sharing apps directly from the screen.

o Power BI for Mobile takes its own screen captures.

o Power BI for Mobile includes an annotation feature.

o Power BI for Mobile allows you to save the dashboard as a link.

If you would like to examine some of the free sample datasets, reports, and dashboards in Power BI,
where will you find them?

o by clicking Services

o by clicking My Workspace

by clicking Get Data

o by clicking Apps

 Question 13 of 27

Katrina is an experienced Power BI service user. When would Katrina choose to work in Power BI
Desktop instead?

o to get data from an Excel file

to perform data modeling

o to work in Power BI while online

o to create dashboards for sharing

 Question 14 of 27

The contextual menu toolbar on the Power BI screen provides the ability to add buttons and to duplicate
a page. Which type of item are you looking at?

o a Dashboard

o a Workbook

a Report

a Dataset

 Question 15 of 27

In order to improve your dataset to get the most use from the Power BI Q&A feature, how should you
name the tables in your data?

o Avoid names that describe the table.

o Name your tables numerically.

Choose user-friendly names for your tables.

 Question 16 of 27

Juan Delgado is an employee in your sales department and Li Park is an outside consultant. If you share a
dashboard with both of them, will there be any difference in their Power BI experience?

Li Park will have the interactivity of the dashboard, but she will not have any of the elements on the left.

o Both Juan Delgado and Li Park will have the same experience if they both have Power BI
installed.

o Both Juan Delgado and Li Park will only be able to see the dashboard in a browser and
not any of the elements on the left.

o Li Park will not be able to view the dashboard because she is not in your company's
domain.

 Question 17 of 27

What will happen if you run Power BI with a display resolution lower than 1440 x 900?

o Power BI will reduce the font size so you can see the tools.

Tools will continue to display but you will not be able to see them.

o Your text display setting will need to be changed to greater than 100%.

o You will receive an error message to increase your display resolution.

 Question 18 of 27

Which video types are the only ones you can add to a dashboard as a media tile?

YouTube or Vimeo

o YouTube or Pinterest

o Vimeo or Pinterest

o Vimeo or Twitter

 Question 19 of 27

If you build a dashboard using Quick Insights, in which format will the insights appear on your
dashboard?

o Excel tables

o text boxes
 o

visualizations

o annotations

 Question 20 of 27

You have a slicer and a chart on the same page for your sales data by state. If you use the menu to sort
by territory in alphabetical order, what effect will that have on the slicer and the chart?

o The slicer will be sorted alphabetically by territory, but the chart will be unchanged.

Everything on the page will be sorted alphabetically by territory.

o The chart will be sorted alphabetically by territory, but the slicer will be unchanged.

Only text items will be sorted alphabetically by territory, but chart items must be sorted separately.

 Question 21 of 27

If you upload data to a file stored locally, when does the data refresh?

o Data in a file stored locally is refreshed as changes are made.

o Data in a file stored locally is refreshed hourly.

o Data in a file stored locally is refreshed every 24 hours.

Data in a file stored locally is not refreshed.

 Question 22 of 27

How does using Power BI impact an organization's IT resources?

IT professionals can spend their time creating reports rather than providing data to analysts.

o The IT department will be the primary resource using Power BI.

o The IT department will be responsible for creating visualizations with Power BI.

IT professionals can spend their time providing data to analysts rather than creating reports.

 Question 23 of 27

After you created an app workspace, you offered the app to your entire sales department for feedback.
Which version of the app will those users see when they access the app?
 o

The version you published, updated with any changes added in real-time.

o The version you published until you as the app owner choose to update again.

The version you published, until you or a collaborator choose to update again.

o The version you published, along with a second version containing updates.

 Question 24 of 27

When you imbed a Power BI report in SharePoint Online, what are you actually doing?

adding a web part by pasting the report link

o imbedding the report as a website

adding a site page by pasting the report link

o imbedding the report as a navigable presentation

 Question 25 of 27

If you create a connection to Sales Analytics for Dynamics 365 in Power BI, what are you doing?

You are adding a connection to Sales Analytics for Dynamics 365 that is installed as an application.

o You are adding an always-on connection to Sales Analytics for Dynamics 365 that will be
a new window.

o You are adding Sales Analytics for Dynamics 365 to Datasets under My Workspace on the
left pane.

o You are adding a Sales Analytics for Dynamics 365 icon to the online catalog of available
services.

 Question 26 of 27

Suppose your report is going to be used in a PowerPoint presentation at the national sales meeting. With
that in mind, what should be the most important consideration when you are creating your report?

o how long it will take to export your report to PowerPoint

o how many visualizations you can fit on a PowerPoint page

o
how you are going to group elements on a page

o how to have charts rather than tables appear on different pages

 Question 27 of 27

When you pin a visualization from a report to a dashboard, what does the visualization become?

o a link

o a data field

a tile

o a filter