PL-100 : Microsoft Power Platform App Maker : Part 07
-
HOTSPOT
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.
Explanation:Box 1: No
They can only use the app.Box 2: Yes
Box 3: No
You would need to publish Version 2 to make it live.Note: If you want to publish the restored version, select Publish this version, and then select Publish this version when prompted to confirm.
Notice the published restore version that shows up as Live.
Box 4: Yes
The most recent version of any app is available only to those who have edit permissions for it. -
You create an automated flow by using Power Automate. The flow appears under My Flows and is connected to the development environment. The development environment has a solution to move components into a production environment.
You need to ensure that you can transfer the flow to another environment.
What should you do?
- Add the flow to the default solution of the development environment and export as a managed solution.
- Change the environment for the flow.
- Add the flow to the existing solution.
- Add the flow to the default solution of the production environment.
Explanation:It is very normal for a developer to build the power automate in one environment and then export that automate & import it to another destination environment.
Exporting our Solution
After validating our flows work in our test environment, we now want to promote it to our production environment. We can export our solution by finding it in our Solutions experience, clicking on the …, selecting Export. -
DRAG DROP
You have a canvas app that uses multiple inputs for calculations.
You must use Test Studio to create automated tests and confirm that the app works as expected.
You need to organize your test scenarios into a hierarchy.
In which order should you create the objects? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Explanation:Step 1: Test suites
By default, a test suite and test case are created for you in Test Studio. Test suites are used to organize your test cases. An app can contain one or more test suites.Step 2: Test cases
Depending on how you want to organize or group your tests, you can create multiple test cases in a test suite. Each case can test a specific feature or a subset of functionalities in your app.Step 3: Test steps
Step 4: Test assertions
A test case consists of test steps that contain actions. Test actions are written using Power Apps expressions that perform a task. You can use the recorder to automatically generate the test steps as you interact with your app. After you record, you can update the test case, add new steps, delete steps, and write test assertions to validate the result of your test. -
A company is implementing the Microsoft Power Platform to assist with consolidation of onsite inspections and audits of retail stores. Currently, the data used by the retail store inspections is located across multiple systems.
The canvas app must use one database to view and record all data used in the inspection process.
You need to design the solution.
Which three capabilities should you implement? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- Use an embedded access management framework for user security.
- Execute real-time data operations against external data sources through virtual entities.
- Use Azure Active Directory for access management.
- Store data used by a Power Apps app on both iOS and Android mobile platforms.
- Use Azure Data Lake storage to host the transactional data.
Explanation:B: Virtual tables (also known as virtual entities) enable the integration of data residing in external systems by seamlessly representing that data as tables in Microsoft Dataverse, without replication of data and often without custom coding.
CE: Authenticating to a Gen 1 Data Lake Store Account
Gen 1 uses OAuth 2.0 in Azure AD for authentication. -
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
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
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 employeeThe 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 implement the change requested by the operations manager.
Which control should you use?
- Camera
- Shape
- Add picture
- Image
Explanation:Scenario: The operations manager asks that the time tracking app display the employee’s photo once they have scanned their badge.
Image control in Power Apps is a control that shows an image from, for example, a local file or a data source.
Incorrect Answers:
C: Add Picture: With this control users can take photos or upload image files from their device and update the data source with this content. On a mobile device the user is presented with the device’s choice dialog to choose between taking a photo or selecting one already available.This control is a grouped control containing two controls: an Image and an Add picture button. The Image control shows the uploaded image or a placeholder if no image has been uploaded. The Add picture button prompts for an image to be uploaded.
Note: If you add one or more Image controls to your app, you can show individual images that aren’t part of a data set, or you can incorporate images from records in data sources.
-
HOTSPOT
You need to meet the requirement for the time tracking app.
Which controls should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation:Box 1: Timer
A Timer control in Power Apps is a control that can determine how your app responds after a certain amount of time passes.Box 2: Barcode scanner
The Barcode scanner control for canvas apps scans barcodes, QR codes, and data-matrix codes on an Android or iOS device.Box 3: Image
Image control in Power Apps is a control that shows an image from, for example, a local file or a data source.
If you add one or more Image controls to your app, you can show individual images that aren’t part of a data set, or you can incorporate images from records in data sources. -
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.
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.
-
You need to implement logic in the app for lost sales.
What should you do?
- Set the probabilities field to zero percent.
- Define a business rule for the Sales Log edit form.
- Enable field security on the Won/Lost field.
- Create a formula for the Description field that uses the Update function.
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 CancelledSalespeople 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. -
HOTSPOT
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.
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:
-
-
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
Overview
Wide World Importers is an importer and supplier of fair trade, handmade home goods to independent retailers in North America. The company has a partner company named Tailwind Traders.
One of the products that the company manufactures was recently featured on several major television talk shows and has become very popular.
Wide World Importers is expanding their prospective sales operations to new markets and plans to engage current customers in a more direct manner.
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.
-
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.
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:
Display Mode – The mode to use for data cards and controls within the form control.Box 2: Submit Form
Scenario: When data is submitted offline, the data must be stored in the app until the app is back online.Use the Submit Form function in the On Select property of a Button control to save any changes in a Form control to the data source.
-
You need to meet the requirements for sales representative that submit status reports.
How should you configure the flow?
- Add a parallel branch that uses the value of a dynamic content variable
- Add a number functions action that evaluates the risk value by using a static variable to determine if an email is required
- Add a condition that evaluates the risk value by using a dynamic content variable
- Add a data operation action that evaluates a dynamic content variable
Explanation:
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.
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. -
HOTSPOT
You need to roll back the mobile app to an earlier version.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation:Box 1: View details for the app in the Power Apps Maker portal.
Scenario: Previous versions of the mobile app must be available for roll back purposes.1. Sign in to Power Apps.
2. Select Apps from the left-pane.
3. Select Apps.
4. Select your app.
5. Select Details.6. Select Versions.
Box 2: Select Restore on the previous version of the app.
Scenario: All versions of software that have been used in production must be retained for five years.Restore an app from your account
1. Sign in to Power Apps.
2. Select Apps from the left-pane.
3. Select Apps.
4. Select your app.
5. Select Details.
6. Select Details option.
7. Select Versions.
8. Select Versions.
9. Select the app version that you want to restore.
10. Select Restore.
11. Select Restore.
12. Confirm by selecting Restore again.
-
-
HOTSPOT
You are configuring security to enable users to analyze data by using Microsoft Excel templates.
You create a security role named Template Administrator and configure the role as shown below and assign the role to a user named User1.
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.
-
HOTSPOT
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.m
Explanation:Box 1: User
Type of dashboard: If you want your dashboards to be available across the organization and do not want to manage the access levels at a more detailed level, you might want to create an organization-owned dashboard. However, if you are concerned about the access privileges and security of your dashboard, consider creating a user-owned dashboard where you have more control on who can access it.Box 2: Single-stream
The single-stream dashboards display real-time data over one stream based on an entity view or queue. The single-stream dashboards are typically helpful to Tier 2 service leads or managers, who monitor fewer, but more complex or escalated cases. -
You need to set the value for a global variable named RunningTotal to 5 and navigate to the previous screen named MainScreen.
Which formula should you use?
-
UpdateContext( { RunningTotal: 5 } ); Navigate( MainScreen, ScreenTransition.Cover, RunningTotal );
-
If( Value(TextBox1.Text) >= 0, (Set( RunningTotal, 5); Back();), Color.Green )
-
UpdateContext( { RunningTotal:5 } ); Back()
-
Set( RunningTotal, 5 ); Back();
Explanation:You set the value of the global variable with the Set function. Set( MyVar, 1 ) sets the global variable MyVar to a value of 1.
Use the Back and Navigate function to change which screen is displayed.
-
-
DRAG DROP
You are developing a Power BI report for a company.
The Power BI report must display company performance metrics in Power BI service. The report must include three fields in a visualization. The data for the report exists in a dataset.
The company will display the report on a large television screen during team meetings.
You need to create the report.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer and arrange them in the correct order.
Explanation:Box 1: Select a dataset
Sign in to your Power BI online account, or sign up, if you don’t have an account yet.
Open the Power BI service.
Get some data and open it in report view.Box 2: Create a report
Use that data to create visualizations and save it as a report.Box 3: Add a visualization to the report
Box 4: Add the report to a new dashboard
Visualizations (known as visuals for short) display insights that have been discovered in the data. A Power BI report might have a single page with one visual or it might have pages full of visuals. In the Power BI service, visuals can be pinned from reports to dashboards. -
DRAG DROP
The company is adding a multi-stream interactive dashboard to a model-driven app.
The company requires configuration of the dashboard to filter the table data based on modified accounts over the last month.
You need to configure the filters for the model-driven app dashboard.
Which configuration should you use? To answer, drag the appropriate locations to the correct requirements. Each configuration 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.
Explanation:Box 1: Filter table
Filter Table: The visual filters and global filter attributes are based on this table.Box 2: Filter By
Filter By: The column that the time frame filter applies to.Incorrect Answers:
Table View: The visual filters are based on this view.
Time Frame: The default time frame filter value for the Filter By column. -
DRAG DROP
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.
Explanation:Box 1: Tag
Box 2: Multi-series
Multi-series charts: Charts that display data with multiple series values mapped to a single category value.Incorrect Answers:
Multi-series charts include stacked column charts, which vertically display the contribution of each series to a total across categories, and 100% stacked column charts, which compare the percentage that each series contributes to a total across categories. -
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.
You need to automatically detect bicycles in pictures taken with the camera.
Proposed solution:
– Create an Object Detection custom model in AI Builder.
– Train the model with pictures of bicycles and then publish the trained model.
– Add the Object Detector control to your canvas app.Does the solution meet the goal?
- Yes
- No
Explanation:To train an object detection model to recognize your objects, you have to gather images that contain those objects.
The first thing you’ll do when you create an AI Builder object detection model is to define its domain.
Upload images
Then Train and publish your object detection modelThe object detector component takes a photo or loads an image file to do an object detection scan. On a mobile device, the user chooses between taking a photo or selecting one already available in the device user interface. When an image is selected, the component automatically scans it to identify objects.
-
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.
You need to automatically detect bicycles in pictures taken with the camera.
Proposed solution:
– Create a Prediction custom model in AI Builder.
– Train the model with pictures of bicycles and then publish the trained model.
– Add the Object Detector control to your canvas app.Does the solution meet the goal?
- Yes
- No
Explanation:Instead create an Object Detection custom model
Note: AI Builder prediction models analyze patterns in historical data that you provide. Prediction models learn to associate those patterns with outcomes. Then, we use the power of AI to detect learned patterns in new data, and use them to predict future outcomes.
-
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.
You need to automatically detect bicycles in pictures taken with the camera.
Proposed solution:
– Create a Category Classification custom model in AI Builder.
– Train the model with pictures of bicycles and then publish the trained model.
– Add the Object Detector control to your canvas app.Does the solution meet the goal?
- Yes
- No
Explanation:
Instead create an Object Detection custom model -
DRAG DROP
A company uses data from a publicly available web service. You plan to create a tabular report by using Power BI Desktop to visualize data from the web service.
The data returned in one column is numeric and must be converted to a corresponding text value. The most up-to-date version of the data must always be used.
You need to create the report and make it available only to co-workers.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Explanation:Step 1: Create a table and input the data from the web service
Step 2: Perform data transformation
Step 3: Create the visualization.
Step 4: Publish to AppSource
With Power BI apps, you can create collections of dashboards and reports and publish these collections as apps to your whole organization or to specific people or groups.Business users get your apps in a few different ways:
– They can find and install your app from Microsoft AppSource.
– You can send them a direct link. -
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
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
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 employeeThe 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
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.
Explanation:Box 1: Power BI Desktop
The Sales dashboard must reside in the Sales channel and must include information about active quotes, sales pipeline, and year-to-date sales KPIs for sales quotas by region.Power BI Desktop to support many data source.
Box 2: Power BI Desktop or Power BI Service on
A dashboard that shows a capacity Heat map by month as well as expected sales that are likely to close for the next month.Both support visualizations.
-
-
You create a model-driven app for a company. The app will be used to manage events that the company organizes.
The Events entity ownership type is set to User or team. Members of the marketing team are assigned the MarketingTeam security role. All privileges for the role are set to User access.
All employees must be able to view event records. Only members of the marketing team are permitted to create or edit event records. You create a role named OtherEmployees.
You need to configure the MarketingTeam and OtherEmployees security roles.
Which three actions should you perform? Each correct selection presents a part of the solution.
NOTE: Each correct selection is worth one point.
- Set the access level for the OtherEmployees security role to Organization for the Read permission.
- Set the access level for the MarketingTeam security role to Organization for the Read permission.
- Set the access level for the OtherEmployees security role to None Selected for the Read permission.
- Set the access level for the MarketingTeam security role to None Selected for the Read permission.
- Set the access level for the MarketingTeam security role to None Selected for the Create and White permission.
- Set the access level for the OtherEmployees security role to None Selected for the Create and Write permission.
-
You create a canvas app within a Power Platform environment.
You need to identify potential accessibility issues for the canvas app before making the app available to other users.
Which tool should you use?
- Portal Checker
- App Checker
- Solution Checker
Explanation:Find accessibility issues
1. In the upper-right corner of Power Apps Studio, select the icon for the App checker.2. In the menu that appears, select Accessibility.
A list of issues appears, sorted first by severity and then by screen.
-
You create a canvas app.
A user is not able to determine which field currently has focus. You run App checker to identify errors.
You need to verify that the focused border thickness is set to a value greater than zero.
Which section of the App checker results should you check?
- Rules
- Performance
- Accessibility
- Runtime
Explanation:The Accessibility checker classifies each issue as an error, a warning, or a tip based the issue’s severity.
Issues include:
Focus isn’t showing
– When the FocusBorderThickness of a control is set to 0. It is good practice to ensure a proper color-contrast ratio between the focus border and the control itself so it’s clearly visible.