Microsoft Power BI Quiz # 1

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

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

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.

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

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.

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

SWITCH

IF

IFX

IFS

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

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

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.

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

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.

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

Formatting options within a visualization depend on what?

The visualization you are formatting

The editor you use

The visualization group

Your permissions

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

Report editor

Power Query Editor

Dashboard

Data modeler

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

Azure data

File data

Relationships data

Database data

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

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

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

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.

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

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

Spotlight

Highlight

Magnify

None of the answers

What does My Workspace on powerbi.com include?

Visualizations and a fields list

Toolbars and preferences

Workbooks and visualizations

Dashboards and reports

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

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

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

Online services

Wiki data sources

Database data sources

File data sources

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

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

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

What is NOT a built-in Power BI visual?

Power KPI

Funnel chart

Waterfall chart

ArcGIS map

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