> > Microsoft Power BI MCQs > Basic Microsoft Power BI MCQs

Basic Microsoft Power BI MCQ

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

Answer

Correct Answer: Using an existing report

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Timeline; map

Note: This Question is unanswered, help us to find answer for this one

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

Answer

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

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Remove users from Power BI

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Name it.

Note: This Question is unanswered, help us to find answer for this one

6. Which feature is not in the Power BI Admin portal?

Usage metrics

Organization visuals

Dashboard Manager

Audit logs

Answer

Correct Answer: Dashboard Manager

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: User a star schema.

Note: This Question is unanswered, help us to find answer for this one

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

Answer

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

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Orders; DISTINCTCOUNT

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: EXCEPT

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: They will be deleted.

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Everyone in your organization

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Drillthrough

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Expand to next level

Note: This Question is unanswered, help us to find answer for this one

15. What does My Workspace on powerbi.com include?

Visualizations and a fields list

Toolbars and preferences

Workbooks and visualizations

Dashboards and reports

Answer

Correct Answer: Dashboards and reports

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Templates

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: All of these answers

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Views

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: All of these answers

Note: This Question is unanswered, help us to find answer for this one

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

Report editor

Power Query Editor

Dashboard

Data modeler

Answer

Correct Answer: Data modeler

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: The dataset is already being used in a published app.

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Data; lookup

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Press Ctrl+Z.

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Sort and group

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Stored in SQL Server

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Click the color in the visual (e.g., the bars) and right-click to select the color.

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: The report has been saved

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: They require fewer resources than more complex visualizations.

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: A directive

Note: This Question is unanswered, help us to find answer for this one

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

Answer

Correct Answer: Running total sales in each month that starts over each month

Note: This Question is unanswered, help us to find answer for this one

Microsoft Power BI MCQs | Topic-wise

MCQ on Basic Microsoft Power BI

General Microsoft Power BI MCQs

Basic Microsoft Power BI MCQ

1. Within Power BI, how can a report be created?

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

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

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

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

6. Which feature is not in the Power BI Admin portal?

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

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

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

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

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

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

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

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

15. What does My Workspace on powerbi.com include?

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

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

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

19. What does Power BI Premium provide?

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

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

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

23. You just deleted a dashboard in the Power BI service and want to get it back. What should you do?

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

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

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

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

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

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

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

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