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

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

List of questions

Question 91

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have several reports and dashboards in a workspace.

You need to grant all organizational users read access to a dashboard and several reports.

Solution: You create an Azure Active Directory group that contains all the users. You share each report and dashboard to the group. Does this meet the goal?

Yes

Yes

No

No

Suggested answer: A

Explanation:

Statements and questions are tricky and confusing. When the access is granted for the group (all users) for ALL (each) dashboards and ALL (each) reports in the workspace, then the will have read access to the specific (A, one) Dashboard and several reports, because they are part of all dashboards and reports. There is no statement, that for the other dashboards (except the one) and the other reports (except the several) that access must be prevented. They are also accessible (maybe it is not desired but not stated here).

asked 05/10/2024
ERIC MERRILL
41 questions

Question 92

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have several reports and dashboards in a workspace.

You need to grant all organizational users read access to a dashboard and several reports.

Solution: You assign all the users the Viewer role to the workspace.

Does this meet the goal?

Yes

Yes

No

No

Suggested answer: A

Explanation:


asked 05/10/2024
Maxime ESSIS
38 questions

Question 93

Report
Export
Collapse

You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an onpremises Oracle database and an Azure SQL database by using one query. You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured. You need to ensure that the data is updated every morning. The solution must minimize configuration effort. Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Configure the dataset to use the existing On-premises data gateway.

Configure the dataset to use the existing On-premises data gateway.

Deploy an On-premises data gateway in personal mode.

Deploy an On-premises data gateway in personal mode.

Set the refresh frequency to Daily.

Set the refresh frequency to Daily.

Configure the dataset to use the personal gateway.

Configure the dataset to use the personal gateway.

Suggested answer: A, C

Explanation:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode

asked 05/10/2024
Jari Tetteroo
38 questions

Question 94

Report
Export
Collapse

You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege. Which role should you assign to the user?

Viewer

Viewer

Contributor

Contributor

Member

Member

Admin

Admin

Suggested answer: C

Explanation:

A Member can add members or others with lower permissions.

Note:

Microsoft PL-300 image Question 61 explanation 106318 10052024010716000000

asked 05/10/2024
Darren Sloan
41 questions

Question 95

Report
Export
Collapse

You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh. From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium capacity. You discover that the dataset refresh fails after the refresh runs out of resources.

What is a possible cause of the issue?

Query folding is not occurring.

Query folding is not occurring.

You selected Only refresh complete periods.

You selected Only refresh complete periods.

The data type of the column used to partition the data changed.

The data type of the column used to partition the data changed.

A filter is missing on the report.

A filter is missing on the report.

Suggested answer: A

Explanation:

The Power BI service partitions data based on date range. This is what enables only certain partitions to be refreshed incrementally. To make this work, the partition filter conditions are pushed down to the source system by including them in the queries. Using Power Query terminology, this is called “query folding”. It is not recommended that incremental refresh is used when the required query folding cannot take place.

Reference:

https://powerbi.microsoft.com/en-us/blog/incremental-refresh-query-folding/

asked 05/10/2024
Pavel Tylich
37 questions

Question 96

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have several reports and dashboards in a workspace.

You need to grant all organizational users read access to a dashboard and several reports.

Solution: You publish an app to the entire organization.

Does this meet the goal?

Yes

Yes

No

No

Suggested answer: B

Explanation:


asked 05/10/2024
Kushantha Gunawardana
49 questions

Question 97

Report
Export
Collapse

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 AppSource visuals and 10 default visuals.

Users say that the report is slow to load the visuals when they access and interact with the report. You need to recommend a solution to improve the performance of the report.

What should you recommend?

Change any DAX measures to use iterator functions.

Change any DAX measures to use iterator functions.

Replace the default visuals with AppSource visuals.

Replace the default visuals with AppSource visuals.

Change the imported dataset to DirectQuery.

Change the imported dataset to DirectQuery.

Remove unused columns from tables in the data model.

Remove unused columns from tables in the data model.

Suggested answer: D
asked 05/10/2024
Luke Smith
30 questions

Question 98

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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table.

Solution: From Power Query Editor, you import the table and then add a filter step to the query.

Does this meet the goal?

Yes

Yes

No

No

Suggested answer: B
asked 05/10/2024
Neha Kumari
50 questions

Question 99

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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table.

Solution: You add a WHERE clause to the SQL statement.

Does this meet the goal?

Yes

Yes

No

No

Suggested answer: A

Explanation:


asked 05/10/2024
Reza Mirabrishami
39 questions

Question 100

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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source. You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition. Solution: You modify the source step of the queries to use DataSourceExcel as the file path.

Does this meet the goal?

Yes

Yes

No

No

Suggested answer: A

Explanation:

Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.

Reference:

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

asked 05/10/2024
alejandro capel
49 questions
Total 370 questions
Go to page: of 37
Search

Related questions