1. Which type of visualization is best when you want to compare proportions in a large volume of data with multiple categories and subcategories?
Answer
Correct Answer:
Treemap
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
Transform > Remove Text
Note: This Question is unanswered, help us to find answer for this one
3. When will links to a web-published report stop working?
Answer
Correct Answer:
Approximately one hour after the report is deleted
Note: This Question is unanswered, help us to find answer for this one
4. Within Power BI, how can a report be created?
Answer
Correct Answer:
Using an existing report
Note: This Question is unanswered, help us to find answer for this one
5. In Power BI, what is the most important difference between tables related in a star schema and in a snowflake schema?
Answer
Correct Answer:
A snowflake schema is much less efficient for Power BI.
Note: This Question is unanswered, help us to find answer for this one
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.
Answer
Correct Answer:
Timeline; map
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
Append
Note: This Question is unanswered, help us to find answer for this one
8. Before you can use a custom visualization from the Power BI Marketplace, you need to ____ in, then __ it to your Power BI account.
Answer
Correct Answer:
Purchase; import
Note: This Question is unanswered, help us to find answer for this one
9. What is the recommended level of security for data extensions?
Answer
Correct Answer:
Allow only certified extensions to load
Note: This Question is unanswered, help us to find answer for this one
10. In the Power BI service, accessing a dataset for an uploaded Power BI file allows you what capabilities?
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
11. In general, you should not add DAX calculated columns to your data moder if you are able to do what?
Answer
Correct Answer:
All of these answers
Note: This Question is unanswered, help us to find answer for this one
12. A group admin for an app workspace cannot _ in their workspace.
Answer
Correct Answer:
Remove users from Power BI
Note: This Question is unanswered, help us to find answer for this one
13. What does Power BI Desktop do when it cannot create a standard map visualization with the available data?
Answer
Correct Answer:
It sends the data to Bing
Note: This Question is unanswered, help us to find answer for this one
14. Which Q&A feature helps you ask questions and refine your visualization?
Answer
Correct Answer:
Autocomplete
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
DATEDIFF and SUMX
Note: This Question is unanswered, help us to find answer for this one
16. What is the purpose of this code? ProductCount = COUNT(Products[ProductID])
Answer
Correct Answer:
It is part of the documentation
Note: This Question is unanswered, help us to find answer for this one
17. You can create a live connection to _ .
Answer
Correct Answer:
All of these answers
Note: This Question is unanswered, help us to find answer for this one
18. You have just pinned a visualization to a new dashboard. Before you can add another visualization, what must you do?
Answer
Correct Answer:
Name it.
Note: This Question is unanswered, help us to find answer for this one
19. You want to count the number of products in the Products data table. Which DAX function works best?
Answer
Correct Answer:
COUNTX
Note: This Question is unanswered, help us to find answer for this one
20. Which feature is not in the Power BI Admin portal?
Answer
Correct Answer:
Dashboard Manager
Note: This Question is unanswered, help us to find answer for this one
21. You can optionally include a filter in which DAX function?
Answer
Correct Answer:
CALCULATE
Note: This Question is unanswered, help us to find answer for this one
22. In general, what is the best way to shape your data for Power BI?
Answer
Correct Answer:
User a star schema.
Note: This Question is unanswered, help us to find answer for this one
23. In the report editor, which task can you NOT accomplish using drag and drop?
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
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?
Answer
Correct Answer:
Scatter chart
Note: This Question is unanswered, help us to find answer for this one
25. Power BI works best with tables that are _,
Answer
Correct Answer:
Long and skinny
Note: This Question is unanswered, help us to find answer for this one
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.
Answer
Correct Answer:
Orders; DISTINCTCOUNT
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
EXCEPT
Note: This Question is unanswered, help us to find answer for this one
28. If you delete a dateset in the Power BI service, what happens to the dashboards and reports supported by the dataset?
Answer
Correct Answer:
They will be deleted.
Note: This Question is unanswered, help us to find answer for this one
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.
Answer
Correct Answer:
A, B, C
Note: This Question is unanswered, help us to find answer for this one
30. What is NOT a built-in Power BI visual?
Answer
Correct Answer:
Power KPI
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
Left Inner Join
Note: This Question is unanswered, help us to find answer for this one
32. The iterator functions SUMX and AVERAGEX are used to perform calculations _.
Answer
Correct Answer:
In the context of a record
Note: This Question is unanswered, help us to find answer for this one
33. When you use Publish to Web in the Power BI service, who can view your published content?
Answer
Correct Answer:
Everyone in your organization
Note: This Question is unanswered, help us to find answer for this one
34. Facebook, Twilio, GitHub, and MailChimp are all examples of Power BI _.
Answer
Correct Answer:
Online services
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
Drillthrough
Note: This Question is unanswered, help us to find answer for this one
36. You want to access the underlying data for a specific data point in a visualization. What should you choose?
Answer
Correct Answer:
Expand to next level
Note: This Question is unanswered, help us to find answer for this one
37. What does My Workspace on powerbi.com include?
Answer
Correct Answer:
Dashboards and reports
Note: This Question is unanswered, help us to find answer for this one
38. What should you use to highlight a specific visualization in a report?
Answer
Correct Answer:
Spotlight
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
Templates
Note: This Question is unanswered, help us to find answer for this one
40. What should you do to increase the readability of a report?
Answer
Correct Answer:
All of these answers
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
Views
Note: This Question is unanswered, help us to find answer for this one
42. What does Power BI Premium provide?
Answer
Correct Answer:
All of these answers
Note: This Question is unanswered, help us to find answer for this one
43. Which data type can be uploaded directly to powerbi.com?
Answer
Correct Answer:
All of these answers
Note: This Question is unanswered, help us to find answer for this one
44. What is NOT a valid data connection type for Power BI Desktop?
Answer
Correct Answer:
Relationships data
Note: This Question is unanswered, help us to find answer for this one
45. What tool can you use in Power BI Desktop to reduce data?
Answer
Correct Answer:
Data modeler
Note: This Question is unanswered, help us to find answer for this one
46. Formatting options within a visualization depend on what?
Answer
Correct Answer:
The visualization you are formatting
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
Split column
Note: This Question is unanswered, help us to find answer for this one
48. You want to delete a dataset but the Power BI service will not let you. What is the most likely cause?
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
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 .
Answer
Correct Answer:
Data; lookup
Note: This Question is unanswered, help us to find answer for this one
50. You just deleted a dashboard in the Power BI service and want to get it back. What should you do?
Answer
Correct Answer:
Press Ctrl+Z.
Note: This Question is unanswered, help us to find answer for this one
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.
Answer
Correct Answer:
Sort and group
Note: This Question is unanswered, help us to find answer for this one
52. Consider the Power BI extract, transform, and load process (ETL). During this process, data is read and then
Answer
Correct Answer:
Stored in SQL Server
Note: This Question is unanswered, help us to find answer for this one
53. The Excel function IF is nearly the same as which DAX function?
Answer
Correct Answer:
IFX
Note: This Question is unanswered, help us to find answer for this one
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?
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
55. In Power BI service, deleted pages are available after deletion until
Answer
Correct Answer:
The report has been saved
Note: This Question is unanswered, help us to find answer for this one
56. What is the primary benefit of using visualizations such as line charts, bar charts, and column charts?
Answer
Correct Answer:
They require fewer resources than more complex visualizations.
Note: This Question is unanswered, help us to find answer for this one
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?
Answer
Correct Answer:
A directive
Note: This Question is unanswered, help us to find answer for this one
58. What daily sales number does this DAX measure formula calculate? CALCULATE(SUM([Sales]) ,DATESMTD([Date] ))
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
