Data Governance

A new analyst at a retail company struggles to find trusted datasets and repeatedly asks colleagues which table contains 'active customers' and how that term is defined. Leadership wants a self-service solution so analysts can search available data assets, view standardized definitions, and see who owns each dataset. Which data governance tool best addresses this need?

A healthcare analytics company is establishing a data governance program. The governance team wants to ensure that datasets are handled according to their sensitivity, so that patient diagnosis records receive stronger encryption and access controls than the company's published marketing brochures. Which governance practice should the team implement to achieve this?

A financial services firm keeps seven years of transaction records to satisfy regulatory requirements. Records older than 18 months are rarely queried but must remain retrievable if an auditor requests them. To reduce costs on the primary analytics platform while still meeting compliance obligations, which data lifecycle action should the governance team take with these older records?

A finance analyst notices that a quarterly revenue figure on an executive dashboard does not match the number in the source ERP system. Before escalating, the analyst needs to understand every transformation, join, and calculation the value passed through from the original source table to the final dashboard metric. Which data governance capability should the analyst use to investigate this?

A junior analyst submits a request to gain read access to a sensitive HR salary dataset for a new compensation study. The organization has a formal data governance program with defined roles. The IT service desk needs to know who has the authority to approve or deny this request, since that person is ultimately accountable for the dataset and defines who may use it. Whose approval should the service desk obtain before granting access?

A pharmaceutical analyst is preparing a dataset for a regulatory audit. The auditor asks the analyst to document not just how the data moved and transformed through the pipeline, but also the original source of the data, who collected it, the methods used, and any custody transfers before it entered the company's systems. Which data governance concept specifically addresses this requirement for documenting the origin and chain of custody of the data?

A data analyst at an insurance company notices that a customer's recorded date of birth in the reporting database shows 1985, but the customer's original signed policy application document lists 1958. All other systems reference the reporting database value. Which data quality dimension is MOST directly compromised in this situation?

A data governance team is establishing quality standards for a new customer database. They discover that 15% of customer records are missing a value in the required 'email' field. Which data quality dimension should the team use as the metric to track and report this specific problem?

A data governance team reviews a customer database and finds that the same customer's state is recorded as 'CA' in the billing system and 'California' in the CRM. Both entries are individually valid, but they conflict across systems. Which data quality dimension is MOST directly failing in this situation?

A regional sales manager complains that the executive dashboard shows figures that no longer match the current state of the business. Investigation reveals the underlying data is accurate and complete, but the nightly load job has been silently failing for the past nine days, so the dashboard reflects data from over a week ago. Which data quality dimension is MOST directly failing in this situation?

A data analyst is establishing quality standards for a new customer master database. During profiling, they find that the same customer appears multiple times because records were entered separately by the sales, support, and billing teams. Management asks which data quality dimension the analyst should define a standard for to prevent this specific problem going forward.

A data quality analyst is reviewing a newly loaded customer table. Several email address fields contain values like 'john.doe@' and 'contact_us', and some phone number fields contain alphabetic characters. The values are populated (not blank) and each customer appears only once. Which data quality dimension is MOST directly failing in this table?

A financial services company has a documented data retention policy stating that customer transaction records must be kept for exactly 7 years to satisfy regulatory audit requirements, after which they must be destroyed. During a routine review, a data analyst discovers a table containing transaction records dating back 11 years that were never removed. What is the MOST appropriate action for the analyst to take?

A multinational retailer wants to consolidate all customer records into a single cloud data warehouse hosted in a US region to simplify analytics. The legal team objects, noting that customer data collected from EU residents is subject to rules requiring that personal data remain within specific jurisdictions unless adequate safeguards exist. Which data governance concept is the legal team invoking?

A healthcare organization is formalizing its data governance program. During a planning meeting, the CFO is designated as accountable for the overall value, appropriate use, and business decisions regarding the finance department's data assets. A senior analyst is then assigned to handle the day-to-day tasks of maintaining data quality, enforcing naming standards, and monitoring adherence to policies for those same finance datasets. Which governance role is the senior analyst fulfilling?

A retail analytics team collected customer email addresses during checkout for the stated purpose of sending order confirmations. A marketing manager now asks the team to use those same email addresses to build a targeted advertising campaign for a new product line. The customers were never informed their data might be used for marketing. From a data ethics and governance standpoint, what is the most appropriate response?

A retail company's analytics team needs a copy of the customer database to build and test a churn model in a non-production environment. The dataset includes Social Security numbers, which the model does not use but which appear in a source table the team must query. Compliance requires that the SSNs be irreversibly obscured before the data enters the analytics environment, while preserving the format so downstream ETL jobs do not break. Which technique best meets this requirement?

A retail company has customer records stored in three separate systems: the e-commerce platform, the loyalty program database, and the in-store point-of-sale system. Each system maintains its own version of customer name, address, and contact details, leading to conflicting information across reports. Leadership wants a single, authoritative version of each customer that all systems and analysts can trust. Which data governance practice should the company implement to address this?

A customer in the EU submits a formal request asking your company to delete all personal data it holds about them. The marketing team says the customer's records are still useful for churn analysis and wants to keep them. As the data analyst supporting governance, what is the appropriate action under GDPR?

A hospital's data analytics team stores patient records in a shared warehouse. Billing analysts need to see charge amounts but must not view clinical diagnosis fields, while clinical researchers need diagnosis data but should never see individual patient names or account numbers. A new analyst joins the billing team. Which access control approach BEST enforces these requirements while remaining scalable as staff change?