Microsoft PL-300 Dumps PDF Free Download - Page: 10

QUESTION: 46

You have a Microsoft Power BI Desktop report named Report1 that uses an Azure SQL database as a data source.
A user named User1 plans to create a report by using the same data source as Report1.
You need to simplify the connection to the data source for User1.
Which type of file should you create?

PBIDS
XLSX
PBIT
PBIX

Answer(s): A

Reveal Solution Next Question

QUESTION: 47

HOTSPOT (Drag and Drop is not supported)
You have a Power BI semantic model.
You discover that the semantic model contains values that display as errors.
You need to use data profiling features in Power Query to preview the data and identify the issues.
What should you select to gain insight into the number of errors in the model, and what should you select to resolve the errors? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.

See Explanation section for answer.

Answer(s): A

Explanation:

Reveal Solution Next Question

QUESTION: 48

You plan to create a Power BI semantic model named Model1 that will contain data from an Azure SQL database named DB1.
Model1 must show updated data within two minutes of the data being updated in DB1.
You need to select a connectivity mode for the connection to DB1.
What should you choose?

DirectQuery
live connection
import

Answer(s): A

Reveal Solution Next Question

QUESTION: 49

You need to create a semantic model in Power BI Desktop. The solution must meet the following requirements:
• The model must contain a table named Orders that has one row per order. Each row will contain the total amount per order.
• The orders must be filtered to the selected CustomerID value.
• Users must select the CustomerID value from a list.
• The list of customers must come from an OData source.
Which three objects should you create in Power Query Editor? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

an Orders query that has a filter on CustomerID
a Customers query that has a filter on CustomerID
an Orders query that has a single column containing a list of customers
a Customers query that has a single column containing a list of customer IDs
a parameter for CustomerID that uses a query to populate the suggested values
a parameter for CustomerID that uses manually entered values to populate the suggested values

Answer(s): A,D,E

Reveal Solution Next Question

QUESTION: 50

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?

In the report, add a DAX calculated column that calculates the length of col1
In the report, add a DAX function that calculates the average length of col1
From Power Query Editor, add a column that calculates the length of col1
From Power Query Editor, change the distribution for the Column profile to group by length for col1

Answer(s): D

Reveal Solution Next Question

Microsoft Power BI Data Analyst PL-300 Dumps in PDF

Free Microsoft PL-300 Real Questions (page: 10)

QUESTION: 46

QUESTION: 47

Explanation:

QUESTION: 48

QUESTION: 49

QUESTION: 50