SNOW-CAD Creating and customizing tables and data Practice Question
A company needs to store data about employee certifications. Each employee may have multiple certifications. 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
✓
Create a new custom table with a reference field to the User table
Creating a new table with a reference field to the User table allows storing multiple certification records per employee without adding unnecessary fields. Option A is wrong because a multi-select field on the User table cannot effectively store multiple certification records and lacks relational integrity. Option C is wrong because extending the User table would add many unwanted fields from the User table and complicate data management. Option D is wrong because database views are read-only and cannot be used for storing data.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Add a multi-select field to the User table to store certification IDs
Why it's wrong here
A multi-select field is not designed to store multiple child records; it stores a list of values within a single field, which violates normal data normalization and makes querying difficult.
- ✓
Create a new custom table with a reference field to the User table
Why this is correct
A new custom table with a reference to the User table is the best practice because it allows multiple certification records per employee, avoids inheriting unnecessary fields, and maintains relational integrity.
- ✗
Extend the User table to store certification fields directly
Why it's wrong here
Extending the User table would add all fields from the User table to the certification record, many of which are unnecessary, and it does not allow multiple certification records per employee without additional workarounds.
- ✗
Create a database view that joins User and certification data
Why it's wrong here
Database views are read-only and cannot store data; they are used for querying and reporting, not for data persistence.
Go deeper
Related to this question
About these practice questions
Courseiva writes every SNOW-CAD question from scratch — 481 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
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.