Verified PL-100 exam dumps Q&As with Correct 128 Questions and Answers
Microsoft PL-100 Test Engine PDF - All Free Dumps from Actual4Exams
Understanding functional and technical aspects of PL-100: Microsoft Power Platform App Maker Certification Analyze and visualize data in context of an app or automated workflow
The following will be discussed in MICROSOFT PL-100 dumps:
- Describe AI Builder models
- Add existing Power BI tile or dashboard to a model-driven dashboard
- Identify model types including prebuilt and custom models
- Create Power BI report by using Power BI service
- Implement other reports
- Create model-driven dashboards
- Merge data from a data source into a Microsoft Word or Excel template
NEW QUESTION 39
You create a canvas app named Hardware Order that suggests computer hardware to customers.
A value must be entered for the EmployeeID field when creating a new order if the value in the OrderType field does not contain the prefix test.
You need to configure the business rule.
Which two actions should you perform? Each correct answer presents part of the complete solution.
NOTE: Each correct selection is worth one point.
- A. Set the scope of the business rule to Entity.
- B. Use the following condition expression:
(OrderType Does not begin with [test]) AND (Modified By Does not contain data) - C. Set the scope of the business rule to All Forms.
- D. Add a Recommendation action and configure it to enter the order type.
Answer: A,B
Explanation:
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-create-business-rule
NEW QUESTION 40
You create a canvas app for technicians at a computer store. You assign technicians cases to work on. The technicians update cases at the end of customer site visit.
The manager wants the technicians to sell warranties to the customers. If a customer agrees to purchase a warranty, technicians use the canvas app to immediately alert the sales team, and then the technician records details about the warranty into the app.
You need to create a flow to alert the sales team.
Which type of trigger should you use?
- A. Power Apps
- B. Flow button for mobile
- C. Common Data Service
- D. Office 365 Outlook
Answer: B
Explanation:
Create a button flow to run routine tasks by simply tapping a button. Customize your flow by allowing the user to provide specific details that will be used when the flow runs.
Note: There are many repetitive tasks that we all wish we could run with just a tap of a button. For example, you may need to quickly email your team to remind them to join the daily team sync, or you may want to start a new Visual Studio Codespaces build of your code base after you've been notified that there are no more checkins planned for the day. Button flows allow you to accomplish these and many other tasks simply by tapping a button on your mobile device.
Reference:
https://docs.microsoft.com/en-us/power-automate/button-flow-with-user-input-tokens
NEW QUESTION 41
You create the following apps for a company that provides financial guidance services: a model-driven app for financial advisers that work in the company's offices and a canvas app for remote financial advisers.
You need to create business rules for a custom counselling entity used by all financial advisers.
Who will be affected by the business rules?
To answer, drag the appropriate financial adviser types to the correct business rules. Each financial adviser type may be used once, more than once, or not at all. You may need to drag the split bat between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-create-business-rule
NEW QUESTION 42
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 43
You need to create the solution assets.
What should you use to create the visualizations? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation:
Box 1: PowerBI Desktop
The Sales dashboard must reside in the Sales channel and must include information about active quotes, sales pipeline, and year-to-date sales KPIs for sales quotas by region.
PowerBI Desktop to support many data source.
Box 2: PowerBI Desktop or Power BI Service on
A dashboard that shows a capacity Heat map by month as well as expected sales that are likely to close for the next month.
Both support visualizations.
NEW QUESTION 44
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.
Answer:
Explanation:
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
NEW QUESTION 45
You need to provide all app components of the application to Tailwind Traders.
What should you do?
- A. Publish the application and flow solutions at the same time before exporting each one.
- B. Run the app checker and flow checker prior to publishing each component for export.
- C. Export each component separately but use the same version number for each component.
- D. Package the application and flow components into a single solution for export.
Answer: B
Explanation:
Scenario: When identifying versions of the app solution, all dependencies, entities, and user interfaces components must be identified to avoid any unintentional issues caused by reverting individual components to a previous version.
Power Apps has added components to the rule set that encourages best practices in the Power Apps Checker.
You can check your canvas apps and flows that are included in solutions and then review all issues in a single, consolidated report.
Reference:
https://docs.microsoft.com/en-us/power-platform-release-plan/2019wave2/microsoft-powerapps/checker- includes-rules-canvas-apps-flows
NEW QUESTION 46
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 47
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.
- A. Dataflow
- B. Power BI Desktop
- C. Data gateway
- D. Business process flow
Answer: A,C
Explanation:
The on-premises data gateway acts as a bridge to provide quick and secure data transfer between onpremises 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-powerplatform-dataflows-in-power-apps/
Topic 1, Contoso, Ltd
Current environment
Overview
Operations for the company are managed very informally. Only a small number of long-term employees are aware of all manufacturing processes.
Accounting system and purchasing
The company has a cloud-based ERP/accounting system and uses the General Ledger, Accounts Receivable, and Accounts Payable modules. The current system does not have any modules that handle shop floor or manufacturing planning functionality.
Employee information is maintained only within the accounting system. Access to the information is strictly controlled due to privacy regulations and company policies.
All purchasing of raw materials is performed based on bills of material (BOMs) generated by the engineering department when engineering prints are created.
The corporate office uses Dynamics 365 Finance. The operations manager reports that Dynamics 365 Finance will not be implemented for the manufacturing plants for at least five years.
Manufacturing and planning
The plant that Contoso, Ltd. acquires uses Microsoft Excel workbooks and Microsoft Word documents to track the sales pipeline, requests for quote responses, and work estimates. The documents are stored on shared network drives.
Printed engineering drawings are sometimes accidently used across orders. This results in rework, cost over runs, and missed deliveries.
The company uses Job Traveler documents to detail the operations that need to be performed and the materials needed for a given job number.
Sales
Requests for quotes are currently stored in a Sales Log workbook. The workbook includes the following information:
Customer request number
Customer name
Description
Estimated value of the sale
Status of the Request for Quote (RFQ) with the values of Won, Lost, No Bid, and Cancelled Names of the sales manager, salesperson, and estimator Name of the product line Date the quote was sent to the customer Approximate start and finish dates of the project Date the order was received, if won Job number, which is assigned if won The company has a formal process in place for managing estimates. Some sales quotes lack required supporting documentation including estimates for labor and materials even though a formal process is in place. The company wants to incorporate the formal process as part of an app.
Salespeople often do not set status of RFQs in the Sales Log to Won when a sale is closed and the customer purchase order is received.
An accurate sales pipeline and win/loss information cannot currently be reported because the close probability field in the Sales Log is being set to 100% when a sale is closed and 0% when a sale is lost.
Setting up a folder system on the network drive by a customer had not improved the hand-off of the current version of the sales quote to manufacturing.
Requirements
Solution
You plan to create a solution that uses Microsoft Teams and Power Platform.
You must convert the Sales Log workbook to a Common Data Service database.
Each department will have a separate Teams channel. Employees must only be able to access the channel for their department. All employees and management will have read access to a general company channel. The Teams site must include the following channels:
Sales
The Sales dashboard must reside in the Sales channel and must include information about active quotes, sales pipeline, and year-to-date sales KPIs for sales quotas by region.
All Sales-related documents must be stored in folders in the files location for this channel. Document versioning will be enabled. You must store the 10 most recent versions of a document.
Manufacturing
A dashboard that shows a capacity Heat map by month as well as expected sales that are likely to close for the next month.
A sortable listing of all in-process jobs from the Job Setup table, by customer, start date, and product.
Printed paper drawings must no longer be used. The drawings must be stored in folders in the files location for the manufacturing channel.
General
You must create the following apps:
Time Tracking
You must create a canvas app to track time for each employee on mobile devices. The app must include the following:
a Sign-in screen
a screen to list the week's time entries for the employee
a screen to edit current time entries for the employee
The app must meet the following requirements:
The app must store its data in the existing on-premises Microsoft SQL Server instance.
Employees must only be able to access their own time tracking records from the app.
Employees must record all time spent in the fabrication of each customer job.
Employees must only be able to modify time records for the current and previous day.
Employees must be able to scan their badges to check in and out of work. Each badge contains the employee name and a current picture.
A QR code must be added to all employee badges. The code must include the employee's number.
Job Traveler documents must be printed as PDF documents and must include UPC E barcodes for the job number and task number. The barcodes will be used with the time tracking application.
Sales
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.
Include a dashboard that shows all currently active quotes, their status in the sales cycle, the probability of closing, and estimated manufacturing and installation dates, by customer, product division, status, and salesperson.
The Sales Log app must enforce process standards related to the completion of estimates and supporting materials needed during the sales lifecycle.
Automatically perform the following actions immediately when a sale is won:
Generate a sequential job number.
Copy key sales information to the Job Setup entity used by manufacturing.
If the sale is lost, the Status field must be set to Lost and the reason for the loss must be entered into a provided text field. The reason must be added to the end of the description field.
Ensure that employees can easily update the Sales Log even if they are at a customer site.
Manufacturing and planning
The app must meet the following requirements:
Provides features to plan and predict capacity resource requirements for current and upcoming orders in the pipeline.
Replace paper timesheets and track check-in, check-out, breaks, and the time spent on each job task.
Record time elapsed while performing work and for viewing of engineering drawings.
The Job Setup entity must store its data in the existing on-premises SQL Server instance.
Job Traveler documents must be generated as a PDF document and printed from the Job Setup entity.
Issues
Uses report that the customer request number is difficult to interpret. They request that you change the number to a system generated sequential number.
The operations manager reports that users often incorrectly sign in to the time tracking app. The operations manager asks that the time tracking app display the employee's photo once they have scanned their badge.
Users want to be able to see their weekly total time entered from all screens.
Testers report that they can see time entries in the Time Tracker app, not just their own. Additionally, they can also edit any existing time entries.
NEW QUESTION 48
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. owninguser
- B. cr7b_accountid
- C. accountid
- D. createdon
Answer: B
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 49
You need to configure the app to meet the requirements.
Which object properties should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation:
Box 1: Fill
Scenario: You must display a visual indicator in the app so that sales representatives know whether the app is offline before submitting reports.
Fill - The background color of a control.
Incorrect Answers:
DisplayMode - The mode to use for data cards and controls within the form control.
Box 2: SubmitForm
Scenario: When data is submitted offline, the data must be stored in the app until the app is back online.
Use the SubmitForm function in the OnSelect property of a Button control to save any changes in a Form control to the data source.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-screen
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-form
NEW QUESTION 50
You are creating a multi-page canvas app that loads tabular data from an external data source.
Once loaded, the data must be available to all screens within the canvas app.
You need to reduce the number of times that the app must retrieve data from the data source.
Which two data stores can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. parameter
- B. collection
- C. global variable
- D. environment variable
Answer: B,D
Explanation:
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-data-sources
NEW QUESTION 51
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 52
You need to configure the system to meet the sales requirements.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-form-detail
NEW QUESTION 53
DRAG DROP
You are configuring a new Common Data Service environment by using the Power Apps Maker portal.
You need to create an entity that uses the prefix xyz.
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.
Select and Place:
Answer:
Explanation:
Explanation/Reference:
https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-create-entity
NEW QUESTION 54
You have a model-driven app that has an entity named Marinas. You have an entity named Boats that list the boats associated with each marina.
You must add a list of boats to the Marinas form. You must also add an option for users to select different views including boat owners and marina members.
You need to embed the list of boats associated with a Marina record in the entity form.
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:
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/form-designer-add-configure-subgrid
NEW QUESTION 55
A company is implementing the Microsoft Power Platform to assist with consolidation of onsite inspections and audits of retail stores. Currently, the data used by the retail store inspections is located across multiple systems.
The canvas app must use one database to view and record all data used in the inspection process.
You need to design the solution.
Which three capabilities should you implement? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Use an embedded access management framework for user security.
- B. Use Azure Active Directory for access management.
- C. Use Azure Data Lake storage to host the transactional data.
- D. Store data used by a Power Apps app on both iOS and Android mobile platforms.
- E. Execute real-time data operations against external data sources through virtual entities.
Answer: B,C,E
Explanation:
B: Virtual tables (also known as virtual entities) enable the integration of data residing in external systems by seamlessly representing that data as tables in Microsoft Dataverse, without replication of data and often without custom coding.
CE: Authenticating to a Gen 1 DataLakeStore Account
Gen 1 uses OAuth 2.0 in Azure AD for authentication.
Reference:
https://www.cdata.com/kb/tech/azuredatalake-odata-powerapps.rst
NEW QUESTION 56
You need to configure the app to meet the requirements.
Which object properties should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-screen
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-form
NEW QUESTION 57
You have a canvas app that uses multiple inputs for calculations.
You must use Test Studio to create automated tests and confirm that the app works as expected.
You need to organize your test scenarios into a hierarchy.
In which order should you create the objects? 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 - Test suites
2 - Test cases
3 - Test steps
4 - Test assertions
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-test-studio
NEW QUESTION 58
You need to resolve the user's issue with the time tracking app.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Add the Total Time field to the screen and set the value of the field property to Rollup
- B. Create a new component inside of the component library for the time tracking app.
- C. Add a component to the time tracking screen for tracking total time.
- D. Upload the component to AppSource.
Answer: B,C
Explanation:
Scenario Issue: Users want to be able to see their weekly total time entered from all screens.
A component library provides a centralized and managed repository of components for reusability.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/component-library
NEW QUESTION 59
A company uses Power Automate and Power Apps to streamline business processes.
You need to use AI Builder to analyze customer reviews of the company's products.
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:
Reference:
https://powerapps.microsoft.com/en-us/blog/introducing-simplified-ai-builder-experience-in-power-automate/
NEW QUESTION 60
You need to resolve the issues found during testing.
Which option should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 61
A coworker creates a canvas app.
The canvas app contains the following formul
a. The formula is attached to the OnVisible property of the first screen that users see:
You are updating the canvas app.
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:
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect
NEW QUESTION 62
You create a canvas app.
You need to make the app available to other people in your company.
What are two possible ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Share the app with a Microsoft Azure Active Directory security group.
- B. Share the app with a Microsoft Exchange distribution list.
- C. Grant access to individual users in your company.
- D. Grant access to a Microsoft Teams team.
Answer: A,C
Explanation:
After you build a canvas app that addresses a business need, specify which users in your organization can run the app and which can modify and even reshare it. Specify each user by name, or specify a security group in Azure Active Directory.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/share-app
NEW QUESTION 63
......
100% Passing Guarantee - Brilliant PL-100 Exam Questions PDF: https://www.actual4exams.com/PL-100-valid-dump.html
Get New PL-100 Certification – Valid Exam Dumps Questions: https://drive.google.com/open?id=1iOeatR_Zz2wkjjUqTSIgjVNKZGvyKVhP