NoSQL databases

BDPC · 30 questions

• A city's citizen-profile service keeps adding optional attributes for new programs, and rigid relational migrations delay each release. Which approach best fits this evolving, high-scale profile data?
• A municipal finance office must post multi-row ledger entries that either all commit or all roll back across related accounts. Which store is the most appropriate primary system?
• A multi-region 311 status store must keep serving during network splits, yet operators also want strong consistency everywhere. What does the CAP theorem imply for this design?
• During a WAN blip between regions, a public city status page should keep answering rather than go dark, even if some counts are briefly stale. Which CAP-oriented choice fits best?
• Ballot tabulation mirrors across election sites must never display conflicting totals to the public. Under a network partition, which consistency stance is most appropriate?
• Which set of traits best characterizes many NoSQL systems used for municipal Big Data workloads?
• A city mobile app needs to look up session tokens quickly using only a session id. Which NoSQL type fits this access pattern best?
• Permit applications arrive as nested JSON-like records with sections that differ by permit type. Which NoSQL type is the best fit for storing these semi-structured civic records?
• Utility meter readings stream in as write-heavy time-series appends that grow sparse columns over long periods. Which NoSQL family is typically suited to this pattern?
• An integrity office wants to explore how vendors, contracts, and employees connect when hunting fraud rings. Which NoSQL type best supports relationship-centric queries?
• One digital-city program stores citizen profiles as documents, fraud links in a graph, and hot session data in a key-value cache. What persistence approach does this illustrate?
• Which description best matches Apache Cassandra as commonly presented in Big Data NoSQL syllabi?
• After a citizen updates a profile, two readers briefly see different versions before the system converges. What NoSQL behavior does this illustrate?
• A smart-city IoT desk lands varied sensor payloads whose shapes keep changing and cannot wait for one universal upfront schema. Which approach aligns best?
• Analysts still run SQL-like Hive queries over lake data that also feeds a NoSQL serving tier for the citizen portal. What role does Hive play in this syllabus-style framing?
• Data engineers use Pig scripts to cleanse and reshape municipal feeds before loading them into NoSQL stores. How is Pig best characterized in this framing?
• Millions of parking-meter heartbeats arrive each hour and overwhelm a single primary database writer. Which NoSQL-oriented strategy best addresses this write pressure?
• Developers assume they can filter a civic NoSQL store on any field as freely as a normalized SQL database. What caution should the architect emphasize?
• The citizen portal is served from NoSQL, but planners need heavy multi-year group-by analytics across all districts. Where should those analytical aggregations typically run?
• Operators place a Redis-like key-value cache in front of citizen profiles to speed reads. What must they remember about that cache tier?
• Engineers are modeling citizen timeline documents for a NoSQL store. Which modeling principle should guide the design?
• A regional NoSQL cluster for emergency services must survive the loss of one datacenter site. What architecture theme does this requirement highlight?
• Transient traffic incidents should disappear from a hot operational store after a set period without manual cleanup jobs. Which NoSQL operational feature fits this need?
• A budget office needs complex multi-table joins across funds, vendors, and appropriations for mandatory financial reports. Why is a typical NoSQL document or KV store often a poor primary fit?
• Cluster operators want stricter consistency for ballot-status reads but looser consistency for anonymous traffic-map pings. What NoSQL concept enables that per-request-class choice?
• A parks department must store photo metadata, free-form tags, and view counters for each trail report in one flexible record instead of rigid columns. Which approach best fits this variety?
• A city wants high-scale citizen profile lookups in NoSQL but must keep tax billing in a relational system with strong ACID controls. What migration pattern fits?
• Several towns share one managed NoSQL service for 311 case documents. How should the platform isolate each town’s data at a basic tenancy level?
• During a festival, almost every write for a street-closure feed uses one popular event id as the partition key and one shard saturates. What problem is this?
• A transit desk uses Spark and Kafka to refresh arrival estimates every few seconds, then riders query those estimates through a fast document store. What role is NoSQL playing?