Microsoft Power BI Test

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

B, C, D

D

A, C, D

Option A

Option B

Option C

Option D

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.

B or C

A or B

B or D

A, B, or D

Option A

Option B

Option C

Option D

What daily sales number does this DAX measure formula calculate?
CALCULATE(SUM([Sales]),DATESMTD([Date]))

rolling average over 12 months of sales

running total sales in each month that starts over each month

running total in entire year for the entire month

total sales for the entire month

Option A

Option B

Option C

Option D

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 PARAMETER

A CUSTOM COLUMN

A DIRECTIVE

AN INDEXED COLUMN

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 ARE FREE TO USE.

THEY REQUIRE FEWER RESOURCES THAN MORE COMPLEX VISUALIZATIONS.

THEY ARE ALSO USED IN EXCEL, SO THEY FEEL FAMILIAR TO USERS.

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

MIDNIGHT OF THE DAY ON WHICH THEY ARE DELETED

THE NEXT BILLING CYCLE

THE REPORT HAS BEEN SAVED

YOU EMPTY THE RECYCLE BIN

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

YOU CANNOT SELECT CUSTOM COLORS IN A BAR CHART OR RELATED VISUAL.

ENTER THE HEX VALUE INTO THE COLOR FORMATTING OPTIONS.

CLICK THE COLOR IN THE VISUAL (E.G., THE BARS) AND RIGHT-CLICK TO SELECT THE COLOR.

SELECT THE VALUE CLOSEST TO THIS COLOR FROM THE COLOR FORMATTING OPTIONS.

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

IF

SWITCH

IFS

IFX

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

STORED IN SQL SERVER

ASSIGNED A DATA TYPE

SORTED BY PRIMARY KEY

WRITTEN TO AN OLAP CUBE

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; DISTINCTCOUNT

ORDERS; COUNT

CUSTOMERS; COUNT

Power BI works best with tables that are _____.?

LONG AND SKINNY

LONG AND WIDE

SHORT AND WIDE

SHORT AND SKINNY

Many data models include a _____ dimension table that can easily be created once in Excel or Power BI and then reused.?

PRESCRIPTIVE

FACT

HIDDEN

DATE

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

POWER BI DESKTOP FILES

EXCEL FILES

ALL OF THESE ANSWERS

COMMA-SEPARATED VALUE (CSV) FILES

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

DRILL DOWN

COLLAPSE

DRILL UP

EXPAND TO NEXT LEVEL

What does Power BI Premium provide?

REPORT SHARING WITHOUT A PER-USER LICENSE

DEDICATED CAPACITY FOR YOUR COMPANY

POWER BI REPORT SERVER

ALL OF THESE ANSWERS

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

DATABASE DATA

RELATIONSHIPS DATA

AZURE DATA

FILE DATA

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

SELECT THE MOST APPROPRIATE VISUALIZATION.

ALL OF THESE ANSWERS

USE BORDERS.

REMOVE UNNECESSARY FIELD LABELS.

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?

PAGE LEVEL

VISUAL LEVEL

DRILLTHROUGH

EXPAND DOWN

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?

MODIFY DATA TYPE

SPLIT COLUMN

REPLACE VALUES

BEST FIT GEOSPATIAL

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?

FILTERS

SLICERS

VIEWS

BOOKMARKS

Page 1 of your report includes multiple visualizations. To filter just the bar chart visualization, what type of filter should you use?

BAR CHART

SLICER

VISUAL LEVEL

PAGE-LEVEL

What does My Workspace on powerbi.com include?

WORKBOOKS AND VISUALIZATIONS

TOOLBARS AND PREFERENCES

VISUALIZATIONS AND A FIELDS LIST

DASHBOARDS AND REPORTS

The iterator functions SUMX and AVERAGEX are used to perform calculations _____.?

FOR POWER BI MOBILE APPS

FOR VERY LARGE DATASETS

IN POWER BI SERVICE RATHER THAN POWER BI DESKTOP

IN THE CONTEXT OF A RECORD

After you enter text in the Q&A box or Q&A visual, Power BI will _____ your data to create a list of appropriate visualizations.?

SORT AND FILTER

SORT, FILTER, AND GROUP

SORT AND GROUP

FILTER AND GROUP

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

REPORT EDITOR

DASHBOARD

DATA MODELER

POWER QUERY EDITOR

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

HIGHLIGHT

MAGNIFY

NONE OF THESE ANSWERS

SPOTLIGHT

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

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

THE DATASET IS ALREADY BEING USED IN A PUBLISHED APP.

THE DATASET IS IN YOUR WORKSPACE.

A REPORT CONTAINS DATA FROM THAT DATASET.

A TILE ON YOUR DASHBOARD CONTAINS DATA FROM THAT DATASET.

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?

TIMEDIFF AND SUM

DATEDIFF AND SUM

TIMEDIFF AND SUMX

DATEDIFF AND SUMX

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

UPLOAD; DOWNLOAD

PURCHASE; UPLOAD

DOWNLOAD; UPLOAD

PURCHASE; IMPORT

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

DATA; LOOKUP

LOOKUP; DATA

DIMENSION; FACT

DATA; SUPPORTING

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

WATERFALL

GAUGE CHART

TREEMAP

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?

TEMPLATES

SHRINK TO FIT

LANDSCAPE MODE

NONE OF THESE ANSWERS

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

EVERYONE IN YOUR ENVIRONMENT

ONLY YOU

EVERYONE IN YOUR ORGANIZATION

ANYONE ON THE INTERNET

Formatting options within a visualization depend on what?

THE EDITOR YOU USE

YOUR PERMISSIONS

THE VISUALIZATION YOU ARE FORMATTING

THE VISUALIZATION GROUP

Your Name: (required)
Your Email: (required)
Skype Username:
Exams you want to pass:

Exam Type:	Microsoft Power BI MCQ Skill Test
Questions Type:	Multiple Choice Questions
Total Questions:	35
Time Limit:	30 Minutes
Last Update	June, 2025

Pass Microsoft Power BI Exam

Microsoft Power BI Quiz

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

B, C, D

D

A, C, D

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.

B or C

A or B

B or D

A, B, or D

What daily sales number does this DAX measure formula calculate?
CALCULATE(SUM([Sales]),DATESMTD([Date]))

rolling average over 12 months of sales

running total sales in each month that starts over each month

running total in entire year for the entire month

total sales for the entire month

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?

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

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

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

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

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

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.?

Power BI works best with tables that are _____.?

Many data models include a _____ dimension table that can easily be created once in Excel or Power BI and then reused.?

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

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

What does Power BI Premium provide?

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

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

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?

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?

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?

Page 1 of your report includes multiple visualizations. To filter just the bar chart visualization, what type of filter should you use?

What does My Workspace on powerbi.com include?

The iterator functions SUMX and AVERAGEX are used to perform calculations _____.?

After you enter text in the Q&A box or Q&A visual, Power BI will _____ your data to create a list of appropriate visualizations.?

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

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

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?

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

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?

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

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

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

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?

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

Formatting options within a visualization depend on what?