Compare and Contrast Various Techniques, Approaches and Considerations for Capturing and Managing Business and Technical Metadata (e.g., Business Dictionary, Data Lineage, Taxonomy, Data Classification). DATA-ARCHITECT Practice Questions (Page 4)

Questions 16–20

1. 16expert · hard

   A data team is troubleshooting a discrepancy in a revenue report. They suspect that a transformation in an ETL job is incorrect. They need to trace the exact field-level changes from the source Salesforce object to the target data warehouse table. Which approach is most effective?

   • AReview the ETL job logs to see the execution history
   • BCompare the source and target schemas manually
   • CAsk the business team to confirm the expected values
   • DUse a data catalog tool that provides column-level lineage and transformation details
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   What does data lineage primarily capture?

   • AThe flow and transformation of data from source to target
   • BThe storage location of data backups
   • CThe business definitions of data elements
   • DThe access permissions for data assets
   Reveal Solution Discussion Select an answer first
4. 18expert · hard

   A company is implementing a metadata management solution. They have a small team and need to ensure that metadata is kept up to date as systems change. They also want to avoid duplication of effort. What is the most effective approach?

   • ARely entirely on manual metadata entry by each team
   • BUse a decentralized model with no central coordination
   • CUse automated metadata harvesting with periodic reviews by data stewards
   • DCapture metadata only once during initial implementation
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A data catalog team wants to allow users to browse data assets by business function and then by sub-function. They also want to apply security classifications to restrict access. What should they implement?

   • AA flat list of assets with no classification
   • BOnly a taxonomy, since it can also handle security
   • CA taxonomy for browsing and sensitivity labels for access control
   • DOnly sensitivity labels, since they can also provide hierarchy
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   Which of the following is a key consideration for metadata management?

   • AEnsuring metadata is stored in the same database as the data
   • BMinimizing the number of metadata users
   • CDefining clear ownership and stewardship of metadata
   • DAvoiding versioning of metadata
   Reveal Solution Discussion Select an answer first