Question 1

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. From Power Query Editor, you profile the data shown in the following exhibit

The IOT ID columns are unique to each row in query. You need to analyze 10T events by the hour and day of the year. The solution must improve dataset performance. Solution: You change the IOT DateTime column to the Date data type. Does this meet the goal?

Options :

A : Yes

B : No

Answer: A

Question 2

You need to design the data model to meet the report requirements. What should you do in Power BI Desktop?

Options :

A : 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.

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

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

D : 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.

Answer: B

Question 3

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power Bl. You need to recommend an application lifecycle strategy. The solution must minimize maintenance to update access and prevent end users from viewing the development assets. What should you recommend?

Options :

A : Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace.

B : In the same workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.

C : Create separate workspaces for development and production. Grant the end users access to the production workspace.

D : Create one workspace for development. From the workspace, publish an app for production.

Answer: C

Question 4

You have a Power BI data model that imports a date table and a sales table from an Azure SQL

database data source. The sales table has the following date foreign keys.

Due Date

Order Date

Delivery Date

You need to support the analysis of sales over time based on all three dates at the same time.

Solution: From the Data pane, you rename the date table as Due Date. You use a DAX expression to

create Order Date and Deliver Date as calculated tables. You create active relationships between the

sales table and each date table.

Does this meet the goal?

Options :

A : Yes

B : No

Answer: B

Question 5

The Sales table contains records of sales by day from the last five years up until today's date.

You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected.

Which DAX expression should you use?

Options :

A :

B :

C :

D :

Answer: B

Free PL-300 Mock Exam – Practice Online Confidently

Buying Options: