Microsoft

PL-600 Free Practice Questions — Page 10

Question 93

You design a Microsoft Power Platform solution for a company. The company has an existing Azure SQL database with customer information that it wants to continue using. The company wants to share access to data that is held in Azure SQL with the following people: • internal company employees, using built-in process functionality • external customers to view their data You need to recommend the appropriate components to use for the application. Which two components should you recommend? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A. Power Pages
B. Custom pages
C. Canvas app
D. Model-driven app
Show Answer
Correct Answer: A, D
Explanation:
External customers should access data through Power Pages, which is designed for secure, anonymous or authenticated external user access and replaces Power Apps Portals. Internal employees who need built-in process functionality (business processes, workflows, forms, and views) are best served by a model-driven app. Model-driven apps can work with Azure SQL data via Dataverse virtual tables, enabling reuse of the existing database while leveraging built-in process capabilities.

Question 94

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. A company plans to automate the expense approval process. Users currently enter data into an on-premises SQL Server database. You need to allow users to submit expenses from mobile devices. Solution: Create a canvas app for expense data entry. Create a custom connector. Create a cloud flow for approval and use the custom connector to add data to the SQL Server database. Does the solution meet the goal?

A. Yes
B. No
Show Answer
Correct Answer: B
Explanation:
The solution does not meet the goal because accessing an on‑premises SQL Server from Power Apps or Power Automate requires an on‑premises data gateway (or equivalent secure relay). The proposed solution uses a custom connector but does not include a gateway or hosted API endpoint reachable from the cloud. Without that connectivity, the cloud flow cannot write data to the on‑premises SQL Server, so the goal is not met.

Question 95

DRAG DROP - A company plans to implement a model-driven app. The company has the following requirements: • Short Message Service (SMS) data must be visible on the model-driven app timeline. • Store location data must be referenced from a SQL server database. • Customer data must be audited and only edited by specific users. You need to recommend the table type for each requirement. Which table types should you recommend? To answer, drag the appropriate solutions to the correct requirements. Each solution 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.

Illustration for PL-600 question 95
Show Answer
Correct Answer: SMS data: Activity – user or team owned Store location data: Virtual – organization owned Customer data: Custom – user or team owned
Explanation:
SMS messages must appear on the timeline, which requires an Activity table. Referencing data from SQL Server uses Virtual tables and is organization owned. Customer data needing auditing and edit control by specific users requires a Custom table that is user or team owned.

Question 96

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. A company plans to automate the expense approval process. Users currently enter data into an on-premises SQL Server database. You need to allow users to submit expenses from mobile devices. Solution: Create a canvas app for expense data entry. Create a desktop flow. Create a cloud flow for approval and trigger the desktop flow to add data to the SQL Server database. Does the solution meet the goal?

A. Yes
B. No
Show Answer
Correct Answer: B
Explanation:
The goal is to allow mobile users to submit expenses into an on‑premises SQL Server. While the proposed design is technically possible, it is not an appropriate or intended solution in the Power Platform architecture. Desktop flows are meant for RPA on a specific machine and are not required to write to SQL Server. The correct pattern is a canvas app with a cloud flow that connects to the on‑premises SQL Server through an on‑premises data gateway. Using a desktop flow adds unnecessary dependency on a running machine and does not meet the goal in a supported, scalable way.

Question 97

DRAG DROP - A company plans to integrate a model-driven app with external data sources. The company has the following requirements: • Consume data in its data warehouse from Microsoft Dataverse. • Use a plug-in to retrieve information from an external service. You need to recommend a Microsoft Azure component for each requirement. Which Azure components should you recommend? To answer, drag the appropriate Azure components to the correct requirements. Each Azure 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.

Illustration for PL-600 question 97
Show Answer
Correct Answer: Consume data in a data warehouse: Azure Synapse Link Consume data from an external source: Azure Service Bus
Explanation:
Azure Synapse Link provides near real-time replication of Microsoft Dataverse data into Azure Synapse/Data Lake for analytics and warehousing. Azure Service Bus is commonly used with Dataverse plug-ins to integrate with external services via reliable, asynchronous messaging.

Question 98

A company plans to use Power BI. The company plans to share reports indefinitely with a specific set of users. You need to recommend a solution. Which solution should you recommend?

A. Embed code by using the website or portal option.
B. Share by using a link.
C. Share directly with the users.
D. Embed code by using the Publish to web option.
Show Answer
Correct Answer: C
Explanation:
The requirement is to share reports indefinitely with a specific set of users. Sharing directly with users assigns explicit permissions in Power BI, ensuring controlled access over time without creating public or reusable links. Share links can be forwarded or hit tenant/quantity limits, and embedding or Publish to web are not appropriate for secure, user-specific sharing.

Question 99

A company plans to use Microsoft Power Platform. The company wants to enhance the user experience of its apps. The company requires a reusable custom color picker control that can be added to model-driven app forms and canvas app screens. You need to recommend a solution. Which solution should you recommend?

A. Web resources
B. Power Apps component framework
C. Plug-ins
D. Client script
Show Answer
Correct Answer: B
Explanation:
A reusable custom control that works in both model-driven app forms and canvas app screens is built by using the Power Apps Component Framework (PCF). PCF is specifically designed to create reusable UI components with custom behavior and styling, such as a color picker, that can be embedded across Power Platform apps. Web resources, plug-ins, and client scripts do not provide reusable cross-app UI controls.

Question 100

HOTSPOT - A company plans to use a combination of model-driven and canvas apps for data interaction and Power BI for data reporting. The company has the following requirements: • Share a canvas app with the auditor team. • Ensure account balance values in Power BI are only viewable by the investment team. • Streamline user administration and role assignment. You need to recommend a security component to use for each requirement. Which security components should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Illustration for PL-600 question 100
Show Answer
Correct Answer: Azure Active Directory security group Report access Manager hierarchy model
Explanation:
Canvas apps are shared with users or Azure AD security groups, making groups ideal for team-based sharing. Limiting visibility of account balance values in Power BI can be achieved by restricting access to the report that contains those values. The manager hierarchy model simplifies user administration and role assignment by automatically granting access based on organizational reporting structure.

Question 101

DRAG DROP - A sales team uses a dedicated mailbox and the assistant for Microsoft Dynamics 365 Sales in their sales process. Technical staff collaborate in a research and development Microsoft Teams channel. Sales reps have a custom insight card that pops up each time certain keywords appear in emails from prospective customers. The sales reps must engage with the technical team before answering the emails. The technical team plans to streamline the email answering process. The technical team needs a similar card to be exposed in the technical channel immediately after an email arrives. You need to provide a solution for the technical team. Which three 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.

Illustration for PL-600 question 101
Show Answer
Correct Answer: Create new flow in Microsoft Power Automate. Add a trigger to the flow when email arrives in the sales mailbox. Add a flow step to post adaptive card in the Teams technical channel.
Explanation:
The technical team needs an automatic notification when emails arrive. Creating a new Power Automate flow ensures no dependency on existing sales automation. The flow starts with an email-arrival trigger on the dedicated mailbox and then posts an adaptive card directly to the technical Teams channel.

Question 102

You are designing an integration between an Azure SQL database and a model-driven app. You have the following requirements: • Audit updates to the data. • Assign security role access to tables at the user level. • Assign security role access to tables at the organization level. • Enable change tracking. • Add and update data. You need to implement virtual tables. Which two requirements can you meet by using virtual tables? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A. Enable change tracking.
B. Assign security role access to tables at the user level.
C. Add and update data.
D. Assign security role access to tables at the organization level.
E. Audit updates to the data.
Show Answer
Correct Answer: C, D
Explanation:
Virtual tables (Dataverse virtual entities) can support create and update operations when using supported providers such as Azure SQL, so users can add and update data directly in the external source. They also support Dataverse security roles at the organization (table) level. However, virtual tables do not support Dataverse auditing, do not support change tracking, and do not support user- or row-level security because the data is not stored in Dataverse.

$19

Get all 247 questions with detailed answers and explanations

  • Instant download HTML + PDF delivered the moment payment clears.
  • Secure Stripe checkout we never see or store your card details.
  • 7-day refund if files are defective see our refund policy.