Power BI Quizzes

Practice Quizzes
Thanks!
Thanks!

Power BI Quizzes

Accelerate your Career and Get Certified

Visualize Data in Power BI

Friday, June 25th, 2021

Welcome to your Visualize Data in Power BI

The general section of the formatting menu allows you to set [select all that apply]

color

font

placement

size

background

KPIs must include a unit of measurement, a goal, and a _____.

time series (daily, monthly, yearly)

a color scheme (red, yellow, green)

a dimension (product category, store location)

Which of the following accessibility features need to be configured? [select all that apply]

Titles and labels

Tab order

Show data table

Alt text

Focus mode

High contrast colors view

Which of the following is true? [select all that apply]

Before you create the R visual, you must install R on your local computer so that Power BI Desktop can run R scripts.

Python and R visualizations can be added through Microsoft AppSource

Before you create the Python visual, you must install Python on your local computer so that Power BI Desktop can run Python scripts.

This chart type looks like an upside-down pyramid

Tree map

Waterfall

Funnel

Slicer

It is best practice to place the most important visual in the ________ of your report.

center

upper-left corner

upper-right corner

upper center

A combo chart visualization combines which two of the following

Pie and donut

Scatter Plot and pie chart

line chart and area chart

Bar and line chart

The custom visual software development kit is based on

NodeJS

Power Query

D3

Tableau

Custom visuals available in Microsoft AppSource are certified, meaning that they meets the code requirements and don't access external services or resources.

False

True

It's possible to hide objects from the tab order

False

True

Once custom visuals are added to Power BI, there will be an icon in the Visualizations pane with the label "Custom." When it is clicked a menu will allow you to choose from the visuals you have imported.

False

True

Web Content Accessibility Guidelines (WCAG) help make web content accessible to people with disabilities. Which of the following is not a key principle of the WCAG guidelines?

Perceivable - Information and user interface components must be presentable to users in ways that they can perceive.

Reversible - Possible to undo actions easily

Understandable - Information and the operation of the user interface must be understandable.

Operable - User interface components and navigation must be operable.

It's best practice to avoid using _______ as the only way of conveying information

labels

position

size

color

By default, no tooltip will be shown, but it can be added through the formatting menu

True

False

Which visualization allows you to ask natural language questions?

Cortana

Waterfall

Q&A visualization

Python

NLP

Tooltips can contain only text, not graphics

True

False

The R script editor creates a _____ with the columns selected

dataframe

bar chart

table

array

Bookmarks in Power BI

Navigate to a specific page in a report

Capture a configured view of a report page

Save a link to a report to the report homepage

This feature allows you to determine which parts of the view are visible

hide button

hide/show menu

selections

bookmarks

You can use conditional formatting to set the navigation destination based on the output of a measure. The first step to do this is:

Go to the Insert tab on the ribbon and select Buttons, then Navigator.

Create a single column table listing the of navigation destinations.

Add the tab list it to the report page as a single-select slicer.

1. Which of the following is not a hierarchy button

Drill down all fields at once

Fully expand hierarchy

Drill-up

Drill-down

Expand all fields at once

The Edit Interactions options allows an interaction to both filter and highlight at the same time

False

True

Cross-highlighting/filtering can be disabled for the entire workbook by selecting File > Options and settings > Options, and selecting ________.

Interaction

Filtering

Query reduction

A single button to navigate to different pages based on the user's selection should have the destination set as

a table with the navigation list

conditional formatting

the tabs in the report

Slicers can be added through the

fields pane

filter pane

visualizations pane

Which should be used for basic filtering?

Slicers

Filters

A button can be used to allow the user to access a view saved in a bookmark

True

False

Conditional formatting in a table can change the background color or font color in a table and can also [select all that apply]

Add icons

Change the font type

Add data bars

Add interactions

Change the font size

The selections pane has _____ icons

highlight

eye

color pallete

star

Sort options include [select all that apply]

Sort by

Sort custom

Sort ascending

Sort descending

Filter, Visualizations and Fields panes are available

on both dashboards and reports

on reports but not dashboards

on dashboards but not reports

It's recommended that production reports are published to

my workspace

app workspace

team workspace

Power BI files are saved with this extension

pbi

pbix

pb

pwbi

By default, Power BI adjust the view based on the screen size. Power BI gives priority to the _____ and adjusts other parts of the visual to keep it visible

data

labels

axes

legend

A dashboard

Must be one page but can use multiple datasets

Can be multiple pages but must use one dataset

Can be multiple pages and use multiple datasets

Must be one page and use one dataset

______ a visual element to add it to a dashboard

drag

import

pin

Power BI alerts will be automatically sent to the Notification Center in Power BI and to your email address.

False

True

Anyone can choose to receive an alert, but only the dashboard owner can create an alert.

False

True

When you pin a live page, any changes that you make to the report will automatically show on the dashboard when the page is refreshed.

False

True

Dashboards can be optimized for mobile using

Power BI Service only

Both Power BI Desktop and Power BI service

Power BI Desktop only

Streaming data can be stored in the Power BI data model.

True

False

To add streaming data, open a dashboard and then select Add Tile. The following window will appear, where you can select Custom Streaming Datasets under _______.

Temporary Data

IoT Data

Real-Time Data

Streaming Data

Big Data

Streaming data is stored in a

data lake

flat file

database

temporary cache

Best practice is to pin the entire report page and then remove any unneeded tiles from the dashboard.

True

False

Dashboards can be created

in Power BI desktop and Power BI service

only in Power BI desktop

only in Power BI service

After updating the mobile view on Power BI desktop

you must select export to mobile to see the updates on mobile

you must published to Power BI service before being able to see the updates on mobile

you must save before being able to see the updates on mobile

the changes will be available on mobile automatically

Dashboards can be viewed

in Power BI desktop and Power BI service

on Power BI service and mobile devices

only in Power BI service

only in Power BI desktop

only on mobile devices

Data classification

helps raise security awareness

enforces security policies

has three standard levels - DO NOT SHARE, ASK FOR PERMISSION, and OK TO SHARE

Power BI paginated reports are descendants of

Access Reports

SQL Server Reporting Services (SSRS)

ReportLab

Microstrategy

Crystal Reports

Company-wide settings for data classification can be set here

Security settings

Tenant settings

Clicking the ellipsis on the dashboard and selecting settings

Maximum alert frequency can be set to be [select all that apply]

Once a week

Once a day

Once an hour

Once a month

Whenever data is refreshed

Data classification can be turned on and off in accordance with your organization's business needs.

True

False

Dashboard themes can be uploaded and downloaded in this format

XML

CSV

JSON

DAX

Paginated reports are created with

Power BI desktop

Power BI mobile

Power BI report builder

Power BI service

Paginated reports render _____ data exceedingly well.

video

JSON

streaming

tabular

Which of the following is not a feature of paginated reports?

optional headers and footers

flexible filtering

total control of how the report renders

outputting thousands of rows of data for hundreds of printable pages

Power BI Report Builder allows the user to merge data from multiple data sources, such as flat files, oracle and SQL server databases, and google sheets

True

False

Power BI Report Builder uses Power Query to connect to a data source

False

True

A ______ can be used to limit the data retrieved for a paginated report

parameter

slicer

data source filter

Power BI Report Builder imports entire tables. It cannot use SQL queries to aggregate or limit the rows imported.

False

True

In the design surface

Headers appear in bold while fields appear in capital letters

Headers appear without brackets while fields appear with brackets

Headers appear in bold while fields appear in italics

Headers appear in lower case while fields appear in capital letters

This symbol is used in a query before a parameter reference

#

$

^

@

Time is Up!

Time's up

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment

Name *

Email *

Website

Δ

About the Author: Lukas Halim

I earned a Masters in Analytics from NC State in 2013 and now work as a data analyst in the health insurance industry. Using tools such as SAS, Tableau, and Teradata, I conduct analysis to help my company improve healthcare affordability and customer engagement.

Learn More

4.6 Instructor Rating
53,604 Students

14,612 Reviews
2 courses

© Learning Tableau. All rights reserved.
Privacy Policy | Design by Liscio Apps, LLC