PL-300 Demo Exam | Skill Course

Question 1

Q&A visual allows natural language queries in reports.

FALSE TRUE

Question 2

What is the best use of Dataflows?

Report formatting Centralized ETL Visualization Security

Question 3

Drill-through pages can be used to analyze detail data.

FALSE TRUE

Question 4

To calculate values using an inactive relationship, we use _______ function in DAX.

RELATED USERELATIONSHIP RELATEDTABLE LOOKUPVALUE

Question 5

DirectQuery mode imports data into the Power BI model.

FALSE TRUE

Question 6

When do calculated columns refresh?

Query time Model refresh time Visual render time User clicks

Question 7

What is Query Folding?

Backend processing Frontend visuals Manual SQL writing Skip refresh

Question 8

You have a report in Power Bl named report1 that is based on a shared dataset.
You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being affected.
What should you do?

Clear Allow recipients to share your dashboard and Allow users to build new content using the underlying datasets for the dataset. Select the Allow end users to export both summarized and underlying data from the service or Report Server Export data option for the report. Select the Don't allow end users to export any data from the service or Report Server Export data option for the report. Apply row-level security (RLS) to the shared dataset.

Question 9

You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has
the following measure.
Customer Count = DISTINCTCOUNT(Customer[CustomerID]) Users frequently refer to customers as subscribers.
You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution must minimize the size of the model.
What should you do?

Add a description of "subscriber count" to the Customer Count measure. Set Summarize By to None for the CustomerlD column. Add a description of "Subscriber" to the Customer table. Add a synonym of "subscriber" to the Customer table.

Question 10

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

DirectQuery Import Live connection Composite