Practice Free PL-300 Exam Online Questions

HOTSPOT

You are creating a Microsoft Power Bl model that has two tables named CityData and Sales.

CityData contains only the data shown in the following table.

Sales contains only the data shown in the following table.

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Yes

The Related function returns a related value from another table.

The RELATED function requires that a relationship exists between the current table and the table with related information. You specify the column that contains the data that you want, and the function follows an existing many-to-one relationship to fetch the value from the specified column in the related table. If a relationship does not exist, you must create a relationship.

Box 2: Yes

Box 3: No

TX only occurs in the Sales table, but not in the CityData table.

Reference:

https://docs.microsoft.com/en-us/dax/related-function-dax

https://docs.microsoft.com/en-us/dax/calculate-function-dax

From Power Query Editor, you attempt to execute a query and receive the following error message.

Datasource.Error: could not find file.

What are two possible causes of the error? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

HOTSPOT

You have the Azure SQL databases shown in the following table.

You plan to build a single PBIX file to meet the following requirements:

• Data must be consumed from the database that corresponds to each stage of the development lifecycle.

• Power Bl deployment pipelines must NOT be used.

• The solution must minimize administrative effort.

What should you do? To answer, select the appropriate options in the answer area.

Reveal Solution Hide Solution

Correct Answer:

You have a Power Bl report that contains the table shown in the following exhibit.

The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency.

What should you do?

Reveal Solution Hide Solution

You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend. You need to include a visual that identifies which fields have the greatest impact on Spend.

Which type of visual should you use?

Reveal Solution Hide Solution

HOTSPOT

You have a folder of monthly transaction extracts.

You plan to create a report to analyze the transaction data.

You receive the following email message: "Hi. I’ve put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions."

You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit 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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Yes

The four columns used in the 2018 transactions are already displayed.

Box 2: Yes

The columns used are based on the entire dataset. The additional columns in the 2019 files will be detected.

Box 3: Yes

Note: Under the hoods, Power BI will automatically detect which delimiter to use, and may even promote the first row as headers. You can manually change the delimiter, or define how Power BI should handle data types. You can set it to automatically detect data types based on first 200 rows, or the entire dataset or you can even opt out the detection of data types.

Adding an index key and normalizing casing in the data source would help resolve issues with undefined values and errors in a case-sensitive column. The index key can provide a unique identifier, and normalizing casing ensures consistency in the data, which would likely prevent the errors you encountered in the Power BI semantic model.

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: For each date foreign key, you add inactive relationships between the sales table and the date table.

Does this meet the goal?

Reveal Solution Hide Solution

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 have a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date.

The tables have the following relationships:

Sales[DueDate] and Date[Date]

Sales[ShipDate] and Date[Date]

Sales[OrderDate] and Date[Date]

The active relationship is on Sales[DueDate].

You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.

Solution: You create measures that use the CALCULATE, COUNT, and USERELATIONSHIP DAX functions.

Does this meet the goal?

Reveal Solution Hide Solution

Which DAX expression should you use to get the ending balances in the balance sheet reports?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution