Learning Power BI Desktop
Which statement is true regarding slicers?
A slicer can filter at both the page level and the report level.
When merging two tables using a left outer join, what shows when there is no match?
Cells that do not match will show null.
Which view is not offered when you launch Power BI Desktop for the first time?
Connections
Which language is behind the custom query formulas?
M
How is previewing a CSV file before loading it different than previewing an Excel file?
How is previewing a CSV file before loading it different than previewing an Excel file?
Which statement is false regarding the Navigator window that opens when you connect to an Excel file?
It allows you to delete data rows.
Which statement is false regarding a column index that you add using the default choices?
It starts with index 1.
Your company is tracking sales data in Excel. What would be your recommendation on how to arrange this data for a multiyear analysis?
Keep all the data in one big sheet, with columns to denote the sale date and year.
When you share a report with other users, what access do they have, assuming there are no low-level security restrictions?
Users have the same access as you.
Preset styles _____.
are based on the theme
You can preview all tables individually.
connecting to data models created in legacy tools, such as Power Pivot and Power Query
A slicer can filter at both the page level and the report level.
data reporting
What does the index of a row represent when you add an index column?
the position of that row in the row order
When will the Replace Values operation generate an error?
when replacing numeric values with letters
You need to add another column to your data that simply sets all values to the text "complete". Which custom column formula should you use?
="complete"
What step should you perform before adding data from more tables, if you need to eventually aggregate the data by which table it originally came from?
Add a custom column to each table, set to the table name.
Which statement is false regarding the Applied Steps in Power Query Editor?
Adding a step immediately changes the underlying data source.
Which statement is not true regarding the Q&A visualization?
By default, field names entered in the Q&A visualization must match the field names in the data model.
What is not an option with Q&A Setup?
Format Q&A visualization
Which statement is true regarding the Power BI Desktop sign-in step?
Microsoft offers a trial period to use Power BI Pro features.
What should you check before changing a text column to a decimal number type?
Negative values use the minus symbol, not a hyphen.
What does the Transpose action perform?
Switch the rows and columns with each other.
How can adding a card visualization to your map help?
The card can show more details on data selected in the map.
Which defaults will a report have for its filters when it is imported into the Power BI service?
The filters will default to the same values they were last saved with.
Your report consists of a bar chart and a tree map visualizing the same data. What happens when you select one bar in the bar chart?
The selection is highlighted in both visualizations.
What happens when you publish a PBIX file with a name that is already used?
The system will ask whether you want to replace the data set.
What is a quick way to tell that data that consists of numbers is actually formatted as text?
The values will be left-justified.
Which statement is false regarding custom visuals?
They have to be purchased.
Does Power BI Desktop truncate the preview for an Access database connection?
Yes it does, by the data size.
The filters will default to the same values they were last saved with.
Yes, quick insights are offered, even if you just publish a data set.
When connecting Power BI Desktop to a web data source pointing to a webpage with multiple tables, what can you preview?
You can preview all tables individually.
In a standard card visualization, a field added to the card is added at the _____.
right
When merging tables in Power BI Desktop, which join kind shows all rows from the second table, and matching from the first table?
right outer
Which capability is missing from the Power BI service?
robust data modeling using the drag-and-drop feature
What is Power BI?
a self-service business intelligence solution
Which cardinality will you use to represent a bank customer in one table related to different bank accounts in a different table?
one to many
