Free CompTIA Data+ Exam DA0-001 Exam Practice Test

An analyst wants to create a historical data set for the past five years with each year in its own data set. Which of the following methods is the best way to create this historical data set?

• Data transpose
• Data concatenation
• Data append
• Data normalization

An analyst in a consumer bank department wants to showcase the concentration of accounts opened in the United States by ZIP Code to describe the effectiveness of the bank's marketing campaigns. Which of the following would be the best way to visualize the data?

• A stacked chart
• A tree map
• A waterfall chart
• A geographic map

Which of following is a non-relational database?

• Neo4j
• SQLite
• MySQL
• PostgreSQL

The senior management team at a company receives a detailed sales report at the end of each quarter. The report is several pages long and includes data from dozens of offices across the country. The team wants a better way to get a quick snapshot of what is included in the report. Which of the following modifications would best meet this requirement?

• Modifying documentation elements to include reference data sources
• Modifying the font size and style so important data points are more visible
• Modifying the report to include a summary section with observations and insights
• Modifying the report layout so it is easier to follow and understand

A data analyst has received a data set that contains actual and projected sales for the fourth quarter of 2019. Which of the following statistical methods should the analyst use to find the measure of dispersion?

• Mean
• Variance
• Correlation
• Confidence interval

An analyst wants to combine two data sets into a single spreadsheet. Column names from the first spreadsheet are listed in rows in the second spreadsheet. Which of the following is the first step the analyst should take to combine the data sets?

• Blend
• Merge
• Concatenate
• Transpose

Which of the following is used for calculations and pivot tables?

• IBM SPSS
• SAS
• Microsoft Excel
• Domo

A county in Illinois is conducting a survey to determine the mean annual income per household. The county is 427sq mi (2.65q km). Which of the following sampling methods would MOST likely result in a representative sample?

• A stratified phone survey of 100 people that is conducted between 2:00 p.m. and 3:00 p.m.
• A systematic survey that is sent to 100 single-family homes in the county
• Surveys sent to ten randomly selected homes within 5mi (8km) of the county's office
• Surveys sent to 100 randomly selected homes that are reflective of the population

Which of the following should be accomplished NEXT after understanding a business requirement for a data analysis report?

• Rephrase the business requirement.
• Determine the data necessary for the analysis
• Build a mock dashboard/presentation layout.
• Perform exploratory data analysis.

A data analyst needs to create a weekly recurring report on sales performance and distribute it to all sales managers. Which of the following would be the BEST method to automate and ensure successful delivery for this task?

• Use scheduled report delivery.
• Implement subscription access delivery.
• Print out a copy.
• Upload the report to the server.