June/2021 Latest Braindump2go PL-100 Exam Dumps with PDF and VCE Free Updated Today! Following are some new PL-100 Real Exam Questions!
QUESTION 52
Case Study 2 – Contoso, Ltd
Background
Overview
Contoso, Ltd. produces industrial furnaces. The company is struggling to meet increased demand in production orders.
The company has corporate offices and manufacturing plants in Germany. The company also has offices and manufacturing plants in other regions of the world.
The company purchases a plant from another company. The plant has been in operation for over 25 years.
Current environment
Accounting system and purchasing
Operations for the company are managed very informally. Only a small number of long-term employees are aware of all manufacturing processes.
Manufacturing and planning
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.
Sales
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.
Requirements
Solution
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.
General
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.
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
Users 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.
You need to modify the entity form to resolve the customer request number issue.
What should you do?
A. Use a calculated field
B. Change the data type of the customer request number field to Lookup
C. Change the data type of the customer request number field to Autonumber
Answer: C
Explanation:
Scenario: Users report that the customer request number is difficult to interpret. They request that you change the number to a system generated sequential number.
Autonumber columns are columns that automatically generate alphanumeric strings whenever they are created.
Incorrect Answers:
B: The LookUp function finds the first record in a table that satisfies a formula.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/autonumber-fields
QUESTION 53
Case Study 2 – Contoso, Ltd
Background
Overview
Contoso, Ltd. produces industrial furnaces. The company is struggling to meet increased demand in production orders.
The company has corporate offices and manufacturing plants in Germany. The company also has offices and manufacturing plants in other regions of the world.
The company purchases a plant from another company. The plant has been in operation for over 25 years.
Current environment
Accounting system and purchasing
Operations for the company are managed very informally. Only a small number of long-term employees are aware of all manufacturing processes.
Manufacturing and planning
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.
Sales
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.
Requirements
Solution
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.
General
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.
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
Users 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.
You need to connect to the data source for the Job Setup app.
What should you do?
A. Configure a scheduled synchronization with the Common Data Service database
B. Configure SQL Server database permissions
C. Create a stored procedure that retrieves time records for a specific employee
D. Configure an on-premises data gateway
Answer: D
Explanation:
Scenario: The Job Setup entity must store its data in the existing on-premises SQL Server instance.
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, Power Apps, 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.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/gateway-reference
QUESTION 54
Case Study 2 – Contoso, Ltd
Background
Overview
Contoso, Ltd. produces industrial furnaces. The company is struggling to meet increased demand in production orders.
The company has corporate offices and manufacturing plants in Germany. The company also has offices and manufacturing plants in other regions of the world.
The company purchases a plant from another company. The plant has been in operation for over 25 years.
Current environment
Accounting system and purchasing
Operations for the company are managed very informally. Only a small number of long-term employees are aware of all manufacturing processes.
Manufacturing and planning
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.
Sales
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.
Requirements
Solution
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.
General
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.
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
Users 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.
Hotspot Question
You need to implement features for the solution.
Which Power Platform component should you use for each feature? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
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
QUESTION 55
Case Study 2 – Contoso, Ltd
Background
Overview
Contoso, Ltd. produces industrial furnaces. The company is struggling to meet increased demand in production orders.
The company has corporate offices and manufacturing plants in Germany. The company also has offices and manufacturing plants in other regions of the world.
The company purchases a plant from another company. The plant has been in operation for over 25 years.
Current environment
Accounting system and purchasing
Operations for the company are managed very informally. Only a small number of long-term employees are aware of all manufacturing processes.
Manufacturing and planning
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.
Sales
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.
Requirements
Solution
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.
General
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.
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
Users 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.
Hotspot Question
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:
Box 1: Use a Business Process flow
Scenario: The Sales Log app must enforce process standards related to the completion of estimates and supporting materials needed during the sales lifecycle.
Box 2: Use a formula to set the DisplayMode property
DisplayMode – The mode to use for data cards and controls within the form control.
Derived from the Mode property based and cannot be set independently:
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-form-detail
QUESTION 56
You are an app designer for a hotel.
The hotel wants to create an app to help the housekeeping staff schedule work.
You need to create a new environment for the app.
Where should you create the environment?
A. Power Platform Admin center
B. Power Apps Maker portal
C. Dynamics 365 Admin center
Answer: A
Explanation:
Manage environment in the Power Platform admin center.
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/create-environment
QUESTION 57
A company delivers products to multiple communities. The company creates a canvas app connected to a Common Data Service database. The app tracks communities to see where the delivery volume is the highest.
Drivers must enter delivery information on a form that uses an entity named Delivery. Depot staff must enter information on a pick-up form that uses an entity named Pick-up. Each form contains a community field that is based on a shared list across both forms.
You need to create the community field.
Which type of field should you create?
A. local option set
B. text
C. global option set
D. text area
Answer: C
Explanation:
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/
QUESTION 58
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. Business process flow
C. Power BI Desktop
D. Data gateway
Answer: AD
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/
QUESTION 59
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.
A. Custom entity
B. Account entity
C. Common Data Service User security role
D. Sitemap
Answer: BC
QUESTION 60
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?
A. Yes
B. No
Answer: A
Explanation:
Create a canvas app and add the text recognizer AI Builder component to your screen. This component takes a photo or loads an image from the local device, and then processes it to detect and extract text based on the text recognition prebuilt model. If it detects text in the image, the component outputs the text and identifies the instances by showing a rectangle for each instance in the image.
Reference:
https://docs.microsoft.com/en-us/ai-builder/prebuilt-text-recognizer-component-in-powerapps
QUESTION 61
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?
A. In the OnChange property of TIC1, set the value of the Text property for TIC1 to a context variable that stores the duration value. Assign the value of the variable to the OnTimerStart property for TIM1.
B. Assign the Text property of TIC1 to the Duration property of TIM1.
C. Assign the Text property of TIC1 to the OnSelect property of a TIM1.
D. Write code in the OnChange property of TIC1 that assigns the value of the Duration property of the Timer control to Text property of the TIC1. In the OnChange property of TIC1, assign the value to the Duration property for TIM1.
Answer: D
Explanation:
The OnTimerStart, OnTimerEnd and OnSelect are the configurations where you can add your code.
Reference:
https://sharepains.com/2019/08/22/all-about-timers-in-powerapps/
QUESTION 62
You create and publish a canvas app component library to perform complex calculations.
You discover an error in one of the calculations. You correct the issue and publish the component library. A co-worker uses the original version of the component library in a canvas app.
You need to ensure that the co-worker uses the updated version of the component library.
What should you do?
A. Export the updated component library and instruct the co-worker to import the updated version into the canvas app
B. Inform the co-worker to edit the canvas app and manually add the updated version of the component library
C. Instruct the co-worker to edit the canvas app and update the component library
Answer: C
Explanation:
You can modify an existing component library and save any changes with additional version notes.
However, the updated component library version must be published for use in existing apps that use the component library.
Makers of other apps are notified of updated components being available. The notification appears when makers edit the apps in canvas app studio. They can choose to update the components:
Select Review, and you’ll see the option to update the component:
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/component-library
QUESTION 63
You are creating a canvas app. You plan to use variables that are scoped to a screen to store values.
You need to create and update the value of the variables.
Which three functions can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Collect
B. Patch
C. Navigate
D. Set
E. UpdateContext
Answer: BCE
Explanation:
B: Use the Patch function to modify records in complex situations. Such as, when you do updates that
require no user interaction or use forms that span multiple screens.
CE: Context variables are scoped for Screen. They are great for passing values to a screen, much like parameters to a procedure in other languages. Can be referenced from only one screen.
Functions available for context variables:
UpdateContext
Navigate
Note:
Use the UpdateContext function to create a context 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.
Context variables are also preserved when a user navigates between screens. You can use Navigate to set one or more context variables for the screen that the formula will display, which is the only way to set a context variable from outside the screen.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-navigate
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-updatecontext
QUESTION 64
You are creating a canvas app.
You need to store and retrieve small amounts of data on a local device when the app is offline.
Which set of functions should you use?
A. SaveData, LoadData
B. Set, Patch
C. Patch, Collect
D. Set, Collect
Answer: A
Explanation:
LoadData and SaveData combine to form a simple mechanism to store small amounts of data on a local device. By using these functions, you can add simple offline capabilities to your app.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/offline-apps
QUESTION 65
You are creating a canvas app.
You need to display a limited list of choices to the end user. You must standardize the values and appearance of the list across all forms.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Add a drop-down field in the app
B. Create a Global Option Set
C. Add a new business rule
D. Add a component to the component library
Answer: AB
Explanation:
A global Option Set can be shared across entities.
Reference:
https://powerapps.microsoft.com/en-us/blog/option-sets-and-many-to-many-relationships-for-canvas-apps/
QUESTION 66
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 column that converts the order total to USD by using the relationship between order local currency and the USD exchange rate table in Power BI Desktop and display this column in a Power BI chart by country/region.
Does the solution meet the goal?
A. Yes
B. No
Answer: B
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
QUESTION 67
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. Yes
B. No
Answer: B
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
QUESTION 68
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 calculated field of type currency on the order table that converts the order total to USD and displays the total amounts by region in a Power BI chart.
Does the solution meet the goal?
A. Yes
B. No
Answer: A
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
QUESTION 69
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. accountid
C. owninguser
D. cr7b_accountid
Answer: D
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
QUESTION 70
You create a dashboard in Power BI. You share the dashboard with the sales team.
Sales team members report that they can see information for the entire company.
You need to ensure that the team is able to see only data for their team.
Where must you configure this restriction?
A. Dashboard
B. Report
C. Dataset
D. Settings
Answer: C
Explanation:
Restrict access to the dataset.
Note: Another way of setting access is through manage permission in the dashboard, report, or dataset. If you share a dashboard, by default the report and the dataset will also be shared as read-only for users.
Reference:
https://radacad.com/dashboard-sharing-and-manage-permissions-in-power-bi-simple-but-useful
QUESTION 71
You create a canvas app that connects to a Common Data Service database.
Users report that they do not see any data in the app.
You need to ensure that users can view data in the app.
What should you do?
A. Share the app with the users
B. Add a Power Apps license to the users
C. Assign a security role to the users
D. Publish the app
Answer: C
Explanation:
Sharing access to the data in the Common Data Service. The users need permission to access the entities the app uses. To grant them access, you will need to:
1. Create a security role
2. Assign users to the security role
Note: Common Data Service for Apps has a powerful enterprise grade security model that allows you to group users in security roles and give those roles varying levels of access to entities that some of our most sophisticated business apps are built on.
Reference:
https://powerapps.microsoft.com/en-us/blog/sharing-a-canvas-app-built-on-top-of-common-data-service/
QUESTION 72
You are creating an app for a company.
You need to evaluate the default solution.
Which two behaviors should you expect from the default solution? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. You can change the prefix of the publisher of the default solution
B. If you create a Power Automate flow in a solution, the flow uses the prefix defined in the publisher
C. If you create an environment variable in a solution, the variable uses the prefix defined in the publisher
D. You can change the version number of the default solution
Answer: BD
Explanation:
The default solution in Power Apps is the Common Data Service Default Solution, which is associated with the Microsoft Dataverse Default Publisher. The default publisher prefix will be randomly assigned for this publisher, for example it might be cr8a3. This means that the name of every new item of metadata created in the default solution will have this prepended to the names used to uniquely identify the items. If you create a new entity named Animal, the unique name used by Dataverse will be cr8a3_animal. The same is true for any new fields (attributes), relationships, or option-set options. If you’ll be customizing this special solution, consider changing the publisher prefix.
Incorrect Answers:
A: You can only change the prefix of unmanaged solutions.
Reference:
https://docs.microsoft.com/en-us/power-platform/alm/use-solutions-for-your-customizations
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-solution
Resources From:
1.2021 Latest Braindump2go PL-100 Exam Dumps (PDF & VCE) Free Share:
https://www.braindump2go.com/pl-100.html
2.2021 Latest Braindump2go PL-100 PDF and PL-100 VCE Dumps Free Share:
https://drive.google.com/drive/folders/1CfAvf7OxWF4SYkHSmhCQ9pz7BFVq33_3?usp=sharing
3.2021 Free Braindump2go PL-100 Exam Questions Download:
https://www.braindump2go.com/free-online-pdf/PL-100-PDF-Dumps(50-60).pdf
https://www.braindump2go.com/free-online-pdf/PL-100-VCE-Dumps(61-81).pdf
Free Resources from Braindump2go,We Devoted to Helping You 100% Pass All Exams!