최신CompTIA Data+ - DA0-002무료샘플문제
문제1
A data analyst is gathering data from multiple tables in a database. The analyst needs certain columns from each table. Which of the following is the best method to accomplish this task?
A data analyst is gathering data from multiple tables in a database. The analyst needs certain columns from each table. Which of the following is the best method to accomplish this task?
정답: B
설명: (ExamPassdump 회원만 볼 수 있음)
문제2
A report triggers an error that prevents information from being displayed. However, the report was functional before a database upgrade. Which of the following should a data analyst do first to troubleshoot the problem?
A report triggers an error that prevents information from being displayed. However, the report was functional before a database upgrade. Which of the following should a data analyst do first to troubleshoot the problem?
정답: D
문제3
A data analyst created a dashboard to illustrate the traffic volume and mean response time for a call center. The traffic data is current, but the mean response time has not updated for more than an hour. Which of the following is the best way to verify the data's freshness?
A data analyst created a dashboard to illustrate the traffic volume and mean response time for a call center. The traffic data is current, but the mean response time has not updated for more than an hour. Which of the following is the best way to verify the data's freshness?
정답: C
설명: (ExamPassdump 회원만 볼 수 있음)
문제4
A data analyst wants to find the mean score that students received in science classes. Given the following tables:
Which of the following will produce the desired results?
A data analyst wants to find the mean score that students received in science classes. Given the following tables:
Which of the following will produce the desired results?
정답: A
설명: (ExamPassdump 회원만 볼 수 있음)
문제5
A teaching administrator wants to measure the distribution of student scores in a class. Which of the following statistical measures should the administrator use?
A teaching administrator wants to measure the distribution of student scores in a class. Which of the following statistical measures should the administrator use?
정답: D
설명: (ExamPassdump 회원만 볼 수 있음)
문제6
A data analyst needs to combine the results of two separate queries that have similar data and the same number of columns. The output must also have distinct rows. Which of the following should the data analyst use?
A data analyst needs to combine the results of two separate queries that have similar data and the same number of columns. The output must also have distinct rows. Which of the following should the data analyst use?
정답: D
설명: (ExamPassdump 회원만 볼 수 있음)
문제7
Which of the following data sources makes online data consumption easier?
Which of the following data sources makes online data consumption easier?
정답: C
설명: (ExamPassdump 회원만 볼 수 있음)
문제8
The human resources department wants to know the number of employees who earn $125,000 or more. However, the department is concerned about duplicates in the data set. Given the following table:
Which of the following SQL statements resolves this issue?
The human resources department wants to know the number of employees who earn $125,000 or more. However, the department is concerned about duplicates in the data set. Given the following table:
Which of the following SQL statements resolves this issue?
정답: A
설명: (ExamPassdump 회원만 볼 수 있음)
문제9
Which of the following makes data unreadable without a required key?
Which of the following makes data unreadable without a required key?
정답: B
설명: (ExamPassdump 회원만 볼 수 있음)
문제10
Hotspot Question
The director of operations at a power company needs data to help identify where company resources should be allocated in order to monitor activity for outages and restoration of power in the entire state. Specifically, the director wants to see the following:
- County outages
- Status
- Overall trend of outages
INSTRUCTIONS
Select each visualization to fit the appropriate space on the dashboard. Once you have selected all visualizations, use the drop-down menus to select the appropriate dashboard titles and axis labels, if applicable.
If at any time you would like to bring back the initial state of the simulation, please click the Reset All button.
Hotspot Question
The director of operations at a power company needs data to help identify where company resources should be allocated in order to monitor activity for outages and restoration of power in the entire state. Specifically, the director wants to see the following:
- County outages
- Status
- Overall trend of outages
INSTRUCTIONS
Select each visualization to fit the appropriate space on the dashboard. Once you have selected all visualizations, use the drop-down menus to select the appropriate dashboard titles and axis labels, if applicable.
If at any time you would like to bring back the initial state of the simulation, please click the Reset All button.
정답:
문제11
Before distributing a report, a marketing analyst notices that the total distinct promotional email messages is less than the combined total of emails sent. Which of the following is the most likely reason for this difference?
Before distributing a report, a marketing analyst notices that the total distinct promotional email messages is less than the combined total of emails sent. Which of the following is the most likely reason for this difference?
정답: A
문제12
An analyst is building a reporting deck. The deck must include tracking and visualizing metrics and row-level security. Which of the following actions should the analyst take after meeting all of the requirements?
An analyst is building a reporting deck. The deck must include tracking and visualizing metrics and row-level security. Which of the following actions should the analyst take after meeting all of the requirements?
정답: A
문제13
A data analyst is following up on a recent, company-wide data audit of customer invoice data.
Which of the following is the best option for the analyst to use?
A data analyst is following up on a recent, company-wide data audit of customer invoice data.
Which of the following is the best option for the analyst to use?
정답: B