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

Questions 36–40

1. 36foundation · easy

   Which control is specifically designed to reduce the risk of re-identification in aggregated data?

   • AImplementing role-based access control
   • BEncrypting the database at rest
   • CSuppressing small cell counts in published tables
   • DUsing a data loss prevention tool
   Reveal Solution Discussion Select an answer first
2. 37foundation · easy

   A data analyst wants to summarize the total sales per region from a large transaction table. Which aggregation technique is most appropriate?

   • AFilter the table to show only one region
   • BGroup by region and sum the sales amounts
   • CSort the table by sales amount
   • DJoin the table with another table
   Reveal Solution Discussion Select an answer first
4. 38application · medium

   A non-profit organization aggregates donor data from multiple fundraising platforms to analyze donation trends. The aggregated dataset includes donor names, email addresses, and donation amounts. The organization wants to publish a report showing total donations by region. Which step should be taken to protect donor privacy in the published report?

   • ARound donation amounts to the nearest thousand dollars.
   • BPublish the full dataset with donor names removed.
   • CPublish the report only to internal staff.
   • DAggregate donations by region and suppress any region with fewer than five donors.
   Reveal Solution Discussion Select an answer first
5. 39application · easy

   A marketing team wants to analyze customer purchase patterns by region. They have transactional data with customer IDs, purchase amounts, and store locations. They need to produce a report showing total sales per region without revealing individual customer behavior. Which aggregation technique is most appropriate?

   • AList all transactions sorted by region.
   • BGroup the data by region and calculate the sum of purchase amounts.
   • CCreate a scatter plot of purchase amounts against customer IDs.
   • DCalculate the average purchase amount per customer and display it with customer IDs.
   Reveal Solution Discussion Select an answer first
6. 40application · medium

   A healthcare analytics team aggregates patient records from multiple hospitals into a single dataset for research. They remove direct identifiers such as name and social security number, but retain zip code, birth date, and diagnosis codes. A privacy impact assessment reveals that a small number of individuals can be uniquely identified when combined with public voter registration data. Which control would most directly mitigate this re-identification risk?

   • AGeneralize the zip code to the first three digits and replace exact birth dates with year of birth.
   • BRestrict access to the aggregated dataset to authorized researchers only.
   • CEncrypt the diagnosis codes in the aggregated dataset.
   • DIncrease the sample size by adding more hospitals to the aggregation.
   Reveal Solution Discussion Select an answer first