ExamGecko
Home Home / Microsoft / PL-900

Microsoft PL-900 Practice Test - Questions Answers, Page 20

Question list
Search
Search

List of questions

Search

Related questions











Your company has an on premises Microsoft SQL Server database that contains legacy sales data. You must display information from the database in a new Power Apps app. You need to establish a secure connection between the database and the app.

What should you use?

A.

Data source

A.

Data source

Answers
B.

App

B.

App

Answers
C.

Data gateway

C.

Data gateway

Answers
D.

Power Automate

D.

Power Automate

Answers
Suggested answer: C

Explanation:

For an on-premises database, identify a data gateway that was shared with you (or create one).

Specify Connect using on-premises data gateway, type or paste the server name, the database name, the user name, and the password for the database that you want to use, and specify the authentication type and the gateway.

Reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-azure-sqldatabase

A recent update has been made to a canvas app.

The update causes a negative impact to users. to users.

You need to roll back the app to a previous version.

What should you do?

A.

Restore the previous version of the app.

A.

Restore the previous version of the app.

Answers
B.

Uninstall the app for all users and reinstall by using the package from a previous version..

B.

Uninstall the app for all users and reinstall by using the package from a previous version..

Answers
C.

Deactivate the live app, import the previous version of the app, and then activate the app.

C.

Deactivate the live app, import the previous version of the app, and then activate the app.

Answers
D.

Delete the app and create a new app based on the previous version.

D.

Delete the app and create a new app based on the previous version.

Answers
Suggested answer: A

Explanation:

Restore a canvas app to a previous version in PowerApps.

Restore an app from your account

1. Open powerapps.com, and then click or tap Apps in the left navigation bar.

2. Near the right edge, click or tap the info icon for the app that you want to restore.

3. Click or tap the Versions tab, and then click or tap Restore for the version that you want to restore.

4. In the confirmation dialog box, click or tap Restore.A new version is added to your list.

Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/restore-an-app

What is a benefit of deploying Microsoft 365 and Dynamics 365 apps in the same tenant?

A.

You do not need to manually back up data.

A.

You do not need to manually back up data.

Answers
B.

Both will use the same time zone.

B.

Both will use the same time zone.

Answers
C.

You can use Power BI to display data that comes from both environments.

C.

You can use Power BI to display data that comes from both environments.

Answers
D.

You can implement Single Sign-On (SSO).

D.

You can implement Single Sign-On (SSO).

Answers
Suggested answer: C

Explanation:

Reference:

https://docs.microsoft.com/en-us/power-platform/admin/use-power-bi

A company runs a call center to handle customer support inquiries.

The company tracks metrics including the number of incoming calls and call resolution rates. The company wants to display the metrics on a shared screen that is visible to all call center staff.

You need to recommend a visualization solution for the company.

Which Power Platform feature should you recommend?

A.

AI Builder

A.

AI Builder

Answers
B.

Power Automate

B.

Power Automate

Answers
C.

Power Apps

C.

Power Apps

Answers
D.

Power BI

D.

Power BI

Answers
Suggested answer: D

You are creating Power BI reports.

You need to choose which filters you can use for reports.

Which three types of filters can you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A.

drill-down

A.

drill-down

Answers
B.

automatic

B.

automatic

Answers
C.

database

C.

database

Answers
D.

manual

D.

manual

Answers
E.

external

E.

external

Answers
Suggested answer: A, B, D

Explanation:

Reference:

https://docs.microsoft.com/en-us/power-bi/power-bi-report-filter-types

A manufacturing company uses Internet of Things (IoT) devices to monitor the temperature in different parts of their warehouse. The current IoT monitoring software is extremely outdated and is not user friendly.

You need to view near-real time information from the IoT devices in Power BI Service dashboards.

Which tool should you use?

A.

Scheduled refresh dataset

A.

Scheduled refresh dataset

Answers
B.

Streaming dataset

B.

Streaming dataset

Answers
C.

Content Pack dataset

C.

Content Pack dataset

Answers
D.

Power BI dataflows

D.

Power BI dataflows

Answers
E.

Quick Insights

E.

Quick Insights

Answers
Suggested answer: B

Explanation:

Reference: https://docs.microsoft.com/en-us/power-bi/service-real-time-streaming https://powerbi.microsoft.com/en-us/blog/using-power-bi-real-time-dashboards-to-display-iot-sensor-data-a-step-by-step-tutorial/

This question-requires that you evaluate the underlined text to determine if it is correct.

You have a Power BI report with a page named RevReceived. The page shows gross revenue received by your company. You want to create an almost identical page that shows net revenue instead of gross revenue. To accomplish this task, you modify the RevReceived page.

Review the underlined text. If it makes the statement correct, "No change is needed". If the statement is incorrect, select the answer choice that makes the statement correct.

A.

No change is needed.

A.

No change is needed.

Answers
B.

duplicate the RevReceived page and update the duplicate copy.

B.

duplicate the RevReceived page and update the duplicate copy.

Answers
C.

import the RevReceived page.

C.

import the RevReceived page.

Answers
D.

copy the visuals from RevReceived to a new page.

D.

copy the visuals from RevReceived to a new page.

Answers
Suggested answer: B

Explanation:

Reference: https://www.tutorialspoint.com/power_bi/power_bi_quick_guide.htm

You create a set of dashboards and reports for a project team that combines data from different sources in Power BI. Some of the data is considered sensitive. You need to distribute the dashboards and reports securely to the team.

What should you create?

A.

a custom data connector

A.

a custom data connector

Answers
B.

a published app

B.

a published app

Answers
C.

a Microsoft flow

C.

a Microsoft flow

Answers
D.

a Power BI workspace

D.

a Power BI workspace

Answers
Suggested answer: B

Explanation:

Reference:

https://docs.microsoft.com/en-us/power-bi/service-how-to-collaborate-distribute-dashboards-reports

You are using Dynamics 365 Sales.

You need to pull data into a Power BI report for your team. The City and State columns must be combined to form one column on the report. Which function would you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A.

Use Power Query to merge columns.

A.

Use Power Query to merge columns.

Answers
B.

Import the data.

B.

Import the data.

Answers
C.

Export data to Microsoft Excel.

C.

Export data to Microsoft Excel.

Answers
D.

Create a view.

D.

Create a view.

Answers
Suggested answer: A

Explanation:

Reference: https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

A carpet cleaning company uses Dynamics 365 Sales.

The process for entering customer information during onsite sales calls is very complicated. The company wants a simplified screen that allows salespeople to capture the customer name, phone number, and other information while speaking to the customer.

You need to recommend a solution that works on various types of mobile devices.

What should you recommend?

A.

Common Data Service

A.

Common Data Service

Answers
B.

Power Automate

B.

Power Automate

Answers
C.

AI Builder

C.

AI Builder

Answers
D.

Canvas app

D.

Canvas app

Answers
E.

Power BI

E.

Power BI

Answers
Suggested answer: D

Explanation:

Reference: https://powerapps.microsoft.com/en-us/build-powerapps/

Total 313 questions
Go to page: of 32