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. 5)

  • 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 #41
Which of the following is used for calculations and pivot tables?
  1. A
    IBM SPSS
  2. B
    SAS
  3. C
    Microsoft Excel
  4. D
    Domo

Correct Answer:
C

Question #42
Given the following report:

Which of the following components need to be added to ensure the report is point-in-time and static? (Choose two.)
  1. A
    A control group for the phrases
  2. B
    A summary of the KPIs
  3. C
    Filter buttons for the status
  4. D
    The date when the report was last accessed
  5. E
    The time period the report covers
  6. F
    The date on which the report was run

Correct Answer:
CE

Question #43
An analyst has been asked to validate data quality. Which of the following are the BEST reasons to validate data for quality control purposes? (Choose two.)
  1. A
    Retention
  2. B
    Integrity
  3. C
    Transmission
  4. D
    Consistency
  5. E
    Encryption
  6. F
    Deletion

Correct Answer:
BD

Question #44
A research analyst wants to determine whether the data being analyzed is connected to other datapoints. Which of the following is the BEST type of analysis to conduct?
  1. A
    Trend analysis
  2. B
    Performance analysis
  3. C
    Link analysis
  4. D
    Exploratory analysis

Correct Answer:
B

Question #45
Which of the following variable name formats would be problematic if used in the majority of data software programs?
  1. A
    First_Name_
  2. B
    FirstName
  3. C
    First_Name
  4. D
    First Name

Correct Answer:
D

Question #46
Which of the following describes the method of sampling in which elements of data are selected randomly from each of the small subgroups within a population?
  1. A
    Simple random
  2. B
    Cluster
  3. C
    Systematic
  4. D
    Stratified

Correct Answer:
C

Question #47
Given the following customer and order tables:


Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?
  1. A
    Five rows, eight columns
  2. B
    Seven rows, eight columns
  3. C
    Eight rows, seven columns
  4. D
    Nine rows, five columns

Correct Answer:
D

Question #48
A development company is constructing a new unit in its apartment complex. The complex has the following floor plans:

Using the average cost per square foot of the original floor plans, which of the following should be the price of the Rose unit?
  1. A
    $640,900
  2. B
    $690,000
  3. C
    $705,200
  4. D
    $702,500

Correct Answer:
C

Question #49
Which of the following is a control measure for preventing a data breach?
  1. A
    Data transmission
  2. B
    Data attribution
  3. C
    Data retention
  4. D
    Data encryption

Correct Answer:
D

Question #50
A user receives a large custom report to track company sales across various date ranges. The user then completes a series of manual calculations for each date range. Which of the following should an analyst suggest so the user has a dynamic, seamless experience?
  1. A
    Create multiple reports, one for each needed date range.
  2. B
    Build calculations into the report so they are done automatically.
  3. C
    Add macros to the report to speed up the filtering and calculations process.
  4. D
    Create a dashboard with a date range picker and calculations built in.

Correct Answer:
B

Previous Questions Next Questions

All Pages