Microsoft Power BI Data Analyst Associate Practice Questions

Get ready to boost your Power BI skills with our Practice Questions designed for the PL-300 Data Analyst exam. Test your knowledge, enhance your understanding, and gain hands-on experience with real-world scenarios. Let’s dive in and excel in the world of data analysis and visualization!

1. You are creating a sales report with two tables in Power BI Desktop. Row-level security (RLS) is set up for both tables. The tables need to be related to one another. The answer must guarantee that the RLS settings are respected by bidirectional cross-filtering. What should you do in PL-300?

A) Make a relationship between the tables that is inactive and choose to apply the security filter in both directions.
B) Establish an active relationship between the tables, then choose to apply the security filter in both directions.
C) Make a relationship between the tables that is inactive and choose to assume referential integrity.
D) Establish an active connection between the tables and choose referential integrity to be assumed.

View Answer

B) Establish an active relationship between the tables, then choose to apply the security filter in both directions.

2. A user must have the option to add individuals to a workspace. The least privilege principle must be applied to the solution. Which role ought you to give the user?

A) Viewer
B) Admin
C) Member
D) Contributor

View Answer

D) Contributor [/expand ]

3. You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that the users can consume the content on a report page in a logical order. What should you configure in Microsoft Power BI Desktop?

A) The bookmark order
B) The layer order
C) The tab order
D) The X position

View AnswerC) The tab order </details>

4. You have a sales transaction database stored in Azure SQL. The database is regularly updated. To find phoney transactions, you must create reports from the data. After an update, the data must be accessible within five minutes. How should the data connection be set up?

A) Set the Command timeout in minutes setting.
B) Set Data Connectivity mode to Import.
C) Set Data Connectivity mode to DirectQuery.
D) Add a SQL statement.

View Answer

C) Set Data Connectivity mode to DirectQuery.

5. In the Customer table, each Customer ID corresponds to a distinct customer. In the Address table, each Address ID corresponds to a distinct address. A query that has one row per client must be made. For each customer, a row must provide their City, State/Region, and Country. What ought you to do?

A) Merge the Customer and Address tables.
B) Group the Customer and Address tables by the Address ID column.
C) Transpose the Customer and Address tables.
D) Append the Customer and Address tables.

View Answer

A) Merge the Customer and Address tables.

6. What is the purpose of DirectQuery in Power BI?

A) To create reports that are based on live, real-time data.
B) To create reports that are based on a static snapshot of data.
C) To create reports that are based on data that is stored in the Power BI service.
D) To create reports that are based on data that is stored in OLAP.

View Answer

A) To create reports that are based on live, real-time data

7. Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a Microsoft Power BI dashboard. Which type of tile should you add?

A) Video
B) Text Box
C) Web Content
D) Custom Streaming Data

View Answer

A) Video

8. You open a query in Power Query Editor. You need to identify the percentage of empty values in each column as quickly as possible. Which Data Preview option should you select?

A) Show whitespace
B) Column profile
C) Column quality
D) Column distribution

View Answer

B) Column profile

9. You have a Power BI tenant. You have reports that use financial datasets and are exported as PDF files. You need to ensure that the reports are encrypted. What should you implement?

A) Dataset Certifications
B) Row-level Security (RLS)
C) Sensitivity Labels
D) Microsoft Intune Policies

View Answer

C) Sensitivity Labels

10. In Power BI Desktop, you are creating visualizations in a report based on an imported dataset. You need to allow Power BI users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data. What should you do?

A) From Power BI Desktop, configure the Data Load settings for the current file.
B) From Power BI Desktop, configure the Report settings for the current file.
C) From Power BI Desktop, modify the data source permissions.
D) From the Power BI service, configure the dataset permissions.

View Answer

B) From Power BI Desktop, configure the Report settings for the current file.