Microsoft PL-300 Exam Practice Test Instant Access

Question 1

You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals.

What should you set as the relationship cardinality?

AOne to one

BMany to one

COne to many

DMany to many

Answer : C

Question 2

You need to create relationships to meet the reporting requirements of the customer service department.

What should you create?

Aan additional date table named ShipDate, a one-to-many relationship from
Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from
Sales[sales_ship_date_id] to ShipDate[date_id]

Ban additional date table named ShipDate, a many-to-many relationship from
Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from
Sales[sales_ship_date_id] to ShipDate[date_id]

Ca one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]

Da one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many
relationship from Sales[sales_ship_date_id] to Date[date_id]

Ea one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]

Answer : A

Scenario: The customer service department requires a visual that can be filtered by both sales month and ship month independently.

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

Question 3

You plan to develop a Power BI report that has a bar chart to display the number of customers by location. You have a table named Customer that has the following columns:

* Customer ID

* CustomerName

* Address

* City

* ProvState

* Country

You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City. How should you configure the drill down in the bar chart?

AIn the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.

BIn the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City.

CIn the Axis field, add Country at the top, followed by ProvState, and then City.

DIn the Value field, add Country at the top, followed by ProvState, and then City.

Answer : C

https://docs.microsoft.com/en-us/power-bi/guided-learning/visualizations#step-18

https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-drill-down

Question 4

You have a data source that contain a column. The column contains case sensitive data.

You have a Power BI semantic model in DirectQuery mode.

You connect to the model and discover that it contains undefined values and errors.

You need to resolve the issue.

Solution: You implicitly convert the values into the required types.

Does this meet the goal?

AYes

BNo

Answer : B

Question 5

You need to create the dataset. Which dataset mode should you use?

ADirectQuery

BImport

CLive connection

DComposite

Answer : D

Composite Model means now you can have a model, that very large tables of that are coming from the DirectQuery connection, without the need for importing, and small tables to be imported to be accessible quickly.

Question 6

You attempt to connect Purer 81 Desktop to a Cassandra database.

From the Get Data connector list you discover that there is no specific connector for the Cassandra database,

You need to select an alternate data connector that will connect to the database.

Which of connector should you choose?

AMicrosoft SQL Server database

BODBC

COData

DOLE DB

Answer : B

Question 7

You have a Power BI report. The report contains visualizations that have interactions. You need to identify which visualizations take the longest to complete. What should you use?

ASQL Server Profiler

BPerformance Analyzer in Power BI Desktop

CQuery Diagnostics in Power BI

DMicrosoft Edge DevTools

Answer : B

Use Power BI Desktop Performance Analyzer to optimize reports.

In Power BI Desktop you can find out how each of your report elements, such as visuals and DAX formulas, are performing. Using the Performance Analyzer, you can see and record logs that measure how each of your report elements performs when users interact with them, and which aspects of their performance are most (or least) resource intensive.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer

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