Explain Data Management Practices DA0-001 Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   A data team is implementing a process to manage changes to a production database. The team wants to ensure that all changes are reviewed, tested, and can be reverted if necessary. Which process element is most critical for achieving the 'revert if necessary' requirement?

   • AAn approval from the data governance committee
   • BA rollback plan or versioned backup
   • CA communication plan to notify users of the change
   • DA detailed change request form
   Reveal Solution Discussion Select an answer first
2. 12expert · hard

   A data platform team manages a large dataset used by multiple downstream analytics teams. The team needs to implement version control for the dataset. The primary constraint is that the dataset is 5 TB and changes incrementally by about 1% daily. The team wants to minimize storage overhead while ensuring any historical version can be fully reconstructed. Which approach best meets these requirements?

   • AMaintain a single copy of the dataset and rely on the database's transaction log
   • BVersion only the schema and document the changes in a wiki
   • CUse a versioning tool that stores deltas or changes between versions
   • DStore a full copy of the dataset in a separate location after each daily update
   Reveal Solution Discussion Select an answer first
4. 13expert · hard

   A large organization has multiple teams documenting their data in different formats: some use wikis, some use spreadsheets, and some use specialized metadata tools. This has led to inconsistent definitions and difficulty in finding information. The organization wants to standardize documentation practices. What is the most effective first step?

   • ACreate a centralized documentation standard that defines required fields, formats, and ownership
   • BMandate that all teams use the same metadata tool immediately
   • CAppoint a single person to document all data across the organization
   • DDelete all existing documentation and start fresh with a new standard
   Reveal Solution Discussion Select an answer first
5. 14expert · hard

   A multinational bank is required by regulators to explain the origin of any data point in its risk reports. The bank's data flows from core banking systems through a complex series of transformations in a data lake, then into a risk warehouse, and finally into regulatory reports. The bank currently has no automated lineage tracking. Which approach should the bank prioritize to meet the regulatory requirement efficiently?

   • AImplement an automated data lineage tool that integrates with the data lake and ETL tools
   • BCreate a data dictionary for the risk warehouse only
   • CTrain analysts to trace data manually using SQL queries when regulators ask
   • DManually document the lineage of all data elements in a spreadsheet
   Reveal Solution Discussion Select an answer first
6. 15expert · hard

   A data governance team is designing a change management process for a customer database. The process must allow for rapid updates to support marketing campaigns, but also must ensure that any change can be audited and rolled back. The team is considering two options: (1) a formal change advisory board (CAB) that approves all changes, and (2) a self-service tool with automated testing and versioned rollback. Which option better balances the need for speed and control?

   • AOption 1, because a CAB provides the highest level of control
   • BBoth options equally, because they provide the same level of control and speed
   • CNeither option, because change management is not needed for marketing data
   • DOption 2, because it provides automated controls and versioned rollback without manual approval delays
   Reveal Solution Discussion Select an answer first