DA0-001 practice questions 171–180

1. Question 171 · 365 in bank

   Given the following data:

   

   Which of the following BEST describes the data set?

   • AThere is data bias.
   • BThe data is incomplete.
   • CThe data is inconsistent.
   • DThe data is outliers.

   Show answer

   Answer: D

   Explanation

   C. The data is inconsistent. There are a few points of inconsistency: Jessie is listed as being 3 years old with an annual income of $75,000, which is not typical as this age is not within working age. Carlos is listed with an annual income of $75, which is unusually low and inconsistent with what one would expect for annual income data. Sara is listed with an annual income of $0, which may be accurate but is atypical and could be considered an outlier or require further context. These inconsistencies suggest that there may be errors or irregularities in the data collection or recording process.

   Source: Adapted from community discussion — Alice00085

   Next question

2. Question 172 · 365 in bank

   An analysts building a monthly report for production and wants to ensure the audience is aware of its once-a-month cadence. Which of the following is the MOST important to convey that information?

   • AThe date of the dashboard build
   • BThe data refresh date
   • CA report summary
   • DFrequently asked questions

   Show answer

   Answer: B

   Next question

3. Question 173 · 365 in bank

   An analyst is working with the income data of suburban families in the United States. The data set has a lot of outliers, and the analyst needs to provide a measure that represents the typical income. Which of the following would BEST fulfill the analyst’s goal?

   • AMedian
   • BMean
   • CMode
   • DStandard deviation

   Show answer

   Answer: A

   Explanation

   The best measure that would fulfill the analyst's goal is the Median. The median represents the middle value of a data set when the data is sorted in ascending or descending order. It is less sensitive to outliers and provides a better representation of typical values compared to the mean, which is affected by outliers. The mode represents the most frequently occurring value in a data set, but it may not provide a good representation of typical values. The standard deviation measures the spread of a data set, but it does not provide an average value. In this case, since the data set has a lot of outliers, the median would provide a better representation of the typical income compared to the mean, which would be affected by the outliers.

   Source: Adapted from community discussion — ronniehaang

   Next question

4. Question 174 · 365 in bank

   Which of the following would be used to store unstructured data from different sources?

   • AA data lake
   • BA database management system
   • CA database
   • DA data warehouse

   Show answer

   Answer: A

   Next question

5. Question 175 · 365 in bank

   A data analyst has received a list of customer names in alphabetical order that needs to instead be put in order by transaction date. Which of the following data manipulation techniques should the analyst use?

   • AAggregating
   • BTransposing
   • CSorting
   • DConsolidating

   Show answer

   Answer: C

   Next question

6. Question 176 · 365 in bank

   Which of the following BEST describes the issue in which character values are mixed with integer values in a data set column?

   • ADuplicate data
   • BMissing data
   • CData outliers
   • DInvalid data type

   Show answer

   Answer: D

   Explanation

   D. Invalid data type is the BEST description for the issue in which character values are mixed with integer values in a data set column. In this case, the data set column has a mix of two different data types - character values (e.g. text or string) and integer values (whole numbers). This is considered invalid as a data set column should have a consistent data type for all values in the column. When character values are mixed with integer values, it can cause problems during data analysis and processing, as the software may not know how to handle these mixed values. For example, if the analyst tries to perform mathematical operations on the column, the software may produce an error or incorrect results, as it does not know how to handle the character values.

   Source: Adapted from community discussion — ronniehaang

   Next question

7. Question 177 · 365 in bank

   An analyst is designing a dashboard to determine which site has the highest percentage of new customers. The analyst must choose an appropriate chart to include in the dashboard. The following data is available:

   

   Which of the following types of charts should be considered to BEST display the data?

   • AInclude a bar chart using the site and the percentage of new customers data.
   • BInclude a line chart using the site and the percentage of new customers data.
   • CInclude a pie chat using the site and percentage of new customers data.
   • DInclude a scatter chart using the site and the percent of new customers data.

   Show answer

   Answer: A

   Explanation

   A. the bar chart would be better then a pie chart (usually used for percent) because, the data set shows percent increases not percent of a whole.

   Source: Adapted from community discussion — Correct_Damage

   Next question

8. Question 178 · 365 in bank

   A cereal manufacturer wants to determine whether the sugar content of its cereal has increased over the years. Which of the following is the appropriate descriptive statistic to use?

   • AFrequency
   • BPercent change
   • CVariance
   • DMean

   Show answer

   Answer: B

   Explanation

   ( B ). To determine whether the sugar content of the cereal has increased over the years, the appropriate descriptive statistic to use is percent change. Percent change allows you to compare the difference in the sugar content between different years as a percentage of the initial value.

   Source: Adapted from community discussion — Alice00085

   Next question

9. Question 179 · 365 in bank

   A data analyst needs to analyze a sales data set to identify the sales representatives who are selling the most units per month. Which of the following should the analyst perform?

   • AA sales analysis
   • BA link analysis
   • CA performance analysis
   • DA trend analysis

   Show answer

   Answer: C

   Next question

10. Question 180 · 365 in bank

    The process of performing initial investigations on data to spot outliers, discover patterns, and test assumptions with statistical insight and graphical visualization is called:

    • Aa t-test.
    • Ba performance analysis.
    • Can exploratory data analysis.
    • Da link analysis.

    Show answer

    Answer: C

    Next question

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

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