Microsoft Power BI Data Analyst (PL-300 ) Exam Questions and Answers – Set 4

You have a BI dataset and a connected report. You need to ensure that users can analyze data in Microsoft Excel by connecting directly to the dataset. You grant the users the Build permission for dataset What Should do next?

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 custom visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report You need to recommend a solution to improve the performance of the report.

You have a Power B1 report that contains three pages named Page1, Page2, and Page3. All the pages have the same slicers. You need to ensure that all the filters applied to Page1 apply to Page1 and Page3 only. What should you do?

You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?

You manage a Power BI model has a table named Sales and product. You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing. What should you do from Power BI Desktop?

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

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?

What is the purpose of DirectQuery in Power BI?

You have a Power BI report named Report' and a dashboard named Dashboard'. Report1 contains a line chart named Sales by month. You pin the Sales by month visual to Dashboard1. In Report1, you change the Sales by month visual to a bar chart. You need to ensure that the bar chart displays on Dashboard', What should you do?

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You create a report by using Microsoft Power BI Desktop. The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company’s internal network. You plan to publish the report to the Power BI Service. What should you implement ta ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

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

You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?

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?

You have a Power BI report named Report' and a dashboard named Dashboard'. Report1 contains a line chart named Sales by month. You pin the Sales by month visual to Dashboard1. In Report1, you change the Sales by month visual to a bar chart. You need to ensure that the bar chart displays on Dashboard', What should you do?

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?

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? 1

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?

You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use?

You manage a Power BI model has a table named Sales and product. You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing. What should you do from Power BI Desktop?

You import a large dataset to Power Query Editor. You need to identify whether a column contains only unique values. Which two Data Preview options can you use?

You build a Power Bl report that displays 10T temperature data streaming from a refrigerator. You publish the report to the Bl service. You need to be notified when the temperature rises above four degrees Celsius. What should you do?

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 Bl Desktop?

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? 1

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?

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?

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?

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 Bl Desktop?

You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders. The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter. City[State Province] = "Kentucky" Role2 contains the following filter. Date[Calendar Year] = 2020 If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders. The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter. City[State Province] = "Kentucky" Role2 contains the following filter. Date[Calendar Year] = 2020 If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

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?

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 custom visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report You need to recommend a solution to improve the performance of the report.

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?

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?

You have a Power B1 report that contains three pages named Page1, Page2, and Page3. All the pages have the same slicers. You need to ensure that all the filters applied to Page1 apply to Page1 and Page3 only. What should you do?

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? 1

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?

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?

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 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? 1

You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use?

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?

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?

What is the purpose of DirectQuery in Power BI?

You import a large dataset to Power Query Editor. You need to identify whether a column contains only unique values. Which two Data Preview options can you use?