CompTIA DA0-002 Online Practice Questions and Exam Preparation

CompTIA DA0-002 Online Questions & Answers

• Question 131:

  A company's analytics manager wants all reports to be delivered once every seven days. Which of the following is the best delivery method?

  A. Recurring
  B. Ad hoc
  C. Custom
  D. Snapshot
  A. Recurring

• Question 132:

  Which of the following is found in metadata?

  A. Transformations
  B. Data lineage
  C. Syntax
  D. Variable types
  D. Variable types

• Question 133:

  A data breach occurs at a company. Which of the following actions should be taken?

  A. Make an announcement on social media so customers are aware as soon as possible.
  B. Tell the company management team and then tell regulatory agencies.
  C. Keep the incident a secret until the issue is resolved.
  D. Inform the entire IT sector, but ask for discretion.
  B. Tell the company management team and then tell regulatory agencies.

• Question 134:

  Which of the following best explains the purpose of data lineage?

  A. To see the steps and path of data flow through different systems
  B. To better understand the granularity of data variable relationships
  C. To track data transformations from acquisition through reporting
  D. To look up data definitions, ensuring consistent use across business units
  C. To track data transformations from acquisition through reporting

• Question 135:

  Which of the following is the best reason for a company to use a CSV file to share data instead of an Excel file?

  A. CSV files can store different types of encoding.
  B. CSV files are not vendor-specific.
  C. CSV files are smaller in size.
  D. CSV files are easier to change in text editors.
  B. CSV files are not vendor-specific.

• Question 136:

  An analyst is creating a resource to improve users' experience when they select specific records based on particular dates. Which of the following should the analyst use to create a resource that best meets user needs?

  A. Drop-down menu
  B. Date range
  C. Text field
  D. Frequency
  B. Date range

• Question 137:

  A data analyst has been asked to create an ad-hoc sales report for the Chief Executive Officer (CEO). Which of the following should be included in the report?

  A. The sales representatives' home addresses.
  B. Line-item SKU numbers.
  C. YTD total sales.
  D. The customers' first and last names.
  C. YTD total sales.

• Question 138:

  Which of the following AI types is the best option for time-series forecasting?

  A. Generative AI
  B. Foundational models
  C. Natural language processing
  D. Robotic process automation
  B. Foundational models

• Question 139:

  A data analyst calculated the average score per student without making any changes to the following table:

  

  Which of the following exploration techniques should the analyst have considered before calculating the average?

  A. Duplication
  B. Redundancy
  C. Binning
  D. Grouping
  A. Duplication

• Question 140:

  An analyst needs to produce a final dataset using the following tables:

  

  The expected output should be formatted as follows:

  | CourseID | SectionNumber | StudentID | FirstName | LastName |

  Which of the following actions is the best way to produce the requested output?

  A. Aggregate
  B. Join
  C. Group
  D. Filter
  B. Join