QUESTION: 45

HOTSPOT (Drag and Drop is not supported)
You have a Power BI semantic model named Model1 that contains a table named Sales.
Sales contains 10 million records and the following data.
The related report displays the weekly sales per region.
You need to minimize the size of Model1.
How should you modify the CustomerID column and the PurchaseDateTime column? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

See Explanation section for answer.

Answer(s): A

Explanation:

Reveal Solution Next Question

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

Free PL-300 Exam Braindumps (page: 13)

QUESTION: 45

Explanation:

QUESTION: 46

QUESTION: 47

Explanation:

QUESTION: 48

PL-300 Exam Discussions & Posts