PL-300: Microsoft Power BI Data Analyst
Which of the following is not a best practice when using the Q&A visual?
Fix incorrect data types
Add axis labels to all the charts
Add missing relationships between tables
Add synonyms to tables and columns
Answer is Add axis labels to all the charts
Best practices are: Use new Q&A tooling to interact with queries and make improvements; add missing relationships between tables; rename tables and columns; fix incorrect data types; normalize your model (single table or column per question); add synonyms to tables and columns.
From the Home tab in Power BI Desktop, you click Enter Data and create a table named Sales that contains the following data.
You add Region and Sales to visualization and the visualization displays the following data.
What causes the visualization to display four rows of data instead of six?
the Data Category of Region
the Default Summarization on Region
the Default Summarization on Sales
the Data Category of Sales
Answer is the Default Summarization on Sales
By default the column aggregation for Sales will be SUM. If there is summarization set on Region then the visualization will show count of regions and not in an unsummarized fashion like the source data.
You need to create a custom visualization for Power BI.
What should you install first?
jQuery
Node.js
Microsoft Azure PowerShell
Microsoft.NET
Answer is Node.js
To develop custom visuals, you need to have NodeJS installed with Power BI tools and a server certificate.
Reference:
https://docs.microsoft.com/en-us/power-bi/service-custom-visuals-getting-started-with-developer-tools
https://docs.microsoft.com/en-us/power-bi/developer/visuals/custom-visual-develop-tutorial
You create a Power BI model that contains the sales for the last five years. The size of the model is 950 MB. The Sales table contains five million rows.
You need to minimize the model size and perform the following analysis:
Current and one previous year sales for all active products
Current year sales by product category
What should you do?
Remove the Product Status column.
Remove the rows that relate to inactive products.
Remove the rows that relate to sales that occurred more than two years earlier.
Remove the Sale Date column.
Answer is Remove the rows that relate to sales that occurred more than two years earlier.
You have a Power BI data model that contains a table named Contacts.
Contacts contains the following text columns:
Name
Phone
Subscribed to Newsletter
The Phone column contains the area code, number, and country code. The Subscribed to Newsletter column contains a value of true or false.
You need to minimize the size of the data model by changing a column’s data type. The solution must prevent data loss. What should you do?
Change Phone to a decimal data type.
Change Phone to a whole number data type.
Change Subscribed to Newsletter to a binary data type.
Change Subscribed to Newsletter to a True/False data type.
Answer is Change Subscribed to Newsletter to a True/False data type.
What is the benefit of using a report tooltip?
To give users the ability to export data from the visual.
To provide additional detail that is specific to the context of the data that is being hovered over.
To give users additional information about a report visual, such as the author and date/time it was created.
Answer is To provide additional detail that is specific to the context of the data that is being hovered over.
Do you need to import custom visuals each time you want to use them when you are developing a new report?
Yes, custom visuals must be imported from AppSource each time you start developing a new report.
No, custom visuals are always available for selection under the Visualization pane.
No, custom visuals only need to be imported once and will always remain in Power BI for future use in a new report.
Answer is Yes, custom visuals must be imported from AppSource each time you start developing a new report.
Which of the following filters are not available in Power BI reports?
Drillthrough
Report level
Page type
Page level
Answer is Page type
How can you analyze performance of each of your report elements?
By using performance analyzer.
By analyzing your metadata.
By deleting unnecessary rows and columns to reduce your dataset size.
Answer is By using performance analyzer.
Can you use bookmarks to create a slide show in Power BI?
No, you cannot, because bookmarks are not dynamic.
Yes, you can, by adding buttons as navigation to go between saved bookmarks.
No, you will require a specific visual to achieve this task.
Answer is Yes, you can, by adding buttons as navigation to go between saved bookmarks.