🔥 40% Off Crucial Exams Memberships — This Week Only

3 days, 6 hours remaining!
Crucial Exams

CompTIA Data+ DA0-002 (V2) Practice Question

You have imported 500 000 rows of customer-survey responses into a PostgreSQL table named survey_responses. Each respondent should appear exactly once, identified by respondent_id. During initial data exploration you want to list only those respondent_id values that are duplicated and show how many times each duplicate occurs so you can decide how to resolve them. Which SQL query accomplishes this goal?

  • SELECT respondent_id FROM survey_responses GROUP BY respondent_id;

  • SELECT respondent_id FROM survey_responses WHERE respondent_id IS NULL;

  • SELECT respondent_id, COUNT() AS occurrences FROM survey_responses GROUP BY respondent_id HAVING COUNT() > 1;

  • SELECT DISTINCT respondent_id FROM survey_responses;

CompTIA Data+ DA0-002 (V2)
Data Acquisition and Preparation
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot