General MCQ for Microsoft Power BI

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

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

3. Formatting options within a visualization depend on what?

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

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

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

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

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

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

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

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

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

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

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

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

16. You can create a live connection to _ .

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

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

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

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

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

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

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

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

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

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

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

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