PL-300 Exam Questions
339 real PL-300 exam questions with expert-verified answers and explanations. Page 3 of 7.
- Question #121Visualize and analyze the data
You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. You need to modify the dashboard to appear as shown in the Modified...
Power BI DashboardsDashboard ThemingVisual Customization - Question #122Visualize and analyze the data
You have the dataset shown in the following exhibit. You need to ensure that the visual shows only the 10 cities that have the highest sales profit. What should you do?
FilteringTop NVisualizationsReport Design - Question #123Visualize and analyze the data
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 q...
Reference LinesMedian vs. AveragePower BI VisualizationsData Analysis - Question #124Visualize and analyze the data
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 q...
Reference LinesPercentile LineMedianData Visualization - Question #136Manage and secure Power BI
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....
On-premises data gatewayData RefreshPower BI ServiceSSAS connectivity - Question #137Model the data
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 import...
Data model optimizationReport performanceImport modeFile size reduction - Question #141Prepare the data
Case Study 1 - Litware, Inc. Overview Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL...
Power Query EditorData profilingData qualityData verification - Question #143Prepare the data
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 q...
Power QueryData SamplingQuery FoldingPerformance Optimization - Question #144Prepare the data
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 q...
Power QueryParametersData source managementQuery optimization - Question #145Visualize and analyze the data
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 q...
Reference linesData visualizationMedian calculationPower BI charts - Question #146Manage and secure 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 Identifiable Inf...
Data securitySensitivity labelsMicrosoft Information ProtectionPower BI governance - Question #147Manage and secure Power BI
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...
Sensitivity labelsData encryptionInformation protectionReport export security - Question #148Deploy and maintain assets
Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI. You need to recommend an application li...
Application Lifecycle Management (ALM)WorkspacesPower BI AppsEnvironment Separation - Question #149Visualize and analyze the data
You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements: - A line chart that shows the number of defective...
Power BI AlertsDashboard MonitoringKPI VisualsNotifications - Question #150Manage and secure Power BI
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 q...
Power BI AppContent SharingAccess ControlPower BI Permissions - Question #154Visualize and analyze the data
You have a Q&A visual that displays information from a table named Carriers as shown in the following exhibit. You need to ensure that users can ask questions by using the term air...
Q&A visualSynonymsNatural Language QueryReport Enhancement - Question #157Visualize and analyze the data
Case Study 3 - Northwind Traders Overview. General Overview Northwind Traders is a specialty food import company. The company recently implemented Power BI to better understand its...
Power BI VisualizationsBar ChartReport DesignData Visualization - Question #158Model the data
Case Study 3 - Northwind Traders Overview. General Overview Northwind Traders is a specialty food import company. The company recently implemented Power BI to better understand its...
Data ModelingDate TableTime IntelligenceRelationships - Question #159Model the data
You have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table. The table has 12 million rows....
Model OptimizationData TypesDateTime HandlingData Size - Question #160Visualize and analyze the data
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 vis...
Data Export ControlReport SettingsPower BI DesktopSummarized vs. Underlying Data - Question #161Visualize and analyze the data
You have a Power BI report. The report contains visualizations that have interactions. You need to identify which visualizations take the longest to complete. What should you use?
Performance analysisVisualizationsPower BI DesktopTroubleshooting - Question #162Visualize and analyze the data
You are building a Power B1 report to analyze customer segments. You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geogr...
Decomposition treePower BI visualsDynamic analysisSegment analysis - Question #167Model the data
In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured. You need to create a relationship between the t...
Data ModelingRelationshipsRow-Level SecurityBidirectional Filters - Question #168Prepare the data
You are designing a Power BI model that uses DirectQuery to connect to an Azure SQL database named sql1. The model will include two tables named Sales and Date. You need to limit t...
DirectQueryQuery FoldingRelative Date FilteringPerformance Optimization - Question #169Model the data
You are configuring a Microsoft Power BI data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has the following measure....
Power BI Q&AData ModelingNatural Language QuerySynonyms - Question #170Prepare the data
You have an imported dataset that contains the following tables: Date Product Customer SalesFact You need to reduce the size of the dataset before you publish it. The solution must...
Dataset optimizationPower QueryCalculated columnsData model efficiency - Question #173Visualize and analyze the data
You have a report that includes a card visualization. You need to apply the following conditional formatting to the card while minimizing design effort. For values that are greater...
Conditional FormattingCard VisualizationReport Design - Question #174Manage and secure Power BI
You have a Power BI report that uses a dataset based on an Azure Analysis Services live connection. You need to ensure that users can use Q&A from the Power BI service for the data...
Power BI Q&ADataset settingsPower BI ServiceAzure Analysis Services - Question #175Prepare the data
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a dif...
Power Query EditorConditional ColumnData TransformationHandling NULLs - Question #176Prepare the data
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a dif...
Power Query MData transformationTable.DistinctData relationships - Question #177Model the data
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a dif...
DAXRankingMeasuresFilter context - Question #178Visualize and analyze the data
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 P...
Report FiltersData FilteringPower BI Desktop - Question #179Manage and secure Power BI
In the Power BI service, you create an app workplace that contains several dashboards. You need to provide a user named [email protected] with the ability to edit and publish dashb...
Power BI ServiceApp WorkspacesWorkspace RolesPermissions - Question #180Manage and secure Power BI
Your organization has a team of power users who recently created 20 Power BI dashboards. The power users share the dashboards with other users in the organization. When the users a...
Power BI LicensingContent SharingUser AccessAdmin Portal - Question #181Manage and secure Power BI
You embed a Power BI report in a Microsoft SharePoint Online page. A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following error m...
Power BI Service PermissionsApp WorkspacesSharePoint EmbeddingUser Access Management - Question #182Model the data
You have an app workspace that contains a dashboard and four reports. All the reports are generated from a single dataset that contains sales data for your company. The reports dis...
Natural Language QueryQ&A FeatureDataset PropertiesSemantic Model Configuration - Question #183Deploy and maintain assets
You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization...
Data ConnectivityDirectQueryOn-premises data gatewayData Refresh - Question #184Deploy and maintain assets
You have an on-premises Power BI Report Server. You plan to create a report in Power BI Desktop and publish the report to the report server. Which data source should the report use...
Power BI Report ServerData sourcesSSASOn-premises reporting - Question #185Manage and secure Power BI
You have a Power BI app named App1. The privacy for the App1 workspace is set to Private. A user named User1 reports that App1 does not appear in the My organization AppSource. App...
Power BI AppsApp AccessAppSourceContent Security - Question #186Manage and secure Power BI
You plan to embed multiple visualization in a public website. Your Power BI infrastructure contains the visualizations configured as shown in the following table. Which two visuali...
Power BI embeddingPublish to WebSharing Power BI contentReport security limitations - Question #187Visualize and analyze the data
You have a Power BI dashboard that displays different visualizations of company sales. You enable Q&A on the dashboard. You need to provide users with sample questions that they ca...
Q&ADataset configurationSuggested questionsNatural language query - Question #188Manage and secure Power BI
You have an app workspace named Retail Analysis in the Power BI service. You need manage the members that have access to the app workspace. What should you do?
Power BI workspacesAccess managementMicrosoft 365 GroupsOffice 365 Admin center - Question #189Visualize and analyze the data
You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server. You need to ensure that all the vi...
Power BI Report ServerVisualization LimitationsReport PublishingVisual Types - Question #190Prepare the data
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different...
Data TransformationCalculated ColumnsData ModelingDate Dimensions - Question #191Prepare the data
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different...
Power QueryData typesData transformationPower BI relationships - Question #192Visualize and analyze the data
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 q...
Excel integrationPower ViewReport publishingData migration - Question #193Visualize and analyze the data
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 q...
Excel to Power BI migrationPower View conversionPower BI Service data connectionReport creation - Question #194Prepare the data
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 q...
Power Query EditorError HandlingData TransformationReplace Errors - Question #195Model the data
You have the following table named Location. The GeoCode column represents the country where each customer is located. You create a map visualization as shown in the exhibit. (Clic...
Map VisualizationGeographical DataColumn NamingData Categories - Question #196Model the data
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 q...
DAX MeasuresModel RelationshipsUSERELATIONSHIPCALCULATE