Update PL-300 Dumps Questions TO Pass Microsoft Power BI Data Analyst Exam

PL-300 Microsoft Power BI Data Analyst is the requirement exam for the Microsoft Certified: Power BI Data Analyst Associate Certification. While preparing for Microsoft PL-300 exam, latest PL-300 dumps questions will be the good online resource. It is highly recommended to read valid online resource, like the latest PL-300 dumps to make sure you have practiced PL-300 dumps questions well. Practice the PL-300 test questions and understand the answers, then pass PL-300 Microsoft Power BI Data Analyst certification exam.

Try online free PL-300 practice exam to test your skills.

1. You need to address the data concerns before creating the data model.

What should you do in Power Query Editor?

Select Column distribution.

Select the sales_amount column and apply a number filter.

Select Column profile, and then select the sales_amount column.

Transform the sales_amount column to replace negative values with 0.

2. You need to create a calculated column to display the month based on the reporting requirements.

Which DAX expression should you use?

FORMAT(‘Date'[date], “MMM YYYY”)

FORMAT(‘Date’ [date], “M YY”)

FORMAT(‘Date'[date_id], “MMM”) “”& & FORMAT(‘Date'[year], “#”)

FORMAT(‘Date’ [date_id], “MMM YYYY”)

3. You need to create the required relationship for the executive’s visual.

What should you do before you can create the relationship?

Change the data type of Sales[region_id] to Whole Number.

In the Sales table, add a measure for sum(sales_amount).

Change the data type of sales[sales_id] to Text.

Change the data type of sales [region_id] to Decimal Number.

4. What should you create to meet the reporting requirements of the sales department?

a measure that uses a formula of SUM (Sales [sales_id])

a calculated column that use a formula of COUNTA(sales [sales_id])

a measure that uses a formula of COUNTROWS (Sales)

a calculated column that uses a formula of SUM (Sales [sales_id])

5. You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers.

What should you do?

In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.

Add the Weekly_Returns data to the Sales table by using related DAX functions.

Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.

6. You need to provide a solution to provide the sales managers with the required access.

What should you include in the solution?

Create a security role that has a table filter on the Sales_Manager table where username = UserName()

Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName().

Create a security role that has a table filter on the Sales_Manager table where name = UserName().

Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.

7. You need to create relationships to meet the reporting requirements of the customer service department.

What should you create?

an additional date table named ShipDate, a one-to-many relationship from
Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]

an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]

a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id]

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]

8. You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.

What should you recommend?

Create a shared dataset for each standardized entity.

Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.

For every report, create and use a single shared dataset that contains the standardized data.

For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.

9. What is the minimum number of datasets and storage modes required to support the reports?

two imported datasets

a single DirectQuery dataset

two DirectQuery datasets

a single imported dataset

10. 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 line chart that shows balances by quarter filtered to account categories that are long-term liabilities.

a clustered column chart that shows balances by date (x-axis) and account category (legend) without filters.

a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities.

a pie chart that shows balances by account category without filters.

a ribbon chart that shows balances by quarter and accounts in the legend.

11. You need to design the data model to meet the report requirements.

What should you do in Power BI Desktop?

From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column.

From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

From Power Bl Desktop, use the Auto date/time option when creating the reports.

From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

12. You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.

Which type of visualization should you create?

bar chart

scatterplot

pie chart

13. You need to minimize me size of the dataset. The solution must meet the report requirements.

What should you do?

Change lite OrderlD column in the Orders table to the text data type.

Filter out discontinued products while importing the Product table.

Remove the QuantityPerUnit column from the Products table

Group the Categories table by the CategorylD column.

14. You need to configure access for the sales department users. The solution must me meet the security requirements.

What should you do?

Add the sales department as a member of the reports workspace

Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.

Distribute an app to the users in the Azure Active Directory group of the sales department.

Share each report to the Azure Active Directory group of the sales department.

15. You need to create the dataset.

Which dataset mode should you use?

DirectQuery

Import

Live connection

Composite

16. 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 Bl. 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: You add a WHERE clause to the SQL statement.

Does this meet the goal?

Yes

17. You have a table that contains sales data and approximately 1,000 rows.

You need to identify outliers in the table.

Which type of visualization should you use?

area chart

donut chart

scatter plot

pie chart

18. You have a collection of reports for the HR department of your company.

You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months.

Which type of visualization should you use?

scatter chart

ribbon chart

line chart

key influences

19. You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success.

Which type of visualization should you use?

Key influences

Funnel chart

Q&A

Line and clustered column chart

20. You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.

You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.

What should you recommend?

Merge tables by using Power Query.

Hide unused columns in the model.

Split the model into multiple models.

Transpose.

Update PL-300 Dumps Questions TO Pass Microsoft Power BI Data Analyst Exam

Try online free PL-300 practice exam to test your skills.

Leave a Reply Cancel reply