A data warehouse contains customer data that must be retained for seven years due to regulatory requirements. After seven years, the data should be deleted. The privacy team wants to automate this process. Which control should be implemented?

Move the data to a cold storage tier after seven years.

Manually review and delete data at the end of each year.

Configure automated data retention policies in the warehouse to delete data after the retention period.

Encrypt the data and keep it indefinitely.

What is the primary purpose of a data warehouse?

To store unstructured data like images and videos

To provide a backup and recovery solution for databases

To handle real-time transaction processing for operational systems

To store and manage large volumes of historical data for analysis and reporting

A retail chain wants to analyze sales trends across its stores. The data is currently scattered across multiple operational databases. The analytics team needs a central repository optimized for querying historical data. Which solution should they implement?

Export the data to spreadsheets for manual analysis.

Build a data warehouse that integrates data from the operational databases and supports historical analysis.

Use one of the operational databases as the central repository.

Create a data lake and store all raw data without transformation.

A startup is building a recommendation engine for an e-commerce site. They have collected user browsing history, purchase history, and product ratings. The privacy team warns that the training data contains personal data. Which practice should the team adopt to align with privacy principles?

Implement data minimization by collecting only the data necessary for the recommendation function.

Collect as much data as possible to improve model accuracy.

Store all data indefinitely for future model training.

Share the raw data with third-party data brokers to enrich the model.

A financial services firm is designing a data warehouse to support regulatory reporting and business analytics. The warehouse will contain customer account data, transaction records, and KYC documents. The firm must ensure that the warehouse can support both detailed regulatory queries and high-level business summaries. Which architecture component is essential to meet both needs efficiently?

Store all data in a data lake and query it directly.

Implement a layered architecture with staging, integration, and presentation layers.

Use a single flat table for all data to simplify access.

Create separate warehouses for each business unit.

Certified Data Privacy Solutions Engineer

Domain 3Objective 4

Data Analytics (Aggregation, AI, Data Warehouse) CDPSE Practice Questions (Page 1)

Part of the Data Life Cycle Management domain, which accounts for 23% of the CDPSE exam.

40questions here

8free pages

10concepts

23%of the exam

Questions 1–5

1application · medium
A data warehouse contains customer data that must be retained for seven years due to regulatory requirements. After seven years, the data should be deleted. The privacy team wants to automate this process. Which control should be implemented?
Select an answer first
2foundation · easy
What is the primary purpose of a data warehouse?
Select an answer first
3application · easy
A retail chain wants to analyze sales trends across its stores. The data is currently scattered across multiple operational databases. The analytics team needs a central repository optimized for querying historical data. Which solution should they implement?
Select an answer first
4application · easy
A startup is building a recommendation engine for an e-commerce site. They have collected user browsing history, purchase history, and product ratings. The privacy team warns that the training data contains personal data. Which practice should the team adopt to align with privacy principles?
Select an answer first
5expert · medium
A financial services firm is designing a data warehouse to support regulatory reporting and business analytics. The warehouse will contain customer account data, transaction records, and KYC documents. The firm must ensure that the warehouse can support both detailed regulatory queries and high-level business summaries. Which architecture component is essential to meet both needs efficiently?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to CDPSE

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by ISACA. “CDPSE” is a trademark of its owner, used for identification only.