Microsoft PL-300 Practice Test - Questions Answers, Page 12

You need to create the Top Customers report.

Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area. NOTE; Each correct selection is worth one point.

You need to create a relationship in the dataset for RLS.

What should you do? To answer select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to create a measure that will return the percentage of late orders.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

ion have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table.

The table has 12 million rows. All the columns are needed for analysis.

You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data. What should you do?

In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset You need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data What should you do?

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?

You are building a Power BI report to analyze customer segments.

You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort. Which type of visualization should you use?

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates. Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together. You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source. Which data modeling design should you use?

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have rowQuestions & Answers PDF P-145 level security (RLS) configured. You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings. What should you do?