Exam PL-400 topic 2 question 41 discussion

Not sure if it is possible to delete the relationship before removing the lookup from TableA Form. We should first remove the lookup from TableA form and then delete the relationship.

D. Confirm ! System will show dependencies error and will not allow you to delete relationship. You need to removed the Lookup field first from Form.

You cannot delete a table in Dataverse if it has active relationships with other tables. Since TableB has a lookup to TableA (which is part of a one-to-many relationship), this relationship must be removed before TableA can be deleted.

This is a tricky question. I recreated the scenario and the very first thing that needs to be done is D. Remove the lookup field to TableA on the TableB form. However, after doing this you are still not able to delete TableA because the relationship dependency still exists, so you need to remove the relationship as well. So, if you think about what needs to be first, then the answer should be D.

The correct answer is A. The error mentioned in the question is related to the Power BI report. If TableA is being used in a Power BI report, that dependency should be removed first. This is because reports in Power BI keep an active reference to the tables involved. If the table is not removed from Power BI reports, you will not be able to remove it from Dataverse.

To delete TableA, you need to address the dependencies that are preventing its deletion. In this case, the most appropriate action is to remove the relationship between TableA and TableB. This will eliminate the dependency that TableB has on TableA, allowing you to delete TableA without errors. So, the correct answer is: B. Remove the relationship between TableA and TableB

C. Remove TableA from the unmanaged solution. Explanation: Since both TableA and TableB are components of an unmanaged solution, removing TableA from the unmanaged solution will remove any dependencies or references to TableA within the solution. This includes any references to TableA in the Power BI report as well as any relationships or lookup fields involving TableA. Deleting TableA directly from the unmanaged solution ensures that all associated components, such as the relationship with TableB and any lookup fields on forms, are also removed, allowing for the successful deletion of TableA from the Dataverse database.

I just tested it and you will have to remove the field from the form first to be able to delete the relationship then delete the table

Answer is D

D IS RIGHT

B should be

Just tested this out.. If you create Table A then Table B then immediately create a Lookup to Table A from Table B then a 1:N relationship is immediately created. Conversely, if you delete the relationship then the Lookup Column is also deleted allowing you to immediately delete Table A after

I think the answer is correct. Just by deleting the lookup feild from the Table B form doesn't ensure the deletion of Table A. Please note that the field is just removed from the form not from the Table B. Hence the final step is to delete the relationship. Additionally, you can't delete the relationship unless field is removed from the Table B form.

D seems good

D is correct answer, relationship not needed to be deleted. Removing the field alone solves the problem.

This question was on my 4/7/23 exam

The relationship (option B) will be automatically removed by the system when you delete the parent table. But the field must be removed from the form first.