Microsoft Power BI Quiz # 2

If you delete a dateset in the Power BI service, what happens to the dashboards and reports supported by the dataset?

They will be stored as static dashboards and reports.

They will be deleted.

They will be converted to image files.

Nothing—they will be unchanged.

Which DAX function compares a column of values in Table A with a similar column in Table B, and returns the values the are not found in Table B?

COMPARE

FINDUNIQUE

EXCEPT

SWITCH

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

Orders; COUNT

Customers; DISTINCTCOUNT

Power BI works best with tables that are _,

Short and wide

Long and skinny

Short and skinny

Long and wide

You have two columns of numerical data and want to create a visual to help determine if there is a relationship between them. What kind of chart is designed to do this?

Bar chart

Bubble chart

Line chart

Scatter chart

In the report editor, which task can you NOT accomplish using drag and drop?

Add more information to a visualization.

All of these tasks can be done with drag and drop.

Create a new visualization.

Rearrange and resize visualizations.

In general, what is the best way to shape your data for Power BI?

User a star schema.

Load all tables from the data source.

All of these answers

Include multiple objects in each data table.

You can optionally include a filter in which DAX function?

CALCULATE

SUM

PICARD

COMPARE

Which feature is not in the Power BI Admin portal?

Usage metrics

Organization visuals

Dashboard Manager

Audit logs

You want to count the number of products in the Products data table. Which DAX function works best?

RECOUNT

COUNTUNIQUE

COUNTX

COUNTROWS

You have just pinned a visualization to a new dashboard. Before you can add another visualization, what must you do?

Save it.

Name it.

Refresh it.

Publish it.

You can create a live connection to _ .

Dynamics 365

SharePoint

All of these answers

SQL Server Analysis Services

What is the purpose of this code? ProductCount = COUNT(Products[ProductID])

It is part of the documentation

It creates and formats a measure called ProductCount

It creates a measure called ProductCount

It calculates the value for an existing measure named ProductCount

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?

DATEDIFF and SUM

DATEDIFF and SUMX

TIMEDIFF and SUM

TIMEDIFF and SUMX

Which Q&A feature helps you ask questions and refine your visualization?

Error dialogs

Autocomplete

All of these answers

Tooltips

What does Power BI Desktop do when it cannot create a standard map visualization with the available data?

It sends the data to the Power BI service

It returns an error

It sends the data to Bing

It substitutes a column chart

A group admin for an app workspace cannot _ in their workspace.

Remove users from the group

Manage group membership

Add users to the group

Remove users from Power BI

In general, you should not add DAX calculated columns to your data moder if you are able to do what?

All of these answers

Create the columns in Power Query during data load

Create a measure instead

Have it added to the data source

In the Power BI service, accessing a dataset for an uploaded Power BI file allows you what capabilities?

The ability to see all of the dataset only in Power BI cloud services, but not in Power BI Desktop

Front-end access to all data queries within this source without the ability to make back-end changes

Connections to all the data queries and the ability to make ETL modifications to existing data

The option to select a single query from within the dataset and build new ETL processes form it

What is the recommended level of security for data extensions?

Prompt the user before load

Allow any extension to load without warning

Allow only certified extensions to load

Load certified extensions and prompt the user for noncertified extensions

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

Download; upload

Purchase; import

Purchase; upload

Upload; download

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

Power BI Q&A chooses the best visualization based on data type - for example, a ** chart for date data and a ** for state/province data.

Column; map

Line; map

Timeline; map

Line; column

In Power BI, what is the most important difference between tables related in a star schema and in a snowflake schema?

A snowflake schema cannot be modeled in Power BI.

A snowflake schema can be modeled only in Power BI service.

A snowflake schema is much less efficient for Power BI.

A snowflake schema has more levels of lookup tables.

Within Power BI, how can a report be created?

Directly from a dataset

Starting with an existing report and editing it

Using an existing report

All of these answers

When will links to a web-published report stop working?

Approximately one hour after the report is deleted

Approximately one month after the report is deleted

Never

Approximately one week after the report is deleted

In the Power Query Editor, what command do you use to remove a symbol - for example, a # that appears in every data now of the selected column?

Transform > Replace Values

Transform > Remove Text

Transform > Remove Values

Transform > Replace Errors

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

Gauge chart

Treemap

Waterfall