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.

Reveal Solution Hide Solution

DRAG DROP

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.

Reveal Solution Hide Solution

Correct Answer:

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

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.

Reveal Solution Hide Solution

HOTSPOT

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.

Reveal Solution Hide Solution

Correct Answer:

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

HOTSPOT

You are creating a capacity planning dashboard with Power BI desktop.

The dashboard must be able to be used within a model-driven manufacturing planning app as well as be embedded within a Microsoft Teams channel.

The data sources are as follows:

You need to determine the appropriate method for accomplishing each task.

Which methods should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Use a Date Gateway

You can install an on-premises data gateway on the same local computer as SQL Server (in production, it would typically be a different computer).

Box 2: Create an entity relationship in CDS Solution Explorer

You can create relationships with CDS Solution Explorer.

Box 3: Create an aggregate table

Rollup columns help users obtain insights into data by monitoring key business metrics. A rollup column contains an aggregate value computed over the rows related to a specified row. This includes regular tables and activity tables such as emails and appointments.

Reference:

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

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-entity-relationships

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/define-rollup-fields

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 build a canvas app for a manufacturing company. The company receives parts and materials from many vendors. You create a form to collect information from packing slips.

Receivers must be able to take a picture of packing slips to receive materials instead of manually

entering data in the app.

You need to ensure that users can scan packing slip information into the form.

Proposed solution: Use a Text Recognition model.

Does the solution meet the goal?

Reveal Solution Hide Solution

DRAG DROP

You are an app maker for a college. You create an app for student enrollment. The app captures the education level of the applicants.

The education level at the time of enrollment is an option set is in the student entity.

The entity includes three levels:

✑ High school

✑ College

✑ Bachelor

You must split the College option into two option sets:

✑ College C 1 Year

✑ College C 2 years

The split must not impact existing data.

You need to create the two option sets.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Reveal Solution Hide Solution

Correct Answer:

You are developing a canvas app to monitor time. The app includes a Text Input control named TIC1 and a Timer control named TIM1.

You need to set TIM1 to a default value.

What should you do?

Reveal Solution Hide Solution

DRAG DROP

You have an existing Power Apps environment.

You need to create a Common Data Service database for the environment.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Step 1: Select an existing environment

Add a database in the admin center:

DRAG DROP

You have an existing Power Apps environment.

You need to create a Common Data Service database for the environment.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Step 1: Select an existing environment

Add a database in the admin center: