DATA-ARCHITECT practice question 19 of 35
Universal Containers (UC) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a…
Full set: 257 questionsThe root cause of the problem is a lack of standardized data definitions across different systems before consolidation. A data taxonomy provides a formal classification system, defining standard values, formats, and hierarchies for data elements like product names and attributes (e.g., color). By defining and applying this taxonomy within the data warehouse—the central point of data consolidation—Universal Containers can enforce consistency. This ensures that all downstream systems, including Salesforce, receive clean, standardized data, resolving inconsistencies in catalogs, invoices, and confirmations. This is a proactive, architectural solution.
A. Changing the integration path does not solve the underlying problem of inconsistent source data; it just moves the problem.
B. Adding custom fields to store different versions of the data in Salesforce would institutionalize the inconsistency, not resolve it.
D. Using Apex Triggers is a reactive approach to clean data after it's already loaded. The best practice is to cleanse and standardize data upstream.
1. DAMA International, DAMA-DMBOK: Data Management Body of Knowledge (2nd Edition). Chapter 3, "Data Governance," discusses the importance of establishing common data definitions and standards (a taxonomy) to ensure data consistency and quality across an organization.
2. Kimball, R., & Ross, M. (2013). The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling (3rd ed.). Chapter 5, "Conformed Dimensions," explains the necessity of creating standardized, shared dimensions (master data like 'Product') to ensure data can be integrated and analyzed consistently across different business processes. This is achieved by establishing a data taxonomy.
Keep practicing
Take the free DATA-ARCHITECT practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DATA-ARCHITECT practice questions
- Question 1Which three characteristics of a skinny table help improve report and query performance?
- Question 2Universal Containers (UC) has built a custom application on Salesforce to help track ship…
- Question 3Universal Containers (UC) has lead assignment rules to assign leads to owners. Leads not …
- Question 4Universal Container (UC) has accumulated data over years and has never deleted data from …
- Question 5Universals Containers’ system administrators have been complaining that they are not able…
- Question 6Universal Containers is experiencing frequent and persistent group membership locking iss…
