Question 209 of 300
hardmultiple choiceObjective-mapped

GCDL Practice Question: An architect is evaluating whether to use a…

This GCDL practice question tests your understanding of an architect is evaluating whether to use a…. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.

An architect is evaluating whether to use a relational database or a NoSQL database for a new application that must store product catalog data. Products have highly variable attributes — a book has ISBN, author, and genre; a bicycle has frame size, wheel diameter, and material. Which database characteristic makes NoSQL document databases advantageous for this use case?

Question 1hardmultiple choice
Full question →

An architect is evaluating whether to use a relational database or a NoSQL database for a new application that must store product catalog data. Products have highly variable attributes — a book has ISBN, author, and genre; a bicycle has frame size, wheel diameter, and material. Which database characteristic makes NoSQL document databases advantageous for this use case?

Answer choices

Why each option matters

Good practice is not just finding the correct option. The wrong answers often show the exact trap the exam wants you to fall into.

A

Best answer

NoSQL document databases support flexible schemas where each document can have different fields — making them well-suited for product catalogs where different product types have different attributes

Schema flexibility is the key advantage here. In a relational table, all rows share the same columns — a shared schema requires either many NULL columns (one per possible attribute across all product types) or complex entity-attribute-value designs. Document databases store each product as a flexible JSON document, accommodating variable attributes naturally without schema changes.

B

Distractor review

NoSQL databases are simpler to query because they don't require learning SQL

NoSQL query languages and APIs have their own learning curves. Some argue they're harder to query than SQL for complex filtering and aggregation. Query language simplicity is not the differentiating advantage for the product catalog use case.

C

Distractor review

NoSQL databases always provide faster query performance than relational databases for all use cases

NoSQL databases provide performance advantages for specific access patterns (key-based lookups, document retrieval) but are not universally faster than relational databases for all query types (especially complex joins and aggregations).

D

Distractor review

NoSQL databases support ACID transactions better than relational databases, making them safer for product catalog updates

Traditional relational databases have stronger ACID transaction support than most NoSQL databases. Some NoSQL databases (like Spanner, Firestore) now support transactions, but ACID strength is not NoSQL's primary advantage.

Common exam trap

Common exam trap: answer the scenario, not the keyword

Many certification questions include familiar terms but test a specific constraint. Read the exact wording before choosing an answer that is generally true but wrong for this case.

Technical deep dive

How to think about this question

This question should be treated as a scenario, not a definition check. Identify the problem, the constraint and the best action. Then compare each option against those facts.

KKey Concepts to Remember

  • Read the scenario before looking for a memorised answer.
  • Find the constraint that changes the correct option.
  • Eliminate answers that are true in general but not in this case.
  • Use explanations to understand the rule behind the answer.

TExam Day Tips

  • Underline the problem statement mentally.
  • Watch for words such as best, first, most likely and least administrative effort.
  • Review why wrong options are wrong, not only why the correct option is correct.

Key takeaway

Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Related practice questions

Related GCDL practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

More questions from this exam

Keep practising from the same exam bank, or move into a focused topic page if this question exposed a weak area.

Practice this exam

Start a free GCDL practice session

Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.

FAQ

Questions learners often ask

What does this GCDL question test?

Read the scenario before looking for a memorised answer.

What is the correct answer to this question?

The correct answer is: NoSQL document databases support flexible schemas where each document can have different fields — making them well-suited for product catalogs where different product types have different attributes — NoSQL document databases (like Firestore, MongoDB) store each record as a self-describing document (JSON) rather than rows in a fixed schema table. This allows different documents to have different fields — a book document has ISBN and author; a bicycle document has frame size and material — without needing schema changes or NULL values for missing attributes. This schema flexibility is NoSQL's primary advantage for variable-attribute product catalogs.

What should I do if I get this GCDL question wrong?

Identify which GCDL exam domain this question belongs to, then review the specific concept being tested. Practise related questions in that domain and focus on understanding why each wrong answer is tempting — not just why the correct answer is right.

About these practice questions

Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Discussion

Loading comments…

Sign in to join the discussion.

This GCDL practice question is part of Courseiva's free Google Cloud 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 GCDL exam.