Microsoft PL-300 Exam Practice Test Instant Access

Question 1

You use Power BI Desktop to open a PBIX file that contains a Microsoft Excel data source.

You attempt to refresh the data and receive the following error message.

Expression.Error: The Colum 'cost' of the table wasn't found.

What is a possible cause of the error?

AThe Cost column was renamed in the data source.

BThe data in the Cost column cannot be converted into the target data type.

CThe privacy level of the data source does not allow combining the data with other data sources.

DThe source file was moved to a new location.

Answer : A

Question 2

You have a Power BI semantic model named Model1 that contains two table named DimDate and FactSales. There is an active relationship between DimDate and FactSales. DimDate is marked as the date table. FactSales contains the following data.

Model1 contains the following measure:

You have a report that uses Model1. The report has a single report page that has a page level filter set to may 9, 2024. The result of the Previous Year measure is displayed in a card visual.

Which value appear in the card visual?

A10

B15

C35

D60

Answer : B

Question 3

You have a Power BI semantic model that contains a table named Table1. Table1 contains the following columns:

* WebsiteName

* URL

You need to create a report named Report1 that will contain a table visual. The solution must meet the following requirements.

* Display the website name

* Enable users to navigate to the website's URL by selecting the website name.

What should you use?

AInline hierarchy labels

BData categories

CURL icons

DConditional Formatting

Answer : B

Question 4

You have a Power B1 semantic model named Model 1 that runs in import storage node.

You need to reduce the size of Model.

Which two action should you perform? Each connect answer presents a complete solution.

NOTE: Each correct selection is worth one point.

ASummarize the detail data.

BChange the active relationship between table to inactive relationship.

COptimize the column data types.

DUpgrade to Power BI premium.

EImplement row-level security (RLS).

Answer : A, C

Question 5

You have a Power Bl report that contains a table visual The visual contains a column.

The column contains whole numbers ranging from o* 1 to 20.

You need to use conditional formatting to meet the following requirements:

* Visually compare the values without having to read the text containing the number.

* Show a different format for each distinct value

* Hide the numeric value of ColumnA.

* Minimize development effort.

Which formatting should you use?

Abackground color

Bfont color

Cicons

Ddata bars

Answer : D

Question 6

You have a Microsoft SharePoint Online site that contains several document libraries.

One of the document libraries contains manufactunng reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

You need to use Power Bl Desktop to load only the manufacturing reports to a table for analysis.

What should you do?

AGet data from a SharePoint folder, enter the site URL and then select Combine & Load

BGet data from a SharePoint list and enter the site URL Select Combine & Transform, then filter by the folder path to the manufacturing reports library.

CGet data from a SharePoint list enter the site URL and then select Combine & Load

DGet data from a SharePoint folder and enter the site URL. Select Transform, then filter by the folder path to the manufacturing reports library,

Answer : D

Question 7

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?

ACreate a column by example that starts with 2018-12-31.

BApply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

CApply a transformation to extract the first 11 characters of the Logged column.

Dsplit the Logged column by using at as the delimiter.

Answer : C

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 isextract 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.

Microsoft PL-300 Microsoft Power BI Data Analyst Exam Practice Test