Free Jan-2023 PL-300 Certification Sample Questions certification Exam
Certification Topics of PL-300 Exam PDF Recently Updated Questions
Benefits
The Microsoft Power BI Data Analyst certification is a globally recognized certification that validates your ability to design, build, and optimize data models using Power BI. It also demonstrates your expertise in building queries and reports with appropriate visuals, including dashboards, scorecards, and visualizations. This certification focuses on the intermediate-level skills required for data modeling and analysis.
The Microsoft Power BI Data Analyst certification provides many benefits to you. It helps you boost your career growth by validating your knowledge in building business intelligence solutions using Power BI platform. It validates your skills in designing reports and visualizations for various business needs. It increases your credibility among employers as most companies look for professionals who have this certification. It provides an opportunity to earn a higher salary package compared to those without this certification. Test4Cram Microsoft PL-300 Dumps will help you to pass your certification exam and get highly paid job.
NEW QUESTION 92
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. (Click the Exhibit tab.)
You need to ensure that the map displays the country locations.
What should you do?
- A. Add a Geoportal column to the Location table.
- B. Change the Default Summarization of the GeoCode column.
- C. Replace the values in the GeoCode column with postal codes or zip codes.
- D. Change the name of the GeoCode column to
- E. Change the name of the Location table to
- F. Change the Data Type of the GeoCode column.
Answer: D
Explanation:
Explanation
References:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks
NEW QUESTION 93
You are creating a Microsoft Power BI data model that has the tables shown in the following table.
The Products table is related to the ProductCategory table through the ProductCategoryID column.
You need to ensure that you can analyze sales by product category.
How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
NEW QUESTION 94
You have the Power BI data model shown in the following exhibit.
Select the appropriate yes or no.
Answer:
Explanation:
NEW QUESTION 95
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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: From Power Query Editor, you import the table and then add a filter step to the query.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
NEW QUESTION 96
How 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.
Answer:
Explanation:
NEW QUESTION 97
You have a Microsoft Excel workbook that contains two tables.
From Power BI, you create a dashboard that displays data from the tables.
You update the tables each day.
You need to ensure that the virtualizations in the dashboard are updated daily.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to answer area and arrange them in the correct order.
Answer:
Explanation:
1 - Dowload and install an on-premises data gateway(personal).
2 - For each dataset, modify the Gateway Connection settings.
3 - For each dataset, modify the Schedule Refresh settings.
NEW QUESTION 98
You are building a financial report by using Power BI.
You have a table named financials that contains a column named Date and a column named Sales.
You need to create a measure that calculates the relative change in sales as compared to the previous quarter.
How should you complete the measure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://community.powerbi.com/t5/Desktop/Error-calculating-QOQ-using-quick-measure/m-p/547054
NEW QUESTION 99
You are creating a quick measure as shown in the following exhibit.
You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures
NEW QUESTION 100
Your company has affiliates who help the company acquire customers.
You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.
The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.
You need to develop a measure to support the visual.
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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax
NEW QUESTION 101
You have a Power Bl workspace that contains a single-page report named Sales.
You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visuals added to the page are added automatically to the dashboard.
Which three 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.
Answer:
Explanation:
1 - Open powerbi.com
2 - Select sales report
3 - Pin the page
NEW QUESTION 102
You receive revenue data that must be included in Microsoft Power Bl reports.
You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.
You plan to create several visuals from the data, including a visual that shows revenue split by year and product.
You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.
Which three 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.
Answer:
Explanation:
1 - Select Use First Row as Headers.
2 - Select Department and Product and Unpivot Other columns.
3 - Rename the Attribute column to Year and the Value column to Revenue.
Reference:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
NEW QUESTION 103
You are profiling data by using Power Query Editor.
The AddressLine2 column in a table named Address is shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 104
You have two CSV files named Products and Categories. The Products file contains the following columns:
* ProductID
* ProduetName
* SupplierID
* CategoryID
The Categories file contains the following columns:
From Power Bl Desktop, you import the files into Power Query Editor.
You need to create a Power Bl dataset that will contain a single table named Product. The Product will table includes the following columns:
Answer:
Explanation:
see the explanation for the answer.
Explanation
Answer as selected
NEW QUESTION 105
You 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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/powerquery-m/text-replace
https://docs.microsoft.com/en-us/powerquery-m/text-end
NEW QUESTION 106
You have a sales system that contains the tables shown in the following table.
The Date table is marked as a date table.
DatelD is the date data type. You need to create an annual sales growth percentage measure.
Which DAX expression should you use?
- A. SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DatelD])
- B. CALCULATE(SUH(sales[sales_araount]), SAMEPERIODLASTYEAR('Date'[DatelD])
- C. CALCULATE(SUM(sales[sales_amount]), DATESYTD('Date'[DatelD]))
- D. (SUN(sales[sales_araount]) - CALCULATE(SUM(sales[sales_amount]), SAHEPERIOOLASTYEAR('Date'[DatelD]))/ CALCULATE(SUM(sales[sales_amount]), SAMEPERIOOLASTYEAR ('Date'[DateID])
Answer: B
NEW QUESTION 107
You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1.
Sheet2 contains the following table named Table2.
Answer:
Explanation:
1 - From Power BI Desktope, import the data from Excel, and select Table1 and Table2
2 - From Power Query Editor, append Table2 to Table1.
3 - From power Query Editor, select Table1, and then select Remove duplicates.
NEW QUESTION 108
You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://powerbidocs.com/2020/01/21/power-bi-top-n-filters/
NEW QUESTION 109
You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity.
How should you complete the measure? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/isfiltered-function-dax
NEW QUESTION 110
You plan to create the Power Bl model shown in the exhibit. (Click the Exhibit tab.) The data has the following refresh requirements:
* Customer must be refreshed daily.
* Date must be refreshed once every three years.
* Sales must be refreshed in near real time.
* SalesAggregate must be refreshed once per week.
You need to select the storage modes for the tables. The solution must meet the following requirements:
Answer:
Explanation:
NEW QUESTION 111
You have a Power BI model that contains a table named Sales. Sales has the following three measures:
A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million.
A measure named Total Sales This Year that displays the sales from the current calendar year. The current value is 11.69 million.
A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year] - Sales[This Year].
You need to create the following visualization.
How should you configure the visualization? To answer, drag the appropriate measures to the correct fields. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts
NEW QUESTION 112
You are enhancing a Power BI model that has DAX calculations.
You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.
Which DAX functions should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Reference:
https://www.kasperonbi.com/get-the-ytd-of-the-same-period-last-year/
NEW QUESTION 113
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. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create an average line by using the Salary measure.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
Explanation:
Instead create a percentile line by using the Salary measure and set the percentile to 50%.
Note: The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.
Reference:
https://dash-intel.com/powerbi/statistical_functions_percentile.php
NEW QUESTION 114
You are modifying a Power Bi model by using Power Bl Desktop.
You have a table named Sales that contains the following fields.
You have a table named Transaction Size that contains the following data.
Answer:
Explanation:
NEW QUESTION 115
......
2023 New Preparation Guide of Microsoft PL-300 Exam: https://www.test4cram.com/PL-300_real-exam-dumps.html
PL-300 Exam Prep Guide: Prep guide for the PL-300 Exam: https://drive.google.com/open?id=13-JwRZFZ42j4S9gl9lvS10knFQ85wwWB