AP CSP Practice Test Data Analysis

Big Idea 2 Practice Test - Part 2

Data Analysis & Visualization

25 Multiple-Choice Questions

⏱ 30 minutes recommended 📊 25 questions 🎯 Big Idea 2 Focus

Test Instructions

  • This test focuses on Big Idea 2: Metadata, databases, data extraction, trends, and data privacy
  • Select one answer for each question
  • You can change your answers before submitting
  • Click "Submit Test" when finished to see your score and explanations
  • For AP exam practice, try to complete the test in 30 minutes
Question 1
A streaming service stores data about movie rentals including date, title, city, and rental count per city. Which question CANNOT be answered using only this database?
Question 2
A social media site stores post content and metadata (timestamp, username, commenter names, comment times). For which goal is analyzing the data more useful than analyzing the metadata?
Question 3
A photo file contains RGB pixel data plus metadata (date, time, GPS location). For which goal is analyzing metadata more appropriate than analyzing pixel data?
Question 4
An e-book library contains metadata for each book. Which is LEAST likely to be included in the metadata?
Question 5
A search engine tracks search term popularity filtered by region, date, and category. Which question is LEAST answerable using this feature?
Question 6
A smartphone stores photo metadata (filename, date/time, GPS location). Which can be determined using this data?

I. Number of photos taken at a specific location
II. Number of photos taken in the past year
III. Name of the person who took the most recent photo
Question 7
An ISP plans to cache frequently-visited web pages for each user. Which outcome is LEAST likely?
Question 8
A database of CS students contains gender, college state, and GPA. Which question CANNOT be answered?
Question 9
A footwear retailer's database contains: item ID, type, price, size, color, quantity available. Using only this database, which can be determined?
Question 10
Students take weather photos with metadata (date, time, location, pixel RGB values). For which goals is analyzing metadata more appropriate? Select TWO answers.
Question 11
A palindrome-filtering algorithm processes a word list to return first letters of palindromes in alphabetical order. Which sequence produces correct results?
Question 12
A database stores daily temperature readings for 50 cities. Which analysis would provide the MOST useful climate trend information?
Question 13
An online retailer collects customer browsing data including pages viewed, time spent, and purchase history. Which is a valid privacy concern?
Question 14
A fitness app tracks user workout data (type, duration, heart rate, GPS route). Which question requires analyzing the GPS data rather than other metadata?
Question 15
A school database contains student ID, grade level, GPA, and attendance. Which analysis would identify students needing academic support?
Question 16
A music streaming service analyzes listening data to recommend songs. Which data point is MOST relevant for personalization?
Question 17
A traffic monitoring system stores vehicle count, speed, location, and timestamp. Which trend analysis is MOST valuable for city planning?
Question 18
A company's employee database includes name, department, salary, and hire date. Which query would identify pay equity issues?
Question 19
An app stores user location history. Which represents the GREATEST privacy risk?
Question 20
A library tracks book checkout data (title, borrower ID, checkout date, return date). Which pattern indicates a popular book series?
Question 21
A weather database contains daily temperature, precipitation, and wind speed for 100 cities over 20 years. Which is the BEST way to identify climate change trends?
Question 22
A social network allows users to control privacy settings for their posts. Which statement about data privacy is MOST accurate?
Question 23
An e-commerce site tracks "items viewed" vs "items purchased" to calculate conversion rates. This analysis is an example of:
Question 24
A hospital database contains patient records with diagnosis codes, treatment dates, and outcomes. Which use of this data raises ETHICAL concerns?
Question 25
A city's public transit system collects ridership data (route, time, fare type). Which analysis would BEST improve service?
--

out of 25

--

Answer Review

Get in Touch

Whether you're a student, parent, or teacher — I'd love to hear from you.

Just want free AP CS resources?

Enter your email below and check the subscribe box — no message needed. Students get daily practice questions and study tips. Teachers get curriculum resources and teaching strategies.

Typically responds within 24 hours

Message Sent!

Thanks for reaching out. I'll get back to you within 24 hours.

🏫 Welcome, fellow educator!

I offer curriculum resources, practice materials, and study guides designed for AP CS teachers. Let me know what you're looking for — whether it's classroom materials, a guest speaker, or Teachers Pay Teachers resources.

Email

[email protected]

📚

Courses

AP CSA, CSP, & Cybersecurity

Response Time

Within 24 hours

Prefer email? Reach me directly at [email protected]