Courseiva
Creating and customizing tables and dataeasyMultiple ChoiceObjective-mapped

SNOW-CAD Creating and customizing tables and data Practice Question

A company needs to create a lookup table to store status codes for incident classification. Which approach is best practice?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

Use a Choice field with the status codes and labels

Using a Choice field is standard for static lists. Option A is wrong because creating a table is overkill for simple lists. Option C is wrong because it loses referential integrity. Option D is wrong because creating a custom table with a reference field on the Incident table adds unnecessary complexity when a simple Choice field suffices.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Create a new table using the Label field type

    Why it's wrong here

    Label fields are for display only; they cannot store values used in conditions or reporting.

  • Use a Choice field with the status codes and labels

    Why this is correct

    Choice fields are built for simple, static lists and integrate well with reporting and UI policies.

  • Store the status codes as a single line of text field

    Why it's wrong here

    Free text fields allow inconsistent data entry and lack reporting capabilities.

  • Create a custom table with a reference field on the Incident table

    Why it's wrong here

    Creating a custom table with a reference field adds unnecessary complexity for a simple lookup; a Choice field is sufficient.

About these practice questions

This SNOW-CAD question is part of Courseiva's 481-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This SNOW-CAD practice question is part of Courseiva's free ServiceNow certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SNOW-CAD exam.