[2024] Use Real Microsoft Dumps - 100% Free PL-100 Exam Dumps
Realistic PL-100 Dumps Latest Microsoft Practice Tests Dumps
3. Analyzing & Visualizing Data (5-10%)
Creating Power BI reports
- Creation of Power BI report with the help of Power BI Service
- Creation of Power BI report with the help of Power BI Desktop
NEW QUESTION # 49
A company is building a Power Apps app to track key project tasks.
Users assign tasks a risk status on a scale of 0 to 100 by using a slider input control named RiskStatus on the app. The highest risks use the risk status value of 100.
For each task, the user selects a button named RiskLevel to send the name of the task and RiskStatus number to key project stakeholders. The color of the button must change to the color listed in the following table based on the value of the RiskStatus control. The default color for the button is green.
You need to configure the solution to change the color of the RiskLevel button.
How should you configure the app? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Text Description automatically generated
Box 1: On the RiskLevel button.
On the RiskLevel button fill property.
Box 2: Risklevel.Fill = RiskStatus.Value > 75 ? Red : Green;
Most every type of control in a Power App, has a Fill property, for the fill color.
Reference:
https://wonderlaura.com/2020/07/23/power-apps-gallery-conditional-formatting/
NEW QUESTION # 50
A company is creating Power Apps apps for their customer service team.
You must create a final released solution to export to their test environment that cannot be changed in the new environment.
You need to determine the types of solutions to use.
Which type of solution should you use? To answer, drag the appropriate solution types to the correct conditions. Each solution type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-platform/alm/solution-concepts-alm
NEW QUESTION # 51
You use Microsoft Power BI Desktop to create a report.
Users note that column headings are confusing.
You need to modify some columns and delete other columns.
Which tool should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
NEW QUESTION # 52
You need to select a design approach for the required features.
Which app type should you use? To answer, drag the appropriate app types to the correct requirements. Each app type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 53
HOTSPOT
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.
Hot Area:
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 Implement and manage solutions Question Set 1
NEW QUESTION # 54
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:
Explanation
Graphical user interface, text, application Description automatically generated
Box 1: Office-based and remote financial advisers
Model driven apps can use all actions available on business rules, however not all business rule actions are available for canvas apps at this time.
Box 2: Office-based financial advisers only
If you're building a Canvas app, you must use table as the scope (not All forms, not a specific form) Box 3: Office-based financial advisers only The following actions are not available on Canvas apps :
Show or hide columns
Enable or disable columns
Create business recommendations based on business intelligence.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-create-business-rule
NEW QUESTION # 55
A company is building a Power Apps app to track key project tasks.
Users assign three tasks a risk status on a scale of 0 to 100 by using slider input controls named RiskStatus on the app. The highest risks use the risk status value of 100.
If the combined value of all the tasks is 150 or above, a header bar on the screen must display the text HIGH RISK.
You need to configure a solution to change the text on the header bar.
How should you configure the app? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Graphical user interface, application Description automatically generated
Box 1: On each RiskStatus slider input
You can change the value based on input.
Box 2: Updateif(..)
Use the UpdateIf function to modify one or more values in one or more records that match one or more conditions. The condition can be any formula that results in a true or false and can reference columns of the data source by name. The function evaluates the condition for each record and modifies any record for which the result is true.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-formulas#change-a-value-based-o
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-update-updateif
NEW QUESTION # 56
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:
NEW QUESTION # 57
You need to connect to the data source for the Job Setup app.
What should you do?
- A. Create a stored procedure that retrieves time records for a specific employee
- B. Configure an on-premises data gateway
- C. Configure a scheduled synchronization with the Common Data Service database
- D. Configure SQL Server database permissions
Answer: B
Explanation:
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 onpremises 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
Topic 2, Wide World Importers
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 # 58
You need to create a flow for sending required emails to the regional manager.
How should you create the flow? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Graphical user interface, text, application, email Description automatically generated
Box 1: Business Process
Scenario: 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.
Business process flows provide a guide for people to get work done. They provide a streamlined user experience that leads people through the processes their organization has defined for interactions that need to be advanced to a conclusion of some kind. This user experience can be tailored so that people with different security roles can have an experience that best suits the work they do.
Box 2: Common Data Service when a record is created
The Microsoft Dataverse (Common Data Service) connector provides the following triggers to help you define when your flows start:
When a row is created, updated, or deleted
When an action is performed
When a flow step is run from a business process flow
Reference:
https://docs.microsoft.com/en-us/power-automate/flow-types
https://docs.microsoft.com/en-us/power-automate/dataverse/overview
NEW QUESTION # 59
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 are creating a canvas app that displays a list of accounts.
Users must be able to select an account and view details for the account. The app must include a feature that brings the user back to the list of accounts.
You add a blank screen named Screen_Accounts and add a gallery named Gallery_Accounts to the screen.
You set the data source of Gallery_Accounts to Accounts and add another blank screen named Screen_AccountDetail.
You need to complete the app.
Solution:
* Add an edit form to Screen_AccountDetail and set the Default Mode of the form to New
* Set the OnSelect property of Gallery_Accounts to Navigate(Screen_AccountDetail).
* Set the data source of the form to Accounts.
* Set the Item property of the form to Selected.
* Add a back icon on Screen_AccountDetail and set its OnSelect property to Navigate(Screen_Accounts).
Does the solution meet the goal?
- A. No
- B. Yes
Answer: A
Explanation:
FormMode.New: the form is populated with default values and the user can modify the values of the fields.
Once complete, the user can add the record to the data source.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-form Create solutions Testlet 2 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
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 # 60
You are designing edit forms to dismay individual records selected from a list m a canvas app.
The control layout must respond to a variety of screen sizes and orientations that demonstrate the following behaviors:
* Automatically resize and arrange controls from top to bottom
* Maintain the original position of the controls.
* Require no additional property changes.
You need to select the layout type.
Which layouts should you use? To answer, select the appropriate options in the answer area.
Answer:
Explanation:
Explanation
NEW QUESTION # 61
The managers in an organization use a model-driven app. The app should display only one dashboard named Corporate Data.
The managers observe that several dashboards are displayed.
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:
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/add-edit-app-components
NEW QUESTION # 62
You are creating entities in a Common Data Service database to capture sales data.
You create an entity named Sales that includes the following fields:
You create a new entity that includes a field named TotalSales. The field is used to capture the aggregated sales for each salesperson.
You need to configure the fields for the entities.
Which field types should you use? To answer, drag the appropriate field types to the correct field names. Each field 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/data-platform/calculated-rollup-attributes
NEW QUESTION # 63
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:
NEW QUESTION # 64
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 # 65
A company must use a Power Apps app custom control that is exported from a different canvas Power Apps app.
You need to insert the custom control into the Power Apps app.
Where should you complete the actions? To answer, drag the appropriate locations to the correct actions. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Graphical user interface, text, application Description automatically generated
Box 1: Components
1. To add code components to a canvas app:
2. Navigate to Power Apps Studio.
3. Create a new canvas app or edit an existing app to which you want to add the code component.
4. Go to Insert > Custom > Import component.
Graphical user interface, text, application, Word Description automatically generated
Box 2: Display
Reference:
https://docs.microsoft.com/en-us/powerapps/developer/component-framework/component-framework-for-canvas
NEW QUESTION # 66
A company uses Power Apps. The company has a model-driven app that accesses a Microsoft Dataverse table.
The app is shared with ail users who all have the Basic User security role.
You must prevent the users from running and sharing the app.
What should you do? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
NEW QUESTION # 67
You are Designing a Power Virtual Agents chatbot in Microsoft Teams. You create an outline to describe how a conversation should be structured.
You need to configure the chatbot.
Which chatbot component should you use? To answer, drag the appropriate components to the correct conversation elements. Each component may be used once, more than once, or not at all. You may need to drag the spirt bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
NEW QUESTION # 68
A company uses Power Apps and Microsoft Dataverse. The company has a managed solution in the production environment You make changes to the solution m the development environment. Some components are unused. The changes to the solution must be reflected in the production environment You need to ensure that all unused components are removed.
What should you do?
- A. Create a new solution
- B. Update the solution.
- C. Patch the solution.
- D. Upgrade the solution.
Answer: B
NEW QUESTION # 69
Rangers in national parks report wildlife they encounter during patrols. The rangers record observations in a notebook when they are on patrol. The rangers manually enter observation data when they are in the office. You are designing an app that allows rangers to record their observations while they are on patrol.
The wildlife is modeled as a custom table named Wildlife. The model has relationships to the annotation entity and to a custom entity named Wildlife Details. In the Wildlife Details entity, rangers capture more information as they observe an animal's habitat. When observing wildlife, rangers must indicate whether an animal requires medical attention. The app must synchronize and save data to Common Data Service when connectivity is available.
You need to design the app.
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://powerapps.microsoft.com/en-us/blog/mobile-offline-for-power-apps/
https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/guide-staff-through-common-tasks-processes
NEW QUESTION # 70
......
PL-100 Dumps PDF - PL-100 Real Exam Questions Answers: https://testinsides.actualpdf.com/PL-100-real-questions.html
