MS PowerBI Assessment

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 or C

• A or B

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

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

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

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

• report editor

• Power Query Editor

• dashboard

• data modeler

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

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

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

• nly 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