CSA QUESTION i am confused between a and b option

sanasayyad
Tera Contributor

How would you describe the relationship between the Incident and Task table?

  1. Incident table has a one to many relationship with the Task table
  2. Incident table is extended from Task table
  3. Incident table is related to the Task table via the INC number
  4. Incident table has a many to many relationship with the Task table
  5. Incident table is a database view of the Task table
3 ACCEPTED SOLUTIONS

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @sanasayyad 

 

  1. Incident table is extended from Task table
*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

swapnali ombale
Kilo Sage

Hi @sanasayyad 

Option 2.Incident table is extended from Task table is correct

 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. 

View solution in original post

iekosmadakis
Mega Sage

Hello @sanasayyad!

The correct answer is the option #2: Incident table is extended from Task table.

 

Here is a brief explanation:

  • In ServiceNow the Task table is a base table used to standardize task-like records.

  • The Incident table is a child table that extends the Task table.

  • This means:

    • Incident inherits all fields and behavior from the Task table (e.g., assigned_to, priority, state).

    • It's part of the table hierarchy: Task > Incident.

    • Extension allows reusability and consistency across all task-based processes like Incident, Change, Problem, etc.

The other options are incorrect because:

  • "Incident table has a one to many relationship with the Task table" –> Not true; Incident is a type of Task, not related via a 1:N relationship.

  • "Incident table is related to the Task table via the INC number" –> INC number (number field) is just a unique identifier, not a relationship key.

  • "Incident table has a many to many relationship with the Task table" –> Incorrect; there is no M:N relation between Incident and Task. They are in a parent-child structure.

  • "Incident table is a database view of the Task table" –> No, Incident is a physical table extended from Task, not a view.

 

Please consider marking my answer as helpful and accepting it as the solution if it assisted you in any way.

View solution in original post

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @sanasayyad 

 

  1. Incident table is extended from Task table
*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

swapnali ombale
Kilo Sage

Hi @sanasayyad 

Option 2.Incident table is extended from Task table is correct

 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. 

iekosmadakis
Mega Sage

Hello @sanasayyad!

The correct answer is the option #2: Incident table is extended from Task table.

 

Here is a brief explanation:

  • In ServiceNow the Task table is a base table used to standardize task-like records.

  • The Incident table is a child table that extends the Task table.

  • This means:

    • Incident inherits all fields and behavior from the Task table (e.g., assigned_to, priority, state).

    • It's part of the table hierarchy: Task > Incident.

    • Extension allows reusability and consistency across all task-based processes like Incident, Change, Problem, etc.

The other options are incorrect because:

  • "Incident table has a one to many relationship with the Task table" –> Not true; Incident is a type of Task, not related via a 1:N relationship.

  • "Incident table is related to the Task table via the INC number" –> INC number (number field) is just a unique identifier, not a relationship key.

  • "Incident table has a many to many relationship with the Task table" –> Incorrect; there is no M:N relation between Incident and Task. They are in a parent-child structure.

  • "Incident table is a database view of the Task table" –> No, Incident is a physical table extended from Task, not a view.

 

Please consider marking my answer as helpful and accepting it as the solution if it assisted you in any way.