What Pinpoint PL-900 Preparation Is

Your company has an on premises Microsoft SQL Server database that contains legacy sales data. You must display information from the database in a new Power Apps app.
You need to establish a secure connection between the database and the app. What should you use?

A recent update has been made to a canvas app. The update has caused a negative impact to users. You need to roll back the app to a previous version. What should you do?

A distribution company has multiple warehouses.
Tax rates charged on sales orders need to be calculated based on locality and region. You need to recommend a cost-effective solution that can be implemented quickly. What should you recommend?

You plan to use Microsoft Flow to monitor what people are saying about your company's products. You store the feedback for research and development purposes.
You need to recommend Flow components to use for the solution.
To answer, drag the appropriate components to the correct requirements. Each component 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.


Solution:
Box 1: Trigger
A trigger is something that triggers or starts the workflow. It could be a new file uploaded to a document library, a new item created in the list or an email sent to your Inbox – something that will start (kick-off the workflow).
There are two types of triggers:
Automatic trigger is pre-programmed into the workflow based on a certain rule (i.e. new document or item created, email sent, etc.)
Manual Trigger is a trigger initiated by a user. Unlike with automatic trigger above, the workflow will only start when initiated manually by the end user (for example, from the Document Library for a selected file). Manual trigger is only supported for certain types of workflows (i.e. Get feedback from your manager for the selected file)
Box 2: action
An action is something that occurs as a result of the workflow. Box 3: expression
Sometimes users just need to do basic operations like getting the current time, adding numbers together, or replacing a part of a string of text. That’s possible inline in any flow action. Microsoft Flow leverages the same Workflow Definition Language used by Azure Logic apps. For new users who are unfamiliar with the expression language, there is an inline help experience that shows how to use each expression as they build out their flow.
Box 4: flow type
There are four different Flow types that you can choose from when starting out. You can create a scheduled flow, automated flow, instant flow, or a business process flow.

Does this meet the goal?

A company is using Power BI to build visualizations.
The company's IT support team needs to know when to install Power BI Desktop on users' computers and where the Power BI Service will suffice to perform tasks.
You need to recommend solutions for the company.
What should you recommend? To answer, drag the appropriate components to the correct requirements. Each component 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.

Solution:
In a Venn diagram comparing Power BI Desktop and the Power BI service, the area in the middle shows how the two overlap. Some tasks you can do in either Power BI Desktop or the service. The two sides of the Venn diagram show the features that are unique to the application and the service.


Does this meet the goal?

You manage the support team at a rapidly growing company.
Customers and support technicians need a better experience when logging and responding to support requests. You need more visibility into what the support technicians are doing every week.
You need to recommend tools to help the company's needs.
Which tools should you recommend? To answer, drag the appropriate tools to the correct requirements. Each tool 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.

Solution:


Does this meet the goal?

You need to explain the major components of the Common Data Model (CDM) and their functions. Match each term to its definition.
Instructions: To answer, drag the appropriate term from the column on the left to its definition on the right. Each term may be used once, more than once, or not at all. Each correct match is worth one point.
NOTE: Each correct selection is worth one point.

Solution:
Box 1: Microsoft Power Platform
Power Platform combines the robust power of PowerApps, PowerBI, and Microsoft Flow into one powerful business application platform – providing quick and easy app building and data insights. Each component of the Microsoft Power Platform is built on the Common Data Service for Apps. Each component is dynamic by itself, but brilliant and masterful when combined.
The Microsoft Power platform brings all your data together into a common data model. Box 2: Entities
An entity is a set of records used to store data, similar to how a table stores data within a database.

Does this meet the goal?

A company plans to use Power BI to visualize data from business systems.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Solution:
Box 1: Yes
The following list provides advantages to using aggregations:
Query performance over big data - as users interact with visuals on Power BI reports, DAX queries are submitted to the dataset. Boost query speeds by caching data at the aggregated level, using a fraction of the resources required at the detail level. Unlock big data in a way that would otherwise be impossible.
Box 2: No
You can connect to model-driven apps in Dynamics 365 with Power BI Desktop to create custom reports and dashboards for use with the Power BI service.
You can use similar steps to connect to model-driven apps in Dynamics 365 using Office Excel Power Query by selecting From Other Sources on the Power Query tab in Excel.
Box 3: Yes
Using the PowerApps custom visual, you will be able to pass context aware data to a PowerApps app which updates in real time as you make changes to your report.

Does this meet the goal?

A company uses Dynamics 365 Sales. The company uses a browser-based app named Sales Hub. You need ensure that users can access data from mobile devices.
Which app should users install?

You need to use Microsoft Flow to perform data-management tasks when users interact with the sales opportunities in Dynamics 365.
Which three types of triggers can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

You are designing a Power Apps solution that allows users to upload a status report directly to the company Microsoft SharePoint project management site from their mobile device.
For each of the following statements, select Yes it the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Solution:
Box 1: No
Box 2: Yes
Box 3: Yes
When you create an app, or someone shares an app with you, you can run that app on Windows, iOS, Android, or in a web browser.
References:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/app-from-sharepoint https://docs.microsoft.com/en-us/powerapps/user/run-app-client

Does this meet the goal?

A company uses Dynamics 365 Supply Chain Management.
When a sales order is created for one of the customers that a specific user manages, a Microsoft Outlook task must be created to remind the user to perform any follow up activities that are required.
You need to implement the functionality to create Outlook tasks.
Which two features should you use? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

You are building Power Apps apps that use both Dynamics 365 Sales and Microsoft 365.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Solution:
Box 1: No
When you offer your application for use by other companies through a purchase or subscription, you make your application available to customers within their own Azure tenants. This is known as creating a
multi-tenant application.
Box 2: No

Does this meet the goal?

A bank uses Power Platform apps and flows to support business processes.
The company would like to use historical client data to predict whether a client's loan application is likely to be approved or rejected.
You need to use AI Builder to implement the solution.
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.

Solution:
Step 1: Import data into Common Data Service.
AI Builder requires the use of Common Data Service, which is the data platform for PowerApps and allows you to store and manage business data. Common Data Service is the platform on which Dynamics 365 apps are built so if you’re a Dynamics 365 customer, your data is already in Common Data Service.
Step 2: Train the model Step 3: Publish the model
The last step is to publish your model.
Step 4: Use the model in PowerApps or Microsoft Flow.

Does this meet the goal?

You create a business rule on contact entity to enforce the requirement that users must enter either a telephone number, fax number, or an email when creating a new record.
The company decides to remove fax number from the condition. You need to update the business rule.
What are two ways of achieving the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.