If you are looking for free PL-300 dumps than here we have some sample question answers available. You can prepare from our Microsoft PL-300 exam questions notes and prepare exam with this practice test. Check below our updated PL-300 exam dumps.
DumpsGroup are top class study material providers and our inclusive range of PL-300 Real exam questions would be your key to success in Microsoft Microsoft Certified: Power BI Data Analyst Associate Certification Exam in just first attempt. We have an excellent material covering almost all the topics of Microsoft PL-300 exam. You can get this material in Microsoft PL-300 PDF and PL-300 practice test engine formats designed similar to the Real Exam Questions. Free PL-300 questions answers and free Microsoft PL-300 study material is available here to get an idea about the quality and accuracy of our study material.
You are creating a Power BI report to analyze consumer purchasing patterns from a tablenamed Transactions. The Transactions table contains a numeric field named Spend. Youneed to include a visual that identifies which fields have the greatest impact on Spend.Which type of visual should you use?
You are creating a dashboard by using the Power Bl service.You have an existing report page that contains three charts.You need to add the charts to the dashboard while maintaining the interactivity between thecharts.What should you do?
You have a Power 31 data model that contains a table named Stores. The table has thefollowing columns:* Store Name * Open Date* Status* State* CityYou need to create a calculated column named Active Store Name that meets the followingrequirements:
You have a Rawer Bl report That imports a dace table and a sales table from an AzureSQL 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 three dates at the sametime.Solution: From the Fields pane, you rename the date table as Due Date. You use a DAXexpression to create Order Date and Delivery Date as calculated tables. You create activerelationships between the sales table and each date table.Does this meet the goal?
You have a dataset that is used infrequently and refreshes every hour.You receive a notification that the refresh was disabled due to inactivity.Which two actions will cause the scheduled refresh schedule to resume? Each correctanswer presents a complete solution.NOTE: Each correct selection is worth one point.
You have two Power Bl reports named ReportA and ReportB that each uses a distinct colorpalette.You are creating a Power Bl dashboard that will include two visuals from each reportYou need to use a consistent dark theme for the dashboard. The solution must preservethe original colors of the reports.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
You need to create a Power BI theme that will be used in multiple reports. The theme willinclude corporate branding for font size, color, and bar chart formatting.What should you do?
You need to create a Power Bl theme that will be used in multiple reports. The theme willinclude corporate branding for font size, color, and bar chartformatting.What should you do?
You have a CSV file that contains user complaints. The file contains a column namedLogged. Logged contains the date and time each compliant occurred. The data in Loggedis in the fol-lowing format: 2018-12-31 at 08:59. You need to be able to analyze thecomplaints by the logged date and use a built-in date hierarchy. What should you do?
You are building a Power Bl report.Users will view the report by using their mobile device.You need to configure the report to display data based on each user s location.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
You have a Power Bl report that contains a page. The page contains the following:• A shape named Shape 1• A card named Sales Summary• A clustered bar chart named Sales by RegionYou need to ensure that Sales Summary renders on top of Shape 1. What should youmodify?
You have a Power BI workspace named BI Data that contains a dataset named BI Finance.You have the Build permission for the 81 Finance dataset but you do NOT havepermissions for the workspace,You need to connect to BI Finance and create a report.Which actions should you perform? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.
Note: This question is part of a series of questions that present the same scenario. Eachquestion in the series contains a unique solution that might meet the stated goals. Somequestion sets might have more than one correct solution, while others might not have acorrect 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 SQLdatabase data source. The sales table has the following date foreign keys:Due DateOrder DateDelivery 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 tableand the date table.Does this meet the goal?
What should you do to address the existing environment data concerns?
In Power BI Desktop, you are creating a report that will contain three pages.You need to create a custom tooltip page and prepare the page for use.Which three actions should you perform? Each correct answer presents part of thesolution.
What is the minimum number of Power BI datasets needed to support the reports?
You have a Power Bl report that contains five pages.Pages 1 to 4 are visible and page 5 is hidden.You need to create a solution that will enable users to quickly navigate from the first pageto all the other visible pages. The solution must minimize development and maintenanceeffort as pages are added to the report.What should you do first?
You have two Power Bl workspaces named WorkspaceA and Workspaces. WorkspaceA contains two datasets named Sales and HR. You need to provide a user named User1 with access to the workspaces. The solution must meet the following requirements: • Create reports that use the HR dataset. • Publish the reports to WorkspaceB. • Prevent the ability to modify the HR dataset. • Prevent the ability to add users to WorkspaceB.
A business intelligence (Bl) developer creates a dataflow in Power Bl 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 have a Power Bl report hosted on powerbi.com that displays expenses by department for department managers. The report contains a line chart that shows expenses by month. You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort. What should you do?
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 m the column chart, the donut chart redraws by using the data from the selected column. What should you do?
You have a PBiX file that imports several tables from an Azure SQL database. The data will be migrated to another Azure SQL database. You need to change the connections in the PBIX file. The solution must minimize administrative effort. What should you do?
You are creating a Power BI model that contains a table named Store. Store contains the following fields. You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City. What should you do to ensure that the locations are mapped property?
You have a Power Bl workspace that contains several reports. You need to provide a user with the ability to create a dashboard that will use the visuals from the reports. What should you do?
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 the Power Bi dashboard shown in the Dashboard exhibit (Click the Dashboard tab.) You need to ensure that when users view the dashboard on a mobile device, the dashboard appears as shown in the Mobile exhibit. (Click the Mobile tab.) What should you do? To answer, select the appropriate options m the answer area NOTE: Each correct selection is worth one point.
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 l, the selection is retained on page 2 and page 3. The solution must prevent page 4 from being affected by selections on the other pages, What should you do?
You have a Power Bl workspace that contains a dataset. a report, and a dashboard. The following groups have access: • External users can access the dashboard. • Managers can access the dashboard and a manager-specific report. • Employees can access the dashboard and a row-level security (RLS) constrained report. You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised. What should you use?
You have a Power Bl report that contains a measure named Total Sales. You need to create a new measure that will return the sum of Total Sates for a year up to a selected date. How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
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 a Power Bl report You have a table named Dalai that contains 10 million rows. Data is used in the following visuals: • A card that shows the number of records • A bar chart that snows total transaction amount by territory • A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory You 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?
You have a report in Power Bl named report1 that is based on a shared dataset. You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being affected. What should you do?
You have a Power BI report that contains one page. The page contains two line charts and one bar chart. You need to ensure that users can perform the following tasks for all three visuals: Switch the measures used in the visuals. Change the visualization type. Add a legend. The solution must minimize development effort. What should you do?
You attempt to connect Purer 81 Desktop to a Cassandra database. From the Get Data connector list you discover that there is no specific connector for the Cassandra database, You need to select an alternate data connector that will connect to the database. Which of connector should you choose?
You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power Bi dataset You need to ensure that the dataset can be refreshed in powefbi.com. Which two connectors can you use to connect to the file? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
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 a Power Bl 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.
You maintain a Power Bl workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals. The dashboard mobile layout is shown in the exhibit. (Click the Exhibit tab.) You need to modify the dashboard mobile layout to meet the following requirements: • Only show single-value visuals. • Minimize scrolling. What should you do?
You need to create a Power 31 theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting. What should you do?
You have a Power Bl report that uses row-level security (RLS). You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets. or dashboards. What should you do?
You need to create a visualization to meet the reporting requirements of the sales managers. HOW Should create the Visualization? TO answer, select the appropriate options in the answer area.
You import two Microsoft Excel tables named Customer and Address into Power Query Customer contains the following columns: • Customer ID • Customer Name • Phone • Email Address • Address ID Address contains the following columns: • Address ID • Address Line 1 • Address Line 2 • City • State/Region • Country • Postal Code Each Customer ID represents a unique customer m the Customer table. Each Address ID represents a unique address m the Address table. You need to create a query that has one row per customer. Each row must contain City. State/Region, and Country for each customer. What should you do?
You have a Power Bl report named Report1 and a dashboard named Dashboard1, 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 bar chart displays on Dashboard1. What should you do?
You have a Power Bi report. The report contains a visual that snows gross sales by date The visual has anomaly detection enabled. No anomalies ate detected You need to increase the likelihood that anomaly detection will identify anomalies in the report. What should you do?
You build a Power Bi report that displays loT temperature data streaming from a refrigerator. You publish the report to the Power BI service. You need to be notified when the temperature rises above four degrees Celsius. What should you do?
You have more than 100 published datasets. Ten of the datasets were verified to meet your corporate quality standards. You need to ensure that the 10 verified datasets appear at the top of the list of published datasets whenever users search for existing datasets. What should you do?
You are creating a Power Bl report by using Power Bi Desktop. You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals. Which type of visual should you use?
You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection'
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 scenario, you will NOT be able to return to it. Asa result, these questions will not appear in the review screen. You have several reports and dashboards in a workspace. You need to grant all organizational users read access to a dashboard and several reports. Solution: You enable included in app for all assets. Does this meet the goal?
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 Information (PII). The solution must minimize configuration effort and impact on the dashboard design. What should you use?
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 manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?
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?