CompTIA DA0-002 Online Practice Questions and Exam Preparation

CompTIA DA0-002 Online Questions & Answers

• Question 81:

  Given the information in the following tables: Which of the following describes merging these tables to create a master file that includes all transactions for both online and in-store sales?

  

  A. Data audit
  B. Data completeness
  C. Data validation
  D. Data consolidation
  D. Data consolidation

• Question 82:

  A database consists of one fact table that is composed of multiple dimensions. Each dimension is represented by a denormalized table. This structure is an example of a:

  A. non-relational schema.
  B. galaxy schema.
  C. snowflake schema.
  D. star schema.
  D. star schema.

• Question 83:

  A data analyst creates a report that identifies the middle 50% of the collected data. Which of the following best describes the analyst's findings?

  A. Interquartile range
  B. The difference between mode and median
  C. Mean variance
  D. Skewness from the slope
  A. Interquartile range

• Question 84:

  Which of the following data repositories stores unstructured and structured data?

  A. Data store
  B. Data silo
  C. Data mart
  D. Data lake
  D. Data lake

• Question 85:

  Which of the following allows a data analyst to send out a spreadsheet containing sensitive information without revealing personal details?

  A. Using a UUID in the data file
  B. Redacting all PII
  C. Adding access controls to the ID column
  D. Encrypting the spreadsheet
  B. Redacting all PII

• Question 86:

  A project manager requests an unscheduled report that provides a list of clients. Which of the following frequencies is best for this report?

  A. Annual
  B. Daily
  C. Weekly
  D. Ad hoc
  D. Ad hoc

• Question 87:

  A data analyst team needs to segment customers based on customer spending behavior. Given one million rows of data like the information in the following sales order table:

  

  Which of the following techniques should the team use for this task?

  A. Standardization
  B. Concatenate
  C. Binning
  D. Appending
  C. Binning

• Question 88:

  A data analyst is creating a forecast for a product line introduced early last year. Which of the following should the analyst use to create projected sales and customer satisfaction for next year?

  A. Standard deviation and constraints
  B. Mean and median
  C. Boolean data and an array
  D. Numerical and ordinal attributes
  D. Numerical and ordinal attributes

• Question 89:

  A sales manager wants quarterly sales reports broken down by unit and week. Which of the following data output lists includes the most necessary information?

  A. Order number. salesperson. date shipped, recipient address, and price
  B. Item name, salesperson. recipient address, shipping cost. and date shipped
  C. Item number, item name, salesperson. date sold. and price
  D. Item name. salesperson. price. shipping cost. and date shipped
  C. Item number, item name, salesperson. date sold. and price

• Question 90:

  A senior manager needs a report that can be generated and accessed at any time. Which of the following delivery methods should a data analyst use?

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