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

List of questions
Question 371

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

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?
Question 373

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?
Question 374

You have a Power Bl report that contains the visual shown in the following exhibit.
You need to make the visual more accessible to users who have color vision deficiency.
What should you do?
Question 375

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?
Question 376

HOTSPOT
You are designing the data model for a Power Bl semantic model. You have the following tables in the star schema.
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.
Answer:
Question 377

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.
Question 378

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?
Question 379

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?
Question 380

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?
Question