PL-300 Exam Questions
339 real PL-300 exam questions with expert-verified answers and explanations. Page 1 of 7.
- Question #1Prepare 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...
Data QualityPower Query ProfilingData ValidationNegative Values - Question #2Model 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...
DAXCalculated ColumnsDate FormattingFORMAT function - Question #3Prepare 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...
Data TypesRelationshipsData Preparation - Question #4Model 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...
DAX MeasuresCOUNTROWSCalculated Columns vs. MeasuresReporting Requirements - Question #5Model 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...
Data ModelingRelationshipsCalculated ColumnsDate Dimension - Question #7Prepare the data
Case Study 2 - Contoso Ltd Overview Existing Environment Contoso, Ltd. is a manufacturing company that produces outdoor equipment Contoso has quarterly board meetings for which fin...
DataflowsData preparationData consistencyShared dimensions - Question #12Prepare 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...
Data ImportSQL FilteringData SamplingLarge Datasets - Question #13Prepare 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...
Data ImportData SamplingDAXPower Query - Question #14Prepare 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...
Data import filteringData samplingReport-level filtersPerformance optimization - Question #15Prepare 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 ParametersData Source ManagementPower Apps VisualDynamic Data Sources - Question #16Prepare 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 QueryParametersM LanguageData Source Configuration - Question #17Prepare 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 ManagementRefactoring - Question #18Visualize and analyze the data
You have the visual shown in the Original exhibit. You need to configure the visual as shown in the Modified exhibit. What should you add to the visual?
VisualizationsForecastingAnalytics paneLine charts - Question #19Visualize and analyze the data
You plan to create the chart shown in the following exhibit. How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?
Chart customizationAnalytics panePercentile lineVisual enhancements - Question #20Visualize and analyze the data
You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table. Which type of visualization should you use?
VisualizationOutlier detectionScatter plotChart types - Question #21Visualize and analyze the data
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 a historic employee counts and predicts...
Data visualizationLine chartsTime series dataTrend analysis - Question #22Visualize and analyze the data
You have the visual shown in the exhibit. You need to show the relationship between Total Cost and Total Sales over time. What should you do?
SlicersTime intelligenceVisual interaction - Question #23Visualize and analyze the data
You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect succes...
VisualizationsKey Influencers visualData analysisIdentify drivers - Question #24Prepare the data
You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the related and relatedtable functions. You need to recommend a sol...
Power QueryData TransformationDAX OptimizationData Modeling - Question #25Model the data
You have a sales system that contains the tables shown in the following table. The Date table is marked as a date table. DateID is the date data type. You need to create an annual...
DAXTime IntelligenceMeasuresSales Growth - Question #26Model the data
You build a report to analyze customer transactions from a database that contains the tables shown in the following table. You import the tables. Which relationship should you use...
Data ModelingTable RelationshipsOne-to-many RelationshipCustomer Transactions - Question #27Model the data
You are configuring a Microsoft Power Bl 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&ANatural Language QueryData Model OptimizationSynonyms - Question #28Visualize and analyze 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...
Report performanceVisual optimizationReport design best practicesQuery optimization - Question #29Manage and secure Power BI
You have four sales regions. Each region has multiple sales managers. You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each rol...
Row-Level Security (RLS)Azure Active Directory (AAD)Data access controlSecurity management - Question #30Manage and secure Power BI
You have five sales regions. Each region is assigned a single salesperson. You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role...
Row-Level Security (RLS)Power BI ServiceDataset securityTroubleshooting - Question #31Manage and secure Power BI
You have a collection of reports for the HR department of your company. The datasets use row- level security (RLS). The company has multiple sales regions that each has an HR manag...
Row-level securityWorkspace accessReport distributionRole-based access control - Question #32Deploy and maintain assets
Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power Bl. You need to recommend an application li...
Application Lifecycle Management (ALM)WorkspacesDeployment strategiesAccess control - Question #33Visualize and analyze the data
You are creating a visual to show the ranking of product categories by sales revenue. Your company's security policy states that you cannot send data outside of your Microsoft Powe...
Power BI visualsCustom visualsAppSource visualsVisual security - Question #34Deploy and maintain assets
You have a Microsoft Power BI dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exh...
Dashboard refreshTile cachingData refresh processPower BI Service - Question #35Visualize and analyze the data
You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are...
SlicersFiltersReport DesignCross-page Interaction - Question #36Visualize and analyze the data
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...
AccessibilityTab orderReport designKeyboard navigation - Question #37Manage and secure Power BI
You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the das...
Power BI ServiceSubscriptionsNotificationsDashboards - Question #38Manage 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 classificationData sensitivityPower BI ServiceInformation governance - Question #39Visualize and analyze the data
You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer servi...
Report settingsData exportUser interactionPower BI Service - Question #40Visualize and analyze the data
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...
SlicersSync SlicersVisual InteractionsReport Filtering - Question #41Visualize and analyze the data
You have a Microsoft Power Bl dashboard. You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard. What...
Power BI ServiceDashboard featuresCollaborationComments - Question #42Prepare the data
You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. A...
SharePoint ConnectorPower Query FilteringDocument LibrariesData Loading - Question #43Prepare the data
You create the following step by using Power Query Editor. = Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasa...
Power QueryM languageTable.ReplaceValueData transformation - Question #44Prepare the data
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? Each correct answer...
Power Query EditorData profilingColumn uniquenessData preview - Question #45Prepare the data
You have a query that returns the data shown in the following exhibit. You need to configure the query to display the data as shown in the following exhibit. Which step should you...
Power QueryData TransformationExpand ListM Language - Question #52Visualize and analyze the data
You have a Power BI report that contains four pages. All the pages contain a slicer for a field named Country, You need to ensure that when a user selects a county on page 1, the s...
SlicersSlicer synchronizationReport interactivityPower BI Desktop features - Question #60Prepare 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 TransformationError HandlingData Cleaning - Question #61
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...
- Question #62Prepare 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 EditorData CleaningError HandlingData Transformation - Question #63Model the data
You have a Power BI model for sales data. You create a measure to calculate the year-to-date sales. You need to compare the year-to-date sales with the previous year for the same t...
DAXTime IntelligenceMeasuresPrevious Year Comparison - Question #64Visualize and analyze the data
From the Home tab in Power BI Desktop, you click Enter Data and create a table named Sales that contains the following data. You add Region and Sales to visualization and the visua...
Default summarizationAutomatic aggregationGrouping dataPower BI visualizations - Question #65Model the data
You have a table named Sales. A sample of the data in Sales is shown in the following table. You create a stacked column chart visualization that displays ProductName by Date. You...
Date HierarchyDate Dimension TableDrill DownTime Intelligence - Question #66Visualize and analyze the data
You need to create a custom visualization for Power BI. What should you install first?
Custom visuals developmentNode.jsPower BI SDKDevelopment prerequisites - Question #67Manage and secure Power BI
You have a Power BI report that is configured to use row-level security (RLS). You have the following roles: - A manager role that limits managers to see only the sales data from t...
Power BI EmbeddedRow-Level Security (RLS)Embed TokenApplication Security - Question #68Visualize and analyze the data
You are creating a report in Power BI Desktop that has two visualizations on a page as shown in the following exhibit. You need to ensure that when you click the bar of a country,...
Report InteractionsVisual FilteringPower BI DesktopVisualizations