Microsoft Microsoft Certifications PL-600 Questions & Answers

• Question 91:

  You need to investigate the canvas app functionality issues.

  Which two tools can you use? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. App checker

  B. Errors function

  C. Solution checker

  D. Power Platform admin center

  Correct Answer: AC

  Scenario: The testing team reports that one of the canvas apps is not working as expected. An error message displays as specific pages load.

  A: The App checker is now available to help provide a clear list of formula issues in your app, and to provide items to fix to make your app accessible. The App checker is an area that the PowerApps team will continue to invest in, and build on in order help to make debugging, performance and best practice decisions an easier and more guided experience.

  C: With the solution checker feature, you can perform a rich static analysis check on your solutions against a set of best practice rules and quickly identify these problematic patterns. After the check completes, you receive a detailed report that lists the issues identified, the components and code affected, and links to documentation that describes how to resolve each issue.

  Reference: https://powerapps.microsoft.com/en-us/blog/new-app-checker-helps-you-fix-errors-and-make-accessible-apps/

• Question 92:

  You need to recommend a reporting solution for the organization.

  Which two options should you recommend? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. AI Builder

  B. SQL Server Reporting Services (SSRS)

  C. Dynamics 365

  D. Power BI

  Correct Answer: BC

  Scenario:

  1.

  The reporting and analytics team must be able to create reports that include data from all facilities and all workers.

  2.

  Management reports must present an overview of the entire organization. Other reports may be limited to specific offices.

  B: Power Apps apps can include reports that provide useful business information to the user. These reports are based on SQL Server Reporting Services and provide the same set of features that are available for typical SQL Server Reporting Services reports.

  C: Microsoft Dynamics 365 online and Model-Driven PowerApps offers several advanced reporting options. Advanced reports are often necessary when business requirements demand complex calculations, returning multiple data sets, grouping large sets of data based on rules, and retrieving data from different data sources.

  Incorrect Answers:

  D: Scenario: Users cannot view Power BI reports within the Power Platform apps.

  Note: Power BI enables data insights and better decision-making, while Power Apps enables everyone to build and use apps that connect to business data. Using the Power Apps visual, you can pass context-aware data to a canvas app,

  which updates in real time as you make changes to your report.

  Reference:

  https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/add-reporting-to-app https://powerusers.microsoft.com/t5/Building-Power-Apps/Creating-SSRS-Report-for-Model-Driven-PowerApps/td-p/621866 https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual

• Question 93:

  HOTSPOT

  A company has an on-premises data warehouse and analytics solution. The data warehouse consists of multiple multi-dimensional data cubes representing over five years of operational data. The data warehouse consolidates and normalizes data that is sourced from 20 different systems. The company plans to replace the existing solution with a Microsoft Power Platform solution that connects to the data warehouse. The company wants to provide analytical information to executives in a Microsoft Teams channel to support

  business planning.

  The new solution must meet these requirements:

  1.

  Support the current data warehouse.

  2.

  The solution must support drill-through capabilities into the data.

  3.

  Retain at least seven years of historical data.

  You need to recommend a solution.

  What should you recommend? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Azure Data Lake

  A data warehouse is a centralized repository of integrated data from one or more disparate sources. Data warehouses store current and historical data and are used for reporting and analysis of the data.

  Incorrect Answers:

  Dataverse is not a database.

  Box 2: Microsoft Teams integration object

  You can use the Teams integration object to easily find and access the Teams integration features and use the improved usability of expressions while integrating your canvas app with Teams.

  You can get a Teams theme inside a canvas app, and you can filter data depending on the team or channel context.

  Reference:

  https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing

  https://docs.microsoft.com/en-us/powerapps/teams/use-teams-integration-object

• Question 94:

  HOTSPOT

  You are designing a model-driven app that provides marketing, sales, and service operations to a company.

  The app must integrate with the following systems and data sources:

  1.

  A third-party marketing system for lead generation and website submissions.

  2.

  A Microsoft Excel Online file that contains manufacturing data on relevant products.

  3.

  A separate Microsoft Dataverse environment.

  You need to recommend Power Automate connectors for the app.

  Which connectors should you recommend? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Custom connector While Azure Logic Apps, Microsoft Power Automate, and Microsoft Power Apps offer over 325+ connectors to connect to Microsoft and non-Microsoft services, you may want to communicate with services that aren't available as prebuilt connectors.

  Box 2: Microsoft Dataverse The Microsoft Dataverse connector provides several triggers to start your flows and many actions that you can use to create or update data in Dataverse while your flows run. You can use Dataverse actions even if your flows don't use a trigger from the Dataverse connector.

  Use the Microsoft Dataverse connector to create cloud flows that start when data changes in Dataverse tables and custom messages.

  Reference: https://docs.microsoft.com/en-us/connectors/custom-connectors/ https://docs.microsoft.com/en-us/power-automate/dataverse/overview

• Question 95:

  HOTSPOT

  You are designing a Microsoft Power Platform solution for a company.

  Which components should you recommend? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Business rule

  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.

  Box 2: Power Automate flow

  Trigger the Power Automate flow with “When a record is updated”, then add a Condition in the flow and configure it with Status Label equals to Won.

  Reference:

  https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-create-business-rule

  https://www.inogic.com/blog/2021/12/how-to-win-lose-dynamics-365-crm-opportunity-through-power-automate-flow/

• Question 96:

  HOTSPOT

  A company is creating a Power Platform solution to manage employees.

  The company has the following requirements:

  Allow only the human resource manager to change an employee's employment status when an employee is dismissed.

  Allow only approved device types to access the solution and company data.

  You need to recommend a solution that meets the requirements.

  What should you recommend? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Field security profile

  Record-level permissions are granted at the entity level, but you may have certain fields associated with an entity that contain data that is more sensitive than the other fields. For these situations, you use field-level security to control access to

  specific fields.

  Field-level security is available for the default fields on most out-of-box entities, custom fields, and custom fields on custom entities. Field-level security is managed by the security profiles.

  Box 2: Compliancy policy

  Compliance policy settings – Tenant-wide settings that are like a built-in compliance policy that every device receives. Compliance policy settings set a baseline for how compliance policy works in your Intune environment, including whether

  devices that haven't received any device compliance policies are compliant or noncompliant.

  Note: Mobile device management (MDM) solutions like Intune can help protect organizational data by requiring users and devices to meet some requirements. In Intune, this feature is called compliance policies.

  Compliance policies in Intune:

  Define the rules and settings that users and devices must meet to be compliant.

  Include actions that apply to devices that are noncompliant. Actions for noncompliance can alert users to the conditions of noncompliance and safeguard data on noncompliant devices.

  Can be combined with Conditional Access, which can then block users and devices that don't meet the rules.

  Reference:

  https://docs.microsoft.com/en-us/power-platform/admin/field-level-security

  https://docs.microsoft.com/en-us/mem/intune/protect/device-compliance-get-started

• Question 97:

  HOTSPOT

  You are supporting a recent go-live for a model-driven app that includes mobile offline functionality.

  Users report the following issues:

  The process of downloading initial metadata for the app takes hours to complete.

  Some account views are unavailable when the app is offline.

  Changes to users’ security privileges are not reflected in the mobile app.

  Contact data is not available when the app is offline.

  You need to resolve the mobile app performance issues.

  What should you review? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 98:

  HOTSPOT

  A company plans to create a Power Platform solution that integrates with Dynamics 365 Sales.

  The solution must meet the following requirements:

  Connect directly with a Microsoft Azure SQL database as an external data source at run time where specific data is available in the Dynamics 365 Sales solution without the need for data replication.

  An external system needs to send data to the company's Dynamics 365 Sales solution.

  You need to recommend the most suitable solution to integrate Dynamics 365 Sales with both systems.

  What should you recommend? To answer, select the appropriate option in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Use Virtual tables

  A virtual entity is a custom entity in Dynamics 365 Customer Engagement (on-premises) that has fields containing data from an external data source. Virtual entities appear in your app to users as regular entity records, but contain data that is

  sourced from an external database, such as an Azure SQL Database. Records based on virtual entities are available in all clients including custom clients developed using the Dynamics 365 Customer Engagement Web Services.

  Box 2: Use Dynamics 365 Web API.

  Dynamics 365 Web Services API: Many times, straight database-to-database integrations aren't a possibility. In these cases, the development of a solution may depend on utilization of the Dynamics 365 Customer Engagement web services

  API (Application Programming Interface).

  Reference:

  https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/create-edit-virtual-entities

• Question 99:

  HOTSPOT

  A company plans to transition from an existing proprietary solution to a Power Platform solution. The company is consolidating data from several sources.

  The company reports the following data quality issues with the existing solution:

  Users often encounter a character limit when entering data.

  The database includes multiple instances of duplicate records.

  You need to recommend solutions to ensure that the data quality issues are not present in the Power Platform solution.

  What should you recommend? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Define the data type and format for each column Increase the data type size of the column.

  Box 2: Define and implement duplicate detection rules

  Reference: https://docs.microsoft.com/en-us/power-platform/admin/set-up-duplicate-detection-rules-keep-data-clean

• Question 100:

  HOTSPOT

  A company reports the following issues with an existing data management system.

  Users cannot search for specific records by using a user-friendly ID or record identifier.

  Users occasionally enter data into fields that is not required.

  The record form displays all fields. Many of the fields are not used.

  You need to ensure that the Power Platform solution will ensure data quality can be properly maintained.

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

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Autonumber column

  Autonumber columns are columns that automatically generate alphanumeric strings whenever they are created.

  Box 2: Business rule

  By combining conditions and actions, you can do any of the following with business rules:

  Enable or disable columns

  Set column values

  Clear column values

  Set column requirement levels

  Show or hide columns

  Validate data and show error messages

  Create business recommendations based on business intelligence.

  Reference: https://docs.microsoft.com/en-us/powerapps/maker/data-platform/autonumber-fields https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-create-business-rule