Get 2023 Free Microsoft PL-300 Exam Practice Materials Collection
Get Latest and 100% Accurate PL-300 Exam Questions
Microsoft PL-300 certification exam is designed to test an individual's ability to work effectively with Microsoft's Power BI platform. PL-300 exam is intended for those who are seeking to become certified data analysts, and who wish to demonstrate their expertise in using Power BI to analyze data and create reports. The PL-300 exam is part of Microsoft's Data and AI certification track, and is a prerequisite for some of the more advanced certifications in this area.
NEW QUESTION # 23
You use Power 81 Desktop to load data from a Microsoft SQL Server database.
While waiting for the data to load, you receive the following error.
You need to resolve the error.
What are two ways to achieve the goal? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.
- A. Use Power Query to combine long running queries into one query.
- B. Disable query folding on long running queries
- C. Reduce number of rows and columns returned by each query.
- D. Split long running queries into subsets Of columns and use power Query to the queries
Answer: A,B
NEW QUESTION # 24
You have an API that returns more than 100 columns. The following is a sample of column names.
client_notified_timestamp
client_notified_source
client_notified_sourceid
client_notified_value
client_responded_timestamp
client_responded_source
client_responded_sourceid
client_responded_value
You plan to include only a subset of the returned columns.
You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 25
DRAG DROP
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:
NEW QUESTION # 26
You have a Power Bl report.
You have the following tables.
You have the following DAX measure.
Answer:
Explanation:
NEW QUESTION # 27
You have a table that contains the following three columns:
City
Total Sales
Occupation
You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)
How should you configure the visualization? 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/visuals/power-bi-visualization-influencers
NEW QUESTION # 28
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:
Reference:
https://www.kasperonbi.com/get-the-ytd-of-the-same-period-last-year/
NEW QUESTION # 29
You are creating a query to be used as a Country dimension in a star schema.
A snapshot of the source data is shown in the following table.
You need to create the dimension. The dimension must contain a list of unique countries.
Which two actions should you perform? Each correct answer presents part of the solution.
- A. Remove duplicates from the City column.
- B. |Remove duplicates from the table.
- C. Delete the Country column.
- D. Delete the City column.
- E. Remove duplicates from the Country column.
Answer: D,E
Explanation:
Explanation
To create a dimension table for Country from your source data, you need to perform these two actions34:
* Delete the City column. You don't need this column for your Country dimension, as it is not a descriptive attribute of Country. You can create another dimension table for City if you want to use it in your analysis.
* Remove duplicates from the Country column. You want to have a list of unique countries in your dimension table, so you need to remove any duplicate values from this column.
NEW QUESTION # 30
You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege.
Which role should you assign to the user?
- A. Admin
- B. Member
- C. Contributor
- D. Viewer
Answer: B
Explanation:
A Member can add members or others with lower permissions.
Note:
NEW QUESTION # 31
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 to link the tables?
- A. one-to-many from Customer to Transaction
- B. one-to-many from Transaction to Customer
- C. one-to-one between Customer and Transaction
- D. many-to-many between Customer and Transaction
Answer: A
Explanation:
Each customer can have many transactions.
For each transaction there is exactly one customer.
NEW QUESTION # 32
Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. a pie chart that shows balances by account category without filters.
- B. a clustered column chart that shows balances by date (x-axis) and account category (legend) without filters.
- C. a ribbon chart that shows balances by quarter and accounts in the legend.
- D. a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities.
- E. a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.
Answer: C,E
Explanation:
Explanation
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a
NEW QUESTION # 33
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?
- A. Add a measure to the visual that uses the following DAX expression.
Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],6.40) - B. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
- C. Create a horizontal line that has a fixed value of 24,000.
- D. Add a measure to the visual that uses the following DAX expression.
Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)
Answer: B
Explanation:
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
1. Click on the analytics tab
2. Select Percentile
3. 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 chart
Add percentile lines to monitor daily revenue
NEW QUESTION # 34
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 different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)
You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).
You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory [Subcategory] contains NULL values.
End of repeated scenario.
You implement the Power BI model.
You need to add a new column to the Product Subcategory table that uses the following formula.
=if [Subcategory] =null then "NA" else [Subcategory]
Which command should you use in Query Editor?
- A. Conditional Column
- B. Invoke Custom Function
- C. Column From Examples
- D. Custom Column
Answer: A
NEW QUESTION # 35
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?
- A. SQL Server Profiler
- B. Query Diagnostics in Power BI
- C. Performance Analyzer in Power BI Desktop
- D. Microsoft Edge DevTools
Answer: C
Explanation:
Explanation
Use Power BI Desktop Performance Analyzer to optimize reports.
In Power BI Desktop you can find out how each of your report elements, such as visuals and DAX formulas, are performing. Using the Performance Analyzer, you can see and record logs that measure how each of your report elements performs when users interact with them, and which aspects of their performance are most (or least) resource intensive.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer
NEW QUESTION # 36
You have a Power BI model that has the following tables:
Product (Product_id, Product_Name)
Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)
Salesperson (Salesperson_id, Salesperson_name, address)
You plan to create the following measure.
Measure1 = DISTINCTCOUNT(Sales[ProductID])
You need to create the following relationships:
Sales to Product
Sales to Salesperson
The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson.
How should you configure the relationships? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 37
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:
Reference:
https://www.kasperonbi.com/get-the-ytd-of-the-same-period-last-year/
NEW QUESTION # 38
You import a Power Bl dataset that contains the following tables:
* Date
* Product
* Product Inventory
The Product inventory table contains 25 million rows. A sample of the data is shown in the following table.
The Product Inventory table relates to the Date table by using the DateKey column. The Product inventory table relates to the Product table by using the ProductKey column. You need to reduce the size of the data model without losing information. What should you do?
- A. Remove the relationship between Date and Product Inventory.
- B. Change Summarization for DateKey to Don't Summarize.
- C. Change the data type of UnitCost to Integer.
- D. Remove MovementDate.
Answer: D
NEW QUESTION # 39
You have a Power BI model that has the following tables:
Product (Product_id, Product_Name)
Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)
Salesperson (Salesperson_id, Salesperson_name, address)
You plan to create the following measure.
Measure1 = DISTINCTCOUNT(Sales[ProductID])
You need to create the following relationships:
Sales to Product
Sales to Salesperson
The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson.
How should you configure the relationships? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 40
You have a Power BI model that contains the following data.
The Date table relates to the Sales table by using the Date columns.
You need to create a calculated table that v/ill contain the following:
Answer:
Explanation:
NEW QUESTION # 41
You are creating an analytics report that will consume data from the tables shown in the following table.
There is a relationship between the tables.
There are no reporting requirements on employeejd and employee_photo.
You need to optimize the data model
What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.
Answer:
Explanation:
Explanation
Table Description automatically generated
Box 1: Hide
Optimize data by hiding fields and sorting visualization data
Box 2: Delete
The fastest way to optimize your Power BI report is to limit the number of columns to only the ones you need in your data model. Go through your tables in Power Query and determine what fields are being used. Delete these columns if they are not being used in any of your reports or calculations.
Reference:
https://tessellationtech.io/optimizing-power-bi-reports/
NEW QUESTION # 42
You have a Power Bl report.
You have the following tables.
You have the following DAX measure.
Answer:
Explanation:
Explanation
NEW QUESTION # 43
You use Power 81 Desktop to load data from a Microsoft SQL Server database.
While waiting for the data to load, you receive the following error.
You need to resolve the error.
What are two ways to achieve the goal? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.
- A. Use Power Query to combine long running queries into one query.
- B. Disable query folding on long running queries
- C. Reduce number of rows and columns returned by each query.
- D. Split long running queries into subsets Of columns and use power Query to the queries
Answer: A,B
NEW QUESTION # 44
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 goal and answer choices, but the text of the scenario is the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.
The following columns contain date information:
- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You need to create a relationship between the Monthly_returns table and Date[Date_ID].
What should you do before you create the relationship?
- A. To the Date table, add a calculated column that uses the RE LATE D(Monthly_ret urns [MonthJD]) DAX formula.
- B. In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.
- C. To the Order table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.
- D. In the Date table, create a new calculated column named MonthJD that uses the yyyydd format.
Answer: B
Explanation:
Explanation
References:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
NEW QUESTION # 45
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:
Explanation
NEW QUESTION # 46
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the fol-lowing format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?
- A. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
- B. split the Logged column by using at as the delimiter.
- C. Create a column by example that starts with 2018-12-31.
- D. Apply a transformation to extract the first 11 characters of the Logged column.
Answer: D
Explanation:
According to Microsoft Certified: Power BI Data Analyst Associate1, Power Query Editor is a tool that lets you connect to one or many data sources, shape and transform the data to meet your needs, then load that model into Power BI Desktop2.
One of the transformations you can perform in Power Query Editor is extract date from text, which creates a date value from a textual representation3. For example, given a text column like this:
Logged
2018-12-31 at 08:59
2019-01-01 at 09:15
You can extract the date part by using the Date.FromText function with a specific format4. The result will be:
Logged
Date
2018-12-31 at 08:59
2018-12-31
2019-01-01 at 09:15
2019-01-01
This makes it possible to use a built-in date hierarchy for analysis.
NEW QUESTION # 47
......
Microsoft PL-300 exam, also known as the Microsoft Power BI Data Analyst exam, is a certification exam designed for professionals who want to demonstrate their expertise in using Microsoft Power BI to create compelling data visualizations and reports. PL-300 exam is one of the most popular and recognized certification exams in the industry and is highly sought after by employers looking for skilled data analysts.
Maximum Grades By Making ready With PL-300 Dumps: https://www.actualvce.com/Microsoft/PL-300-valid-vce-dumps.html
Prepare PL-300 Exam Questions Recently Updated Questions: https://drive.google.com/open?id=1raqbblO0YquZDUaAXjjlogAWV7Ljd-SY