Microsoft

PL-200 Free Practice Questions — Page 14

Question 131

A company uses Power Apps with Microsoft Dataverse. The company enables auditing on the Dataverse database. The company tenant reaches the maximum storage capacity. You need to delete some auditing data. Which three deletion options should you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A. by record
B. between two specified dates
C. by table
D. older than a specified date
E. by column
Show Answer
Correct Answer: A, C, D
Explanation:
Dataverse auditing data can be deleted using supported audit log reduction options. You can delete audit history for a specific record, delete audit logs for one or more tables, and delete all audit logs up to and including (older than) a specified date. Deletion by column is not supported, and deleting strictly between two dates is not an available admin option.

Question 132

A company uses Power Apps. Users must be able to view only the address1 columns in the Account table. You need to ensure other address columns are not visible to users when creating views and filters. What should you do?

A. Delete the other address columns from the table.
B. Disable the Search option for the columns.
C. Use column-level security to remove read access to all users.
D. Create business rules to hide the other address columns.
Show Answer
Correct Answer: C
Explanation:
Users must not see the other address columns when creating views and filters. Disabling the Search option only affects search behavior and does not remove columns from views or filters. Business rules only hide fields on forms, not in views or filters. Deleting columns is not appropriate. Column-level security with read access removed ensures those columns are invisible in views, filters, and elsewhere unless explicitly permitted.

Question 133

HOTSPOT - You are creating a business process flow for a Power Apps app. The business process flow must meet the following requirements: • Must be available offline. • Send an email to the team when a record is created. You need to set up business process flow. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Illustration for PL-200 question 133
Show Answer
Correct Answer: Ensure that the business process flow is referencing one table. Create a stage.
Explanation:
Business process flows are available offline only when they reference a single table. Email notifications in a business process flow are triggered at the stage level (for example, via a workflow or flow tied to stage changes), not by individual steps.

Question 134

You are creating tables for use with Microsoft Power Platform components. The display names of the tables must not be changed when the solution is promoted to the user acceptance testing environment. You need to apply this restriction to the solution. Where should you make the changes?

A. Segmented solution
B. Default solution
C. Power Apps
D. Unmanaged solution
E. Managed solution
Show Answer
Correct Answer: E
Explanation:
To ensure that table display names cannot be changed when the solution is promoted to another environment, you must deploy the solution as a managed solution. Managed solutions lock components and enforce managed properties (such as preventing renaming) in target environments like UAT. Although these properties are configured while the solution is unmanaged in development, the restriction only takes effect once the solution is exported and installed as a managed solution.

Question 135

A company uses Power BI dashboards. A manager wants to understand the raw data in one of the charts. You need to present the data. What should you do?

A. Export the dashboard to Microsoft PowerPoint.
B. Export the dashboard to Microsoft Excel.
C. Change to focus mode.
D. Drill down in the dashboard controls.
Show Answer
Correct Answer: B
Explanation:
To understand the raw (underlying) data behind a chart in a Power BI dashboard, exporting the data to Microsoft Excel is the appropriate option. Exporting allows the manager to view the underlying rows in a tabular format. Drill down only navigates through aggregated levels of the visual, focus mode only enlarges the visual, and exporting to PowerPoint does not expose raw data.

Question 136

HOTSPOT - You plan to create a Power BI dataflow. The Power BI dataflow has the following requirements: • Be able to create a copy of the dataflow to separate Power BI workspaces. • Schedule the dataflow to update every day at 11:00 AM. You need to configure the dataflow. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Illustration for PL-200 question 136
Show Answer
Correct Answer: Export the JSON file. Configure the Power BI service.
Explanation:
Power BI dataflows can be copied between workspaces by exporting and importing the dataflow as a JSON file. Scheduling a daily refresh (such as 11:00 AM) is configured in the Power BI service refresh settings for the dataflow.

Question 137

You have a canvas app with an embedded Power BI tile. You share the canvas app. Users report that they are unable to access the Power BI content. You need to determine why users are unable to access the content. What is the cause of the user's problems?

A. The Power BI dashboard is not shared.
B. The Power BI connection is not shared.
C. The Power BI Display mode property on the Power BI tiles is set to Disabled.
D. The Power BI interactions property on the Power BI tiles is set to Off.
Show Answer
Correct Answer: A
Explanation:
In a canvas app, embedding a Power BI tile does not grant access to the underlying Power BI content. Each user must also have permission to the Power BI dashboard or report itself. If the dashboard is not shared with them in Power BI, they will see access issues even though the app is shared. The other options affect behavior or configuration, not access rights.

Question 138

DRAG DROP - A company that manufactures medical devices uses Power Apps to manage their sales and device maintenance. A table named Devices in Microsoft Dataverse has a column named Status. The Status column must have a new status value of Review added to the existing Choice values of Active and Inactive. The table must be added to a solution to be promoted once the change is made. Only this change must be promoted to the test environment. The changes must not be able to be changed once promoted. You need to add the change to a solution for promotion.

Illustration for PL-200 question 138
Show Answer
Correct Answer: Add the Devices table to the solution. Add existing Add the status column changes only to the solution. Add required components
Explanation:
The Devices table already exists, so it must be added to the solution as an existing component. To promote only the specific change to the Status choice (and keep it unmanaged/locked after promotion), include only the required components, which brings in just the necessary column metadata without the entire table.

Question 139

HOTSPOT - You are a consultant. A client asks you to remove several solutions in one of their Microsoft Dataverse environments. The client wants to know what effect removing the solutions will have on the rest of the system. You need to explain the results of removing the solutions. Which components will be affected? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Illustration for PL-200 question 139
Show Answer
Correct Answer: The solution only. The solution and the updated column label. The solution, the table, and any data in the table.
Explanation:
Unmanaged solutions remove only the solution container, not components. Managed solution patches roll back their specific changes, such as a column label update. Removing a managed ISV solution deletes the solution and all its components, including custom tables and their data.

Question 140

You have a classic workflow. The workflow updates a custom column on a record when an account record is created. The workflow must update the custom column based on the following conditions: • Update the custom column value using the Account Number. • If the Account Number column is blank, update the custom column value using the Ticker Symbol. • If the Ticker Symbol column is blank, update the custom column value to N/A. You need to configure the custom column value by using the update record step. What should you do?

A. Add a formula that evaluates the two column values and uses the first populated value or else the default value.
B. Add an expression that evaluates the two column values and uses the first populated value or else the default value.
C. Add the two columns with the default value by using the Forms Assistant.
D. Add check conditions to determine if the two columns contain data.
Show Answer
Correct Answer: D
Explanation:
In a classic workflow, the Update Record step does not support expressions or formulas. To apply conditional logic (Account Number first, then Ticker Symbol, else N/A), you must use Check Conditions with If / Else If / Else branches, and place an Update Record step in each branch to set the custom column accordingly.

$19

Get all 296 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.