CompTIA Data+ - DA0-002 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

A recent server migration applied an update to dataset naming conventions. Multiple users are now reporting stale information in an existing dashboard. The date in the dataset confirms a successful data refresh. Which of the following should a data analyst do first?

A. Filter the data in the dashboard. B. Verify that the dashboard subscription is not expired. C. Escalate user permissions on the server. D. Confirm the dashboard is pointed to the newest dataset.

Discussion 0

Correct Answer: D Vote an answer

Question 2

A complex report is being created from a database. Within the database the storage location of the orders, packaging, and logistics details is unclear. The table's attributes names are abbreviated and not easily identifiable. Which of the following types of documentation would be most useful for reference lookup?

A. Database specifications B. Entity-relationship diagrams C. Data dictionary D. Data flow diagrams

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 3

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. Verify the connection to the database. B. Check whether the data structures were modified. C. Change the report's refresh rate. D. Ensure the system has permissions for the report service.

Discussion 0

Correct Answer: A Vote an answer

Question 4

A data analyst is cleaning up a data set that contains images. The analysts wants to keep everything that was produced within the last 12 months. Which of the following best describes where the analyst should check for the date of creation on these products?

A. The folder creation date on the filesystem B. The data set creation date on the database C. The data dictionary of the data set D. The metadata of each item in the data set

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 5

A data analyst is creating a dashboard to monitor and manage processes on a daily, weekly, and quarterly basis. Which of the following types of dashboards is the best for this purpose?

A. Analytical B. Tactical C. Strategic D. Operational

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 6

An analyst needs to make a collection of sales dashboards for C-suite members, managers, and salespeople. Which of the following should the analyst consider when designing these dashboards?

A. Branding B. Sensitive information C. User persona type D. Accessibility

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 7

Which of the following best describes the semi-structured data that is gathered when web scraping?

A. JSON B. CSS C. CSV D. HTML

Discussion 0

Correct Answer: A Vote an answer

Question 8

A data analyst needs to provide a weekly sales report for the Chief Financial Officer. Which of the following delivery methods is the most appropriate?

A. A detailed text document B. A granular daily report in a dashboard C. A spreadsheet with raw data D. A high-level email

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 9

Which of the following best describes the purpose of a primary key?

A. To eliminate the need to join tables B. To provide a helper index that allows the database to find subsets of data easily C. To organize data so that the database has an efficient way to find data in a table D. To create a unique way to identify each row in a table

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 10

Which of the following is the best way to ensure a procedure performs appropriately during heavy use?

A. Requirements test B. Network throughput test C. Stress test D. User acceptance test

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 11

A data analyst needs to generate a list of employees who currently live in Dade, FL. Given the following table:

Which of the following SQL statements should the analyst use to complete this task?

A. SELECT * FROM Employee WHERE emp_city = 'Dade' OR emp_st = 'FL'; B. SELECT * FROM Employee WHERE emp_city LIKE 'D%'; C. SELECT * FROM Employee WHERE emp_city IN ('Dade', 'FL'); D. SELECT * FROM Employee WHERE emp_city = 'Dade' AND emp_st = 'FL';

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 12

The following SQL code returns an error in the program console:
SELECT firstName, lastName, SUM(income)
FROM companyRoster
SORT BY lastName, income
Which of the following changes allows this SQL code to run?

A. SELECT firstName, lastName, SUM(income) FROM companyRoster ORDER BY firstName, income B. SELECT firstName, lastName, SUM(income) FROM companyRoster GROUP BY firstName, lastName C. SELECT firstName, lastName, SUM(income) FROM companyRoster D. SELECT firstName, lastName, SUM(income) FROM companyRoster HAVING SUM(income) >
10000000

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 13

A data analyst is working on a three-year project to deliver sales reports on a monthly basis. The client wants a thorough analysis into customer profiles for a specific region and month. Which of the following delivery methods best fulfills this request?

A. Dynamic B. Ad hoc C. Self-service D. Dashboard

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 14

A sales manager wants a dashboard that shows sales aggregated by region and identifies high- volume sales by salesperson per region. Which of the following communication techniques best displays this information?

A. Level of detail B. Defined parameters C. User persona D. Filter options

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).