Microsoft Power BI MCQ Questions Answers

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

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

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

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

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

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

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

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

9. What is the recommended level of security for data extensions?

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

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

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

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

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

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

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

17. You can create a live connection to _ .

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

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

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

21. You can optionally include a filter in which DAX function?

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

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

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

25. Power BI works best with tables that are _,

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

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

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

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

30. What is NOT a built-in Power BI visual?

31. In Power BI Desktop Model view, what type of join will yield all results from Table 1 and any matching results from Table 2?

32. The iterator functions SUMX and AVERAGEX are used to perform calculations _.

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

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

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

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

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

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

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

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

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

42. What does Power BI Premium provide?

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

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

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

46. Formatting options within a visualization depend on what?

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

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

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

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

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

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

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

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

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

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

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

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