Microsoft Power BI

Q1. A dataset that includes _ can be used to create a map visualization. (Select all that apply.)

A. house numbers, street names
B. geospatial data
C. city names, country names
D. longitude, latitude

A, B, C, D
A, C, D
B, C, D
D

Q2. How do you create a chart visual in Power BI Desktop Report view? (Select all that apply.)

A. Click New Visual on the Home tab.
B. Select a chart visual in the Visualizations pane.
C. Click New Visual on the Data Tools tab.
D. Select a field that contains values.

A, B, or D
B or D
B orC
A or B

Q3. What daily sales number does this DAX measure formula calculate?

CALCULATE(SUM([Sales]) ,DATESMTD([Date] ))

running total sales in each month that starts over each month
total sales for the entire month
running total in entire year for the entire month
rolling average over 12 months of sales

Q4. You are creating a report in Power BI Desktop and want to restrict the data to records where Country="Canada". To accomplish this, what do you need to create?

a directive
a custom column
an indexed column
a parameter

Q5. What is the primary benefit of using visualizations such as line charts, bar charts, and column charts?

They are easier to create than other visualizations.
They require fewer resources than more complex visualizations.
They are also used in Excel, so they feel familiar to users.
They are free to use.

Q6. In Power BI service, deleted pages are available after deletion until

midnight of the day on which they are deleted
the next billing cycle
you empty the Recycle Bin
the report has been saved

Q7. You need to add a required color to a bar chart. How can you add an exact color value to an existing bar chart?

Click the color in the visual (e.g., the bars) and right-click to select the color.
You cannot select custom colors in a bar chart or related visual.
Select the value closest to this color from the color formatting options.
Enter the hex value into the color formatting options.

Q8. The Excel function IF is nearly the same as which DAX function?

SWITCH
IF
IFX
IFS

Q9. Consider the Power BI extract, transform, and load process (ETL). During this process, data is read and then

stored in SQL Server
written to an OLAP cube
assigned a data type
sorted by primary key

Q10. Power BI's Publish to Web option allows you to embed visualizations within _. (Select all that apply.)

A. blog posts
B. email messages
C. web sites
D. text messages

A,C
C
A, B, C
A, B, C, D

Q11. What can you do within the Power BI Desktop #### Query Settings pane? (Select all that apply.)

A. Rename a query step.
B. Delete a query step.
C. Delete from one query step to the end.
D. Reorder the steps.

B, C, D
A, B, C, D
A, B, D
A, B, C

proof link

Q12. After you enter text in the #### Q&A box or O&A visual, Power BI will `\_` your data to create a list of appropriate visualizations.

filter and group
sort and filter
sort, filter, and group
sort and group

Q13. You just deleted a dashboard in the Power BI service and want to get it back. What should you do?

Press Ctrl+Z.
Select Undo from the toolbar.
You cannot undo the deletion of a dashboard.
Recover it from the Recycle Bin.

proof link1
link2

Q14. You have a sales data source and want to relate the tables. The table that contains sales transactions is a _ table that contains product information is a _ table .

dimension; fact
lookup; data
data; lookup
data; supporting

Q15. When you are creating a formula in the Power Query Editor, what does IntelliSense provide a list of? (Select all that apply.)

A. columns
B. tables
C. functions
D. data sources

B,C
A, C, D
C,D
A, B, C

Q16. You want to delete a dataset but the Power BI service will not let you. What is the most likely cause?

A tile on your dashboard contains data from that dataset.
The dataset is already being used in a published app.
A report contains data from that dataset.
The dataset is in your workspace.

Q17. One of your data columns includes the city, state, and postal code line of a mailing address. You need to separate the fields so you can access the geospatial elements for a map visualization. What transformation should you apply?

Replace values
Split column
Modify data type
Best fit geospatial

Q18. Formatting options within a visualization depend on what?

the visualization you are formatting
the editor you use
the visualization group
your permissions

proof link

Q19. What tool can you use in Power BI Desktop to reduce data?

report editor
Power Query Editor
dashboard
data modeler

Q20. What is NOT a valid data connection type for Power BI Desktop?

Azure data
file data
relationships data
database data

Q21. Which data type can be uploaded directly to powerbi.com?

Excel files
comma-separated value (CSV) files
Power BI Desktop files
all of these answers

Q22. What does Power BI Premium provide?

Power BI Report Server
report sharing without a per-user licens
all of these answers
dedicated capacity for your company

Q23. You have a report in Power BI service and want to save the state of a report page for easy access. What feature helps you do this?

views
filters
bookmarks
slicers

Q24. What should you do to increase the readability of a report?

all of these answers
Remove unnecessary field labels.
Select the most appropriate visualization.
Use borders.

Q25. Which feature in the Power BI service is most useful when you need to create pages that present the same visualizations for different territories, salespeople, or teams?

landscape mode
none of these answers
Shrink to Fit
templates

Q26. What should you use to highlight a specific visualization in a report?

Spotlight
Highlight
Magnify
None of the answers

Q27. What does My Workspace on powerbi.com include?

Visualizations and a fields list
Toolbars and preferences
Workbooks and visualizations
Dashboards and reports

Q28. You want to access the underlying data for a specific data point in a visualization. What should you choose?

Drill up
Drill down
Expand to next level
Collapse

Q29. You have a treemap visualization that groups by sales territory. To allow users to further analyze data for a specific territory, what filter should you apply?

Visual level
Page level
Drillthrough
Expand down

Q30. Facebook, Twilio, GitHub, and MailChimp are all examples of Power BI _.

online services
Wiki data sources
database data sources
File data sources

Q31. When you use Publish to Web in the Power BI service, who can view your published content?

everyone in your environment
anyone on the internet
everyone in your organization
only you

Q32. The iterator functions SUMX and AVERAGEX are used to perform calculations _.

for Power BI mobile apps
in Power BI service rather than Power BI desktop
in the context of a record
for very large datasets

Q33. In Power BI Desktop Model view, what type of join will yield all results from Table 1 and any matching results from Table 2?

Right Outer Join
Left Outer Join
Left Inner Join
Right Inner Join

Q34. What is NOT a built-in Power BI visual?

Power KPI
funnel chart
waterfall chart
ArcGIS map

Q35. You want to combine several CSV files into a single data file after you connect a folder. What must be true about these CSV data files? (Select all that apply.)

A. They must be stored in the same folder. B. They must have the same schema. C. They must have the same file type. D. They must have no duplicate data rows.

B, C
A, B, C
A, B, D
B, C, D

Q36. If you delete a dateset in the Power BI service, what happens to the dashboards and reports supported by the dataset?

They will be stored as static dashboards and reports.
They will be deleted.
They will be converted to image files.
Nothing—they will be unchanged.

Q37. Which DAX function compares a column of values in Table A with a similar column in Table B, and returns the values the are not found in Table B?

COMPARE
FINDUNIQUE
EXCEPT
SWITCH

Q38. Your data model includes two related tables, Customers and Orders. To determine the number of customers that have placed orders, create a measure on the _ table using the _ function.

Orders; DISTINCTCOUNT
Customers; COUNT
Orders; COUNT
Customers; DISTINCTCOUNT

Q39. Power BI works best with tables that are _,

short and wide
long and skinny
short and skinny
long and wide

Q40. You have two columns of numerical data and want to create a visual to help determine if there is a relationship between them. What kind of chart is designed to do this?

bar chart
bubble chart
line chart
scatter chart

Explanation: As both of the columns have numeric data, we will use a scatter chart and apply them in X-axis and Y-axis

Q41. In the report editor, which task can you NOT accomplish using drag and drop?

Add more information to a visualization.
All of these tasks can be done with drag and drop.
Create a new visualization.
Rearrange and resize visualizations.

Q42. In general, what is the best way to shape your data for Power BI?

User a star schema.
Load all tables from the data source.
all of these answers
Include multiple objects in each data table.

Q43. You can optionally include a filter in which DAX function?

CALCULATE
SUM
PICARD
COMPARE

Q44. Which feature is `not` in the Power BI Admin portal?

usage metrics
organization visuals
Dashboard Manager
audit logs

Q45. You want to count the number of products in the Products data table. Which DAX function works best?

RECOUNT
COUNTUNIQUE
COUNTX
COUNTROWS

Q46. You have just pinned a visualization to a new dashboard. Before you can add another visualization, what must you do?

Save it.
Name it.
Refresh it.
Publish it.

Q47. You can create a live connection to _ .

Dynamics 365
SharePoint
all of these answers
SQL Server Analysis Services

Q48. What is the purpose of this code?

ProductCount = COUNT(Products[ProductID])

It is part of the documentation
It creates and formats a measure called ProductCount
It creates a measure called ProductCount
It calculates the value for an existing measure named ProductCount

Q49. Your computer rental dataset includes columns for StartTime, EndTime, and PerHourRate. What two DAX functions could you use to calculate the total earned for rentals?

DATEDIFF and SUM
DATEDIFF and SUMX
TIMEDIFF and SUM
TIMEDIFF and SUMX

Q50. Which Q&A feature helps you ask questions and refine your visualization?

error dialogs
autocomplete
all of these answers
tooltips

Q51. What does Power BI Desktop do when it cannot create a standard map visualization with the available data?

It sends the data to the Power BI service
It returns an error
It sends the data to Bing
It substitutes a column chart

Q52. Bookmarks capture the state of a page. What does this capture state include?

A. sorting
B. filtering
C. current selection
D. properties of visuals

A, B
A, B, C
A, B, C, D
A, B, D

Q53. Your company's national maintenance team is divided into 12 regions, and the Issues report they use is filtered by the user's region. What report modification would help technicians while using the mobile app on the road? (Select all that apply.)

A. Add a geographic filter to City.
B. Add a geographic filter to State.
C. Add a geographic filter to Street Address.
D. Add a geographic filter to Country.

A, B, D
A, B, C, D
A, B, C
A, B

Q54. What does the usage metric "Most Consumed Dashboards by Users" include? (Select all that apply.)

A. the person who built the dashboard
B. other people who share the dashboard
C. users who consume the dashboard in a content pack
D. individual user downloads of the dashboard

A, B, C, D
A, B, C
A, D
B, C, D

Q55. How can you allow users to filter an entire report to display information for the last week, last two weeks, or last month?

Add a date field to the report filter area and set filtering to Relative date filtering.
all of these answers
Add a date field to the page filter area, set filtering to Relative date filtering and click Extend.
Add a slicer for a date field to the report. Click the upper right corner and select Relative.

Q56. A group admin for an app workspace cannot _ in their workspace.

remove users from the group
manage group membership
add users to the group
remove users from Power BI

Q57. In general, you should not add DAX calculated columns to your data moder if you are able to do what?

all of these answers
Create the columns in Power Query during data load
Create a measure instead
Have it added to the data source

Q58. In the Power BI service, accessing a dataset for an uploaded Power BI file allows you what capabilities?

the ability to see all of the dataset only in Power BI cloud services, but not in Power BI Desktop
front-end access to all data queries within this source without the ability to make back-end changes
connections to all the data queries and the ability to make ETL modifications to existing data
the option to select a single query from within the dataset and build new ETL processes form it

Q59. What is the recommended level of security for data extensions?

Prompt the user before load
Allow any extension to load without warning
Allow only certified extensions to load
Load certified extensions and prompt the user for noncertified extensions

Q60. Your data model includes a Members data table and ten other tables, including these the lookup tables with unique IDs: City, State, and Country. How can you improve your data model for Power BI?

A. Combine City, State, and Country into one lookup table
B. Move City, State, and Country to the Member table
C. Combine City and State into one lookup table and remove the Country table
D. Leave the model as it is.

A or C
A
D
A or B

Q61. Before you can use a custom visualization from the Power BI Marketplace, you need to __ in, then it to your Power BI account.

download; upload
purchase; import
purchase; upload
upload; download

Q62. You have two Excel spreadsheets with data from separate reporting units. Both spreadsheets have the same column names. What Power Query Editor feature can you use to create a unified dataset?

Unify
Append
Merge
Group

Q63. Power BI Q&A chooses the best visualization based on data type - for example, a chart for date data and a for state/province data.

column; map
line; map
timeline; map
line; column

Q64. In Power BI, what is the most important difference between tables related in a star schema and in a snowflake schema?

A snowflake schema cannot be modeled in Power BI.
A snowflake schema can be modeled only in Power BI service.
A snowflake schema is much less efficient for Power BI.
A snowflake schema has more levels of lookup tables.

Q65. What are benefits of modifying your Excel data source in the Power Query Editor rather than in Excel?

A. You can track the changes you make.
B. It is less error prone than manual editing.
C. It will not affect other users of the spreadsheet.
D. It "locks down" the spreadsheet columns in Excel.

A, B, C
A, B, C, D
A, C, D
B, D

Q66. Your report is based on imported data from Excel. What is a valid reason to use a slicer rather than a report-lever filter?

A. A slicer makes it easier for users to filter
B. Users should be able to see both filtered and nonfiltered values.

A and B
B and C
A and C
There is no reason to use a slicer rather than a report-level filter.

Q67. Within Power BI, how can a report be created?

directly from a dataset
starting with an existing report and editing it
using an existing report
all of these answers

Q68. In the Power BI service, filters are applied in what view?

Filter
Editing
Reading
Query

Q69. What are the first steps you take to connect to an Access database data source in Power BI?

You cannot to an Access database from Power BI.
Click Reports > Database > Connect in Power BI Desktop
Click Get Data > Database > Access Database > Connect in Power BI Service
Click Get Data > Database > Access Database > Connect in Power BI Desktop

Q70. What can you use Power BI for?

all of these answers
to create visualizations
to model data
to generate reports

Q71. What is the primary purpose of the Relationship view in Power BI Desktop?

to transform data
to add members to your team or group
to grant permission to view a specific table
to relate tables

Q72. What do you call a visualization that has the single purpose of filtering other visuals in the view?

waterfall
none of these answers
ArcGIS visual
slicer

Q73. To share a dashboard and your comments from a mobile device, _ the dashboard.

comment and share
annotate and share
publish
team share

Q74. In the Power Query Editor, you have selected multiple columns. How do you set them all to the Whole Number data type?

Click Data Type Any and select Whole Number.
Select Group By and select Whole Number.
Right-click the primary key and select Whole Number.
Right-click any column and select Format Data

Q75. When will links to a web-published report stop working?

approximately one hour after the report is deleted
approximately one month after the report is deleted
never
approximately one week after the report is deleted

Q76. What are the first steps to connect to a data table on Wikipedia from Power BI Desktop?

Get Data > OData feed > Web URL
Get Data > Web > Enter Web URL
Get Data > Web Table > Enter Web URL
Get Data > Data Source > Enter Web URL

Q77. In the Power Query Editor, what command do you use to remove a symbol `-` for example, a `#` that appears in every data now of the selected column?

Transform > Replace Values
Transform > Remove Text
Transform > Remove Values
Transform > Replace Errors

Q78. Which type of visualization is best when you want to compare proportions in a large volume of data with multiple categories and subcategories?

donut chart
gauge chart
treemap
waterfall

Files

microsoft-power-bi-quiz.md

Latest commit

History