Question 1

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?

Options :

A : Microsoft SQL Server database

B : ODBC

C : OData

D : OLE DB

Answer: B

Question 2

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?

Options :

A : SQL Server Profiler

B : Performance Analyzer in Power BI Desktop

C : Query Diagnostics in Power BI

D : Microsoft Edge DevTools

Answer: B

Question 3

You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions. You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions. What should you recommend?

Options :

A : Merge tables by using Power Query.

B : Hide unused columns in the model.

C : Split the model into multiple models.

D : Transpose.

Answer: A

Question 4

You need to design the data model to meet the report requirements. What should you do m Power Bl Desktop?

Options :

A :

From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

B : From Power Bi Desktop, use the Auto date/time option when creating the reports.

C :

From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

D :

From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column

Answer: B

Question 5

You are creating a dashboard by using the Power Bl service. You have an existing report page that contains three charts. You need to add the charts to the dashboard while maintaining the interactivity between the charts. What should you do?

Options :

A : Pin each chart as a tile.

B : Edit interactions in the report and set all interactions to Filter

C : Edit the dashboard theme and pin each chart as a file.

D : Pin the report page as a live tile.

Answer: D

Higher Test Marks with Free Online PL-300 Exam Practice

Buying Options: