DA0-001 practice questions 91–100

1. Question 91 · 365 in bank

   Given the following numbers: 7, 2, 3, 3, 5 Which of the following is the mean?

   • A2
   • B3
   • C4
   • D7

   Show answer

   Answer: C

   Next question

2. Question 92 · 365 in bank

   A data analyst has been asked to manipulate the data in the table below by first applying a DISTINCT function, and then applying a SUM function, to get the total product cost for a customer:

   

   Which of the following is the final cost of the product?

   • A$5,402
   • B$6,297
   • C$7,634
   • D$8,642

   Show answer

   Answer: D

   Next question

3. Question 93 · 365 in bank

   A market research firm has data sets based on surveys. A data analyst wants to know if any outliers are present in a data set. Which of the following would be the BEST method to examine the numerical variables in the data set visually and find any outliers?

   • APlot the linear correlations between each pair of variables and look for unusual relationships
   • BCreate a bar chart for each variable and look for any distributions that are unusual.
   • CBuild a scatter plot of each variable and look for observations that are out of place.
   • DOrder each variable in a spreadsheet from lowest to highest and look for unusual numbers at the beginning or at the end of the list.

   Show answer

   Answer: C

   Next question

4. Question 94 · 365 in bank

   A staff member is analyzing open-ended customer comments from an email survey. Which of the following is the EASIEST way to visualize the data?

   • AA stacked chart
   • BA word cloud
   • CA bar chart
   • DA bubble chart

   Show answer

   Answer: B

   Next question

5. Question 95 · 365 in bank

   A product department wants to review the performance of all products that launched in 2019 in the Midwest. The data provided in the table below is for all sales throughout the entire company and will need to be filtered prior to review.

   

   Which of the following filters must be applied to get the desired results?

   • ALaunch year and region
   • BRegion and product
   • CBrand and sales
   • DLaunch year and product

   Show answer

   Answer: A

   Next question

6. Question 96 · 365 in bank

   Which of the following inferential statistical methods would be used to determine if there is a significant difference between the means of two groups?

   • Ap-value
   • BZ-score
   • CChi-squared test
   • Dt-test

   Show answer

   Answer: D

   Next question

7. Question 97 · 365 in bank

   A data analyst works for a condominium development company. The company is undergoing unit number changes. Which of the following would be MOST appropriate to include on the unit inventory sheet that is shown in board meetings?

   • ADisplay a column with historical unit numbers and new unit numbers.
   • BCreate a new unit inventory with new unit numbers only.
   • CDelete historical files with previous unit numbers.
   • DCreate a hidden column that shows the historical unit numbers.

   Show answer

   Answer: A

   Next question

8. Question 98 · 365 in bank

   A data analyst needs to present the results of an online marketing campaign to the marketing manager. The manager wants to see the most important KPIs and measure the return on marketing investment. Which of the following should the data analyst use to BEST communicate this information to the manager?

   • AA real-time monitor that allows the manager to view performance the day the campaign was launched
   • BA sell-service dashboard that allows the manager to look at the company’s annual budget performance
   • CA spreadsheet of the raw data from all marketing campaigns and channels
   • DA summary with statistics, conclusions, and recommendations from the data analyst

   Show answer

   Answer: D

   Explanation

   D. To communicate the results of an online marketing campaign to the marketing manager, the data analyst should provide a summary that includes statistics, conclusions, and recommendations. This summary should highlight the most important key performance indicators (KPIs) and measure the return on marketing investment. The summary should be presented in a clear and concise manner, and should be tailored to the specific needs and interests of the manager. The other options (a real-time monitor, a self-service dashboard, or a spreadsheet of raw data) would not be as effective at communicating the key information in a clear and concise manner.

   Source: Adapted from community discussion — CineFeX

   Next question

9. Question 99 · 365 in bank

   The accounting team has requested a series of self-serve, dynamic reports. Aside from the reporting time frame, the report criteria are identical. Which of the following should the analyst create?

   • AA single report with the option to select the date range
   • BOne consolidated report with all available data
   • CAutomated reports to be distributed based on the time frames in the requirements
   • DThe reports as requested in the requirements document

   Show answer

   Answer: A

   Next question

10. Question 100 · 365 in bank

    Which of the following BEST describes an ad hoc report?

    • AA one-time report
    • BA recurring report
    • CA tactical report
    • DA monthly report

    Show answer

    Answer: A

    Next question

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

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