Big 11.11 Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Selected PL-300 Microsoft Certified: Power BI Data Analyst Associate Questions Answers

Page: 9 / 12
Total 464 questions

Microsoft Power BI Data Analyst Questions and Answers

Question 33

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a data source that contains 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 type.

Does this meet the goal?

Options:

A.

Yes

B.

No

Question 34

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?

Options:

A.

Add a description of "subscriber count" to the Customer Count measure.

B.

Set Summarize By to None for the CustomerlD column.

C.

Add a description of "Subscriber" to the Customer table.

D.

Add a synonym of "subscriber" to the Customer table.

Question 35

You plan to use Power B1 to create sales invoices for customers. The solution must meet the following requirements:

• Sales invoices must be exported in a PDF format

• The PDF exports must show all columns and rows clearly.

What should you create?

Options:

A.

a paginated report that contains a table

B.

an interactive report that contains a matrix

C.

a dashboard that contains a table

D.

an inlet active report that contains a table

Question 36

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.

What should you recommend?

Options:

A.

Create a shared dataset for each standardized entity.

B.

Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.

C.

For every report, create and use a single shared dataset that contains the standardized data.

D.

For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.

Page: 9 / 12
Total 464 questions