PL-300 Exam – Practice 13

You should create a report that shows the company‘s sales performance. The sales team asked you to add a single visualization that could help identify the factors that affect sales and influence success. Which of the following visualization would you use?

You build a map of 3,40,000 students using an R visual. You ensure that the values of student_id, longitude, and latitude are added in the fields sent to the visual. Each Student_id is unique representing an individual student. But when the visual is loaded by the users in Power BI, it shows the details for only some of the students; not all. What is the reason behind this issue?

You are working on the K slidingWindow for a model training and stuck with the inference. How many data points should be accessible from the source file during inference to get valid results?

You have recently joined an organization as a Database Administrator Associate. Your senior has asked you to create aggregation for a particular database. Which of the following methods can’t be used to create the aggregation?

True or False: In Power BI, by default column profiling is based on the top 1,000 rows.

What does it mean to “assume referential integrity“ when developing relationships between tables in Power BI Desktop?

Which of the following options is not a privacy level in Power BI desktop?

Which of the following options is not a Microsoft 365 sensitivity label?

In Power BI, column _____ shows the number of valid, error, and empty cells in a column.

Select from the list below the types that are not valid in the M programming language?

In Power BI, column _____ include(s) characteristics like count, error, empty, distinct, unique, zero, min, max, and average.

What is the first parameter in the DAX function PATHITEM?

You need to register an app for embedding Power BI content. You are thinking of using an account which does not have a Power BI Pro license. Will it work for you?

Which of the following is a way to improve performance when retrieving data in Power BI?

You are creating a sales report that should consist of several pages. Each page is to contain the response to a specific business query.
You decide to create a menu page that displays all business queries. Users should be able to click on any business query and then be redirected to the page with the answer to the query they clicked on.  You also need to make sure that the menu page works when it is published to any workspace.
What would you do to make this work?

Your team is working on a project where there will be different scenarios for using the decomposition tree. For which purposes would you NOT recommend using the decomposition tree?

What is the second parameter in the DAX function LOOKUPVALUE?

Which Power BI license type is the standard license required for most Power BI development work?

You are developing a Power BI report for a large data set. You want to improve the performance of the dataset update by performing an incremental update. Which of the following statements about this scenario are true?

Why is it advisable to avoid NULL values in a numeric column?

Which of the following statements correctly defines the rules for creating table relationships when designing a data model? (Choose two)

Which of the following statements about calculated columns in Power BI is false?

Which of the following tasks can be performed ONLY by the workspace admin? (Choose three)

Which of the following lists presents the phases of Power BI report creation in correct order?

In Power BI, Power Query Editor is available through the ______ menu.

Which of the following elements can you set in a bookmark? (Choose three)

You develop a dataset named from the flat files and use incremental refresh. The dataset is deployed to Premium Power BI along with other related reports. You discover that the incremental refresh for the dataset fails due to lack of resources. Which of the following could be a possible reason for this issue?

True or False: The queries in the query editor do not have to be loaded into the data model. You can decide and select whether they should be loaded or not.

True or False: The nodes in a decomposition tree are fixed and cannot be changed by the end users viewing the report.

Your team leader has asked you to print some Power BI reports and distribute them to team members during the meeting. Before you start printing the reports, you notice that some tables show fewer rows than there actually are. Which of the following is the correct method to fix this problem?

Can you create a relationship between two columns with different DATA TYPE?

You model the data using Microsoft Power BI. The data model consists of a large Microsoft SQL Server table called “Transactions“ and more than 120 million records.
During the development phase, it is necessary to import a sample of data from the “Transactions“ table.
You decide to write a DAX expression that uses a filter function.
Will this help you achieve your goal?

You want to split your query into two parts. Which of the following options would you use in Power BI?

For what reasons is the Lineage view in Power BI important? (Choose three)

Which of the following statements about Slicer Visual in a Power BI report are true?

You want to develop some visualizations in Power BI Desktop using R Scripting. Which of the following actions do you need to perform to use R Scripting in Power BI Desktop?

You need to create Power BI reports which are to be deployed to Power BI Report Server. Which of the following tools would you use?

Which three parameters are required in the API requests for training and inference? (Choose three)

Note: This Question is part of a series of Questions that present the same scenario. Each Question in the series contains a unique solution that might meet the stated goals. Some Question sets might have more than one correct solution, while others might not have a correct solution.After you answer a Question in this section, you will NOT be able to return to it. As a result, these Questions will not appear in the review screen.You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars.You need to create a reference line to show which employees are above the median salary.Solution: You create a percentile line by using the Salary measure and set the percentile to 50%.Does this meet the goal?

What is the difference between a calculated column and a measure in Power BI?

For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder.The data model contains several measures.You need to create a Power BI report from the existing data. The solution must minimize development effort.Which type of data source should you use?

What is the difference between a calculated column and a calculated table in Power BI?

You have multiple dashboards.You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally IdentifiableInformation (PII). The solution must minimize configuration effort and impact on the dashboard design.What should you use?

Note: This Question is part of a series of Questions that present the same scenario. Each Question in the series contains a unique solution that might meet the stated goals. Some Question sets might have more than one correct solution, while others might not have a correct solution.After you answer a Question in this section, you will NOT be able to return to it. As a result, these Questions will not appear in the review screen.You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:✑ Due Date✑ Order Date✑ Delivery DateYou need to support the analysis of sales over time based on all the date foreign keys.Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.Does this meet the goal?

How can you ensure that a report is up-to-date in Power BI?

A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an on-premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow. You need to use the dataflow in a report. The solution must meet the following requirements: ✑ Minimize online processing operations. ✑ Minimize calculation times and render times for visuals. ✑ Include data from the current year, up to and including the previous day. What should you do?

You need to create a data source that can be used by Power Automate. Which type of data source should you use?

You have a Power BI workspace named Inventory that contains a dataset, a report, and a dashboard.You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

How can you handle data that is not in the correct format for analysis?

You have a collection of reports for the HR department of your company.You need to create a visualization for the HR department that shows historical employee counts and predicts trends during the next six months.Which type of visualization should you use?

You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings.You need to modify the report so that when you select a column in the column chart, the donut chart redraws by using the data from the selected column.What should you do?

From Power BI Desktop, you publish a new dataset and report to a Power BI workspace. The dataset has a row-level security (RLS) role named HR.You need to ensure that the HR team members have RLS applied when they view reports based on the dataset.What should you do?

How can you ensure that a report is using the correct dataset in Power BI?

You have a Power BI report.You have a table named Data1 that contains 10 million rows.Data1 is used in the following visuals:✑ A card that shows the number of records✑ A bar chart that shows total transaction amount by territory✑ A scatter plot that shows transaction amount and profit amount on the axes and points colored by territoryYou need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals.What should you do?