CertsTopics Logo

Summer Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Microsoft PL-300 Based on Real Exam Environment

Page: 5 / 15
Total 459 questions
Get PL-300 Full Access Download PL-300 PDF

Microsoft Power BI Data Analyst Questions and Answers

Question 17

You have the data lineage shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Options:

Question 18

You have the Power BI data model shown in the following exhibit.

Select the appropriate yes or no.

Options:

Question 19

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?

Options:

A.

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

B.

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

C.

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

D.

split the Logged column by using at as the delimiter.

Question 20

You have a Power Bl visual that uses indicators to show values that are out of range as shown in the following exhibit.

Options:

Page: 5 / 15
Total 459 questions
Get PL-300 Full Access Download PL-300 PDF