CDP (Financial Data) 5 — Questions and Answers
Question 1: What is the primary purpose of an audit trail in financial data systems?
- To provide a chronological record of all changes to financial data for accountability and compliance (Correct answer)
- To archive old financial records that are no longer actively used
- To optimize query performance on large financial datasets
- To compress historical financial data to save storage costs
Correct answer: To provide a chronological record of all changes to financial data for accountability and compliance
An audit trail logs every insert, update, and delete action with timestamps and user identifiers, supporting regulatory compliance and fraud detection.
Question 2: In portfolio analytics, what does 'alpha' represent?
- Excess return of an investment relative to a benchmark index (Correct answer)
- The correlation between a portfolio and its benchmark
- The volatility of a portfolio relative to the market
- The total absolute return of a portfolio
Correct answer: Excess return of an investment relative to a benchmark index
Alpha measures the active return on an investment above or below a benchmark, representing the value added by the portfolio manager.
Question 3: Which data quality dimension is most critical when integrating real-time market tick data for algorithmic trading?
- Timeliness (Correct answer)
- Completeness
- Uniqueness
- Conformity
Correct answer: Timeliness
In algorithmic trading, stale or delayed tick data can lead to incorrect signals and costly trading errors, making timeliness paramount.
Question 4: What is 'goodwill' in financial data, and when does it appear on a balance sheet?
- The excess purchase price paid over the fair value of net identifiable assets in an acquisition (Correct answer)
- The estimated future earning potential of a company's brand
- The accumulated depreciation on all intangible assets
- The present value of future cash flows from operations
Correct answer: The excess purchase price paid over the fair value of net identifiable assets in an acquisition
Goodwill arises in a business combination when the acquirer pays more than the fair value of the target's identifiable net assets.
Question 5: A CDP professional is asked to calculate 'Days Sales Outstanding (DSO)'. Which formula is correct?
- (Accounts Receivable / Net Credit Sales) × Number of Days (Correct answer)
- (Net Credit Sales / Accounts Receivable) × Number of Days
- (Total Revenue / Accounts Payable) × Number of Days
- (Accounts Receivable / Total Assets) × Number of Days
Correct answer: (Accounts Receivable / Net Credit Sales) × Number of Days
DSO measures the average number of days a company takes to collect payment after a sale, calculated as AR divided by daily credit sales.
Question 6: When working with financial data under IFRS 9, what is the expected credit loss (ECL) model used for?
- Estimating and provisioning for probable future credit losses on financial assets (Correct answer)
- Calculating the maximum allowable leverage ratio for banks
- Determining the fair value of complex financial instruments
- Measuring interest rate risk in a bond portfolio
Correct answer: Estimating and provisioning for probable future credit losses on financial assets
IFRS 9's ECL model requires financial institutions to recognize credit loss provisions based on forward-looking expected losses rather than incurred losses.
Question 7: In financial data lineage tracking, which practice best supports regulatory reporting accountability?
- Documenting the transformation steps, source systems, and business rules applied to each reported data element (Correct answer)
- Storing all raw source data indefinitely without modification
- Using a single monolithic database to eliminate source system complexity
- Encrypting all financial data fields with end-to-end encryption
Correct answer: Documenting the transformation steps, source systems, and business rules applied to each reported data element
Data lineage documents the origin and all transformations of each data element, enabling regulators to trace reported figures back to source transactions.
CDP (Financial Data) 5
What is the primary purpose of an audit trail in financial data systems?