CompTIA DA0-002 Online Practice Questions and Exam Preparation

CompTIA DA0-002 Online Questions & Answers

• Question 121:

  A data analyst received the information in the table below from a recently completed marketing campaign: Which of the following is the total order conversion rate?

  

  A. 13.2%
  B. 14.8%
  C. 22.3%
  D. 85.2%
  B. 14.8%

• Question 122:

  Which of the following best represents a type of infrastructure that requires a company to purchase and maintain all of its own servers?

  A. Private
  B. Cloud
  C. Hybrid
  D. Public
  A. Private

• Question 123:

  A data professional wants to identify all customers who made a purchase in January. Given the following table:

  

  Which of the following types of functions should the professional use to flag the customers?

  A. Statistical
  B. Logical
  C. Mathematical
  D. Date
  B. Logical

• Question 124:

  The sales department wants to include the composition of total sales amounts across all three sales channels in a report. Given the following sample sales table:

  

  Which of the following visualizations is the most appropriate?

  A. Pivot table
  B. Pie chart
  C. KPI card
  D. Box plot
  B. Pie chart

• Question 125:

  Given the table below:

  

  Which of the following variable types BEST describes the "Year" column?

  A. Numeric
  B. Date
  C. Alphanumeric
  D. Text
  B. Date

• Question 126:

  Which of the following data sources makes online data consumption easier?

  A. Data mart
  B. Web scraping
  C. Database
  D. Application programming interface
  D. Application programming interface

• Question 127:

  Alex wants to use data from his corporate sale, CRM, and shipping systems to try and predict future sales. Which of the following systems is the most appropriate?

  A. Data mart.
  B. OLAP.
  C. Data Warehouse.
  D. OLTP.
  C. Data Warehouse.

• Question 128:

  What SQL command is used to delete an entire table from a database?

  A. DROP.
  B. MODIFY.
  C. DELETE.
  D. ALTER.
  A. DROP.

• Question 129:

  Which of the following is business intelligence software?

  A. SAS
  B. Python
  C. Notepad++
  D. Tableau
  D. Tableau

• Question 130:

  An organization would like to add a secondary email field to its customer database in order to enrich the customer profiles. Which of the following data manipulation techniques should the analyst use to add this information?

  A. Blend
  B. Merge
  C. Append
  D. Aggregate
  C. Append