This page was exported from Top Exam Collection [ http://blog.topexamcollection.com ] Export date:Mon Jan 20 20:48:12 2025 / +0000 GMT ___________________________________________________ Title: Microsoft PL-300 Real 2023 Braindumps Mock Exam Dumps [Q166-Q189] --------------------------------------------------- Microsoft PL-300 Real 2023 Braindumps Mock Exam Dumps PL-300 Exam Questions | Real PL-300 Practice Dumps For more info visit: Microsoft Power BI Data Analyst Certification Exam Reference Understanding Microsoft Power BI Data Analyst Certification Exam Topics Microsoft Power BI Data Analyst Certification Exam Topics are below: Model the data (30-35%)Deploy and maintain assets (20-25%)Prepare the data (15-20%)Visualize and analyze the data (25-30%)   QUESTION 166You 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?  Create a horizontal line that has a fixed value of 24,000.  Add a measure to the visual that uses the following DAX expression.Heasurel – PERCENTUEX.EXC (Sales,Sales[Total Sales],.40)  Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.  Add a measure to the visual that uses the following DAX expression.Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40) The analytics feature enables you to show percentiles across groups specified along a specific axis.Example:1. Click on the analytics tab2. Select Percentile3. You can choose a specific percentile along with other formatting options.4. Drag a date or non-numeric dimension into the Axis of a column chartAdd percentile lines to monitor daily revenueQUESTION 167HOTSPOTHow should you distribute the reports to the board? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. QUESTION 168Note: 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. As a 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 publish an app to the entire organization.Does this meet the goal?  Yes  No https://docs.microsoft.com/es-es/power-bi/collaborate-share/service-create-distribute-appsQUESTION 169You 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, geography, and demographics. The solution must minimize analysis effort.Which type of visualization should you use?  decomposition tree  funnel chart  Q&A  key influencers QUESTION 170You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.You need to build the dashboard.Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. 1 – Pin items from report to Dashboard.2 – Open Dashboard.3 – Change the dashboard view to Phone view.4 – Rearrange, resize the visuals.QUESTION 171Remove unused columns from tables in the data model. This will reduce the size of your PBIX file and make your data model more efficient. You can use Power Query Editor to remove any columns that are not used in your report or calculations.You need to shape the query to display the following three columns:* Month* Sales* Year‘What should you select in Power Query Editor?  Pivot column  Merge columns  Unpivot columns.  Transpose ExplanationThis will convert your column headers (Jan-20, Feb-20,…) into row values under a new column called Attribute. You can then rename this column as Month and change its data type to Date. You will also have a new column called Value that contains the sales amounts for each month. You can rename this column as Sales and change its data type to Decimal Number.QUESTION 172You are preparing a financial report in Power BI.You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.You need to prepare the data to support the following:* Visualizations that include all measures in the data over time* Year-over-year calculations for all the measuresWhich four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. ExplanationReference:https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c70QUESTION 173You have a column named UnitslnStock as shown in the following exhibit ExplanationQUESTION 174You 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?  Pin a report page to a dashboard and set an alert on the page.  Set an alert on a KPI visual in the report.  Pin a card visual to a dashboard and set an alert on the tile.  Pin a card visual to a dashboard and create a subscription. QUESTION 175You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.For each of the following statement, select Yes if the statement is true, Otherwise, select No.NOTE: Each correct selection is worth one point. QUESTION 176You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:CustomerIDCustomer CityCustomer StateCustomer NameCustomer Address 1Customer Address 2Customer Postal CodeThe Invoice table contains the following fields:Order IDInvoice IDInvoice DateCustomer IDTotal AmountTotal Item CountThe Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.The Power BI model must provide the following information:The number of customers invoiced in each state last monthThe average invoice amount per customer in each postal codeYou need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.What should you configure? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Reference:https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understandQUESTION 177You 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?  Remove the card visual, increase the size of the map and bar chart visuals  Decrease the size of the map and bar chart visuals Move all the card visuals to the top of the layout.  Move the bar chart visuals to the top of the layout Remove the map visuals. Decrease the size of the card visuals.  Decrease the size of the card visuals. Remove the map and bar chart visuals. QUESTION 178You need to create a Power BI 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?  From Power Bl Desktop, customize the current theme,  From power Bl Desktop, use a built in report theme.  Create a theme as a JSON file and import the theme into Power Bl Desktop.  Create a theme as a PBIVlZ file and import the theme into Power Bl Desktop. QUESTION 179You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.For each of the following statement, select Yes if the statement is true, Otherwise, select No.NOTE: Each correct selection is worth one point. ExplanationQUESTION 180You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit.Which type of visual should you use?  Q&A  decomposition tree  smart narrative  key influencers QUESTION 181You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)The related dimension tables are imported into the model.For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point. Reference:https://finance-bi.com/power-bi-basket-analysis/QUESTION 182You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.Sales contains only the data shown in the following table.For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point. Reference:https://docs.microsoft.com/en-us/dax/related-function-daxhttps://docs.microsoft.com/en-us/dax/calculate-function-daxQUESTION 183HOTSPOTYou need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table .Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. QUESTION 184You have two CSV files named Products and Categories.The Products file contains the following columns:ProductIDProductNameSupplierIDCategoryIDThe Categories file contains the following columns:CategoryIDCategoryNameCategoryDescriptionFrom Power BI Desktop, you import the files into Power Query Editor.You need to create a Power BI dataset that will contain a single table named Product. The Product will table includes the following columns:ProductIDProductNameSupplierIDCategoryIDCategoryNameCategoryDescriptionHow should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. QUESTION 185You plan to create a report that will display sales data from the last year for multiple regions You need to restrict access to individual rows of the data on a per region-basis by using roles.Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. 1 – Import the data to Power BI Desktop.2 – Create a role definition.3 – Assign users to the role.QUESTION 186You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?  Apply row-level security (RLS) to the Region table based on the sales manager username.  Configure a bi-directional relationship between Region and Sales.Region.  Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column.  In the Region table, create a hierarchy that has the manager name, and then the sales manager name. OverviewThis is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.To start the case studyTo display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.Topic 3, Northwind TradersOverview. General OverviewNorthwind Traders is a specialty food import company.The company recently implemented Power BI to better understand its top customers, products, and suppliers.Overview. Business IssuesThe sales department relies on the IT department to generate reports in Microsoft SQL Server Reporting Services (SSRS). The IT department takes too long to generate the reports and often misunderstands the report requirements.Existing EnvironmentData SourcesNorthwind Traders uses the data sources shown in the following table.Source2 is exported daily from a third-party system and stored in Microsoft SharePoint Online.Existing Environment. Customer WorksheetSource2 contains a single worksheet named Customer Details. The first 11 rows of the worksheet are shown in the following table.All the fields in Source2 are mandatory.The Address column in Customer Details is the billing address, which can differ from the shipping address.Existing Environment. Azure SQL DatabaseSource1 contains the following table:OrdersProductsSuppliersCategoriesOrder DetailsSales EmployeesThe Orders table contains the following columns.The Order Details table contains the following columns.The address in the Orders table is the shipping address, which can differ from the billing address.The Products table contains the following columns.The Categories table contains the following columns.The Suppliers table contains the following columns.The Sales Employees table contains the following columns.Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region.Requirements. Report RequirementsNorthwind Traders requires the following reports:Top ProductsTop CustomersOn-Time ShippingThe Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.The Top Products report will show the top 20 products based on the highest sales amounts sold in a selected order month or quarter, sales region, and product category. The report must also show which suppliers provide the top products.The On-Time Shipping report will show the following metrics for a selected shipping month or quarter:The percentage of orders that were shipped late by country and shipping region Customers that had multiple late shipments during the last quarter Northwind Traders defines late orders as those shipped after the required shipping date.The warehouse shipping department must be notified if the percentage of late orders within the current month exceeds 5%.The reports must show historical data for the current calendar year and the last three calendar years.Requirements. Technical RequirementsNorthwind Traders identifies the following technical requirements:A single dataset must support all three reports.The reports must be stored in a single Power BI workspace.Report data must be current as of 7 AM Pacific Time each day.The reports must provide fast response times when users interact with a visualization.The data model must minimize the size of the dataset as much as possible, while meeting the report requirements and the technical requirements.Requirements. Security RequirementsAccess to the reports must be granted to Azure Active Directory (Azure AD) security groups only. An Azure AD security group exists for each department.The sales department must be able to perform the following tasks in Power BI:Create, edit, and delete content in the reports.Manage permissions for workspaces, datasets, and report.Publish, unpublish, update, and change the permissions for an app.Assign Azure AD groups role-based access to the reports workspace.Users in the sales department must be able to access only the data of the sales region to which they are assigned in the Sales Employees table.Power BI has the following row-level security (RLS) Table filter DAX expression for the Sales Employees table.[EmailAddress] = USERNAME()RLS will be applied only to the sales department users. Users in all other departments must be able to view all the data.QUESTION 187You 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 use in the query?  =Table.ExpandListColum(Table.TransformColunins(Source, {{“classes”. Splitter.SplitTextByDelimiter(”,”, QuoteStyle.None), let itemType – (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), “classes”)  = Table.Unpivot(Source, {“classes”}, “Attribute”, “Value”)  = Table.SplitColumn(Source, “classes”. Splitter.SplitTextByDelimiterf”,”, QuoteStyle.None), {“classes.1”})  = Table.SplitColumn(Source, “classes”. Splitter.SplitTextByPositions({10}), {“classes.1”}) Power Query Unpivot columns: You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.Note:Syntax: Table.Unpivot(table as table, pivotColumns as list, attributeColumn as text, valueColumn as text) as table Table.Unpivot translates a set of columns in a table into attribute-value pairs, combined with the rest of the values in each row.Reference:https://docs.microsoft.com/en-us/power-query/unpivot-columnhttps://docs.microsoft.com/en-us/powerquery-m/table-unpivotQUESTION 188You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.You need to add a new column that contains the data in the format of nnn-nnn-nnnn.How should you complete the Query Editor formula? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Reference:https://docs.microsoft.com/en-us/powerquery-m/text-replacehttps://docs.microsoft.com/en-us/powerquery-m/text-endQUESTION 189You create the following step by using Power Query Editor.=Table.ReplaceValue(SalesLT_Address,”1318″,”1319″,Replacer.ReplaceText,{“AddressLine 1”}) A row has a value of 21318 Lasalle Street in the AddressLine1 column .What will the value be when the step is applied?  1318  1319  21318 Lasalle Street  21319 Lasalle Street  Loading … Microsoft PL-300 (Microsoft Power BI Data Analyst) Certification Exam is designed to test the skills and knowledge of professionals who work with Power BI. Power BI is a business analytics service provided by Microsoft that enables organizations to visualize and analyze their data. A Microsoft Power BI Data Analyst is responsible for creating reports, dashboards, and other visualizations to help organizations make informed decisions. Microsoft Power BI Data Analyst certification exam is a great way for professionals to demonstrate their expertise in Power BI and stand out in the competitive job market.   Verified PL-300 Exam Dumps Q&As - Provide PL-300 with Correct Answers: https://www.topexamcollection.com/PL-300-vce-collection.html --------------------------------------------------- Images: https://blog.topexamcollection.com/wp-content/plugins/watu/loading.gif https://blog.topexamcollection.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2023-12-27 10:32:35 Post date GMT: 2023-12-27 10:32:35 Post modified date: 2023-12-27 10:32:35 Post modified date GMT: 2023-12-27 10:32:35