Microsoft Power BI Data Analyst (PL-300) Sample Questions

The Microsoft Power BI Data Analyst (PL-300) data analyst offers useful insights by utilising readily available data and putting domain knowledge to use. The Power BI data analyst identifies business requirements with the help of important stakeholders from diverse industries, cleans and transforms the data, and then uses Power BI to develop data models. By producing simple-to-understand data visualisations, empowering people to conduct self-service analytics, and deploying and configuring solutions for usage, the Power BI data analyst offers value to the organisation. Candidates for this test should be proficient in writing DAX expressions and using Power Query.

The article provides a list of Microsoft Power BI Data Analyst (PL-300) Sample Questions that cover core exam topics including –

• Prepare the Data (15-20%)
• Model the Data (30—35%)
• Visualize and Analyze the Data (25—30%)
• Deploy and Maintain Assets (20—25%)

Advanced Sample Questions

What is the purpose of Power BI Desktop?

• A) To create and publish reports to the Power BI service.
• B) To create and share dashboards with others.
• C) To connect to and import data from various data sources.

Answer: A) To create and publish reports to the Power BI service.

Explanation: Power BI Desktop is a tool for creating and publishing reports to the Power BI service. It allows individuals to create interactive reports and visualizations, connect to and import data from various data sources, and publish reports to the Power BI service for others to view and interact with.

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.

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

Explanation: DirectQuery is a feature in Power BI that allows individuals to create reports that are based on live, real-time data. When using DirectQuery, the report is linked to the data source and updates in real-time as the data changes.

What is the purpose of DAX (Data Analysis Expressions) in Power BI?

• A) To create calculations and custom expressions in Power BI reports.
• B) To create data models in Power BI.
• C) To connect to and import data from various data sources.

Answer: A) To create calculations and custom expressions in Power BI reports.

Explanation: DAX (Data Analysis Expressions) is a formula language used in Power BI to create calculations and custom expressions in Power BI reports. DAX can be used to create complex calculations and perform operations on data in a Power BI report, making it a powerful tool for data analysis and visualization.

What is the purpose of Power BI Report Server?

• A) To host and share Power BI reports within an organization.
• B) To publish reports to the Power BI service.
• C) To connect to and import data from various data sources.

Answer: A) To host and share Power BI reports within an organization.

Explanation: Power BI Report Server is a tool for hosting and sharing Power BI reports within an organization. It allows individuals to publish and share reports on-premises, making it easier for organizations to use Power BI for data analysis and visualization without the need for a cloud-based solution.

What is the purpose of the Power BI Dataflows feature?

• A) To automate the process of importing data into Power BI.
• B) To clean and transform data in Power BI.
• C) To store and manage data in the Power BI service.

Answer: C) To store and manage data in the Power BI service.

Explanation: Power BI Dataflows is a feature that allows individuals to store and manage data in the Power BI service. It enables users to connect to a variety of data sources, clean and transform the data, and store it in the Power BI service for use in reports and dashboards. Power BI Dataflows help streamline the data preparation process and make it easier to share and reuse data across multiple reports and dashboards.

What is the purpose of the Power BI Q&A feature?

• A) To allow users to ask questions of their data using natural language.
• B) To allow users to create and share custom visuals in Power BI.
• C) To store and manage data in the Power BI service.

Answer: A) To allow users to ask questions of their data using natural language.

Explanation: Power BI Q&A is a feature that allows users to ask questions of their data using natural language. It uses natural language processing and machine learning to understand user questions and generate visualizations based on the data in a Power BI report. This feature makes it easier for users to quickly find insights and gain a better understanding of their data without the need for complex queries or technical knowledge.

What is the purpose of the Power BI Publish to Web feature?

• A) To allow users to share Power BI reports and dashboards with individuals outside their organization.
• B) To host and share Power BI reports within an organization.
• C) To clean and transform data in Power BI.

Answer: A) To allow users to share Power BI reports and dashboards with individuals outside their organization.

Explanation: Power BI Publish to Web is a feature that allows users to share Power BI reports and dashboards with individuals outside their organization. This feature allows users to create and share interactive reports and dashboards with anyone with a web browser, regardless of whether they have a Power BI account. This can be useful for sharing insights with stakeholders, partners, and customers.

What is the purpose of the Power BI Workspace feature?

• A) To store and manage data in the Power BI service.
• B) To collaborate with others on Power BI reports and dashboards.
• C) To automate the process of importing data into Power BI.

Answer: B) To collaborate with others on Power BI reports and dashboards.

Explanation: Power BI Workspaces is a feature that allows individuals to collaborate with others on Power BI reports and dashboards. This feature allows users to create and share workspaces with others, making it easier for teams to work together on data analysis and visualization projects. Power BI Workspaces also provide a centralized location for managing reports and dashboards, making it easier for teams to stay organized and find the information they need.

What is the purpose of the Power BI Paginated Reports feature?

• A) To create and share interactive reports and dashboards in Power BI.
• B) To create and share paginated reports with users.
• C) To store and manage data in the Power BI service.

Answer: B) To create and share paginated reports with users.

Explanation: Power BI Paginated Reports is a feature that allows individuals to create and share paginated reports with users. These reports are optimized for printing and are designed to present data in a tabular format, similar to traditional paper-based reports. Paginated reports are useful for providing detailed information that is best presented in a structured format, such as invoices, receipts, or other financial statements.

What is the purpose of the Power BI Report Server feature?

• A) To host and share Power BI reports within an organization.
• B) To allow users to share Power BI reports and dashboards with individuals outside their organization.
• C) To automate the process of importing data into Power BI.

Answer: A) To host and share Power BI reports within an organization.

Explanation: Power BI Report Server is a feature that allows individuals to host and share Power BI reports within their organization. It provides an on-premises solution for hosting and sharing reports and dashboards, making it easier for organizations to share insights with employees and stakeholders who may not have access to the cloud-based Power BI service. Power BI Report Server also provides a centralized location for managing and organizing reports, making it easier for organizations to stay organized and find the information they need.

Basic Sample Questions

Q1)You have a fully hosted project management app on Microsoft Teams. Microsoft Power Apps were used in the development of the app. A Power BI report that integrates with the project management software must be written. Which connector ought you to choose?

• A. Microsoft Teams Personal Analytics
• B. SQL Server database
• C. Dataverse
• D. Dataflows

Correct Answer: C

Q2)You create a Power BI report for your company’s sales division that imports data from a Microsoft Excel file that is housed in a Microsoft SharePoint folder. The data model includes a number of measurements. From the current data, a Power BI report must be made. The solution must reduce the amount of development work. Which kind of data source need to you employ?

• A. Power BI dataset
• B. a SharePoint folder
• C. Power BI dataflows
• D. an Excel workbook

Correct Answer: B

Q3)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.

Correct Answer: A

Q4)You have many document libraries on your Microsoft SharePoint Online site. There are manufacturing reports saved as Microsoft Excel files in one of the document libraries. The data structure is the same across all manufacturing reports. To load only the manufacturing reports to a table for analysis, you must utilise Power BI Desktop. What ought you to do?

• A. Retrieve information from a SharePoint folder and type the site URL. Choose Transform, then filter using the manufacturing reports library’s folder location.
• B. Enter the site URL and retrieve information from a SharePoint list. Filter by the folder path to the manufacturing reports library after choosing Combine & Transform.
• C: Enter the site URL, choose Combine & Load, and then get the data from a SharePoint folder.
• D. Enter the site URL, choose Combine & Load, and then get data from a SharePoint list.

Correct Answer: A

Q5)You have a CSV file with user complaints in it. The file has a column called Logged in it. Each complaint’s log entry includes the date and time that it happened. The information in Logged is organised in follows: 2018-12-31 at 08:59. You must be able to use an internal date hierarchy and the logged date to assess the complaints. What ought you to do?

• A. Use a transformation to pull off the last 11 characters from the Logged column, then change the new column’s data type to Date.
• B. Change the Logged column’s data type to Date.
• C. Use at as the delimiter to split the Logged column.
• D. Use a transformation to obtain the Logged column’s first 11 characters.

Correct Answer: D

Q6)In a Microsoft OneDrive folder, you have a Microsoft Excel document. A Power BI dataset must import the file. You must make sure that PowerBI.com can refresh the dataset. How do you link to the file using the two connectors? Each accurate response offers an entire resolution.

• A. Excel Workbook
• B. Text/CSV
• C. Folder
• D. SharePoint folder
• E. Web

Correct Answer: A and C

Q7)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. Add a SQL statement.
• B. Set the Command timeout in minutes setting.
• C. Set Data Connectivity mode to Import.
• D. Set Data Connectivity mode to DirectQuery.

Correct Answer: D

Q8)A Power BI dataflow is created by a business intelligence (BI) developer that makes use of DirectQuery to retrieve tables from an on-premises Microsoft SQL server. The dataflow’s Enhanced Dataflows Compute Engine is activated. The dataflow must be utilised in a report. The answer must adhere to the following criteria: Minimize visual calculations and render times, as well as online processing tasks. Include information from this year, up to and including the day before. What ought you to do?

• A. Set the DirectQuery mode for a dataflows connection.
• B. Set up a gateway connection for the dataset and create a dataflows connection with the DirectQuery mode checked.
• C. Create a dataflows connection and choose the Import mode. Then, set the connection to refresh every day.
• D. Develop a dataflows connection with the Import mode checked, then use Microsoft Power Automate to create a solution that will automatically update the data every hour.

Correct Answer: C

Q9)You are using Power BI Desktop to create a report. You open a data extract that has a coll free text field. The frequency distribution of the string lengths in col1 has to be examined. The size of the model must not be impacted by the solution. What ought you to do?

• A. Include a DAX computed column in the report that determines the length of col1.
• B. Include a DAX function that determines the average length of col1 in the report.
• C. Add a column that determines the length of col. 1
• D in the Power Query Editor. Change the distribution for the Column profile in Power Query Editor to group by length for col1.

Correct Answer: D

Q10)You have a number of reports for your company’s HR division. Row-level security is used with the datasets (RLS). The business has several sales territories. An HR manager oversees each sales territory. The HR managers should only be able to deal with data from their region, you must make sure of that. The layout of the reports cannot be altered by the HR managers. How should you grant the HR managers access to the reports?

• A. Upload the reports to an app and allow access for the HR managers.
• B. A new workspace should be created, the datasets and reports copied, and the HR managers added as workspace members.
• C. Publish the reports to a workspace separate from the one that houses the datasets.
• D. Include the HR managers as users in the workspace that already houses the datasets and reports.

Correct Answer: A

Q11)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 to you give the user?

• A. Viewer
• B. Admin
• C. Contributor
• D. Member

Correct Answer: D

Q12)You have a custom connector that gives you the following information for each email sent in the last year: ID, From, To, Subject, Body, and Has Attachments. There are returned more than 10 million records. Based on whom employees send emails to, you create a report that analyses the internal networks of those employees. You must keep the recipients of the report from viewing the examined emails. The model size must be reduced in the solution. What ought you to do in PL-300?

• A. Change the Subject and Body columns in Model view to Hidden.
• B. During the import, delete the Subject and Body columns.
• C. Use row-level security (RLS) to limit the report recipients’ ability to view results to those that correspond to the emails they sent.

Correct Answer: B

Q13)You have a report from Microsoft Power BI. The PBIX file is 550 MB in size. By using an App workspace in a shared capacity on powerbi.com, one can see the report. One fact table from an imported dataset is used in the report. There are 12 million rows in the fact table. At 8:00 and 17:00, the dataset will refresh twice daily. The report is one page long and has 10 default visuals in addition to 15 AppSource visuals. When users access and engage with the report, they complain that the visuals take a long time to load. You must offer a suggestion for enhancing the report’s functionality. What ought to you suggest in PL-300?

• A. Use iterator functions in place of any DAX measurements.
• B. Make visual interactions possible.
• C. Substitute AppSource visuals for the standard ones.
• D. Divide the images among several pages.

Correct Answer: D

Q14)You cannot go back to a question you’ve already answered in this section. As a result, the review screen will not display these questions. You are using Microsoft Power BI to model data. A sizable Microsoft SQL Server table named Order that contains more than 100 million records is a component of the data model. You must import a portion of the Order table’s data during the development process. Solution: You import the table from Power Query Editor before adding a filter step to the query. Is the objective being met in PL-300?

• A. Yes
• B. No

Correct Answer: B

Q15)You are using Microsoft Power BI to model data. A sizable Microsoft SQL Server table named Order that contains more than 100 million records is a component of the data model. You must import a portion of the Order table’s data during the development process. The FILTER function is incorporated into a DAX expression as the solution. Is the objective being met in PL-300?

• A. Yes
• B. No

Correct Answer: B

Q16)You are using Microsoft Power BI to model data. A sizable Microsoft SQL Server table named Order that contains more than 100 million records is a component of the data model. You must import a portion of the Order table’s data during the development process. Solution: You modify the SQL statement by including a WHERE clause. Is the objective being met in PL-300?

• A. Yes
• B. No

Correct Answer: A

Q17)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 ought you to 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 a relationship between the tables that is active, then choose Apply security filter in both directions.
• C. Make a relationship between the tables that is inactive and choose Assume referential integrity.
• D. Establish an active connection between the tables and choose Referential integrity to be assumed.

Correct Answer: B

Q18)You are using Microsoft Power BI to model data. A sizable Microsoft SQL Server table named Order that contains more than 100 million records is a component of the data model. You must import a portion of the Order table’s data during the development process. Solution: You provide a filter at the report level that is dependent on the order date. Is the objective being met in PL-300?

• A. Yes
• B. No

Correct Answer: B

Q19)You have a Power BI report that imports two tables from an Azure SQL database: a sales table and a date table. The sales table’s date foreign keys are as follows: Due date, purchase date, and delivery date You must back up the historical sales analysis based on all date foreign keys. Solution: You generate measures that filter sales based on the current relationship between the sales table and the date table using the USERELATIONSHIP DAX function. Is the objective being met in PL-300?

• A. Yes
• B. No

Correct Answer: B

Q20)You have a report with a column chart and a bar chart in it. By client segment, the customer count is displayed as a bar graph. Sales are displayed in a column chart by month. The percentage of the month’s total sales that belong to the customer segment must be visible when a segment is selected in the bar chart. When the bar chart is used, how should the visual interactions be configured on the column chart in PL-300?

• A. highlight
• B. filter
• C. no impact

Correct Answer: A