Exam PL-200 topic 9 question 5 discussion

I am thinking A. B. You can't sum with a calculated column and it can only use fields on the same record or a direct parent. That random generated number bit, it could generate a low or high number everytime, its random, not gong to guarantee a even spread. C. Randomly generate a number again, no guarantee that number will be will be less than 10% of the total 10% of the time. D. Wrong table.

The answer is A. The requirement is for 10% of Qualification records, not Service Request records. The other three options are based on the wrong table.

To assign 10 percent of the Qualification records to the QV queue through table configuration by using a Power Automate flow, you should: A. Create an autonumber column on the Qualification table and assign its qualification records if the number cleanly divides by 10. This approach ensures that exactly 10 percent of the records are assigned based on a simple and deterministic rule. Here’s how it works: Create an Autonumber Column: Add an autonumber column to the Qualification table. This column will automatically generate a unique number for each record. Power Automate Flow: Create a Power Automate flow that triggers when a new Qualification record is created. In the flow, check if the autonumber value for the record cleanly divides by 10 (i.e., the remainder is zero). Assign to QV Queue: If the condition is met, assign the record to the QV queue. This method is straightforward and ensures that approximately 10 percent of the records are consistently assigned to the QV queue.

I believe it is A as well. Option C involves creating a roll-up column on the Service Request table to count qualification records and then generating a random number to assign records. While this approach could work, it introduces additional complexity and dependencies on the Service Request table, which might not be necessary. Option A, creating an autonumber column on the Qualification table and assigning records based on whether the number cleanly divides by 10, is simpler and more direct. It ensures that approximately 10 percent of the records are assigned without needing to generate random numbers or rely on roll-up columns.

while Option C is technically feasible, Option A is more straightforward and better suited for consistently achieving the requirement of assigning 10 percent of the Qualification records. Therefore, Option A remains the more appropriate choice.

Seems A

As i am from Switzerland, maybe i have difficulties with english grammar but when i read 'C. Create a roll-up column on the Service Request table that is the count of qualification records, generates a random number between zero and the number from the new field, and assigns each qualification record if the number generated is 10 percent or less of the value of the new field.' 'assignS' has raised my attention. What assigns? If i understood it correctly (maybe someone does a linguist course here?) 'assigns' refers to 'a roll-up column' that 'assignS' but no, roll-up columns cannot assign. as i read it: 'a roll-up column' ... ''that is the count of...', --> true 'a roll-up column' ...'that generates a random number...' --> true 'a roll-up column' ...' that assignS' --> false!! if ever, I am right (gpt seems to confirm it, but gpt is excessively opportunistic ...), we can rule out C as a possible correct result?!

for B and C: complexity and potential inconsistency in ensuring that an exact 10% of Qualification records are randomly selected for review. is it more important to be random or is it more important to be exactly 10% (what if you have 235 records with selecting every 10th record it isn't 10% either..)

In the exam 28/Dec/2023

Roll-up columns can do sum, min, max etc and In Power Automate, you can use the rand function to generate a random number between two specified values.

On test 5/23

A is wrong as it wouldn't be random 10% it would just be exactly every 10th record which is not a very 'professional / scientific' way of checking things. You need to do things randomly which what answer C does if you work through it's formula.

B. Create a calculated column on the Service Request table that sums the number of qualification records, generates a random number between zero and the number from the new field, and assigns each qualification record if the number generated is 10 percent or less of the value of the new field.

A can not be accepted due to following reasons. 1. Auto number is not consistent always (if you delete records) 2. The calculation is mathematically wrong for the given requirement

I choose A.

A is correct

For me it's also A