PL-100 Online Practice Questions and Answers

Correct Answer:

Step 1: Upload the worksheets to OneDrive

A data source needs to be specified. The data needs to be available.

Step 2: Create a dataflow Step 3: Create queries for the worksheets You can shape your data selection into a form that works best for your table using a Power Query editing experience, similar to the Power Query Editor in Power BI Desktop.

Step 4: Add conditional columns to perform checks on the data Step 5: Append the output of the queries Reference:

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-and-use-dataflows https://docs.microsoft.com/en-us/power-query/dataflows/add-data-power-query

Correct Answer:

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.

Incorrect Answers:

1.

Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Power BI, Analysis Services, and Power Pivot in Excel data models.

2.

With Modeling view in Power BI Desktop, you can view and work with complex datasets that contain many tables.

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

Correct Answer:

Box 1: AI Builder

The object detection component of AI Builder for PowerApps takes a photo or loads an image file to do an object detection scan. On a mobile device, the user chooses between taking a photo or selecting one already available in the device

user interface. When an image is selected, the component automatically scans it to identify objects.

Box 2: Extract entities and their types from text

The Entity extraction prebuilt model identifies and classifies key elements from text into pre-defined entities. You can use the prebuilt model out of the box in power apps and power automate.

Box 3: Scope

Scope is a simple way to put similar actions and conditions together like a Stage.

Reference:

https://docs.microsoft.com/en-us/ai-builder/object-detector-component-in-powerapps

https://powerapps.microsoft.com/en-us/blog/new-ai-builder-models-are-now-generally-available/

Correct Answer:

App Type: Screens

To insert the Camera control in your PowerApps program you can use the blank screen, and select Insert->Media->Camera.

Media Type: Camera

Use the Camera control to capture pictures with a device's camera. The device must have a camera and the user must authorize the app to use the camera.

Tap or select the camera control to capture a picture from the camera.

The most recently captured picture is available through the Photo property. With this property, the images can be:

Viewed with the Image control. Use the Image control to view the captured image.

Temporarily put in a variable or a collection.

Stored in a database.

Transmitted as a base64 encoded text string.

Reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-camera

Correct Answer:

Box 1: Model-driven app The Sales app must meet the following requirements: Provide a central location for all sales pipeline and quote information that is easily accessible and maintains all of the versions of the estimate, quote, and engineering documents.

Compared to canvas apps, model-driven apps in PowerApps are based on underlying data — specifically, the data stored in Common Data Service (CDS).

Box 2: Power BI Desktop

You can create a KPI in Power BI Desktop.

1.

Open your report editor in Power BI Desktop then select a report on which you are working.

2.

On your right, you will see a Visualizations pane and a Fields pane.

3.

From the Visualizations pane, select the KPI visual.

4.

Etc.

Box 3: Power Automate

Correct Answer: C

Can use a global option set, no need to use localized option sets.

Note: In PowerApps Option set is one of the field types you can use in your Entity. The information type that Option Set stores is a list of text values. And here comes the Option Set advantage ?once you define its text values you can centrally managed it.

Reference: https://powerapps.microsoft.com/en-us/blog/option-sets-and-many-to-many-relationships-for-canvas-apps/

Correct Answer: B

Common Data Model is built upon a rich and extensible metadata definition system that enables you to describe and share your own semantically enhanced data types and structured tags, capturing valuable business insight which can be integrated and enriched with heterogeneous data to deliver actionable intelligence.

Common Data Model can be used by various applications and services including Microsoft Dataverse, Dynamics 365, Microsoft Power Platform, and Azure ensuring that all of your services can access the same data.

Note: A wide variety of applications and services can easily access data in a data lake, however, each consumer must understand the format and meaning of the data before it can provide value. The Common Data Model simplifies this process by providing a metadata system that describes the data and standard entities to which producers can map.

Reference: https://docs.microsoft.com/en-us/common-data-model/use

Correct Answer: A

Reference: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-create-business-rule

Correct Answer: AD

Reference: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/create-edit-nn-relationships-portal

Correct Answer: C

Standard and custom connectors Power Apps provides standard connectors for many commonly used data sources. If Power Apps has a standard connector for the type of data source that you want to use, you should use that connector. If you want to connect to other types of data sources, such as a service that you've built, use custom connectors.

Reference: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections-list