power_bi doc

Prévia do material em texto

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?
o
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.
o
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.
o
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
This study source was downloaded by 100000825833104 from CourseHero.com on 05-26-2021 14:44:58 GMT -05:00
https://www.coursehero.com/file/61195148/power-bidocx/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/61195148/power-bidocx/
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
o
SQL
o
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
o
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
o
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?
This study source was downloaded by 100000825833104 from CourseHero.com on 05-26-2021 14:44:58 GMT -05:00
https://www.coursehero.com/file/61195148/power-bidocx/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/61195148/power-bidocx/
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.
o
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.
o
The values that are included in the thermometer you add from the Marketplace.
o
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.
o
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?
o
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.
This study source was downloaded by 100000825833104 from CourseHero.com on 05-26-2021 14:44:58 GMT -05:00
https://www.coursehero.com/file/61195148/power-bidocx/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/61195148/power-bidocx/
 Question 12 of 27
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
o
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
o
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
o
a Report
o
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.
This study source was downloaded by 100000825833104 from CourseHero.com on 05-26-2021 14:44:58 GMT -05:00
https://www.coursehero.com/file/61195148/power-bidocx/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/61195148/power-bidocx/
o Do not use data models from Power Pivot.
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?
o
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
This study source was downloaded by 100000825833104 from CourseHero.com on 05-26-2021 14:44:58 GMT -05:00
https://www.coursehero.com/file/61195148/power-bidocx/
Th
is 
stu
dyre
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/61195148/power-bidocx/
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.
o
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.
o
Data in a file stored locally is not refreshed.
 Question 22 of 27
How does using Power BI impact an organization's IT resources?
o
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.
o
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?
This study source was downloaded by 100000825833104 from CourseHero.com on 05-26-2021 14:44:58 GMT -05:00
https://www.coursehero.com/file/61195148/power-bidocx/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/61195148/power-bidocx/
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.
o
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?
o
adding a web part by pasting the report link
o imbedding the report as a website
o
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?
o
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
This study source was downloaded by 100000825833104 from CourseHero.com on 05-26-2021 14:44:58 GMT -05:00
https://www.coursehero.com/file/61195148/power-bidocx/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/61195148/power-bidocx/
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
o
a tile
o a filter
This study source was downloaded by 100000825833104 from CourseHero.com on 05-26-2021 14:44:58 GMT -05:00
https://www.coursehero.com/file/61195148/power-bidocx/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
Powered by TCPDF (www.tcpdf.org)
https://www.coursehero.com/file/61195148/power-bidocx/
http://www.tcpdf.org