ExamGecko
Home / Microsoft / PL-300 / List of questions
Ask Question

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

Add to Whishlist

List of questions

Question 371

Report Export Collapse

DRAG DROP

You use Power Query Editor to load two queries named Query 1 and Query2 Query1 results in the following error.

Microsoft PL-300 image Question 1 63881986188333139394920



Become a Premium Member for full access
  Unlock Premium Member

Question 372

Report Export Collapse

You have a Power 81 semantic model that contains a table named Table1. Table1 runs in Import storage mode. You need to update the model to change the storage mode of Table1 to DirectQuery. What should you do?

Become a Premium Member for full access
  Unlock Premium Member

Question 373

Report Export Collapse

Vou plan to create a Power B1 report that will be connected to multiple data sources. One of the data sources contains law records. You need to ensure that other queries cannot access the tax record Information. To what should you set Privacy Level for the data source?

Become a Premium Member for full access
  Unlock Premium Member

Question 374

Report Export Collapse

You have a Power Bl report that contains the visual shown in the following exhibit.

Microsoft PL-300 image Question 4 63881986188380011739522

You need to make the visual more accessible to users who have color vision deficiency.

What should you do?

Become a Premium Member for full access
  Unlock Premium Member

Question 375

Report Export Collapse

You have a Power Bl app that contains a report named Report1.

You add a new page to Report1.

You need to ensure that users can view the new page. The solution must minimize administrative effort.

What should you do?

Become a Premium Member for full access
  Unlock Premium Member

Question 376

Report Export Collapse

HOTSPOT

You are designing the data model for a Power Bl semantic model. You have the following tables in the star schema.

Microsoft PL-300 image Question 6 6388198618839563643641

Which table is the fact table of the star schema, and which column in the Patient table is the surrogate key of the star schema? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Microsoft PL-300 image Question 6 6388198618839563643641

Answer:

Microsoft PL-300 image Question 6 6388198618839563643641

Become a Premium Member for full access
  Unlock Premium Member

Question 377

Report Export Collapse

You have a Power Bl semantic model that contains two queries.

You discover that a report based on the model has performance issues.

You plan to use Power Query to reduce the data loaded to the model.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

Become a Premium Member for full access
  Unlock Premium Member

Question 378

Report Export Collapse

For the sales department at your company, you publish a Power Bl report and a semantic model that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder. The semantic model contains several measures.

You need to create a new Power Bl report from the existing data that will use many of the measures created in the initial Power Bl semantic model. The solution must minimize development effort.

Which type of data source should you use?

Become a Premium Member for full access
  Unlock Premium Member

Question 379

Report Export Collapse

You use Power BI Desktop to import two tables named Customer and Contacts. The Customer table contains the following columns:

* Customer_Name

* Customer ID

* Website

The Contacts table contains the following columns:

* Contact ID

* Contact Email

* Contact Name

* Customer Name

A web-based contact form is used to fill the Contacts table. The data is not sanitized.

You need to create a merge for the Customer and Contacts tables.

What should you do?

Become a Premium Member for full access
  Unlock Premium Member

Question 380

Report Export Collapse

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 an on-premises data gateway.

You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.

Solution: You create aggregations to summarize results.

Does this meet the goal?

Become a Premium Member for full access
  Unlock Premium Member
Total 414 questions
Go to page: of 42
Search

Related questions