20+ practice questions focused on Data Acquisition and Preparation — one of the most tested topics on the CompTIA Data+ (DA0-002) exam. Each question includes a detailed explanation so you learn why the right answer is correct.
Start Data Acquisition and Preparation PracticeA data engineer is configuring access to a data lake in Amazon S3. What does the JSON policy shown allow?
Explanation: Based on the correct answer, the JSON policy shown implicitly grants the `s3:GetObject` action, which allows reading objects from the specified S3 bucket. In AWS IAM, reading objects requires explicit `GetObject` permission, making B the only correct choice.
Which THREE are common challenges when acquiring data from external APIs? (Choose three.)
Explanation: Authentication requirements are a common challenge because external APIs typically require valid credentials (e.g., API keys, OAuth 2.0 tokens, or JWT) to access protected resources. Without proper authentication, requests are rejected with HTTP 401 Unauthorized or 403 Forbidden errors, and managing token expiration, refresh cycles, and secure storage adds significant complexity to data acquisition pipelines.
Refer to the exhibit. A data engineer is setting up data acquisition from a cloud storage bucket with this policy. What does the policy enforce?
Explanation: The bucket policy includes a condition using a source IP address with a CIDR block, which restricts access to requests originating from the specified IP range. This enforces network-level access control, allowing only clients within that IP range to perform the allowed actions (like GET requests) on the bucket. Option D correctly identifies this IP-based restriction.
A data analyst needs to count the number of customers who have placed at least one order. Which SQL query should be used?
Explanation: COUNT(DISTINCT customer_id) returns the number of unique customers who have placed orders, correctly counting those with at least one order. Option B sums customer IDs, which is not a valid count. Option A uses invalid syntax. Option C counts all orders including duplicates.
A data analyst is pulling data from a production database for a report. The database contains customer orders with a column 'order_date'. The analyst notices that some orders have dates in the future. Which data quality issue does this represent?
Explanation: Future order dates violate a business rule that order_date must be in the past or present. This is a classic data integrity issue where the data does not conform to domain-specific constraints, such as 'order_date <= CURRENT_DATE'. The analyst should flag this as a violation of business rules, not a data type or consistency problem.
+15 more Data Acquisition and Preparation questions available
Practice all Data Acquisition and Preparation questions1. Baseline your knowledge
Start with 10 questions to gauge your current understanding of Data Acquisition and Preparation. This tells you whether you need a concept refresher or just practice.
2. Review every explanation
For each question — right or wrong — read the full explanation. Understanding why an answer is correct is more valuable than knowing the answer itself.
3. Focus on exam traps
Data Acquisition and Preparation questions on the DA0-002 frequently use trap wording. Look for subtle differences in answers that test your precision, not just general knowledge.
4. Reach 80% consistently
Do repeated sessions until you score 80%+ three times in a row. Then move to mixed-mode practice to test cross-topic recall under realistic conditions.
The exact number varies per candidate. Data Acquisition and Preparation is tested as part of the CompTIA Data+ (DA0-002) blueprint. Practicing with targeted Data Acquisition and Preparation questions ensures you can handle any format or difficulty that appears.
Yes. Courseiva provides free DA0-002 practice questions across all exam topics and domains. The platform includes topic-based practice, mock exams, missed-question review, bookmarked questions, and readiness tracking — no account required.
Difficulty is subjective, but Data Acquisition and Preparation is a high-priority exam concept tested in multiple ways — direct recall, scenario analysis, and command-output interpretation. Consistent practice is the best way to build confidence.
Launch a full Data Acquisition and Preparation practice session with instant scoring and detailed explanations.
Start Data Acquisition and Preparation Practice →