Microsoft PL-600 Exam - Topic 7 Question 29 Discussion

Actual exam question for Microsoft's PL-600 exam

Question #: 29
Topic #: 7

[All PL-600 Questions]

You are designing a database table for a client.

You have the following requirements:

Maintain a comprehensive list of colors and their corresponding RGB values and hexadecimal values.

Prevent the addition of duplicate colors based on the hexadecimal value for the color.

You need to recommend a design for the table.

Which two actions should the client perform after the table is created? Each correct answer presents part of the

solution.

NOTE: Each correct selection is worth one point.

AMark the hex value column as business required.

BConfigure and schedule a recurring bulk record deletion job.

CCreate alternate keys for the table.

DMark the RGB value column as business required.

Show Suggested Answer

Suggested Answer: B, C

B: Setting a column to Business Required means that the default behavior of a model-driven or canvas app will enforce this requirement in the app.

C: With alternate keys you can now define a column in a Dataverse table to correspond to a unique identifier (or unique combination of columns) used by the external data store. This alternate key can be used to uniquely identify a record in Dataverse in place of the primary key. You must be able to define which columns represent a unique identity for your records. Once you identify the columns that are unique to the table, you can declare them as alternate keys through the customization user interface (UI) or in the code.

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-field-portal

https://docs.microsoft.com/en-us/powerapps/developer/data-platform/define-alternate-keys-entity

by Janey at Aug 22, 2022, 03:47 PM

Limited Time Offer

25%

Off

Get Premium PL-600 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Catina

4 months ago

Are we sure marking RGB as required is needed? Feels a bit off.

upvoted 0 times

...

Colette

4 months ago

Agreed, no duplicates means hex should be required!

upvoted 0 times

...

Dong

4 months ago

Wait, why would you need a bulk record deletion job? Seems unnecessary.

upvoted 0 times

...

Erasmo

4 months ago

I think creating alternate keys is a must too.

upvoted 0 times

...

Helga

5 months ago

Definitely mark the hex value column as business required!

upvoted 0 times

...

Cheryl

5 months ago

I’m a bit confused about the bulk record deletion job; I don’t see how that fits into this scenario.

upvoted 0 times

...

Bobbye

5 months ago

I practiced a similar question where we had to enforce uniqueness, so I feel like option C might be the right choice.

upvoted 0 times

...

Marya

5 months ago

I'm not entirely sure about creating alternate keys, but I remember it being important for preventing duplicates.

upvoted 0 times

...

Wilbert

5 months ago

I think marking the hex value column as business required makes sense to ensure we always have that data.

upvoted 0 times

...

Yoko

5 months ago

Okay, I think I've got a good strategy here. Pub/Sub and Dataflow seem like a solid approach to handle the high volume and process the votes efficiently. And using Bigtable for real-time results is a nice touch.

upvoted 0 times

...

Eleni

5 months ago

This seems like a straightforward question. I'd recommend going with Azure DevOps since it's a comprehensive platform for managing the entire software development lifecycle, including tracking test steps.

upvoted 0 times

...

Mabel

5 months ago

This one seems tricky. I'll need to carefully review the partnership agreement details and the concept of apparent authority to figure out the best approach.

upvoted 0 times

...

Adria

5 months ago

Hmm, I'm not totally sure about this one. I know SMED has something to do with lean manufacturing, but I can't remember the exact definition. I'll have to think it through carefully.

upvoted 0 times

...