Microsoft PL-900 Online Practice Questions and Exam Preparation

Microsoft PL-900 Online Questions & Answers

• Question 141:

  HOTSPOT

  You are building Power BI visualizations for a team.

  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

  Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

  https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

• Question 142:

  A coworker is creating an app in Power Apps and needs to automatically synchronize data from an external source. The coworker is unable to locate a suitable Microsoft approved connector template in AppSource.

  You need to recommend a solution for the coworker.

  What should you recommend?

  A. Create a custom connector.
  B. Ask the outside source to send you the data once a week.
  C. Use Microsoft Flow to connect to the database.
  D. Open a ticket with Microsoft and request a new connector.
  E. Use Microsoft Azure Service Bus.
  A. Create a custom connector.

  ---

  Explanation

  There are 250 + predefined connectors that you can use in your PowerApps and in your Microsoft Flows. If you do not find any that suits your needs you have the possibility to create a Custom Connector. Note: A Custom Connector is a wrapper around a REST API (Logic Apps also supports SOAP APIs) that allows Logic Apps, Microsoft Flow, or PowerApps to communicate with that REST or SOAP API.

  https://carinaclaesson.com/2019/09/06/setting-up-a-custom-connector-from-an-openapi-file-and-utilizing-it-in-powerapps-and-flow/

• Question 143:

  A company has a website. The website includes a form that allows the company to collect information about leads.

  You need to set up an automated workflow to create leads in Dynamics 365 Sales when leads are created on the company's custom website.

  What should you create?

  A. Task Flow
  B. Power Automate flow
  C. Dynamics 365 workflow
  D. Business Process Flow
  A. Task Flow

  ---

  Explanation

  https://trellispoint.com/create-crm-leads-using-microsoft-flow/

• Question 144:

  You create a multi-page Power B1 report for an organization.

  You must enable salespeople in the organization to use the report to view data relevant to their sales region only.

  You need to enable security for the report.

  What should you use?

  A. Microsoft Trust Center
  B. row-level security
  C. data loss prevention policies
  D. sensitivity labels
  E. Microsoft Azure Active Directory
  B. row-level security

  ---

  Explanation

  Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.

  You can configure RLS for data models imported into Power BI with Power BI Desktop. You can also configure RLS on datasets that are using DirectQuery, such as SQL Server. For Analysis Services or Azure Analysis Services lives connections, you configure Row-level security in the model, not in Power BI Desktop.

  https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

• Question 145:

  HOTSPOT

  A company needs to create several workflows and applications to help streamline their sales operations.

  You need to determine which applications are appropriate for given scenarios.

  Which applications should you use? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

  Explanation

  Reference: https://docs.microsoft.com/en-us/power-automate/getting-started

  https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-overview

  https://powerapps.microsoft.com/pl-pl/blog/business-model-may/

• Question 146:

  HOTSPOT

  Instructions: 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

• Question 147:

  A company is considering using AI Builder to gain insights into its data. You need to determine whether the use cases for AI Builder meet the company's requirements. What are three use cases for AI Builder? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

  A. Prediction
  B. Object detection
  C. Anomaly detection
  D. Conversational language understanding
  E. Category classification
  A. Prediction
  B. Object detection
  E. Category classification

  ---

  Explanation

  Anomaly detection is a valid option but given anomalies are far smaller, the category classification is a higher benefit for the Organisation

• Question 148:

  A company is using Power Automate to automate business processes.

  You need to run a flow when a user presses a button in an app.

  Which trigger type should you recommend?

  A. Power Apps
  B. for a selected row
  C. manually trigger a flow
  A. Power Apps

  ---

  Explanation

  The Power Apps trigger allows you to run a flow when a user performs a specific action, such as pressing a button, in a Power App. This trigger type is specifically designed to integrate with Power Apps and allows you to create custom actions within your app that trigger a flow to run in the background. This is the best option for your scenario where you need to run a flow when a user presses a button in an app.

  https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/using-logic-flows

• Question 149:

  A company plans to move an on-premises customer service data management system to a cloud-managed solution.

  The customer service application must be replaced by a model-driven application. The company uses Microsoft SQL Server Integration Services (SSIS) packages to move data from the on-premises database system to a third-party enterprise resource planning (ERP) system.

  You need to replace the SSIS packages for data transfer.

  What should the company use in place of the packages to move the data?

  A. Microsoft Azure Data Lake
  B. Power Virtual Agents
  C. Data Migration Framework
  D. Power Platform connector
  C. Data Migration Framework

  ---

  Explanation

  Data Migration Framework is a tool that can be used to migrate data from on-premises to cloud solutions such as Azure SQL Database and Azure SQL Data Warehouse, which can help to migrate data from SQL Server to ERP system on cloud.

  It is one of the option to consider along with A and

  B.

  A. Power Platform connector and

  B. Microsoft Azure Data Lake are also valid options to consider depending on the specific requirements and use cases. It is important to evaluate the different options and choose the one that best fits the company's needs and goals for the data migration.

• Question 150:

  A company uses Dynamics 365 Supply Chain Management.

  You need to use Power Automate to automate the process of receiving and tracking raw materials.

  Which type of connector should you use?

  A. Common Data Service
  B. Dynamics 365
  C. Dynamics 365 for Fin and Ops
  D. Dynamic Signal
  A. Common Data Service

  ---

  Explanation

  Dynamics 365 for Finance and Operations is now being licensed as Dynamics 365 Finance and Dynamics 365 Supply Chain Management. You can use Common Data Service to enable the flow of data between Finance and Operations apps and Dynamics 365 Sales.

  https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/data-integration-cds