Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home CompTIA DA0-001

CompTIA DA0-001 Exam Practice Questions (P. 1)

  • Full Access (321 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #1
A data analyst needs to calculate the mean for Q1 sales using the data set below:

Which of the following is the mean?
  1. A
    $2,466.18
  2. B
    $2,667.60
  3. C
    $3,082.72
  4. D
    $12,330.88

Correct Answer:
B

Question #2
A data analyst is creating a report that will provide information about various regions, products, and time periods. Which of the following formats would be the MOST efficient way to deliver this report?
  1. A
    A workbook with multiple tabs for each region
  2. B
    A daily email with snapshots of regional summaries
  3. C
    A static report with a different page for every filtered view
  4. D
    A dashboard with filters at the top that the user can toggle

Correct Answer:
D

Question #3
A customer list from a financial services company is shown below:

A data analyst wants to create a likely-to-buy score on a scale from 0 to 100, based on an average of the three numerical variables: number of credit cards, age, and income. Which of the following should the analyst do to the variables to ensure they all have the same weight in the score calculation?
  1. A
    Recode the variables.
  2. B
    Calculate the percentiles of the variables.
  3. C
    Calculate the standard deviations of the variables.
  4. D
    Normalize the variables.

Correct Answer:
C

Question #4
Which of the following actions should be taken when transmitting data to mitigate the chance of a data leak occurring? (Choose two.)
  1. A
    Data identification
  2. B
    Data processing
  3. C
    Data reporting
  4. D
    Data encryption
  5. E
    Data masking
  6. F
    Fata removal

Correct Answer:
DE

Question #5
A data analyst has been asked to organize the table below in the following ways:

By sales from high to low -

By state in alphabetic order -

Which of the following functions will allow the data analyst to organize the table in this manner?
  1. A
    Conditional formatting
  2. B
    Grouping
  3. C
    Filtering
  4. D
    Sorting

Correct Answer:
B

Question #6
Which of the following BEST describes the issue in which character values are mixed with integer values in a data set column?
  1. A
    Duplicate data
  2. B
    Missing data
  3. C
    Data outliers
  4. D
    Invalid data type

Correct Answer:
A

Question #7
Which of the following is a process that is used during data integration to collect, blend, and load data?
  1. A
    MDM
  2. B
    ETL
  3. C
    OLTP
  4. D
    BI

Correct Answer:
B

Question #8
An analyst has received the requirements for an internal user dashboard. The analyst confirms the data sources and then creates a wireframe. Which of the following is the NEXT step the analyst should take in the dashboard creation process?
  1. A
    Optimize the dashboard.
  2. B
    Create subscriptions.
  3. C
    Get stakeholder approval.
  4. D
    Deploy to production.

Correct Answer:
A

Question #9
A data analyst has been asked to derive a new variable labeled “Promotion_flag” based on the total quantity sold by each salesperson. Given the table below:

Which of the following functions would the analyst consider appropriate to flag “Yes” for every salesperson who has a number above 1,000,000 in the Quantity_sold column?
  1. A
    Date
  2. B
    Mathematical
  3. C
    Logical
  4. D
    Aggregate

Correct Answer:
D

Question #10
Given the diagram below:

Which of the following data schemas shown?
  1. A
    Key-value pairs
  2. B
    Online transactional processing
  3. C
    Data lake
  4. D
    Relational database

Correct Answer:
D

Next Questions

All Pages