FC0-U71 Data and Database Fundamentals Practice Question
A ticket system logs a row for every check-in scan at an event gate, capturing the timestamp, gate identifier, and badge number. Staff want a quick daily count of scans per gate. Which statement about this data is most accurate?
⚠ Common exam trap
The trap here is classifying data by the data type of one field, such as a timestamp or a text code, instead of by whether records share a consistent defined structure.
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
✓
The scan log is structured data because each row follows a consistent set of defined fields
Each scan row uses the same defined fields, so the log is structured data and can be grouped and counted directly. Classifying data depends on whether records follow a consistent, defined organization, not on whether individual values happen to be dates or text.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The log is semi-structured because gate identifiers are text values
Why it's wrong here
Semi-structured data is characterized by self-describing organization, such as tagged or nested elements, not by the data type of a single field. A gate identifier stored in a defined column is ordinary structured data. The storage type of one attribute does not change how the overall record set is classified.
- ✓
The scan log is structured data because each row follows a consistent set of defined fields
Why this is correct
Every scan record uses the same named fields, so the data fits neatly into columns and can be grouped and counted directly. Aggregating scans by gate for a given day is a straightforward grouped count over that consistent structure, which is exactly what structured data supports well.
- ✗
The scan log is unstructured data because it contains timestamps
Why it's wrong here
Timestamps are highly structured values with a fixed format and defined ordering, not free-form content. The log rows have consistent, named fields such as timestamp, gate, and badge, which makes this structured data. The presence of a date or time value does not make data unstructured.
- ✗
Counting scans per gate requires converting the log to unstructured form first
Why it's wrong here
Moving consistent, column-aligned records into free-form content would destroy the very structure that makes grouping easy. A per-gate daily count is a grouping operation over defined fields, so the data should remain structured; converting it would add work and remove usable organization.
Go deeper
Related to this question
About these practice questions
Courseiva writes every FC0-U71 question from scratch — 988 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 and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official CompTIA exam blueprint
This FC0-U71 practice question is part of Courseiva's free CompTIA 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 FC0-U71 exam.