PASS PL-100 exam with Microsoft Real Exam Questions - 100% Valid!
Actual PL-100 Exam Recently Updated Questions with Free Demo
NEW QUESTION # 145
A company uses Microsoft Power Platform. Users create charts based on specific needs in the production environment. Users cannot create system charts in production.
You create a solution in a development environment. You rebuild personal charts of the users inside the solution. All charts must appear on one page.
You need to create a single page that includes all charts without switching to classic.
Which three steps 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.
Answer:
Explanation:
1 - Open the solution in the Maker portal.
2 - Add the charts to the dashboard.
3 - Create a new interactive experience dashboard.
NEW QUESTION # 146
You are designing an app for a bank. You plan to use the following entities in the app:
You need to configure the relationships between the entities.
Which relationship types should you use? To answer, drag the appropriate relationship types to the correct relationships. Each source 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.
Answer:
Explanation:
NEW QUESTION # 147
You store data about products in two Microsoft Excel worksheets.
The data contains duplicate rows.
You need to consolidate data from the two worksheets into a Microsoft Dataverse custom table.
In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
Explanation
Graphical user interface, text, application, email Description automatically generated
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
NEW QUESTION # 148
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 Category classification model.
Does the solution meet the goal?
- A. No
- B. Yes
Answer: A
Explanation:
A Category classification model categorizes text by its meaning.
Reference:
https://knowledgefrommanish.com/powerplatform/ai-builder-entity-extraction-ai-model/
NEW QUESTION # 149
A company uses Power Apps.
The company requites a canvas app that connects to the following sources:
* SharePoint list
* Microsoft 365 mailbox
* SOAP API
You need to select connector types.
Which connector types should you use' To answer, drag the appropriate connector types to the correct sources.
Each connector 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.
Answer:
Explanation:
Explanation
NEW QUESTION # 150
A company has the following divisions: wholesale and retail.
The manufacturer wants to create a single Power BI report to allow users to view data from a Microsoft SQL Server database.
You need to ensure that each user sees data only for the team to which the user is assigned.
How should you secure the report?
To answer, drag the appropriate options to the correct action. Each option 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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-rls
NEW QUESTION # 151
A company uses two SQL Server environments and two Common Data Service environments.
The company policy states that only specific administrators can create environments. SQL Server and Common Data Service groups must be distinct.
You need to assign security access.
What should you assign? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Graphical user interface, text, application Description automatically generated
Box 1: System Administrator and Environment Security group
Security model for the databases
When a database is created, the users who have environment roles assigned to them, will continue to maintain those privileges.
Users with Environment Admin role are now assigned to System Administrator role. Users with Environment Maker continue to possess the same role.
Box 2: Environment Admin
TheEnvironment Adminrole can perform all administrative actions on an environment, including the following:
* Add or remove a user from either the Environment Admin or Environment Maker role.
Box 3: Environment Maker
Environment Maker: Can create new resources associated with an environment, including apps, connections, custom APIs, gateways, and flows using Microsoft Power Automate. However, this role doesn't have any privileges to access data within an environment. More information:
Box 4: System Customizer
System Customizer: Has full permission to customize the environment. However, users with this role can only view records for environment entities that they create.
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/database-security
NEW QUESTION # 152
A call center manager monitors incoming phone calls. The manager analyzes the performance of phone reps by using a custom view. The view contains a custom field named Phone call Duration in Minutes.
The call center manager must present an Excel spreadsheet daily to upper management. The spreadsheet must contain the call center performance for further trending analysis and corrective actions.
You need to create the spreadsheet.
Which four 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.
Answer:
Explanation:
Explanation
Timeline Description automatically generated with low confidence
Step 1: Export the custom view to an Excel dynamic pivot table
You can export app data to an Office Excel PivotTable to see patterns and trends in data. An Excel PivotTable is a great way to summarize, analyze, explore, and present your app data.
Step 2: Create a pivot table, and then use the Phone Rep field as a category and the Phone call Duration in Minutes as field as series Step 3: Set the formula for phone call duration in minutes to Average and add a pie chart linked to the pivot table Step 4: Save the spreadsheet and upload it back to the system.
Reference:
https://docs.microsoft.com/en-us/powerapps/user/export-excel-pivottable
NEW QUESTION # 153
You are designing a canvas app that will be used by all users including users who have vision impairments.
Which outcome is achieved by each action? To answer, drag the appropriate outcomes to the correct actions.
Each outcome 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.
Answer:
Explanation:
Explanation
Reference:
https://docs.microsoft.com/sv-se/powerapps/maker/canvas-apps/accessible-apps
NEW QUESTION # 154
You have a Power Platform solution that uses Common Data Service.
You need to secure all fields that support field-level security.
Which field can you secure?
- A. createdon
- B. owninguser
- C. description
- D. accountid
Answer: C
Explanation:
Explanation
Which fields can be secured?
Although most attributes can be secured, there are system attributes, such as IDs, timestamps, and record tracking attributes, that can't. Below are a few examples of attributes that can't be enabled for field security.
ownerid, processid, stageid, accountid, contactid
createdby, modifiedby, OwningTeam, OwningUser
createdon, EntityImage_Timestamp, modifiedon, OnHoldTime, overriddencreatedon statecode, statuscode Reference:
https://docs.microsoft.com/en-us/power-platform/admin/field-level-security
NEW QUESTION # 155
You create multiple apps as part of an unmanaged solution.
You need to move the apps to another environment.
You need to pick the appropriate solution type for each requirement.
Which types of solutions should you create? To answer, drag the appropriate solution types to the correct requirements. Each solution 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.
Answer:
Explanation:
Reference:
https://powerusers.microsoft.com/t5/Power-Apps-Pro-Dev-ISV/Managed-vs-Unmanaged/td-p/495685
NEW QUESTION # 156
You use a Microsoft SharePoint list to record information about customers.
You must perform a series of actions only when a new item is added to a SharePoint list.
You need to configure a Power Automate flow.
Which trigger should you use?
- A. For a selected item
- B. When an item is created
- C. When an item is created or modified
- D. When a file is created (properties only)
Answer: B
Explanation:
Trigger - When an item is created
Triggers when an item is created.
MS Flow will trigger when an item is created in the list. It will return all list item properties which can be used in the Flow.
Reference:
https://www.c-sharpcorner.com/article/sharepoint-based-triggers-in-ms-flow-part-2/
NEW QUESTION # 157
A company uses data from a publicly available web service. You plan to create a tabular report by using Power 81 Desktop to visualize data from the web service.
The data returned in one column is numeric and must be converted to a corresponding text value. The most up-to-date version of the data must always be used.
You need to create the report and make it available only to co workers.
Which four 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.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select
Answer:
Explanation:
Explanation
NEW QUESTION # 158
You are creating a model-driven app for onboarding new employees.
You need to implement business logic for the app.
Which tool should you use? To answer, drag the appropriate tools to the correct requirements. Each tool 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.
Answer:
Explanation:
Explanation
Graphical user interface, text, application Description automatically generated
Box 1: Business process flow
A business process flow is a visual guide meant to help users complete a business process by using a set of predefined stages. Users are not limited on how long they run a business process or how long they have a stage open.
Box 2: Business rule
Box 3: Power Automate
A Power Automate flow does not have any visual components like a business process flow. Power Automate flows can be configured to work with many different data sources, and a flow can connect to many different data sources within the same flow. A flow can be configured to time out if it is not completed in a certain time and can be triggered to move between steps based on data or user interaction.
Reference:
https://docs.microsoft.com/en-us/learn/modules/intro-business-process-flows/2-differences
NEW QUESTION # 159
You need to store a list of products and their colors. You have a Power Apps app that includes the following elements:
a text box for the product name
a drop-down list for the product color
a button to add a product to the list
a status message that shows whether the addition of a product to the list was successful The button uses the following formula:
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE:Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Graphical user interface, text, application, email Description automatically generated
Box 1: No
The Collect function adds records to a data source. If the data source doesn't already exist, a collection is created.
Box 2: Yes
Box 3: No
Use the Set function to set the value of a global variable, which temporarily holds a piece of information, such as the number of times the user has selected a button or the result of a data operation.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-set
NEW QUESTION # 160
You create a model-driven app for salespeople.
Users must interact with a business process flow that invokes multiple tables. You need to instruct users where to find the business process flow, which component should you use?
- A. site map
- B. command bar
- C. form
- D. dashboard
Answer: A
NEW QUESTION # 161
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.
A company has locations in multiple countries and regions across four continents.
The company stores the total amount of each order in the local currency of the country/region where the customer is located. The company stores the applicable exchange rates in a custom US dollars (USD) exchange rate table.
You need to create a visualization that displays the total amount of orders by country/region in USD.
Proposed solution:
Create a custom rollup field of type currency on the country/region table that aggregates all the total amounts for the orders from that country/region and display this rollup field in a Power BI chart.
Does the solution meet the goal?
- A. No
- B. Yes
Answer: A
Explanation:
Explanation
Instead use a calculated field.
Need to calculate the exchange rate in USD.
Calculated columns are calculated in real-time when they are retrieved.
Reference:
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/calculated-rollup-attributes
NEW QUESTION # 162
A company is consolidating communications processes by using Microsoft Teams and Microsoft Power Platform technologies.
A Power Automate flow monitors social media channels to identify high-impact trends.
When the Power Automate flow identifies the trends, consistently formatted and standardized feedback must be collected from the channel members within Teams.
You need to streamline the Power Automate and Teams communication process.
What should you use?
- A. Al Builder
- B. Adaptive cards
- C. Common Data Service business process flows
- D. Integrated approval flows
Answer: A
Explanation:
"Microsoft Power Platform and AI Builder components allowed us to quickly deliver an innovative and well-integrated solution within our Dynamics 365 platform for our marketing and sales business partners. The platform is a game-changer in this new world of rapid app delivery." Jim Parker: Web and Collaboration Services Manager Reference:
https://customers.microsoft.com/en-au/story/810656-hexion-manufacturing-power-platform
NEW QUESTION # 163
You are an app builder for a medical office. The medical office uses activities to book appointments and business process flows to track patient status. The cleaning staff wants the app to connect directly to a Microsoft Excel workbook to track cleaning tasks. The office does not have access to reporting tools including Power BI.
You need to create apps for the following groups of users. Apps must not require customizations or the use of additional products.
Which type of app should you build for each group? To answer, drag the appropriate app types to the correct groups. Each app 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.
Answer:
Explanation:
Explanation
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/embedded-canvas-app-guidelines
https://global.hitachi-solutions.com/blog/canvas-vs-model-driven-apps
NEW QUESTION # 164
A production line app maker at a manufacturing company creates a canvas app that looks for available inventory in a SQL database. The production line workers use the inventory app across all work centers.
The production line workers report the following app issues from the shop floor:
The app reports a delegation warning.
Voice command functionality is unreliable.
You have minimal information about the issues. You are not allowed to enter the production facility.
You need to troubleshoot the issues.
How should you troubleshoot the issues? To answer, select the appropriate options in the answer area.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview
https://docs.microsoft.com/en-us/powerapps/maker/monitor-canvasapps
NEW QUESTION # 165
A company uses two SQL Server environments and two Common Data Service environments.
The company policy states that only specific administrators can create environments. SQL Server and Common Data Service groups must be distinct.
You need to assign security access.
What should you assign? To answer, select the appropriate options in the answer area.
NOTE:Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Graphical user interface, text, application Description automatically generated
Box 1: System Administrator and Environment Security group
Security model for the databases
When a database is created, the users who have environment roles assigned to them, will continue to maintain those privileges.
Users with Environment Admin role are now assigned to System Administrator role. Users with Environment Maker continue to possess the same role.
Box 2: Environment Admin
TheEnvironment Adminrole can perform all administrative actions on an environment, including the following:
Add or remove a user from either the Environment Admin or Environment Maker role.
Box 3: Environment Maker
Environment Maker: Can create new resources associated with an environment, including apps, connections, custom APIs, gateways, and flows using Microsoft Power Automate. However, this role doesn't have any privileges to access data within an environment. More information:
Box 4: System Customizer
System Customizer: Has full permission to customize the environment. However, users with this role can only view records for environment entities that they create.
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/database-security
NEW QUESTION # 166
You create a custom field on the Account entity.
Members of TeamA must have full access to the field. Members of TeamB must have no access to the field.
You need to configure security.
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.
Answer:
Explanation:
Explanation
Step 1: Enable field security for the field
Step 2: Create a field security profile and set all the permissions for the custom attribute to Yes.
Step 3: Add TeamA to the field security profile.
Note: Field-level security is available for the default fields on most out-of-box entities, custom fields, and custom fields on custom entities. Field-level security is managed by the security profiles. To implement field-level security, a system administrator performs the following tasks.
* Enable field security on one or more fields for a given entity.
* Associate one more existing security profiles, or create one or more new security profiles to grant the appropriate access to specific users or teams.
NEW QUESTION # 167
......
PL-100 Free Sample Questions to Practice One Year Update: https://www.torrentvalid.com/PL-100-valid-braindumps-torrent.html
Free Microsoft PL-100 Exam Questions: https://drive.google.com/open?id=1JSRBkAE7OrHwDh1AUpdoA9lKTHU8J4OE