Get PL-100 Braindumps & PL-100 Real Exam Questions
Microsoft PL-100 Actual Questions and Braindumps
Exam Content
The content of the Microsoft PL-100 certification test encompasses a wide range of topics, including designing solutions, creating solutions, analyzing & visualizing data, and implementing & managing solutions. Each of the above-mentioned domains comes with the specific knowledge and skills that the candidates must possess. The outline of the knowledge areas as well as their percentage share in the exam syllabus is provided below:
1. Designing Solutions (10-15%)
Creating a high-level design
- Real-world objects to be described as entities
- Creation of a high-level data model
- Business requirements should be collected
- Data sources should be looked in
NEW QUESTION 84
A company is building a canvas app.
A user needs to understand which data they can make available for the 500 contacts that are present in the Contact table. All relevant data must be shown in the app. Single fields must show one record and grids must show multiple records. Only the primary fields for each related table should be shown for a contact.
Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 85
You need to implement logic in the app for lost sales.
What should you do?
- A. Create a formula for the Description field that uses the Update function.
- B. Define a business rule for the Sales Log edit form.
- C. Create a business process flow.
- D. Set the required field property of the Won/Lost field to Required.
Answer: B
Explanation:
Scenario: Requests for quotes are currently stored in a Sales Log workbook. The workbook includes the following information:
* Status of the Request for Quote (RFQ) with the values of Won, Lost, No Bid, and Cancelled 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.
You can create business rules and recommendations to apply logic and validations without writing code or creating plug-ins. Business rules provide a simple interface to implement and maintain fast-changing and commonly used rules.
Business rules defined for an entity apply to both canvas apps and model-driven apps if the entity is used in the app.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-create-business-rule Create solutions Testlet 3 This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. When you are ready to answer a question, click the Question button to return to the question.
Background
Current environment
Sales representatives submit weekly status reports to regional managers. There is no standardized format for these status reports. The process for managing status reports is challenging.
Wide World Importers has decided to use Microsoft 365, Microsoft Azure, and Power Platform for future app development. Both Wide World Importers and Tailwind Traders have identical Microsoft SharePoint and Azure configurations. Both companies use separate tenants.
Requirements
Application
You must create a mobile app to streamline the creation of status reports by sales representatives. You must make the same app available to Tailwind Traders. The mobile app must meet the following requirements:
* Minimize the use of code.
* Use formulas and expressions when necessary.
* Support a variety of visual layouts.
* Use a SharePoint list to store information about regional managers and sales representatives.
* Use Azure SQL Database to store other data.
Status reports
* Sales representatives must provide a weekly status report for all work processes each Monday.
* Representatives must enter the following information for each process:
* If a sales representative submits a status report and assigns the At Risk status to a process, the app must prompt the sales representative to enter a detailed description for the risk. This information must be emailed to the regional manager. If the category is Work/life balance, the information must be carbon copied to the human resources department.
* If a sales representative does not submit a weekly status report by an agreed upon deadline, the system must send an email to remind the sales representative.
* The app must be able to run both online and offline. If the mobile device on which the app runs is connected to the internet, the app must immediately submit the status report.
* You must display a visual indicator in the app so that sales representatives know whether the app is offline before submitting reports.
* When data is submitted offline, the data must be stored in the app until the app is back online.
Technical
Regardless of the UI layouts, the data recorded must be standardized in the Azure DB tables. You must use global variables in the app.
Deployment
* Before deploying the app to production, you must ensure that the app conforms to Microsoft accessibility and performance guidelines.
* The completed app and all supporting components must be provided to Tailwind Traders.
* Tailwind Traders must not be able to make changes to any of the components.
* You must use the following version control numbering scheme:
* Major: The last two digits of the year the app is packaged
* Minor: Two digits that represent the month when the app is packaged
* Build: A number that is incremented to represent significant changes to the app
* Revision: The incremented revision for a package
* New versions of the application must completely replace previous versions of the app.
* 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.
* Previous versions of the mobile app must be available for roll back purposes.
* All versions of software that have been used in production must be retained for five years.
Issues
The mobile app has been live for several months. Eight versions of the app have been released since the initial version of the app was deployed to sales representatives. You must revert the app to an earlier version and redesign some features.
User1 often works in a warehouse that does not have internet connectivity. User1 needs to edit an existing status report and submit a new status report.
Several sales representatives have accessibility restrictions. User2 is visually impaired and cannot see images.
User3 is unable to use a mouse.
NEW QUESTION 86
A user named Bill Jones creates a canvas app and shares it with other users in his company as shown in SharePowerUsers and ShareJimSmith exhibits. (Click the SharePowerUsers tab and the ShareJimSmith tab.)

There are multiple versions of the app. Users must only be able to run the most recently published version of the app as shown in the table below:
You need to ensure that sharing is configured correctly.
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/share-app
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/restore-an-app
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/save-publish-app
NEW QUESTION 87
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:
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/database-security
NEW QUESTION 88
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:
1 - Export the custom view to an Excel dynamic pivot table
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
3 - Set the formula for phone call duration in minutes to Average and add a pie chart linked to the pivot table
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 89
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 90
You need to configure the system to meet the requirements.
What 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/powerapps/maker/common-data-service/types-of-entities
NEW QUESTION 91
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 92
You need to ensure that the app can support the needs of User2 and User3, and meets the production deployment requirements.
Which tools should you use? To answer, select the appropriate tool 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/accessibility-checker
https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/use-powerapps-checker
NEW QUESTION 93
You need to configure the system to meet the requirements.
What 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/powerapps/maker/common-data-service/types-of-entities
NEW QUESTION 94
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:
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/database-security
NEW QUESTION 95
HOTSPOT
You need to configure the system to meet the requirements.
What should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Answer:
Explanation:
Explanation:
Box 1: 1:N
Scenario: A sortable listing of all in-process jobs from the Job Setup table, by customer, start date, and product.
Box 2: User or Team owned
Scenario: Employees must only be able to access their own time tracking records from the app.
User or team: Data belongs to a user or a team. Actions that can be performed on these records can be controlled on a user level.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/types-of-entities
NEW QUESTION 96
Each maker at a company has a separate Common Data Service environment. You are customizing a canvas app. You create two new entities in your environment.
You are leaving for a vacation. Another maker will continue customizing the app in your absence.
You need to transfer the work to the other maker and ensure that you can work on the updated app when you return from your vacation.
What should you export?
- A. ununmanaged solution that includes all customizations
- B. the app
- C. the default solution
- D. a managed solution that includes all customizations
Answer: A
Explanation:
Unmanaged Solution: The beginning state of solution is the unmanaged solution state. During this phase, you can add, edit, update, remove, delete, and test any of the components of the solution.
Reference:
https://powerusers.microsoft.com/t5/Power-Apps-Pro-Dev-ISV/Managed-vs-Unmanaged/td-p/495685
NEW QUESTION 97
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 98
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:
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 99
You are creating a Power Automate flow.
You have an array that contains items with different color attributes. You plan to filter the array by using the following filter expression within the flow:
@or(equals(item()?['color'], 'red'),contains(item()?['color'],'blue'))
The filter returns results only when the expression resolves to true.
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:
NEW QUESTION 100
You create an app with multiple screens.
Test users report that the size and type of gallery displayed on each screen are different. You must improve the consistency for the app screens.
You need to create a reusable gallery that displays information based on the current record.
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.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/add-gallery
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/create-component
NEW QUESTION 101
You need to implement logic in the app for lost sales.
What should you do?
- A. Create a formula for the Description field that uses the Update function.
- B. Define a business rule for the Sales Log edit form.
- C. Create a business process flow.
- D. Set the required field property of the Won/Lost field to Required.
Answer: B
Explanation:
Scenario: Requests for quotes are currently stored in a Sales Log workbook. The workbook includes the following information:
* Status of the Request for Quote (RFQ) with the values of Won, Lost, No Bid, and Cancelled 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.
You can create business rules and recommendations to apply logic and validations without writing code or creating plug-ins. Business rules provide a simple interface to implement and maintain fast-changing and commonly used rules.
Business rules defined for an entity apply to both canvas apps and model-driven apps if the entity is used in the app.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-create-business- rule Create solutions Testlet 3 This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. When you are ready to answer a question, click the Question button to return to the question.
Background
Current environment
Sales representatives submit weekly status reports to regional managers. There is no standardized format for these status reports. The process for managing status reports is challenging.
Wide World Importers has decided to use Microsoft 365, Microsoft Azure, and Power Platform for future app development. Both Wide World Importers and Tailwind Traders have identical Microsoft SharePoint and Azure configurations. Both companies use separate tenants.
Requirements
Application
You must create a mobile app to streamline the creation of status reports by sales representatives. You must make the same app available to Tailwind Traders. The mobile app must meet the following requirements:
* Minimize the use of code.
* Use formulas and expressions when necessary.
* Support a variety of visual layouts.
* Use a SharePoint list to store information about regional managers and sales representatives.
* Use Azure SQL Database to store other data.
Status reports
* Sales representatives must provide a weekly status report for all work processes each Monday.
* Representatives must enter the following information for each process:
* If a sales representative submits a status report and assigns the At Risk status to a process, the app must prompt the sales representative to enter a detailed description for the risk. This information must be emailed to the regional manager. If the category is Work/life balance, the information must be carbon copied to the human resources department.
* If a sales representative does not submit a weekly status report by an agreed upon deadline, the system must send an email to remind the sales representative.
* The app must be able to run both online and offline. If the mobile device on which the app runs is connected to the internet, the app must immediately submit the status report.
* You must display a visual indicator in the app so that sales representatives know whether the app is offline before submitting reports.
* When data is submitted offline, the data must be stored in the app until the app is back online.
Technical
Regardless of the UI layouts, the data recorded must be standardized in the Azure DB tables. You must use global variables in the app.
Deployment
* Before deploying the app to production, you must ensure that the app conforms to Microsoft accessibility and performance guidelines.
* The completed app and all supporting components must be provided to Tailwind Traders.
* Tailwind Traders must not be able to make changes to any of the components.
* You must use the following version control numbering scheme:
* Major: The last two digits of the year the app is packaged
* Minor: Two digits that represent the month when the app is packaged
* Build: A number that is incremented to represent significant changes to the app
* Revision: The incremented revision for a package
* New versions of the application must completely replace previous versions of the app.
* 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.
* Previous versions of the mobile app must be available for roll back purposes.
* All versions of software that have been used in production must be retained for five years.
Issues
The mobile app has been live for several months. Eight versions of the app have been released since the initial version of the app was deployed to sales representatives. You must revert the app to an earlier version and redesign some features.
User1 often works in a warehouse that does not have internet connectivity. User1 needs to edit an existing status report and submit a new status report.
Several sales representatives have accessibility restrictions. User2 is visually impaired and cannot see images. User3 is unable to use a mouse.
NEW QUESTION 102
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:
Reference:
https://docs.microsoft.com/en-us/power-bi/fundamentals/service-service-vs-desktop
NEW QUESTION 103
An administrator plans to create and deploy dashboards for use only by sales associates. The dashboards will display the current sales pipeline, open cases, recent major wins, and key opportunities by postal code.
Sales associates must be able to act on the specific data displayed in dashboards.
You need to create the dashboards.
Which type of dashboards should you create? 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/developer/model-driven-apps/create-dashboard
https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/configure-interactive-experience-dashboards
NEW QUESTION 104
You are an app and report maker. You provide visualizations for two departments in an organization.
Each department requires department-specific visualizations:
You need to create the visualizations.
Which chart type should you use? To answer, drag the appropriate chart type to the correct requirements. Each chart 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://docs.microsoft.com/en-us/powerapps/developer/model-driven-apps/understand-charts-underlying-data-chart-representation
NEW QUESTION 105
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. description
- C. accountid
- D. owninguser
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 106
......
Designing user interface
- Component reuse opportunities to be identified
- Design aimed for accessibility
- Design aimed for localization
- Application of user interface (UI) standards
PL-100 Dumps To Pass Microsoft Exam in 24 Hours - DumpsTests: https://www.dumpstests.com/PL-100-latest-test-dumps.html
Buy Latest PL-100 Exam Q&A PDF - One Year Free Update: https://drive.google.com/open?id=1vpU7pJQpkIwtFvtWTVLce6A2iY3pVgz3