CIMP practice questions
eLearningCurve · CIMP · 300 questions
Original practice questions for the eLearningCurve Certified Information Management Professional (CIMP) exam, covering data quality, data governance, master data management, metadata management, data architecture, and data analysis.
This course contains the use of artificial intelligence.
About the CIMP exam
This credential is earned across several exams rather than in one sitting, so there is no single cost, duration or question count to quote.
- Format
- Track-based certification - several exams, not one sitting
Track requirements at the vendor
Exam details published by the vendor, checked 25 August 2026. Vendors change fees and formats without notice — confirm on the vendor's own page before you book.
Practice Quizzes
Test your knowledge with standard 20-question practice sets.
Quiz 1
Quiz 2
Quiz 3
Quiz 4
Quiz 5
Quiz 6
Quiz 7
Quiz 8
Quiz 9
Quiz 10
Quiz 11
Quiz 12
Quiz 13
Quiz 14
Quiz 15
Browse by Domain
Study specific topics at your own pace.
Data Quality · 50 questions
- A county assessor finds parcel records with blank owner names in a required field used for tax notices. A clerk calls it 'incomplete paperwork' and wants to ignore it. How should the information manager treat the blanks?
- A city utility customer information system shows two different account balances for the same customer depending on which screen staff open. What data quality concern does this primarily illustrate?
- A public-health registry contains rows where the recorded birth date falls after the recorded death date. Which data quality issue do these rows primarily demonstrate?
- A municipal permitting office needs yesterday's permit volume for a 9 a.m. council briefing, but the warehouse batch that normally loads overnight finished six hours late. How should timeliness be judged in this situation?
- A transit authority CRM lists the same rider under three slightly different names and phone formats. What data quality problem does this primarily represent?
- A library consortium asks why 'data quality' means more than running a spell-check on free-text notes. Which statement best captures the practitioner definition?
- A township finance lead assumes poor data quality is always caused by careless clerks. What should an information manager emphasize instead?
- A city launches a new online form that silently truncates long street names to fit a short database field. What does this scenario primarily illustrate?
- A county merges two departments' spreadsheets without a shared definition of 'active client.' What is the most likely data quality cause of the resulting inconsistencies?
- A parks department dashboard looks correct until staff learn that 'open work orders' intentionally excludes closed-but-unverified jobs by documented business rule. How should an information manager classify this situation?
- A municipal GIS team runs frequency counts and null rates on a new parcel extract before trusting it for mapping. What is the primary purpose of this statistical profiling?
- A clerk charts value distributions for a sample of addresses and immediately spots impossible ZIP codes. Which technique is the clerk primarily using?
- Before writing automated rules, a DQ analyst samples free-text 'issue type' fields and finds twenty synonyms for the same complaint. What practice does this illustrate?
- A county wants every parcel ID to match an established cadastral pattern. Which family of data quality rules does this requirement represent?
- A utility requires that every meter reading reference an existing meter ID in the asset register. Which type of data quality rule is this?
- Analysts cannot use a 'priority' field because half the values are blank and the other half are inconsistent free text. Which quality criterion family is most directly at stake for consumers?
- A municipal risk score systematically under-represents rural ZIP codes because source coverage is uneven across the county. At information-management practitioner depth, what quality concern does this raise?
- A DQ lead publishes a monthly red/yellow/green scorecard by domain for the CIO. What is the primary role of such a scorecard?
- An issue queue shows the same address defect opened twelve times by different teams. What should structured DQ issue management emphasize?
- Nightly jobs keep cleansing bad ZIP codes, yet the source CRM continues generating the same errors. What should the DQ approach prioritize?
- A city wants 'quality by design' in a new permitting workflow. Which approach best matches that goal?
- After a data integration job, orphan foreign keys spike in a municipal case-management warehouse. What does this primarily indicate?
- A DQ specialist proposes thresholds and named owners for each critical data element. What program practice does this exemplify?
- SPC-style control charts on daily null rates show a sudden shift immediately after a public form change. How should the team interpret this monitoring signal?
- A city council asks whether making data more 'accurate' always makes it more 'complete.' What is the sound information-management answer?
- Permit clerks export license rows to a spreadsheet, fix misspelled business names locally, and never write the corrections back to the licensing system. What data-quality anti-pattern is this?
- A vendor inventory feed passes every format check, yet every unit code is systematically the wrong UOM for the city's warehouse system. What quality distinction should the analyst make?
- A county clinic must submit immunization records to the state and needs data-quality rules for required shot fields. How should those rules be chosen?
- A DQ dashboard shows 99% complete phone fields for utility customers, but half the values are placeholders like 000-0000. What measurement pitfall does this illustrate?
- A remediation sprint cleans years of bad address rows in the property system but leaves the capture form free-text and unconstrained. What outcome should the program expect?
- After a case-management upgrade, old-to-new status crosswalk tables were never maintained, so reports mix retired and current codes. What integrity failure is this?
- A city's DQ charter lists critical data elements for billing, safety alerts, and regulatory reports—not every column in every system. What prioritization principle is being applied?
- Profiling of 'household size' on housing applications shows multimodal spikes at 0 and 99. How should the DQ analyst interpret that signal?
- Executives ask for one enterprise 'data quality score' that rolls every domain into a single number. What caveat should the DQ lead raise?
- A nightly job 'fixes' organization names by Title-Casing every token, which breaks legitimate acronyms such as HUD and FEMA. What DQ lesson applies?
- HR insists a null middle name is a defect; permitting staff say it is fine. How should the DQ team settle whether the null is defective?
- A parks department is onboarding a new SaaS reservation tool, and the contract has no data-quality acceptance criteria for inbound feeds. What quality-by-design gap exists?
- Root-cause analysis on wrong fee codes finds training gaps and ambiguous UI labels—not a database constraint bug. What should the team conclude?
- Daily DQ dashboards turn red when thresholds fire, but nobody is on-call and no playbook assigns owners. What management failure is this?
- Before a tax-system go-live, the migration team wants to 'clean everything' with no prioritization under a hard cutover date. What approach should the DQ lead urge?
- IT proposes a reusable address standardization service that many civic apps will call at capture time. How should this be framed in a quality-by-design program?
- An analyst claims that running profiling tools equals having a data-quality program. What distinction should leadership make?
- Seasonal building-permit spikes create temporary completeness dips that trip a static DQ threshold every spring. What measurement design change is needed?
- Clerks type fee amounts into a free-text 'notes' field because the fee field is locked, then finance scrapes those notes for billing. What anti-pattern is this?
- After a GDPR-style minimization project, several analytics fields were dropped—improving privacy but breaking completeness for a legacy grant report. What should the program do?
- A DQ assessment lists defects by system, owner, and recommended control. How should leadership treat that report?
- A deduplication tool's match confidence scores are used to auto-merge citizen records with no business review, including near-threshold matches. What practice should DQ insist on?
- The CIO wants 'one number' proving data-quality ROI for the next budget cycle. How should the DQ lead communicate value?
- A team debates whether machine learning can replace data-quality rules entirely for permit and billing constraints. What balanced stance fits modern DQ practice?
- When a verified fix lands, what closed-loop remediation practice should the issue workflow enforce?
Data Governance · 50 questions
- A city manager asks whether standing up data governance mainly means buying a catalog tool. How should the information management lead define data governance?
- A county board wants a data governance program after hearing conference slogans that 'data is the new oil.' What business rationale should the DG lead emphasize instead?
- Two agencies share a client index but never agreed who owns definitions and quality expectations. Which governance gap should they close first?
- Department heads appoint data stewards by name but allocate no hours for stewardship duties. What does this reveal about the stewardship model?
- A draft policy bans all cloud storage with no exceptions process. What policy-design problem should the governance council flag?
- Leaders treat a one-project warehouse steering committee as the organization's data governance council. What distinction should the IM lead draw?
- Executives sponsor a data governance kickoff then disappear from subsequent forums. Which success factor is missing?
- Staff describe data governance as 'the data police' and resist engagement. What cultural approach should the program take?
- A team skips a privacy review because the personal data will only be used internally. What should governance require?
- Retention schedules exist on paper, yet production systems never delete or archive expired records. What gap should DG close?
- A resident asks what personal data the city holds about them. Which governance capability should respond?
- A proposal would reuse school free-lunch eligibility lists for unrelated city marketing outreach. Beyond checking a legal checkbox, what should data ethics guidance emphasize?
- A RACI for critical data elements leaves the Accountable cell blank for three systems. What design flaw does this create?
- IT is about to approve a new SaaS that creates another customer master with no integration plan. How should data governance influence the intake?
- A cataloging project auto-scrapes technical schemas but assigns no ownership for business glossary terms. What balance should the team restore?
- Program metrics celebrate how many policies were published, ignoring adoption and defect trends. What measurement shift should leadership make?
- The city proposes organizing stewardship around data domains such as customer, location, and asset. What operating-model idea does this apply?
- Security demands lock-down of all datasets while analysts need broader access for service insights. How should governance mediate?
- Consultants urge a small town to copy a large bank's full governance operating model unchanged. What principle should the town apply?
- Stewards escalate issues ad hoc because no path from steward to domain owner to council is defined. What governance design element is missing?
- A quality policy states that 'all data must be perfect' with no thresholds or measures. How should DG improve the standard?
- Council KPIs are pulled from unmanaged shadow spreadsheets instead of known systems of record. What should data governance require?
- New employees never receive data-handling expectations during onboarding. Which culture control should the program add?
- Two agencies share data without agreements on permitted use, quality expectations, or privacy constraints. What artifact should governance require?
- Council asks data governance to 'guarantee AI is safe' while the city still lacks a data inventory and quality baselines. What scoping response is appropriate?
- A city data council debates whether business stewards or technical stewards alone can own parcel-attribute quality. What should the council recognize?
- A department director verbally waived a retention rule for a one-off research extract, and months later no one can prove what was allowed. What should governance require for exceptions?
- An agency still fights daily data fires with unclear ownership, yet a consultant proposes enterprise-wide federated governance platforms first. How should leaders sequence the work?
- Workshops teach staff how to read dashboards, but creators still enter incomplete case fields with no training. What literacy gap remains?
- The agency published public, internal, and confidential labels, but systems still treat every field the same. What is missing?
- Business units want local flexibility, while enterprise risk needs common guardrails. Which governance pattern fits?
- After a major permitting system replacement, auditors find access and retention policies still describe the retired platform. What operating practice was missing?
- Cleaner parcel-owner addresses cut returned mail and failed foreclosure notices. How should the governance team frame this outcome?
- Utility outage systems hold wrong emergency contact numbers for critical facilities. How should governance prioritize?
- Cross-department working groups discuss standards weekly, yet no body can approve a conflicting definition. What structural gap exists?
- Metadata stewardship is assigned, but no role owns physical deletion when retention expires. What accountability gap should leaders close?
- A quick-win data catalog launches, but users who spot bad values have no path into the data-quality issue process. What integration is missing?
- Departments refuse to share glossary definitions, fearing loss of control over “their” data. What should the deploy approach emphasize?
- Leaders want enterprise-wide governance in the first quarter across every dataset. What success factor should temper that plan?
- Counsel asks which reports and datasets fall under a new state privacy act. What prerequisite must governance complete first?
- Privacy leads propose a register of higher-risk data processing activities for resident casework systems. What practice does this support?
- Staff are unsure whether the ethics board or the data governance council decides a disputed algorithmic scoring use case versus a routine field standard. What should leaders clarify?
- A team installs a free website analytics plugin that sends resident interaction data to a vendor, skipping data-processing agreement review. What governance expectation applies?
- The program dashboard currently shows only training-seat counts. Which operating metric better indicates governance health?
- Teams request new data products through informal chats, causing surprise compliance gaps. What enablement practice helps?
- Several local governments will share a regional homeless-services dataset. What sharing-governance control is most essential?
- A breach tabletop drill shows unclear ownership for external communications and evidence preservation. What should governance strengthen with security and legal?
- Finance, sales, and service each use a different definition of “active customer,” breaking executive metrics. What should governance do?
- A temporary task force writes twenty policies in a month, then disbands with no owners for reviews or exceptions. What lesson applies?
- Before buying additional governance tools, what foundational sequence should the program complete?
Master Data Management · 50 questions
- A city IT lead claims every table in the permitting database is master data because staff reuse those tables often. Which distinction should the information manager make?
- Permit, licensing, and inspection systems each store slightly different spellings and tax IDs for the same contractor companies, causing wrong notifications and duplicate vendor payments. What problem does this primarily motivate?
- Multiple municipal systems need read access to a trusted golden customer record, while local updates are reconciled centrally before republishing. Which architecture pattern best fits this requirement at a conceptual level?
- A county proposes an MDM style that only indexes pointers to resident records in source systems and does not materialize a composed set of attributes. How does this differ from a consolidation approach?
- Utility billing, CRM, and field-service apps will keep local customer copies, while an MDM layer synchronizes a defined set of critical shared attributes. Which pattern is being applied?
- Two resident rows show 'Jon Smith' and 'John Smith' at the same address with the same phone number. What should matching capability primarily accomplish?
- Before comparing parcel and mailing addresses for resident matching, the team breaks street lines into house number, street name, and unit. Why is that step important?
- CRM shows one email for a taxpayer while billing shows a different email for the same matched person. What should survivorship design do?
- An aggressive auto-merge collapses two different residents who share a common name into one golden person, mixing their benefit histories. What risk does this illustrate, and what control helps?
- Match rules are so strict that true duplicate customer rows never merge, leaving fragmented service history across systems. What does this situation represent?
- An MDM platform is live, yet conflict queues stall because no one is accountable for approving match and survivorship decisions. What role is missing?
- A municipality wants MDM for every entity at once—parties, assets, vendors, employees, and more—before any domain is mastered. What sequencing guidance fits best?
- A project team labels permit-type code lists as 'master data' in the same sense as contractor and parcel entities. What distinction should be clarified?
- After a trusted golden resident record is published to the call center, agents resolve more issues on the first contact without hunting across systems. What does this outcome demonstrate?
- For the same property party, the assessor system is trusted for legal owner name while CRM is trusted for contact preference. What survivorship principle applies?
- A service desk needs to recognize returning residents during the call, but party matching only runs in a weekly batch. What architectural concern does this raise?
- Before writing party match rules, analysts profile name fields and find heavy nickname use, missing middle initials, and inconsistent suffixes. Why does that profiling matter for MDM?
- A city plans multi-domain MDM covering party, location, and asset but only designs isolated golden records with no links among them. What is missing?
- Fraud and audit teams need prior resident addresses after a move updates the golden record. What MDM design requirement should be included?
- Architects debate issuing a new surviving enterprise party ID versus keeping each source key and maintaining a crosswalk. What is the sound guidance?
- Matching discussions contrast a stable business license number with an internal surrogate database key that resets when systems are rebuilt. What principle should guide the team?
- A utility proposes 'householding' accounts that share a service address for marketing and outreach, separate from legal person entities used for contracts. What clarification is needed?
- Clerical staff can propose resident merges, stewards must approve them, and only then does the MDM system execute the merge. What does this workflow emphasize?
- The MDM team plans to call an external address-validation service to standardize locations before matching. What implementation stance is appropriate?
- Leadership funds an MDM product install with no business workshops on match or survivorship rules, treating the effort as a pure IT deployment. What outcome is most likely?
- A city MDM program wants operational KPIs that show whether matching and golden records are improving. Which metric set best fits that goal?
- Canonical model debates keep delaying the first MDM go-live across every enterprise entity type. What delivery approach should the program favor?
- Clerks enter free-text company names that mix legal names, trade names, and noise tokens, so organization matching fails. What should MDM implement first for reliable matching?
- Two golden records appear for the same branch because legacy regional codes differ. How should matching be redesigned?
- Stewards merge two parties and later prove the merge was wrong. What capability must the MDM design provide?
- A municipality needs a trusted catalog of fees and services used across permitting and billing. How should MDM thinking apply?
- Emergency routing depends on the location master, and wrong geocodes have delayed responses. What should the program do?
- Downstream systems need master changes within minutes, while a reporting warehouse can wait overnight. How should master distribution be designed?
- A billing app silently overwrites mastered address attributes with local edits. What consumption rule should governance enforce?
- An initial MDM load floods the match queue with years of historical duplicates. What should the implementation plan include?
- Consolidating citizen personal data into a golden hub concentrates privacy risk. What control change is most appropriate?
- Leadership wants to buy an MDM platform before domains, match rules, or success metrics are defined. What sequencing should the candidate recommend?
- Business licenses must attach to legal entities while inspections occur at branch locations. What MDM modeling need does this create?
- Leadership proposes timing stewards only on how fast they clear match suspects. What measurement approach is more sound?
- After merges, legacy systems still need their original keys to keep integrations working. What identifier practice should MDM retain?
- A peer city shares fuzzy-match thresholds that look convenient to copy unchanged. What should the MDM team do before production use?
- Teams still treat local spreadsheets as the real customer list after the hub goes live. What adoption action best addresses the bypass?
- Only a shared core of party attributes should be mastered, while volatile order details stay in transactional systems. Which retrieval pattern fits?
- The data governance council is standing up MDM for the party domain. What ownership action should it take?
- Citizen names in a multilingual community are often spelled inconsistently across systems. Which matching technique belongs in the toolkit?
- Survivorship must keep the oldest account-open date but the newest verified email when records merge. What rule design is required?
- Retired master records are subject to retention schedules and legal holds. How should deletion be handled?
- Match thresholds are about to freeze for production. What testing step should precede that decision?
- Leaders ask how to prove address mastering helped residents. Which KPI best shows outside-in outcome value?
- After the first cleanse, sponsors treat MDM as finished. How should the roadmap be framed instead?
Metadata Management · 50 questions
- A new analyst cannot tell which field means "active permit" across five city systems. What should the information-management team prioritize first?
- A permitting director asks what "active" means for a license, while a DBA asks which tables and ETL jobs store that status. Which distinction should the metadata lead draw?
- A council dashboard for water-main breaks looks fine, but analysts do not know when it last refreshed or how many rows loaded. What metadata category fills that gap?
- Before a bond presentation, leadership asks which source systems feed the "water main breaks" KPI. Which metadata practice answers that origin question?
- A municipal data catalog was populated last year, but many entries are stale and unused. What is the most likely missing practice?
- A city wants models for permitting: business concepts first, then normalized attributes and keys, then tables and indexes. Which sequencing of model levels is correct?
- Parks and Public Works both publish conflicting glossary definitions for "asset." Catalog searches return both and confuse staff. What should happen next?
- An auto-harvested catalog lists tables and columns for housing data but lacks owners, business tags, and plain-language descriptions. What should the team add?
- IT plans to change values in a shared municipal code table used by many applications. What should precede the change?
- A civic analytics team wants to explore how people, parcels, and permits connect for investigation—not only query one table at a time. At awareness depth, what approach highlights those relationships?
- A catalog audit finds missing owners, empty descriptions, and broken lineage links. How should the team treat this finding?
- Security wants consistent handling of sensitive resident fields discovered in the catalog. Which metadata practice best enables that?
- Before designing database tables for a civic asset register, what modeling step should come first?
- After years of production hotfixes, the physical permitting schema no longer matches the approved logical model. What does this signal?
- Analysts abandon the catalog because they must guess technical table names. What design change most improves adoption?
- Lineage shows source-to-target tables for a finance extract, but transformation logic is undocumented. What is the primary risk?
- A modern metadata platform can notify stewards when a production schema changes unexpectedly. What capability is that demonstrating?
- Staff still search for "occupancy" while the official term is now "vacancy status," and an old synonym remains unmarked. What should stewards do in the glossary?
- Profiling shows high null rates on a "parcel owner contact" field. Where should that fitness signal appear for consumers?
- A data product for emergency shelter occupancy promises hourly refresh and 99% uptime. Where should those consumer expectations be registered?
- Vendors are pitching catalog platforms before the city has named metadata use cases or owners. What sequencing should the program follow?
- Housing systems disagree on what "vacancy status" means, blocking shared reporting. What metadata-and-modeling response is most appropriate?
- Technical metadata harvest is noisy because tables and columns follow inconsistent naming across departments. What hygiene practice helps most?
- Business stewards need to edit glossary definitions, while engineers maintain harvested schema docs. How should edit rights be set?
- A regulatory report requires proving which source columns feed each disclosed figure. Table-level lineage alone is available today. What should the team conclude about granularity?
- A city analytics onboarding checklist teaches new analysts SQL but never shows the data catalog or business glossary. What metadata-literacy step should the information management lead add?
- A municipal catalog lists dozens of warehouse tables with no owner, no description, and no recent queries. What remediation approach best curates these orphans?
- A housing authority keeps critical eligibility business rules only in long email threads between analysts. How should those rules become visible metadata?
- Two departments independently redefine the shared entity Citizen differently in local models. What lightweight governance practice should prevent semantic forks?
- A county open-data portal publishes datasets with vague titles, empty descriptions, and no stated update frequency. What metadata quality concern should the portal owner prioritize?
- Analysts routinely export warehouse extracts that accidentally include Social Security numbers. Which metadata-driven control best reduces that exposure risk?
- After a policy change, the city’s official definition of unemployed no longer matches last year’s meaning, but longitudinal dashboards still use one unversioned glossary entry. What should metadata management do?
- An automated scanner flags hundreds of columns as possible PII and writes tags straight into enforcement without human review. What practice should the metadata program require instead?
- A director claims the metadata program is complete because every major system has an entity-relationship diagram on a shared drive. What gap should the CIMP practitioner highlight?
- Analysts keep asking which datasets leadership trusts for official reporting. How should the catalog communicate that trust status?
- Integration teams map dozens of source fields into canonical citizen attributes, but the mappings live only in a developer’s private notes. What should metadata management require?
- On-call staff triage stale civic dashboards by guessing which upstream jobs failed. How should runbooks use the catalog?
- Official metric definitions appear in Confluence, SharePoint, and the data catalog with slightly different wording. What glossary practice should leadership enforce?
- Glossary entries for citizen attributes list only a one-line synonym and no allowed values or owner contact. What minimum content should stewards require?
- A warehouse team will retire a legacy permits table in ninety days, but consumers still discover it as if it were fully supported. What catalog action should accompany the technical deprecation?
- During a permitting-system migration, legacy status codes must map to a new code list, but analysts cannot find any published translation. What reference metadata should the program provide?
- Data stewards are flooded with requests to fix typos in catalog descriptions while semantic definition changes wait weeks. How should change control be tiered?
- A metrics store defines active household differently from the business glossary by a few quiet edge cases. What alignment action should metadata management take?
- A regional partnership will receive a weekly civic dataset, but the package includes only raw files and no definitions or refresh expectations. What should accompany the share?
- Product teams expose GraphQL and REST APIs whose field names never link back to glossary business terms. What metadata practice should close that gap?
- Catalog search logs show repeated zero-result queries for phrases residents use, while official titles use different jargon. How should the team improve metadata?
- Regulators ask the city to prove what a reported KPI meant and which sources fed it on a specific past quarter. What metadata capability is required?
- Several BI teams rebuild their own versions of Date and Geography dimensions with conflicting hierarchies. What modeling-plus-metadata practice should the enterprise adopt?
- A new catalog crawler is configured with production database passwords stored in its admin UI and broad access to export connection secrets. What protection principle should stop that design?
- Leadership asks how to judge whether the metadata program is delivering value beyond counting cataloged tables. Which outcome metric best fits that ask?
Data Architecture · 50 questions
- A city CIO says the data architecture project is done because a cloud warehouse was purchased. What should the information management lead emphasize?
- A county wants one platform tuned for both high-volume permit transactions and heavy cross-year analytics. Which architecture stance is most sound?
- Three agencies must exchange permit status without growing a web of brittle point-to-point feeds. What interoperability architecture move best reduces that sprawl?
- Business units need consolidated operational reporting without hammering the live OLTP permit system. Which pattern best fits that need?
- Leaders argue endlessly that warehouses are always right and lakes are always wrong—or the reverse. How should the architect choose?
- A new architecture initiative finds undocumented feeds and shadow databases across departments. Where should architecture work start?
- A municipality wants a target data architecture that can adapt as services change. What process stance best supports that goal?
- A statewide program proposes replacing every departmental data system in one cutover weekend. What modernization approach is more sustainable?
- Agencies repeatedly remap the same citizen and organization attributes for every new interface. Which interoperability design reduces that pairwise cost?
- A city is organizing its data estate and wants clearer ownership as services evolve. How should data domains be aligned?
- Emergency outage maps must refresh within minutes, while annual grant audits tolerate day-old extracts. What should architecture do with that difference?
- A legacy partner still requires nightly batch file drops while modern apps consume APIs. How should the architecture treat this situation?
- An analytic platform accumulates raw dumps with no certification steps and users stop trusting dashboards. What was missing from the analytic architecture?
- Non-architect executives struggle to grasp dense technical diagrams of the reference architecture. What communication approach helps most?
- Each operational application keeps its own conflicting copy of customer-of-record attributes. When governance can support it, what operational architecture preference is stronger?
- Sensitive resident health-related fields are proposed for an open analytic zone used by many contractors. What should guide placement?
- City asset inventory consumers need timely notice when an asset record changes, not only a nightly warehouse refresh. Which movement pattern fits?
- Project teams keep making conflicting trade-offs on master data and automation of controls. What foundational artifact should architecture publish?
- Departmental marts each define ‘open case’ differently, breaking enterprise performance reporting. What analytic architecture response is appropriate?
- A program lifts a brittle point-to-point integration graph into the cloud unchanged. What limitation should leaders expect?
- Shared datasets used across agencies lack owners, interface contracts, and freshness expectations. What modern architecture orientation addresses that gap?
- Heavy operational reports run directly against the live OLTP licensing database and cause lock contention for clerks. What architecture response is indicated?
- Partner agencies reinterpret status codes differently in every message exchange. Which interoperability assets should architecture elevate?
- Analytic storage costs rise because rarely used history sits on the same expensive tier as hot dashboards. What architecture practice should be applied?
- A team proposes a high-impact change to the city’s core data platform patterns. What lightweight governance practice should apply?
- A city licensing office maps current information flows for permit issuance and finds five separate person stores holding overlapping applicant identities. What should the architecture team prioritize next?
- Two municipal systems need to exchange case status repeatedly. Leadership wants durable system-to-system access without hard-coding database links between teams. Which pattern best fits?
- A county analytics team wants flexible landing of raw operational extracts plus trusted curated tables for official dashboards. Which layered pattern best describes that mediate approach?
- Platform engineers discover aging ETL jobs, undocumented schemas, and brittle overnight feeds, but the roadmap only lists new cloud projects. What should architecture leadership add?
- Emergency dispatch case stores must recover within minutes, while a best-effort monthly park-usage dashboard can tolerate longer outages. How should resilience be designed?
- A project proposes a new “integration database” so every department can dump and query shared tables freely, with no named owner or quality controls. What is the main architecture risk?
- A civic transformation program is planning architecture change by listing vendor replacements year by year. What planning approach better supports durable outcomes?
- A water utility must ingest high-frequency meter sensor readings continuously and also apply periodic batch GIS layer updates under one governed estate. What ingestion approach fits?
- A permits API is changing fields that several downstream agency apps consume. What practice best protects consumers from breaking producer changes?
- Multiple city applications each maintain their own copies of status codes, country codes, and fee categories that drift apart. What architectural placement helps?
- Analysts need freedom to experiment in sandboxes, but council briefing packs must use only certified metrics. How should architecture draw the boundary?
- The team chose an event-driven integration pattern for inter-agency case updates after debating hub-and-spoke alternatives. What documentation practice best preserves that rationale?
- A regional shared-services proposal would store citizen identity attributes in a cloud region outside the jurisdiction’s residency rules. How should architecture treat that constraint?
- Municipal traffic-event facts grow rapidly and analysts filter almost always by event date and district. At architecture pattern depth, what physical-design awareness helps performance?
- Three BI tools in the same city government show different “open case” counts for the same week. What architectural layer most directly mitigates competing metric definitions?
- After cutover to a new permitting platform, legacy databases remain online “just in case,” quietly attracting new writes. What should the modernization roadmap include?
- A city’s overnight pipelines occasionally stall silently, ship broken schemas, or spike in volume without alerts. What should architecture include among non-functionals?
- As more agencies join a shared services program, every team adds direct custom links to every other system. What integration direction scales better?
- A program places the only master person hub exclusively behind the warehouse team for analytics, while operational permitting apps keep creating conflicting local persons. What placement mistake is this?
- Domain teams want local data copies for autonomy, while the enterprise architecture board wants one centralized store for consistency. What is the sound response?
- A newly annexed department brings five legacy systems into the city’s data estate. What should architecture provide so onboarding is repeatable?
- A new benefits domain service must use data from a noisy legacy eligibility system without absorbing that system’s tangled model. Which boundary pattern helps?
- Two years into an architecture program, executives ask how to judge success beyond counting new diagrams. Which outcome metrics fit best?
- The city wants domain product teams to move fast without each reinventing pipelines, identity, and platform glue. Which team-topology pattern supports that?
- Leaders ask what principle should close a data-architecture program so tomorrow’s team can evolve the estate safely. What should be emphasized?
Data Analysis · 50 questions
- A council briefing asks how many active library cardholders the city has, but nobody has defined what active means. What should the analyst do first?
- A public-works lead wants a monthly summary of how many service requests were opened and closed, not an investigation into why spikes occurred. Which analytic aim fits?
- A call center wants a forecast of next month's contact volume, while a separate team is explaining why last month spiked. How should an information-management practitioner separate those aims?
- A public dashboard truncates the y-axis so a one-percent change in recycling diversion looks like a steep cliff. What visualization practice should the team follow instead?
- An analyst prepared twelve charts for a budget workshop, but the decision is whether to extend Saturday library hours. How should the briefing be structured?
- Billing complaint volume rose after a rate change. Structured root-cause analysis traces the spike to a bad rate-table deploy rather than customer behavior. What does this illustrate about analysis practice?
- Five analysts each maintain a separate Excel pivot of revenue for the same municipal enterprise fund, and the totals disagree in every council packet. What risk does unmanaged spreadsheet analysis create?
- A department proposes tracking social-media likes as its primary service KPI, while completed service SLAs already exist. Which metric choice better supports civic performance management?
- Citywide average complaint rates look stable, but neighborhood segments show large gaps. What analysis practice should the team apply before concluding performance is equitable?
- A briefing notes that park visits and ice cream sales rise together and concludes that ice cream sales cause park visits. What analytic caution should the information manager apply?
- A transit satisfaction survey shows rising scores, but unhappy riders appear more likely to abandon the survey mid-way. What missingness concern should the analyst raise?
- A city dashboard contains thirty charts but names no decision owners or actions when thresholds breach. What critique should an information-management practitioner make?
- Before modeling membership churn for recreation centers, what should the analyst verify first about the source data?
- Permit backlog looks stubborn when measured only as today's queue length. What alternate view better explains process health over time?
- After a process change, a quality team watches weekly defect rates for unusual shifts rather than reacting to every small wiggle. What diagnostic monitoring mindset does this reflect?
- A city staggers a new permit web form to some applicants while others still use the legacy form, then compares completion rates. What comparative-evaluation caution applies?
- Geospatial analysis of pothole reports produces conflicting maps because street centerlines and address points disagree across systems. What prerequisite should the analyst emphasize?
- An executive storyboard for a funding decision should stay concise and actionable. Which structure best fits?
- Self-service BI is rolled out without a shared glossary, and teams soon publish conflicting definitions of on-time. What balance should information management enforce?
- An overtime hours distribution shows extreme outliers. What should analysts do before dropping those points?
- A time series of municipal water usage shows swings that analysts want to interpret as demand changes alone. What should they account for when reading the series?
- Supervisors need today's permit queue for staffing, while directors need multi-year intake and clearance trends for strategy. How should analytic products be matched to purpose?
- Association mining on service requests finds that tree-trim tickets often appear near sidewalk-repair tickets. What is the appropriate next stance before changing policy?
- Web analytics show heavy drop-off in the online permit application funnel. What condition must be true before those funnel insights reliably inform UX fixes?
- A public dashboard team can show neighborhood-level service metrics or row-level resident records. Which publishing practice aligns with privacy-minded analysis?
- A city budget office cannot rerun last year's cost-driver notebook for an audit because library versions and input parameters were never recorded. What practice should the information manager require next?
- A parks survey uses 1–5 Likert scales, yet a dashboard reports average satisfaction as 3.847291. What reporting problem should the information manager correct?
- Economic development leaders want metrics they can manage mid-year, but the only published KPI is last year's citywide economic impact estimate. What should the information manager add?
- A citywide dashboard lets users drill from an enterprise KPI to a department and then to a team, but filters reset at each level and comparisons stop making sense. What analytic UX requirement should be enforced?
- After a new inspection workflow launched, an analyst picks a post-launch week with unusually low backlog as the 'baseline' and reports a huge improvement. What baseline practice should the information manager insist on?
- A 311 analytics pilot proposes auto-tagging free-text service notes to prioritize neighborhoods, but the corpus mixes languages and informal slang. What caution should guide next steps?
- An analysis finds a clear intake bottleneck in licensing, but the deliverable is only a slide deck with no owner assigned to try a fix. What should the information manager require to close the loop?
- Parks planners survey only weekday downtown office visitors about weekend trail use and conclude citywide demand is low. What sampling problem should the information manager flag?
- Two BI tools both show 'active customer' counts for the same utility program but disagree by thousands. What should the information manager escalate first?
- Budget planners ask for a single exact revenue forecast, but key drivers such as grant awards and permit volume are uncertain. How should the information manager structure the analysis?
- A public safety heatmap on the open data portal uses color intensity with no legend or units, and residents cannot tell what the colors mean. What visualization standard should be required?
- For a sensitive equity study, analysts keep trying new cuts until a stark disparity appears, then plan to publish only that cut. What integrity practice should the information manager require?
- Exploratory work shows that duplicate and missing source records explain most of an apparent performance spike, yet modelers want to proceed with a complex predictive model anyway. What sequencing decision is correct?
- An operations manager disputes an analyst's on-time metric chart, insisting the numbers 'feel wrong.' How should they resolve the disagreement?
- Public works wants to judge winter road-treatment performance by comparing this February to January, which routinely has different storm patterns. What comparison approach should the information manager recommend?
- A public health briefing presents sample-based rates as exact citywide counts with no ranges or caveats. What communication practice should replace that approach?
- Self-serve users keep exporting spreadsheet extracts that live for months as unofficial shadow marts with stale figures. What governance response fits?
- A service-request KPI spikes overnight. Before proposing staffing changes, what diagnostic structure should the analyst apply?
- A partner agency shares a dashboard the city wants to republish, but it arrives with no metric definitions or freshness notes. What standard should analysts enforce?
- A predictive pilot for inspecting rental properties proposes features that directly encode protected demographic attributes without ethics review. What should the information manager do?
- In a service redesign meeting, one vivid constituent story is used to override a representative dataset that shows a different primary bottleneck. How should the information manager guide the group?
- A 311 call center capacity plan is built only from last month's total call count, ignoring when calls arrive and how long agents spend per contact. What inputs should the analysis include?
- After winter ends, the city never compares snow-response forecasts to what actually happened, and the same planning misses repeat. What analytics-lifecycle practice should be added?
- Leadership proposes a opaque weighted 'livability index' as the primary public accountability KPI, though simpler transparent service metrics already exist. What preference should the information manager advocate?
- An executive asks why analytic recommendations keep failing even though dashboards look polished. What integrated view should the information manager emphasize?
These questions are original practice material and are NOT actual exam questions or brain-dump content. All vendor marks are trademarks of their respective owners. This site is not affiliated with, endorsed by, or sponsored by eLearningCurve.