PL-600 Microsoft Power Platform Solution Architect Questions and Answers

Box 1: Microsoft Teams

First up employees must be able to contact each other by using a secure system to ask and answer questions about medical cases.

Microsoft Teams key capabilities:

• Connected
• Secure
• Managed
• Collaborative and productive

Box 2: Microsoft 365 Business Voice

Workers must be able to communicate in near real-time with worker support agents.

Microsoft 365 Business Voice makes it easy for small and medium organizations to turn Microsoft Teams into a powerful and flexible telephone system. It's a replacement for traditional telephony providers and in-house phone systems that can be difficult and costly to manage.

Graphical user interface, text, application, chat or text message Description automatically generated

Box 1: Add users to Microsoft 365.

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

Issue: The people you share with may see a locked tile in a dashboard, or a "Permission required" message when they try to view a report.

Solution: You need to grant them permission to the underlying dataset.

• Go to the All or the Datasets + dataflows tab in your content list.
• Select More options (...) next to a dataset, then select Manage permissions.
• Select Add user.
• Enter the full email addresses for individuals, distribution groups, or security groups.
• Select Grant access.

Box 2: Configure an on-premises data gateway.

Scenario: The company plans to reference historical data in the [on-premises] existing system. The records held in these systems will not be migrated to the new solution except for medication information.

The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services. These cloud services include Power BI, PowerApps, 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.

A: Customers should be able to adopt business applications from Microsoft and expect they speak the same

language and seamlessly work together. Dual Write allows our customers to not think about these apps as

different systems to write to independently; rather, the underlying infrastructure makes it seamless for these

apps to write simultaneously.

D: Use Custom APIs to create your own APIs in Dataverse. With a Custom API you can consolidate a group of

operations into an API that you and other developers can call in their code. The Common Data Service (current

environment) connector enables calling Custom APIs actions in Power Automate.

E: Common Data Service provides access to the environment database on the Microsoft Common Data

Service. It is available for Logic Apps, Power Automate, and Power Apps.

Graphical user interface, text, application, email Description automatically generated

There is barcode scanner control in Power Apps. The control opens a native scanner on an Android or iOS device. The scanner automatically detects a barcode, a QR code, or a data-matrix code when in view.

Use the Dynamics 365 for phones or Dynamics 365 for tablets app to run customer engagement apps (such as Dynamics 365 Sales, Dynamics 365 Customer Service, and Dynamics 365 Marketing), built on Microsoft Dataverse on your mobile device.

Box 1: Review the fields that are on the form

Keep the number of table columns (fields) to a minimum.

The more table columns (formerly referred to as fields) you have in a form, the more data that needs to be downloaded to view each record.

Box 2: Review one to many relationships to verify whether cascade settings are necessary.

Restrict Delete: Prevent the Referenced table record from being deleted when referencing tables exist.

Microsoft Dataverse uses a role-based security model to help secure access to the database. Security roles can be used to configure environment-wide access to all resources in the environment.

A: How to View Auditing Log Details?

System administrators can see activities for the entities that are enabled for audit logging. To view the audit logs:

• Go to Settings > System >Auditing.
• Choose Audit Summary View.
• Under Audit Summary View, you will see the list of audit entries

B: You can view details about solution operations from the Solutions area of Power Apps. An operation can be a solution import, export, or uninstall. The solution history displays information such as solution version, solution publisher, type of operation, operation start and end time, and operation status.

D: Trace log records are written to the PluginTraceLog Table. Writing of these records is controlled by the trace settings mentioned in Enable trace logging.

This data can be found in model-driven applications by navigating to Settings and choosing the Plug-in Trace Log tile.

Box 1: Schedule board

The Dynamics 365 Field Service schedule board provides an overview of resource availability and bookings you can make.

Box 2: Azure IoT Central connector

Information about each machine produced must be transferred to Dynamics 365 Field Service.

The difference between IoT hub and IoT central is that IoT is an application platform that simplifies the creation of Internet of Things solutions. IoT central helps to reduce the challenges of implementing IoT development, operations, and management. IoT Central is a fully managed Software as a Service solution.

Note: There are three ways you can use to connect IoT-enabled devices into the Field Service solution:

• Connected Field Service for Azure IoT Central
• Connected Field Service for Azure IoT Hub
• Connected Field Service for non-Azure IoT providers using the extensible IoT provider framework

Box 1: Microsoft Teams

Maintenance supervisors must not have access to Dynamics 365 Customer Service. The supervisors must be able to communicate with the contracts team about contracts.

Box 2: Dynamics 365 Workspace

Aircraft maintenance vendors must have only view and upload privileges to their invoices and receipts.

The Expense management mobile workspace lets users capture and upload a receipt, so that they can attach it to an expense report later.

Scenario:

• Customers can select a meal when they make a reservation and can save the meal choices as a customer preference.
• The company offers two types of meals: standard and vegetarian. Meal types can be temporarily unavailable. The airline is considering offering other meal types, such as gluten-free and low-sodium options.

In PowerApps Option set is one of the field types you can use in your Entity. The information type that Option Set stores is a list of text values. And here comes the Option Set advantage – once you define its text values you can centrally managed it.

Example:

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.

Use business process flows to define a set of steps for people to follow to take them to a desired outcome.

With business processes flows available as an entity, you can now use advanced finds, views, charts, and dashboards sourced from business process flow data for a given entity, such as a lead or opportunity.

Scenario:

• Agents need a solution to replace paper reservation checklists.
• Agents need dashboards to show a current count of all reservations on the entity.
• Agents need a way to track reservation issues.
• Agents need a visual indicator in the interface to determine the reservation step to provide a seamless customer experience.

Box 1: Field controls

You must standardize the format used by agents to enter customer phone numbers.

Box 2: Workflow

Log issues as cases. The case form must show variable sections based on the case type.

Scenario: The security rule for agents must contain the privileges in the default Customer Service

Representative security role.

Create a security role by Copy Role:

Step 1 (E): Copy the Customer Service Representative role.

Step 2 (F): Select the New Role Name.

Step 3: (B): When Copying Role is complete, navigate to each tab, ie Core Records, Business Management, Customization, etc.

Set the privileges on each tab.

Scenario: IT staff needs a mobile solution to see IT cases at the top of the menu since this is their primary focus.

Managers need to see all customer dashboards at the top of their menu on their mobile device.

Scenario: IT specialists want to design Power BI reports. They need to understand the underlying table relationships of the system.

Business process modeler (BPM) in Microsoft Dynamics Lifecycle Services (LCS) is a tool that you can use to create, view, and modify repeatable implementations that are based on business process libraries. BPM helps you align your business processes with industry-standard processes that are described by the American Productivity & Quality Center (APQC)

Scenario: Agents need a way to track reservation issues.

Use Dynamics 365 Customer Service to:

• Track customer issues through cases

Microsoft Dynamics 365 Customer Service is a module for customer service automation that streamlines case and knowledge management, enables personalized customer service with a 360-degree customer view, and provides visibility into customer service department performance with dashboards and reports.

Scenario: Ensure that employees can sign in to all Microsoft apps by using one set of credentials per employee.

Synchronized identity. Synchronize on-premises directory objects with Microsoft 365 and manage your users on-premises. You can also synchronize passwords so that the users have the same password on-premises and in the cloud, but they will have to sign in again to use Microsoft 365.

Box 1: Dashboard

Agents need dashboards to show a current count of all reservations on the entity.

Box 2: Power BI

Management requires paginated reports for stakeholders.

Luggage: Custom activity table

An activity can be thought of as any action for which an entry can be made on a calendar. An activity has time dimensions (start time, stop time, due date, and duration) that help determine when the action occurred or will occur. Activities also contain data that helps determine what action the activity represents, for example, subject and description.

Passenger: Customer table

The account and contact tables in Microsoft Dataverse are essential for identifying and managing customers, selling products and services, and providing superior service to the customers. A customer address table is used to store address and shipping information for a customer.

Scenario: The company has a custom app for managing and tracking passenger luggage. The app uses Microsoft Dataverse.

Agents need to view which pieces of luggage match to each passenger, and then need to add the total on the passenger record.

Scenario:

• The reporting and analytics team must be able to create reports that include data from all facilities and all workers.
• 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.

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.

Graphical user interface, application, table Description automatically generated

Box 1: Power Platform Local Business Owner Team

Owner team: An owner team owns records and has security roles assigned to the team. A user's privileges can come from their individual security roles, those of the teams that they're part of or the ones they inherit. A team has full access rights on the records that the team owns. Team members are added manually to the owner team.

Scenario: Employee authentication with the existing system is provided by an on-premises Active Directory instance that is linked to Azure Active Directory.

Box 2: Azure Active Directory Security Group Team

An Azure Active Directory (Azure AD) group team. Similar to owner team, an Azure AD group team can own records and can have security roles assigned to the team.

Note: The administration of app and data access for Microsoft Dataverse has been extended to allow administrators to use their organization's Azure Active Directory (Azure AD) groups to manage access rights for licensed Dataverse users.

Box 3: Azure Active Directory B2B Guest Access

An Azure AD B2B collaboration user is an external user, typically from a partner organization, that you invite to sign into your Azure AD organization using their own credentials. This B2B collaboration user (also generally referred to as a guest user) can then access the apps and resources you want to share with them. A user object is created for the B2B collaboration user in the same directory as your employees. B2B collaboration user objects have limited privileges in your directory by default, and they can be managed like employees, added to groups, and so on.

Scenario: Before First Up signs a contract to place workers at a client company, a member of the audit team visits the company and interviews company management. Audit members use different types of devices including Android and iOS devices. First Up has no plans to require the use of a single type of device.

A virtual table is a custom table in Microsoft Dataverse that has columns containing data from an external data source. Virtual tables appear in your app to users as regular table rows, but contain data that is sourced from an external database, such as an Azure SQL Database. Rows based on virtual tables are available in all clients including custom clients developed using the Dataverse web services.

Scenario:

• First Up uses an on-premises system to manage current and historical patient data including medications and medical visits.
• The company plans to reference historical data in the existing system. The records held in these systems will not be migrated to the new solution except for medication information.
• The solution must provide a worker appointment booking system that can access worker historical job placement data.
• First Up staff members must be able to view and update worker records. They must be able to see current and historical job placement data on the same form in the new solution.

Box 1: Assign: Cascade None

Scenario: Worker still records must be archived after ten years and are then removed from the main system.

Assign: The referenced table record owner is changed.

Cascade None: Do nothing.

Graphical user interface, text, application, chat or text message Description automatically generated

Box 1: Virtual Table

A virtual table is a custom table in Microsoft Dataverse that has columns containing data from an external data source. Virtual tables appear in your app to users as regular table rows, but contain data that is sourced from an external database, such as an Azure SQL Database. Rows based on virtual tables are available in all clients including custom clients developed using the Dataverse web services.

Scenario:

• First Up uses an on-premises system to manage current and historical patient data including medications and medical visits.
• The company plans to reference historical data in the existing system. The records held in these systems will not be migrated to the new solution except for medication information.
• The solution must provide a worker appointment booking system that can access worker historical job placement data.
• First Up staff members must be able to view and update worker records. They must be able to see current and historical job placement data on the same form in the new solution.

Box 2: Lookup (N:1)

Each worker can have many security clearances, so need a 1:N relationship.

Scenario: The solution must support tracking of security clearance information for a worker including the date, status, and certifying agency.