DA0-001 practice questions 11–20

1. Question 11 · 365 in bank

   A company’s human resources department has asked a data analyst to categorize the income of all employees into five salary bands:

   

   Which of the following types of functions would be the most appropriate to use?

   • AStatistical
   • BAggregate
   • CLogical
   • DMathematical

   Show answer

   Answer: C

   Explanation

   C. Logical functions are the most appropriate to use for categorizing data into bands, because they allow the data analyst to apply conditional statements and criteria to the data values. For example, the IF function can be used to assign a band name based on whether a value meets a certain condition or not. Other logical functions that can be useful for categorizing data are AND, OR, NOT, and IFERROR12.

   Source: Adapted from community discussion — Swift_and_Quick

   Next question

2. Question 12 · 365 in bank

   Five dogs have the following heights in millimeters: 300, 430, 170, 470, 600 Which of the following is the standard deviation for the five dogs?

   • A147mm
   • B154mm
   • C394mm
   • D21,704mm

   Show answer

   Answer: A

   Next question

3. Question 13 · 365 in bank

   A company’s marketing department wants to do a promotional campaign next month. A data analyst on the team has been asked to perform customer segmentation, looking at how recently a customer bought product, at what frequency, and at what value. Which of the following types of analysis would this practice be considered?

   • APrescriptive
   • BTrend
   • CGap
   • DCuster

   Show answer

   Answer: D

   Explanation

   D. Customer segmentation is the practice of dividing a customer base into smaller groups based on common characteristics such as demographics, buying behaviors, or psychographic traits. In this case, the analyst is looking at three characteristics: how recently a customer bought a product, how frequently they bought, and the value of their purchases. By grouping customers based on these characteristics, the company can tailor its promotional campaign to different segments, ensuring that the right message and offer is being communicated to the right people. Customer segmentation is considered a descriptive analysis, as it involves looking at the data and grouping it into meaningful categories. This type of analysis is often used in marketing and sales to better understand customer behavior and develop targeted strategies for customer engagement and retention. By using customer segmentation, companies can more effectively allocate their marketing resources and create more personalized experiences for their customers.

   Source: Adapted from community discussion — ronniehaang

   Next question

4. Question 14 · 365 in bank

   Which of the following is a non-parametric test?

   • AOne-sample t-test
   • BTwo-way ANOVA
   • CCorrelation coefficient
   • DSpearman’s rank correlation

   Show answer

   Answer: D

   Next question

5. Question 15 · 365 in bank

   Which of the following best describes a 95% confidence interval?

   • AThere is a 95% probability that the population mean lies within the stated interval.
   • BA stated range may contain 95% of the population mean, 95% of the time.
   • CA set of ranges contains the population mean with 95% certainty.
   • DA range contains 95% of the population mean.

   Show answer

   Answer: A

   Next question

6. Question 16 · 365 in bank

   Given the table below:

   

   Which of the following boxes indicates that a Type II error has occurred?

   • A1
   • B2
   • C3
   • D4

   Show answer

   Answer: C

   Next question

7. Question 17 · 365 in bank

   A user imports a data file into the accounts payable system each day. On a regular basis, the field input is not what the system is expecting, so it results in an error for the row and a broken import process. To resolve the issue, the user opens the file, finds the error in the row, and manually corrects it before attempting the import again. The import sometimes breaks on subsequent attempts, though. Which of the following changes should be made to this process to reduce the number of errors?

   • ADelete all incorrect inputs and upload the corrected file.
   • BHave the user manually review the file for data completeness before loading it.
   • CCreate a data field to data type validator to run the file through prior to import.
   • DSpot-check the file prior to import to catch and correct field errors.

   Show answer

   Answer: C

   Next question

8. Question 18 · 365 in bank

   Given the table below:

   

   Which of the following numbers represents a Type I error?

   • A1
   • B2
   • C3
   • D4

   Show answer

   Answer: C

   Next question

9. Question 19 · 365 in bank

   A sales manager wants quarterly sales reports broken down by unit and week. Which of the following data output lists includes the most necessary information?

   • AOrder number, salesperson, date shipped, recipient address, and price
   • BItem name, salesperson, recipient address, shipping cost, and date shipped
   • CItem number, item name, salesperson, date sold, and price
   • DItem name, salesperson, price, shipping cost, and date shipped

   Show answer

   Answer: C

   Next question

10. Question 20 · 365 in bank

    An analyst is preparing a report that contains weather data. The temperatures are shown in Fahrenheit, but they must be reported in Celsius. Which of the following should the analyst do to fix this issue?

    • ANormalize the data.
    • BStandardize the data.
    • CRescale the data.
    • DAggregate the data.

    Show answer

    Answer: C

    Explanation

    C. Rescale the data. Rescaling involves converting the data from one scale to another, which is precisely what's needed in this scenario. Converting temperatures from Fahrenheit to Celsius involves a specific mathematical transformation, making rescaling the appropriate choice. Options like normalizing, standardizing, or aggregating the data do not address the need to convert temperature scales.

    Source: Adapted from community discussion — Swift_and_Quick

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DA0-001 practice, question 11. 365 questions available.