I85PREP
⌘ K
Informatica CDGC Foundation study materials
Informatica CDGC Foundation study resources

Informatica CDGC Foundation practice questions

One question at a time. Build your Informatica CDGC Foundation understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Data Governance & Catalog

In Informatica Cloud Data Governance and Catalog (CDGC), which asset type represents a physical or logical grouping of columns within a relational source?

  1. Policy
  2. Data domain
  3. Business glossary term
  4. Table asset Correct answer.

Explanation

A table asset is the catalog object that holds a set of columns scanned from a relational source and carries technical metadata such as row counts and source system. Glossary terms, domains, and policies are governance constructs rather than container objects for columns.

Question 2Data Governance & Catalog

Which CDGC capability lets stewards link a business glossary term to the technical columns that implement it?

  1. Reference data management
  2. Column profiling
  3. Business term association Correct answer.
  4. Data classification

Explanation

Business term association creates the relationship between a glossary term and catalog assets such as columns or tables, giving lineage from business language to physical implementation. Profiling computes statistics, classification assigns data classes, and reference data management handles code sets.

Question 3Data Governance & Catalog

A steward wants to see how a value moves from a source table through transformations into a target table. Which CDGC feature should be used?

  1. Glossary workflow
  2. Asset certification
  3. Data quality scorecard
  4. Column lineage Correct answer.

Explanation

Column lineage traces the flow of data from source columns through transformation logic to downstream columns, which is exactly the movement described. Scorecards report quality results, workflows manage approvals, and certification marks asset trust status.

Question 4Data Governance & Catalog

What is the primary purpose of a business glossary in CDGC?

  1. Storing row-level source records
  2. Defining shared business vocabulary with owners and definitions Correct answer.
  3. Encrypting sensitive columns
  4. Scheduling metadata scans

Explanation

The glossary holds business terms with definitions, stewards, and status so that stakeholders share one vocabulary across systems. It does not store source data, schedule scans, or perform encryption.

Question 5Data Governance & Catalog

Which object in CDGC groups assets by a business subject area such as Customer or Product so that stewards can manage them together?

  1. Data domain Correct answer.
  2. Folder
  3. Connection
  4. Mapping task

Explanation

A data domain is a governance grouping of assets that share a business subject area, allowing scoped stewardship and reporting. Connections hold access details, mapping tasks run integration jobs, and folders organize project content.

Question 6Data Governance & Catalog

In CDGC, what does assigning a data class to a column indicate?

  1. The column's content matches a recognized pattern or category Correct answer.
  2. The column is the primary key of the table
  3. The column is excluded from lineage
  4. The column is certified for production use

Explanation

A data class identifies the kind of data a column holds, such as email address or national identifier, based on pattern or manual assignment. Certification, key constraints, and lineage exclusion are separate concepts.

Question 7Data Governance & Catalog

A data steward needs to record that a glossary term has been reviewed and approved by the business owner. Which CDGC mechanism supports this?

  1. Lineage diagram export
  2. Column profiling run
  3. Connection test
  4. Term workflow with review and approval states Correct answer.

Explanation

Glossary terms move through workflow states, and approval by a designated reviewer records the governance sign-off. Profiling, lineage export, and connection tests are technical operations with no approval semantics.

Question 8Data Governance & Catalog

Which CDGC feature helps an analyst find assets by typing a partial name or by browsing by domain and asset type?

  1. Mapping specification
  2. Parameter file
  3. Catalog search Correct answer.
  4. Session log

Explanation

Catalog search indexes asset metadata so users can locate assets by keyword, filter by type, or browse governance groupings. Mapping specifications, session logs, and parameter files belong to integration execution.

Question 9Data Governance & Catalog

A steward loads a new source system into CDGC and wants technical metadata plus automatic data class suggestions. Which configuration must be in place before the first scan?

  1. A published glossary term for every column
  2. A completed lineage diagram
  3. A certified data domain
  4. A catalog source with a connection and scan schedule Correct answer.

Explanation

Catalog ingestion requires a configured catalog source that holds the connection details and scan settings; the scan then extracts metadata and can apply classification. Glossary terms, lineage diagrams, and certifications are downstream governance activities, not prerequisites for scanning.

Question 10Data Governance & Catalog

Two glossary terms, 'Client' and 'Customer', are used interchangeably across departments. What is the most appropriate CDGC action?

  1. Move both terms into separate data domains
  2. Delete one term and keep the other
  3. Relate the terms as synonyms and document the preferred term Correct answer.
  4. Assign both terms to the same data class

Explanation

Synonym relationships preserve both business usages while designating a preferred term, which supports search and consistent interpretation. Deleting a term loses institutional knowledge, domains group assets rather than terms, and data classes describe column content rather than vocabulary.

Question 11Data Governance & Catalog

An analyst opens a column asset and sees upstream source columns and downstream target columns. Which CDGC capability produced this view?

  1. Reference data set
  2. Data quality rule
  3. Data lineage Correct answer.
  4. Business glossary

Explanation

Lineage is computed from mapping and SQL metadata to show upstream and downstream relationships for a column. Quality rules evaluate data, reference data sets define code values, and the glossary defines business vocabulary.

Question 12Data Governance & Catalog

A privacy officer must locate every column that stores government-issued identification numbers. Which CDGC approach is most efficient?

  1. Search by data class and review associated columns Correct answer.
  2. Open each table asset one by one
  3. Run a mapping task for each source
  4. Export all glossary terms to a spreadsheet

Explanation

Classifying columns with the relevant data class lets the officer search or filter by that class and review the associated columns in one pass. Manual review, glossary export, and mapping runs do not surface classified columns systematically.

Question 13Data Governance & Catalog

A steward wants to track which catalog assets are governed by a specific data domain and who owns them. Which CDGC construct should be configured?

  1. A parameter set for runtime values
  2. A connection with a scan schedule
  3. A data domain with assigned assets and owners Correct answer.
  4. A mapping with an expression transformation

Explanation

Data domains group governed assets and carry ownership, enabling scoped reporting on coverage and accountability. Connections, mappings, and parameter sets are technical integration objects with no governance ownership semantics.

Question 14Data Governance & Catalog

A glossary term is created but does not appear when users search the catalog. Which condition most likely explains this?

  1. The term's domain has no assets
  2. The term's owner is also a steward
  3. The term has too many synonyms
  4. The term is still in draft and not published Correct answer.

Explanation

Unpublished draft terms are typically not visible in general catalog search until they are approved and published. Synonym count, empty domains, and dual owner-steward roles do not block search visibility.

Question 15Data Governance & Catalog

A column's lineage shows a source column but the transformation logic is missing. What is the most likely cause in CDGC?

  1. The column has no assigned data class
  2. The glossary term is unapproved
  3. The table is certified
  4. The mapping metadata was not ingested or parsed Correct answer.

Explanation

Lineage depends on ingested mapping or SQL metadata; if the transformation asset was not scanned or could not be parsed, the path appears incomplete. Classification, certification, and term approval do not supply transformation logic.

Question 16Data Governance & Catalog

Which statement best describes the relationship between a table asset and its column assets in CDGC?

  1. Columns are separate connections
  2. Columns are child assets contained within the table asset Correct answer.
  3. Columns are glossary terms linked to the table
  4. Columns are data domains under the table

Explanation

When a table is scanned, its columns are cataloged as child assets of that table, inheriting context such as source system and schema. Columns are not glossary terms, connections, or domains.

Question 17Data Governance & Catalog

A governance lead wants to measure how many critical data elements have an assigned steward and a linked glossary term. Which CDGC reporting approach fits best?

  1. Inspect session logs from integration jobs
  2. Review parameter files for each mapping
  3. Export connection properties
  4. Use governance reports and dashboards over domains and glossary coverage Correct answer.

Explanation

Governance reporting surfaces coverage metrics such as stewardship assignment and term linkage across domains. Session logs, parameter files, and connection properties describe execution and connectivity rather than governance coverage.

Question 18Data Governance & Catalog

A steward links a glossary term to a column, but the term's definition conflicts with the column's documented meaning. What is the correct CDGC action?

  1. Disable lineage for the table
  2. Resolve the definition conflict with the term owner before finalizing the association Correct answer.
  3. Reclassify the column as a primary key
  4. Delete the column asset from the catalog

Explanation

Associations should reflect agreed meaning, so conflicting definitions must be reconciled with the term owner before the link is finalized. Deleting assets, altering key status, or disabling lineage all damage metadata without resolving the semantic conflict.

Question 19Data Governance & Catalog

Which CDGC feature automatically proposes data class assignments for scanned columns based on inferred patterns?

  1. Connection pooling
  2. Auto classification during scanning Correct answer.
  3. Manual glossary approval
  4. Lineage stitching

Explanation

During or after scanning, CDGC can infer data classes by analyzing column values and names and propose assignments for review. Glossary approval, lineage stitching, and connection pooling serve different purposes.

Question 20Data Governance & Catalog

An organization wants every new glossary term to require business owner approval before it becomes visible to analysts. Which configuration enforces this?

  1. A term workflow with an approval step before publishing Correct answer.
  2. A data domain with no owner
  3. A scan schedule that runs nightly
  4. A lineage setting that hides draft assets

Explanation

The term workflow controls lifecycle states and can require an approval task before the term is published and searchable. Scan schedules, lineage settings, and ownerless domains do not govern term publication.

Question 21Data Governance & Catalog

A lineage view shows a source table feeding two target tables, but one target is missing its downstream columns. Which explanation is most consistent with CDGC behavior?

  1. The target table belongs to a data domain
  2. The downstream mapping was not scanned or its SQL could not be parsed Correct answer.
  3. The target table has too many columns
  4. The source table is not certified

Explanation

Lineage is only as complete as the ingested metadata; an unscanned mapping or unparseable SQL leaves downstream columns unresolved. Column count, certification, and domain membership do not determine whether lineage is generated.

Question 22Data Governance & Catalog

Two source systems use different column names for the same business concept, and analysts need one governed definition. Which combination of CDGC features best addresses this?

  1. A distinct data class per source column
  2. Two separate data domains, one per source
  3. A separate connection for each source with no glossary link
  4. A single glossary term associated with both columns, supported by lineage Correct answer.

Explanation

Associating one governed term with both columns unifies the business meaning, while lineage shows where each implementation flows. Separate domains, per-source classes, or unlinked connections preserve the inconsistency instead of resolving it.

Question 23Data Governance & Catalog

A steward must prove that a reported metric traces back to an approved glossary definition and an owning steward. Which CDGC evidence set is most appropriate?

  1. The session log and parameter file
  2. The table's row count and column count
  3. The term's approved status, its linked assets, and the assigned owner Correct answer.
  4. The scan schedule and connection string

Explanation

Governance evidence combines the term's approval state, the assets linked to it, and documented ownership, forming an auditable chain from definition to implementation. Schedules, logs, and statistics are technical facts with no governance accountability.

Question 24Data Governance & Catalog

A catalog scan completes but a sensitive column is left unclassified, and analysts can still see it. Which CDGC control combination best reduces exposure?

  1. Delete the column from the source system
  2. Disable all lineage for the table
  3. Remove the glossary term linked to the column
  4. Assign the correct data class and apply domain-scoped access with stewardship review Correct answer.

Explanation

Accurate classification identifies the sensitive data, and scoped access plus stewardship review limits who can see it while preserving metadata. Deleting source data, disabling lineage, or unlinking terms removes useful context without controlling visibility.

Question 25Data Governance & Catalog

A governance team notices that glossary terms exist for most critical data elements, but few are linked to catalog columns. Which conclusion is best supported?

  1. The data domains are overpopulated
  2. The catalog has no scanned sources
  3. The lineage engine is disabled
  4. Definitions exist but traceability to physical implementation is weak Correct answer.

Explanation

Terms without column associations indicate that business definitions are documented but not connected to the physical assets that implement them, weakening traceability. Missing scans, domain size, and lineage settings are not implied by the term-linkage gap alone.

Question 26Data Governance & Catalog

In CDGC, which asset type represents a business-level definition that is independent of any physical database structure?

  1. Column asset
  2. Schema asset
  3. Connection asset
  4. Glossary term Correct answer.

Explanation

A glossary term captures business vocabulary and agreed meaning, so it can exist before or without any physical implementation. Physical assets such as columns and schemas are cataloged technical objects discovered by scanning.

Question 27Data Governance & Catalog

Which CDGC object is used to group related glossary terms into a hierarchy such as Finance > Reporting > Revenue?

  1. Reference dataset
  2. Glossary category Correct answer.
  3. Data domain
  4. Business area scan

Explanation

Glossary categories provide the hierarchical structure inside a glossary so terms can be organized and browsed by subject area. Data domains govern catalog assets rather than organizing term vocabulary.

Question 28Data Governance & Catalog

What is the primary purpose of a data domain in CDGC?

  1. To define the physical schema of a target warehouse
  2. To group catalog assets under a governance scope with accountable owners Correct answer.
  3. To generate SQL transformations for lineage
  4. To store connection credentials for scanning source systems

Explanation

Data domains create governance scopes so assets can be grouped, owned, and reported on by subject area or business unit. They are organizational constructs, not storage or transformation mechanisms.

Question 29Data Governance & Catalog

A steward needs to know who is accountable for a cataloged table's quality and definitions. Which CDGC assignment satisfies this?

  1. Assigning a tag to the table
  2. Assigning a data steward role to the table Correct answer.
  3. Assigning the table to a scanning schedule
  4. Assigning a data class to the table

Explanation

Owner and steward assignments record the people accountable for an asset's governance. Schedules, classes, and tags describe processing or characteristics, not accountability.

Question 30Data Governance & Catalog

Which CDGC capability lets a user see the business definition, owner, and linked technical assets for a governed concept in one place?

  1. The data class pattern editor
  2. The connection properties panel
  3. The glossary term detail page Correct answer.
  4. The scanner job log

Explanation

A glossary term's detail view consolidates its definition, stewardship, and the catalog assets linked to it. Scanner logs, connection properties, and pattern editors serve technical configuration rather than governed meaning.

Question 31Data Governance & Catalog

Which statement describes how a CDGC tag differs from a data class?

  1. A tag is stored only in the source system, while a data class is stored only in the glossary
  2. A tag is inferred only by pattern matching, while a data class is always manual
  3. A tag is mandatory for every asset, while a data class is optional
  4. A tag is a free-form label for grouping or flagging, while a data class describes the semantic type of data Correct answer.

Explanation

Tags are flexible labels used for grouping, flagging, or campaigns, whereas data classes describe what the data represents, such as a phone number or address. Classification can be automated, but tagging is a separate labeling mechanism.

Question 32Data Governance & Catalog

A governance team wants to publish a policy document that states how customer data must be handled and attach it to relevant catalog assets. Which CDGC construct fits best?

  1. A business policy asset linked to governed assets Correct answer.
  2. A column profile rule
  3. A reference dataset of customer codes
  4. A scan definition for the customer schema

Explanation

Policy assets document governance rules and can be associated with the assets they govern. Reference data, scans, and profiling rules are technical or validation constructs.

Question 33Data Governance & Catalog

Which CDGC view is most useful for confirming that a scanned table was discovered under the expected data domain?

  1. The asset's overview showing its domain assignment Correct answer.
  2. The data class inference threshold settings
  3. The glossary term approval history
  4. The reference dataset value list

Explanation

An asset's overview displays its governance context, including the data domain it belongs to. Approval history, reference values, and inference thresholds do not show asset-to-domain membership.

Question 34Data Governance & Catalog

A steward wants to record that a column contains personally identifiable information so that downstream reports can be filtered by that flag. Which CDGC mechanism is designed for this kind of marker?

  1. A tag applied to the column asset Correct answer.
  2. A glossary category
  3. A lineage transformation
  4. A reference dataset

Explanation

Tags are lightweight labels that can be applied to assets and used to filter or group them in searches and reports. Glossary categories organize terms, reference datasets validate values, and lineage describes data movement.

Question 35Data Governance & Catalog

A steward needs to see every catalog asset that has been associated with a specific data domain. Which CDGC action surfaces that list?

  1. Open the reference dataset and review its values
  2. Open the scanner configuration and review source filters
  3. Open the glossary and sort terms alphabetically
  4. Open the domain and review its associated assets Correct answer.

Explanation

A data domain's detail view lists the catalog assets placed within that governance scope. Scanner filters, glossary sorting, and reference values do not enumerate domain membership.

Question 36Data Governance & Catalog

A business owner wants a glossary term to carry a formal status that distinguishes draft definitions from those approved for enterprise use. Which CDGC concept provides this?

  1. Term lifecycle status with workflow Correct answer.
  2. Data class inheritance
  3. Lineage level depth
  4. Scan frequency

Explanation

Glossary terms move through lifecycle states, and workflow controls who can move a term to approved status. Classification inheritance, lineage depth, and scan frequency are unrelated to term governance state.

Question 37Data Governance & Catalog

An analyst wants to find all glossary terms related to a subject such as 'supply chain' without knowing exact term names. Which CDGC search approach is most effective?

  1. Searching glossary terms by keyword and filtering by category Correct answer.
  2. Reviewing scanner job history
  3. Filtering catalog assets by connection type
  4. Sorting column assets by name length

Explanation

Glossary search supports keyword matching and category filters, which lets users discover terms by subject even without exact names. The other options operate on technical or operational metadata.

Question 38Data Governance & Catalog

A steward wants to attach the same approved definition to three columns in different systems so that all three resolve to one governed meaning. Which CDGC action achieves this?

  1. Create three separate glossary terms with identical text
  2. Link the single glossary term to each of the three column assets Correct answer.
  3. Tag each column with a different label
  4. Create a reference dataset per column

Explanation

Linking one term to multiple assets creates a shared governed definition and avoids duplicated vocabulary. Separate terms with identical text would fragment the definition and its ownership.

Question 39Data Governance & Catalog

A governance lead needs to see which glossary terms currently have no linked catalog assets. Which CDGC analysis supports this?

  1. Reviewing the connection's extraction statistics
  2. Reviewing the reference dataset crosswalk
  3. Reviewing term-to-asset linkage coverage across the glossary Correct answer.
  4. Reviewing the data class pattern library

Explanation

Linkage coverage analysis compares glossary terms against their associations with catalog assets to expose unlinked terms. Extraction statistics, crosswalks, and pattern libraries describe technical metadata rather than term adoption.

Question 40Data Governance & Catalog

A steward must show that a data domain has named owners before the domain can be considered operational. Which CDGC configuration demonstrates this?

  1. Creating a tag with the domain name
  2. Adding more columns to the domain
  3. Assigning a data steward and owner to the domain Correct answer.
  4. Setting a shorter scan interval on the domain

Explanation

Domains become operational when accountability is established through owner and steward assignments. Scan intervals, asset volume, and naming tags do not create accountability.

Question 41Data Governance & Catalog

A compliance officer wants evidence that a glossary term's definition was changed after approval and by whom. Which CDGC capability provides this?

  1. The term's category path
  2. The term's data class assignment
  3. The term's linked reference dataset
  4. The term's version history and audit trail Correct answer.

Explanation

Version history and audit trails record changes to a term, including who made them and when, which supports compliance evidence. Class assignments, reference data, and category paths describe content rather than change history.

Question 42Data Governance & Catalog

A steward wants to mark a glossary term as deprecated while keeping it visible for historical reference. Which CDGC action is most appropriate?

  1. Move the term to a new glossary
  2. Rename the term with a 'zzz' prefix
  3. Delete the term and remove all links
  4. Change the term's lifecycle status to deprecated and retain its links Correct answer.

Explanation

Deprecating a term preserves its history and existing associations while signaling that it should no longer be used for new work. Deleting it would break lineage of meaning and remove audit evidence.

Question 43Data Governance & Catalog

A steward wants to capture that a column's values must conform to a defined set of country codes. Which CDGC construct is intended for this?

  1. A reference dataset containing the valid codes Correct answer.
  2. A data domain
  3. A lineage transformation
  4. A glossary category

Explanation

Reference datasets hold enumerated valid values, such as country codes, that can be associated with columns for validation and documentation. Categories, domains, and lineage serve different governance purposes.

Question 44Data Governance & Catalog

A governance team wants to compare glossary coverage across two business units to decide where to invest stewardship effort. Which CDGC reporting approach is most direct?

  1. Compare the file sizes of exported lineage diagrams
  2. Compare term counts and linked-asset coverage by domain across the two units Correct answer.
  3. Compare scanner run durations for each unit's sources
  4. Compare the number of connections configured per unit

Explanation

Glossary coverage reporting by domain shows where vocabulary exists and how well it is linked to catalog assets, which directly informs stewardship investment. Operational metrics such as scan duration or connection counts do not measure governance coverage.

Question 45Data Governance & Catalog

A steward links a glossary term to a column, but the term's approved definition covers a broader concept than the column actually stores. What is the most defensible CDGC response?

  1. Delete the glossary term to avoid confusion
  2. Remove the link and create or select a term that matches the column's actual meaning Correct answer.
  3. Leave the link and rely on the term's broader meaning
  4. Change the column's data class to match the term

Explanation

Links should represent genuine semantic agreement between a term and an asset, so a mismatch calls for a more precise term or removal of the link. Altering classification or deleting vocabulary does not resolve the definitional gap.

Question 46Data Governance & Catalog

A steward must demonstrate that a governed term's definition, owner, linked columns, and policy references are all consistent before sign-off. Which CDGC review best supports this?

  1. Inspecting only the scanner job summary
  2. Inspecting the term's associations and stewardship in one consolidated review Correct answer.
  3. Inspecting only the source connection properties
  4. Inspecting only the reference dataset values

Explanation

A consolidated review of a term's definition, ownership, asset links, and policy associations verifies end-to-end governance consistency. Technical or validation views alone cannot confirm term-level governance completeness.

Question 47Data Governance & Catalog

A governance lead observes that many approved glossary terms exist but few are linked to data domains, weakening accountability reporting. Which CDGC remediation is most appropriate?

  1. Increase scan frequency for all source systems
  2. Disable automatic data class inference
  3. Reduce the number of glossary categories
  4. Establish a linkage program that associates terms with the domains and assets they govern Correct answer.

Explanation

Accountability reporting depends on explicit associations between terms and the domains and assets they govern, so a linkage program addresses the root cause. Scanning cadence, category structure, and classification settings do not create those associations.

Question 48Data Governance & Catalog

A steward needs to record that a term's definition was approved by a specific business owner on a specific date, and later prove it. Which CDGC evidence is most reliable?

  1. A comment on a related column asset
  2. The workflow approval record with approver and timestamp Correct answer.
  3. A tag applied to the term
  4. A note in the term description text

Explanation

Workflow approval records capture the approver identity and timestamp as structured, auditable evidence. Free-text descriptions, tags, and comments are editable and do not constitute a formal approval record.

Question 49Data Governance & Catalog

A steward wants to reuse the same governed definition for a concept that appears in five source systems with different column names. Which CDGC design keeps governance maintainable?

  1. One data domain per source column name
  2. One tag per source column name
  3. One glossary term linked to all five columns Correct answer.
  4. Five glossary terms, one per source column name

Explanation

A single governed term linked to multiple physical columns keeps one authoritative definition while accommodating naming differences across systems. Per-column terms, tags, or domains fragment governance and multiply maintenance.

Question 50Data Governance & Catalog

A steward needs to explain why a term appears in one glossary but not in another when users search. Which CDGC factor is most relevant?

  1. The scan schedule of the source connections
  2. The term's publication scope and status within each glossary Correct answer.
  3. The number of columns in the source tables
  4. The size of the reference dataset

Explanation

Term visibility depends on which glossary holds the term and whether its status makes it discoverable to users. Physical table size, scan schedules, and reference data volume do not control glossary search results.