Periodic archiving of transaction data from a production CRM system is critical for:
A.
Training junior DBAs
B.
Managing deleted customer records
C.
The maintenance of database performance
D.
Enabling the distribution of transaction data across the enterprise
E.
Providing alternate sources for reporting systems
The Answer Is:
C
This question includes an explanation.
Explanation:
Archiving transaction data in a production CRM system is primarily aimed at optimizing database performance by reducing the volume of active data, which enhances query response times and system efficiency. According to the DAMA-DMBOK, archiving is a key activity in data lifecycle management that supports data storage and operations. The DMBOK states: “Archiving involves moving data that is no longer actively used to a separate storage device for long-term retention. Archiving helps maintain database performance by reducing the size of active datasets, which can improve query performance and reduce resource consumption” (DMBOK2, Chapter 10: Data Storage and Operations, p. 387).
This process ensures that the database remains efficient for transactional processing, as large volumes of historical data can slow down operations if not archived. Options A, B, D, and E, while potentially related to data management, do not directly address the primary purpose of archiving in this context. For instance, managing deleted customer records (B) relates more to data retention policies, and providing alternate sources for reporting (E) is a secondary benefit rather than the primary goal.
[Reference:DAMA-DMBOK2, Chapter 10: Data Storage and Operations, Section 4.3, p. 387., ]
DMF-1220 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"