Free DA0-001 Sample Questions — Data+

Free DA0-001 sample questions for the Data+ exam. No account required: study at your own pace.

Want an interactive quiz? Take the full DA0-001 practice test

Looking for more? Click here to get the full PDF with 301+ practice questions for $10 for offline study and deeper preparation.

Question 1

During data cleansing, an analyst conducts measures of central tendency on a data set. Which of the following data is the analyst attempting to identify?

  • A. Duplicate
  • B. Missing
  • C. Outlying
  • D. Invalid
Show Answer
Correct Answer:
C. Outlying
Question 2

An analyst is summarizing the results from a recently completed survey. The results have been validated, but the analyst notices a few rows of data are missing at the bottom. For which of the following data qualities does this present the GREATEST issue?

  • A. Data completeness
  • B. Data integrity
  • C. Data consistency
  • D. Data accuracy
Show Answer
Correct Answer:
A. Data completeness
Question 3

An analyst is conducting a survey to measure height. Which of the following is the most likely to decrease as the analyst collects more survey responses?

  • A. The mean
  • B. The sample size
  • C. The population
  • D. The confidence interval
Show Answer
Correct Answer:
D. The confidence interval
Question 4

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
Show Answer
Correct Answer:
D. star schema
Question 5

A data analyst added some missing data to a list of observations, since only a small amount of the data was absent. Which of the following actions did the data analyst perform?

  • A. Concatenate
  • B. Parse
  • C. Append
  • D. Merge
Show Answer
Correct Answer:
C. Append
Question 6

Which of the following data formats are examples of unstructured data? (Choose two.)

  • A. XML
  • B. CSV
  • C. XLS
  • D. PNG
  • E. JSON
  • F. MP4
Show Answer
Correct Answer:
  • D. PNG
  • F. MP4
Question 7

Which of the following centralized documents best describes table schema and mapping used in future analyses?

  • A. Technical specification
  • B. Project requirements
  • C. Terms and conditions
  • D. Data dictionary
Show Answer
Correct Answer:
D. Data dictionary
Question 8

Which of the following data analytics tools would be BEST to retrieve data from a relational database management system?

  • A. R
  • B. Python
  • C. SQL
  • D. SAS
Show Answer
Correct Answer:
C. SQL
Question 9

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
Show Answer
Correct Answer:
C. Append
Question 10

During an interview, a hiring manager asks an analyst about the analyst's experience using programming languages. The analyst has used HTML, Python, and SQL. Which of the following explains what the analyst has most likely used HTML to accomplish?

  • A. To collect data from user input on the internet
  • B. To design graphics on video games
  • C. To manipulate data with statistical functions
  • D. To develop the front end of a website
Show Answer
Correct Answer:
D. To develop the front end of a website
Question 11

Which of the following best describes an exploratory analysis?

  • A. Involves the use of descriptive statistics to understand observations
  • B. Involves analysis of exploring data sets for performance tracking
  • C. Involves the testing of specific hypotheses
  • D. Involves the use of arithmetic algebra to determine the distribution
Show Answer
Correct Answer:
A. Involves the use of descriptive statistics to understand observations
Question 12

Which of the following types of analysis is used when comparing last week's sales to the previous week's sales?

  • A. Trend analysis
  • B. Exploratory analysis
  • C. Prescriptive analysis
  • D. Link analysis
Show Answer
Correct Answer:
A. Trend analysis
Question 13

Which of the following statistical measures is the most suitable and simple measure of the strength and direction of the linear relationship between price and volume?

  • A. Standard deviation
  • B. Interception
  • C. Correlation
  • D. Covariance
Show Answer
Correct Answer:
C. Correlation
Question 14

A data analyst is working with a team to create a dashboard for a client who requires on-demand access. Which of the following is the best delivery method to support the client's requirement?

  • A. Email
  • B. Scheduled
  • C. Subscription
  • D. Static
Show Answer
Correct Answer:
C. Subscription
Question 15

A business analyst has performed the following steps: • Reviewed research questions and business needs. • Identified data needs and how to collect this information. • Scoped the type of issues of interest based on the data. • Outlined the time frame needed. Which of the following describes what the analyst is trying to develop with this process?

  • A. Type of analysis
  • B. Type of data structures
  • C. Type of observations
  • D. Type of measurements
Show Answer
Correct Answer:
A. Type of analysis
Question 16

Which of the following BEST describes an ad hoc report?

  • A. one-time report
  • B. recurring report
  • C. tactical report
  • D. monthly report
Show Answer
Correct Answer:
A. one-time report
Question 17

A database administrator is required to mask certain table columns containing PII in order to comply with the company privacy policy. Which of the following are the most likely types of information the administrator should mask? (Choose two.)

  • A. Government-issued ID
  • B. Address
  • C. Order ID
  • D. Order date
  • E. Customer ID
  • F. Referral number
Show Answer
Correct Answer:
  • A. Government-issued ID
  • B. Address
Question 18

Which of the following types of data manipulation functions should a data analyst use to implement a YES/NO condition in a spreadsheet?

  • A. Text
  • B. Statistical
  • C. Financial
  • D. Logical
Show Answer
Correct Answer:
D. Logical
Question 19

An analyst is training a new coworker on the importance of data governance and is focusing on security requirements. Which of the following should the analyst include in the training? (Choose two.)

  • A. Data masking
  • B. Data encryption
  • C. Data parallelism
  • D. Data inclusiveness
  • E. Data exclusiveness
  • F. Data openness
Show Answer
Correct Answer:
D. Data inclusiveness
Question 20

Which of the following is an example of a structured data type?

  • A. Video file
  • B. Email message - B. Audio file
  • C. SQL database
Show Answer
Correct Answer:
C. SQL database

Aced these? Get the Full Exam

Download the complete DA0-001 study bundle with 301+ questions in a single printable PDF.