QUESTION: 13 Exam Topic: Design solutions questions

A company has an on-premises system that stores product information. The company plans to replace the information with a Power Platform solution that uses the Common Data Service.

The Power Platform solution needs to use data from the product information system. You need to transform and import the data from the product information system.
Which two tools should you use? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Dataflow
Business process flow
Power BI Desktop
Data gateway

Answer(s): A,D

Explanation:

The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on- premises data (data that isn't in the cloud) and several Microsoft cloud services. These cloud services include Power BI, PowerApps, Power Automate, Azure Analysis Services, and Azure Logic Apps. By using a gateway, organizations can keep databases and other data sources on their on-premises networks, yet securely use that on-premises data in cloud services.
Can use the Power Platform dataflows to load entity in CDS with the option to transform data.

Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
https://nishantrana.me/2020/07/07/load-data-from-sql-on-premise-to-cds-common-data-service-using-power-platform-dataflows-in-power-apps/

Reveal Solution Next Question

QUESTION: 14 DRAG DROP Exam Topic: Design solutions questions

You are creating entities in a Common Data Service database to capture sales data. You create an entity named Sales that includes the following fields:

You create a new entity that includes a field named TotalSales. The field is used to capture the aggregated sales for each salesperson.

You need to configure the fields for the entities.

Which field types should you use? To answer, drag the appropriate field types to the correct field names. Each field type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.
Select and Place:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: Calculated
Calculated columns are calculated in real-time when they are retrieved. Calculated columns can be composed using different data types. For example, an Integer calculated column may reference values from Decimal or Currency columns.

Box 2: Simple
A simple column isn’t defined as a calculated or rollup column.

Box 3: Rollup
Because rollup columns persist in the database, they can be used for filtering or sorting just like regular columns.

Reference:

https://docs.microsoft.com/en-us/powerapps/developer/data-platform/calculated-rollup-attributes

Reveal Solution Next Question

QUESTION: 15 Exam Topic: Design solutions questions

In a Common Data Service database, you create a canvas app and a custom entity. The app also reads data from the Account entity in the Common Data Service database.

Entity access permissions will be controlled by the Common Data Service User security role. You create a Common Data Service solution.

You need to replicate the changes to a new Common Data Service database.

Which two components should you include with the canvas app? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Custom entity
Account entity
Common Data Service User security role
Sitemap

Answer(s): B,C

Reveal Solution Next Question

QUESTION: 16 HOTSPOT Exam Topic: Design solutions questions

You need to create a model-driven app without using code.
Which tools should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.
Hot Area:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: App designer
As an app maker, you can create and edit public views by using Power Apps.

Box 2: Site Map designer
Site maps define the navigation for your app. Create a site map for your app with ease by using the tile-based site map designer.

Reference:

https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/create-edit-views-app-designer
https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/create-site-map-app

Reveal Solution Next Question

Free PL-100 Exam Braindumps (page: 4)

QUESTION: 13 Exam Topic: Design solutions questions

Explanation:

Reference:

QUESTION: 14 DRAG DROP Exam Topic: Design solutions questions

Explanation:

Reference:

QUESTION: 15 Exam Topic: Design solutions questions

QUESTION: 16 HOTSPOT Exam Topic: Design solutions questions

Explanation:

Reference: