Microsoft PL-300 Exam Practice Test Instant Access

Question 1

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

Question 2

Remove unused columns from tables in the data model. This will reduce the size of your PBIX file and make your data model more efficient. You can use Power Query Editor to remove any columns that are not used in your report or calculations.

* Month

* Sales

* Year

'What should you select in Power Query Editor?

APivot column

BMerge columns

CUnpivot columns.

DTranspose

Answer : C

Question 3

You are creating a query to be used as a Country dimension in a star schema.

A snapshot of the source data is shown in the following table.

You need to create the dimension. The dimension must contain a list of unique countries.

Which two actions should you perform? Each correct answer presents part of the solution.

ARemove duplicates from the Country column.

BRemove duplicates from the City column.

C|Remove duplicates from the table.

DDelete the City column.

EDelete the Country column.

Answer : A, D

Question 4

In Power BI Desktop, you are creating a report that will contain three pages.

You need to create a custom tooltip page and prepare the page for use.

Which three actions should you perform? Each correct answer presents part of the solution.

AConfigure filters on the target visual.

BFor the target page, set Allow use as tooltip to On.

CAdd and configure visuals on the tooltip page.

DFor the tooltip page, set Allow use as tooltip to On.

EFor the tooltip page, configure filters.

Answer : B, C, D

Question 5

You have a dataset that is used infrequently and refreshes every hour.

You receive a notification that the refresh was disabled due to inactivity.

Which two actions will cause the scheduled refresh schedule to resume? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

AEnable query caching for the dataset.

BImport the dataset to Microsoft Excel.

CFrom the Power BI service, open a dashboard that uses the dataset.

DFrom the Power BI service, open a report that uses the dataset.

EFrom PowerShell, run the get-powerbireport cmdlet.

Answer : C, D

Question 6

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 in 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?

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

BChange the data type of the Logged column to Date.

CSplit the Logged column by using at as the delimiter.

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

Answer : C

Question 7

You are creating a report in Power BI Desktop.

You load a data extract that includes a free text field named coll.

You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.

What should you do?

AIn the report, add a DAX calculated column that calculates the length of col1

BIn the report, add a DAX function that calculates the average length of col1

CFrom Power Query Editor, add a column that calculates the length of col1

DFrom Power Query Editor, change the distribution for the Column profile to group by length for col1

Answer : D

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

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7