PL-600 – Question 22


Question 22

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.

A. Mark the hex value column as business required.
B. Configure and schedule a recurring bulk record deletion job.
C. Create alternate keys for the table.
D. Mark the RGB value column as business required.

Correct Answer: AC