Exam PL-900 topic 1 question 125 discussion

I think this should be: Entity (because question says it cannot be part of Account or Contact table) Field Option Set (because question says be able to pick from 10 insurance companies)

to store a new doctor profile, - this should be record (this is because it will take more than one field to store all the info about one doctor) 2. to store the doctor's specialty - this should be Field instead. (because it is one column or field that will hold that info amongst the doctors record) 3. Option set or (choice) new term for Option set

It should be Entity (table), Field (column) and OptionSet. Verified in Exam on 16/04/2025.

Store additional doctor profile data: Entity: Create a new entity to store the doctor profile data that is not part of the account table or the contact table. Store information about the doctor’s specialty: Field: Add a new field within the entity to capture the doctor’s specialty. Select an insurance company: Option set: Use an option set to allow users to pick one of the 10 different insurance companies.

1. Record 2. Field 3. Option

My understanding: 1. Entity - Store additional doctor profile data. Entity is "A set of records used to store data" and in question there is "a place to enter doctor profile data that is not part of the account table or the contact table". So we need a separate place to store set of records. Even if we write all new data in one Record, this Record can not be part of existing tables, according to question. So I go with Entity. 2. Field - Store information about the doctor's speciality In question there is "a place to enter the doctor's specialty in the profile form". So each doctor have only ONE speciality and this data can be a part of existing tables. Record could be used (A record contains one or more categories of information), but you must always pick THE BEST option. So Field will be enough. 3. Option set - Select an insurance company According to question "a column for insurance with the ability to pick one of 10 different insurance companies". So, we have to prepare predefined list of options. So Option Set is the only pick.

Store additional doctor profile data. -> Entity Store information about the doctor’s specialty. -> Field Select an insurance company. -> Option set

For A I would create a new entity as the question says that the doctor profile is not part of either account or contact table. I would later create 1:N relationship b/w Doctor Profile and Contact entity.

Field/Record/Option Set

On Exam 12/16/2022. I passed with 896.

1. Field: Note that the question is on additional doctor profile data. Doctor's profile already exists as a record. You may only add fields to that record. He is not a new doctor. 2. Record. In a relational database this will be an ENTITY related to the doctor's profile with the Doctor's unique identity (Primary Key). But notice that the question says 'a place to enter the doctor's specialty in the profile form'. In System Analysis and Design, this is an area/block on a form/screen dedicated to capturing or maintaining doctor's specialty information which could be one or more fields (Record) that completely describes a doctor's specialty. 3. Option Set. Remember 'a column for insurance with the ability to pick one of 10 different insurance companies'. 10 is total no. in the Option Set simple.

1. Field: Note that the question is on additional doctor profile data. Doctor's profile already exists as a record. You may only add fields to that record. He is not a new doctor. 2. Record. In a relational database this will be an ENTITY related to the doctor's profile with the Doctor's unique identity (Primary Key). But notice that the question says 'a place to enter the doctor's specialty in the profile form'. In System Analysis and Design, and area/block on a form/screen dedicated to capturing or maintaining doctor's specialty information which could be one or more fields (Record) that completely describes a doctor's specialty 3. Option Set. Remember 'a column for insurance with the ability to pick one of 10 different insurance companies'. 10 is total no. in the Option Set simple.

no one knows what is the correct answer. This site is not reliable

Considering these are all old terms (see here https://docs.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-intro#terminology-updates), I would go for: Record (aka Row) Field (aka column) Optionset (Aka Choice)

Question has "what should you use to store data" hence i go for Entity, Field and Record

Additional doctor profile data should be stored in Account or Contact table, therefore it should be filed(s) However, specialty is also additional info about the doctor and can also be stored as field in Account or Contact table. If so, the question needn't explicitly describe Specialty besides additional info. So I guess, the question means another table only used for doctor's specialty. Then a record makes sense. It is really hard to understand PL900 questions wording...Sounds like the guy who made these questions has a lot hidden information in his mind but he is reluctant to write them out assuming everyone knows his intention.

In exam today 11/04/2022 Record - 'Additional' doctor profile data, can't be entity Field - Single text Option Set - Optional data