CompTIA DA0-002 Online Practice Questions and Exam Preparation

CompTIA DA0-002 Online Questions & Answers

• Question 71:

  Which of the following is a difference between a primary key and a unique key?

  A. A unique key cannot take null values, whereas a primary key can take null values.
  B. There can be only one primary key in a data set, whereas there can be multiple unique keys.
  C. A primary key can take a value more than once, whereas a unique key cannot take a value more than once.
  D. A primary key cannot be a date variable, whereas a unique key can be.
  B. There can be only one primary key in a data set, whereas there can be multiple unique keys.

• Question 72:

  A data analyst needs to join together a table data source and a web API data source using Python. Which of the following is the best way to accomplish this task?

  A. Convert the data from the API and database to a varchar format and convert them to pandas DataFrames that are then merged together.
  B. Convert the data from the API and database to a JSON format and convert them to pandas DataFrames that are then merged together.
  C. Convert the data from the API and database to a TXT format and convert them to pandas DataFrames that are then merged together.
  D. Convert the data from the API and database to a string format and convert them to pandas DataFrames that are then merged together.
  B. Convert the data from the API and database to a JSON format and convert them to pandas DataFrames that are then merged together.

• Question 73:

  Which of the following tables holds relational keys and numeric values?

  A. Fact
  B. Graph
  C. Dimensional
  D. Transactional
  A. Fact

• Question 74:

  A data analyst encounters an issue with new software and a code that they are using. The analyst includes print statements in the code to try to identify the issue, without success. An informal peer review of the code also produces the same result. The analyst confirms that the software is updated to the latest version and compatible with the code. Which of the following troubleshooting steps should the analyst take next?

  A. Use the old software and preexisting code, since both were functional.
  B. Contact the IT department and inform them that the software has a bug.
  C. Escalate to the department manager and ask for assistance.
  D. Research the issue online and see if a solution is available.
  D. Research the issue online and see if a solution is available.

• Question 75:

  Software end users are happy with the quality of product support provided. However, they frequently raise concerns about the long wait time for resolutions. An IT manager wants to improve the current support process. Which of the following should the manager use for this review?

  A. Infographic
  B. KPI
  C. Survey
  D. UAT
  C. Survey

• Question 76:

  A table in a hospital database has a column for patient height in inches and a column for patient height in centimeters. This is an example of:

  A. dependent data.
  B. duplicate data.
  C. invalid data
  D. redundant data
  D. redundant data

• Question 77:

  Which of the following is the most efficient to use when programming repeatable tasks?

  A. LLM
  B. Deep learning
  C. NLP
  D. RPA
  D. RPA

• Question 78:

  A data company needs a visualization that shows the availability zones from the last ten years and any future availability zones that the company will be using in the next five years. Which of thefollowing is the most appropriate visualization to display this information?

  A. Bar chart
  B. Mosaic plot
  C. Map
  D. Pie chart
  C. Map

• Question 79:

  A data analyst receives four files that need to be unified into a single spreadsheet for further analysis. All of the files have the same structure, number of columns, and field names, but each file contains different values. Which of the following methods will help the analyst convert the files into a single spreadsheet?

  A. Merging
  B. Appending
  C. Parsing
  D. Clustering
  B. Appending

• Question 80:

  An analyst must use the same data to create reports for police patrol supervisors, the city council, and a public website. Which of the following is the best way to differentiate the reports?

  A. Persona type
  B. Detail levels
  C. Accessibility
  D. Sensitivity
  A. Persona type