(2023) PL-300 Exam Dumps, Practice Test Questions BUNDLE PACK
Microsoft Certified: Power BI Data Analyst Associate Certification PL-300 Sample Questions Reliable
NEW QUESTION # 61
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 # 62
Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? 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 - From Power BI Desktop, publish the dataset to powerbi.com
2 - From Power BI Desktop, create four roles.
3 - From Power BI Desktop, add a Table Filter DAX Expression to the roles.
4 - From powerbi.com, add role members to the roles.
NEW QUESTION # 63
You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the following 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 the parse function from the Date transformations options to the Logged column.
- B. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.
- C. Create a column by example that starts with 2018-12-31.
- D. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
Answer: A
NEW QUESTION # 64
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 # 65
You have a report page that contains the visuals 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:
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-interactions
NEW QUESTION # 66
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. Yes
- B. No
Answer: B
NEW QUESTION # 67
Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:
Access a published Power BI app
Modify reports in an app workspace
Share dashboards created in My Workspace
You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.
Which license should you identify for each task? 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/service-create-distribute-apps
https://docs.microsoft.com/en-us/power-bi/service-collaborate-power-bi-workspace
NEW QUESTION # 68
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 # 69
You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.
The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.
You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.
How should you complete the calculation? 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/allselected-function-dax
NEW QUESTION # 70
You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the following 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 the parse function from the Date transformations options to the Logged column.
- B. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.
- C. Create a column by example that starts with 2018-12-31.
- D. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
Answer: A
NEW QUESTION # 71
You have a query named Customer that imports CSV files from a data lake. The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)
Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.
You need to keep only the last modified row for each customer ID.
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 - Duplicate Customer query
2 - Group by CustId by Max ModifiedDate,,,,
3 - Merge two queries on CustId and ModifiedDate inner join,,,,,,,
NEW QUESTION # 72
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 # 73
You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1.
A user wants to create a report by using the data In DS1 and publish the report to another workspace.
You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user.
What should you do?
- A. Add the user as a member of Workspace1.
- B. Share RPT1 with the user.
- C. Grant the Build permission for DS1 to the user.
- D. Add the user as a Viewer of Workspace1.
Answer: A
Explanation:
Microsoft says: To copy a report to another workspace, and to create a report in another workspace based on a dataset in the current workspace, you need Build permission for the dataset. For datasets in the original workspace, if you have at least the Contributor role, you automatically have Build permission through your workspace role.
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces
NEW QUESTION # 74
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 # 75
You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail dat a. The users require insights on the completeness of the data and the value distributions.
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 - Create a blank query a sa data soure.
2 - Specify the following query, then close and apply.,,,,,
3 - Create a visual for the query table.
NEW QUESTION # 76
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 presents a complete solution. NOTE: Each correct selection is worth one point
- A. Column quality
- B. Column profile
- C. Column distribution
- D. Monospaced
- E. Show whitespace
Answer: A,E
NEW QUESTION # 77
HOTSPOT
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:
NEW QUESTION # 78
HOTSPOT
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:
NEW QUESTION # 79
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 # 80
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 filters sales transaction data by salesperson.
Salespeople must see only the data from their region.
You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.
A salesperson reports that she believes she should see more data.
You need to verify what data the salesperson currently sees.
What should you do?
- A. Use the Test as role option to view data as the Sales role.
- B. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.
- C. Instruct the salesperson to open the report in Microsoft Power Bl Desktop.
- D. Use the Test as role option to view data as the salesperson's user account.
Answer: A
Explanation:
Validate the roles within Power BI Desktop
After you've created your roles, test the results of the roles within Power BI Desktop. From the Modeling tab, select View as.
Select a role you created, and then select OK to apply that role. The report renders the data relevant for that role.
Select OK. The report renders based on what that user can see.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
NEW QUESTION # 81
You are creating a column chart visualization.
You configure groups as shown in the Groups exhibit. {Click the Groups tab.)
The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
No
Yes
No
NEW QUESTION # 82
A manager can represent only a single country.
You need to use row-level security (RLS) to meet the following requirements:
The managers must only see the data of their respective country.
The number of RLS roles must be minimized.
Which two actions should you perform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Create one role for each country.
- B. For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.
- C. Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.
- D. For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.
- E. Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.
Answer: B,E
Explanation:
In Power BI Service the username and userprincipalname both return the email address, it's only in Power BI Desktop that username is domain/username rather than the email address. So I agree that userprincipalname is better generally as you always get the same value, the answer is correct and you can use username as your RLS since the role will be applied in the Service. See https://community.powerbi.com/t5/Community-Blog/USERNAME-v-s-USERPRINCIPALNAME-in-RLS-for-Power-BI-Embedded/ba-p/1867670 for more information.
NEW QUESTION # 83
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 # 84
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 # 85
......
The PL-300 certification exam is intended for data analysts, business analysts, and other professionals who use Power BI to analyze and visualize data. It is also suitable for individuals who are responsible for creating reports and dashboards for business users or stakeholders. Microsoft Power BI Data Analyst certification can help these professionals demonstrate their expertise in using Power BI to deliver meaningful insights and analysis to their organizations.
Prepare for the Actual Microsoft Certified: Power BI Data Analyst Associate PL-300 Exam Practice Materials Collection: https://www.suretorrent.com/PL-300-exam-guide-torrent.html
Microsoft Certified: Power BI Data Analyst Associate Certified Official Practice Test PL-300: https://drive.google.com/open?id=1UEfWOBd1IraUH5u-V4ARufjV8FQ-tgmU