CompTIA DA0-002 Online Practice Questions and Exam Preparation

CompTIA DA0-002 Online Questions & Answers

• Question 1:

  Which of the following would be the best way to identify multicollinear attributes in a data set?

  A. Correlation coefficient
  B. Chi-squared test
  C. Two-sample f-test
  D. Two-way ANOVA
  A. Correlation coefficient

• Question 2:

  A company's entire server environment is located at the company's headquarters. Which of the following describes this type of environment?

  A. Cloud
  B. On-premises
  C. Public
  D. Hybrid
  B. On-premises

• Question 3:

  A data analyst reviews the following data set:

  

  Which of the following is the range value?

  A. 9
  B. 10
  C. 12
  D. 13
  D. 13

• Question 4:

  A data analyst creates a report, and some of the fields are empty. Which of the following conditions should the analyst add to a query to provide a list of all the records with empty fields?

  A. WHERE [ColumnName] = NULL
  B. WHERE [ColumnName] IS NULL
  C. WHERE [ColumnName] IS NOT NULL
  D. WHERE [ColumnName] = 'NULL'
  B. WHERE [ColumnName] IS NULL

• Question 5:

  Which of the following elements is the most important to include in a dashboard for internal technical audiences?

  A. Methodology section
  B. Dynamic features
  C. Key performance indicators
  D. Company branding
  C. Key performance indicators

• Question 6:

  A data analyst is evaluating all conditions in a query. Which of the following is the best logical function to accomplish this task?

  A. OR
  B. NOT
  C. AND
  D. IF
  C. AND

• Question 7:

  A product goes viral on social media, creating high demand. Distribution channels are facing supply chain issues because the testing and training models that are used for sales forecasting have not encountered similar demand. Which of the following best describes this situation?

  A. Model bias
  B. Data drift
  C. Incorrect sizing
  D. Skewing
  B. Data drift

• Question 8:

  Which of the following file types separates data using a delimiter?

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

• Question 9:

  Given the diagram below: Which of the following types of sampling is depicted in the image?

  

  A. Stratified
  B. Random
  C. Cluster
  D. Systematic
  D. Systematic

• Question 10:

  A data analyst is generating a custom report for a Chief Executive Officer's executive meeting. Later, the analyst learns that other custom reports will be required for future executive meetings. Which of the following delivery methods should the analyst use?

  A. Ad hoc
  B. Real-time
  C. Recurring
  D. Self-service
  C. Recurring