DA0-001 practice questions 141–150

1. Question 141 · 365 in bank

   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?

   • ARecode the variables.
   • BCalculate the percentiles of the variables.
   • CCalculate the standard deviations of the variables.
   • DNormalize the variables.

   Show answer

   Answer: D

   Explanation

   D. Normalize the variables. Normalization involves transforming the values of the variables so that they have the same scale and range, typically from 0 to 1. This allows the analyst to ensure that each variable has the same weight in the calculation, since all the values are on the same scale. Normalizing the variables will also make it easier to interpret the results and compare the scores of different customers. This is important in creating a likely-to-buy score because it ensures that all three variables have an equal impact on the final score, rather than one variable having a larger weight due to its scale or range.

   Source: Adapted from community discussion — ronniehaang

   Next question

2. Question 142 · 365 in bank

   An analyst has been tracking company intranet usage and has been asked to create a chat to show the most-used/most-clicked portions of a homepage that contains more than 30 links. Which of the following visualizations would BEST illustrate this information?

   • AScatter plot
   • BHeat map
   • CPie chart
   • DInfographic

   Show answer

   Answer: B

   Explanation

   A heat map is a visual representation of data that uses color to encode values. It is often used to show patterns or trends in data, and it can be a useful tool for illustrating the most-used or most-clicked portions of a homepage. In the case of an analyst who has been tracking company intranet usage and has been asked to create a chart to show the most-used or most-clicked portions of a homepage that contains more than 30 links, a heat map would be the best visualization to illustrate this information. The heat map could use color to encode the number of clicks or usage for each link, with warmer colors indicating higher levels of usage and cooler colors indicating lower levels of usage. This would allow the analyst to quickly identify the most popular links on the homepage. The other options (scatter plot, pie chart, and infographic) are not as well suited to illustrating the most-used or most-clicked portions of a homepage, as they do not use color to encode data values and may not be as effective at showing patterns or trends.

   Source: Adapted from community discussion — CineFeX

   Next question

3. Question 143 · 365 in bank

   The marketing team has a C-level executive who requires a dashboard that displays real-time sales data and performance metrics. The dashboard needs to be accessible on the executives tablet during board meetings. Which of the following dashboard considerations is the most important?

   • AAudience
   • BTable dimensions
   • CData sources
   • DStreamlined access

   Show answer

   Answer: A

   Explanation

   The most important dashboard consideration for a C-level executive who needs real-time sales data and performance metrics accessible on their tablet during board meetings is A. Audience. Explanation: Audience: C-level executives require a concise and impactful overview of key metrics, focusing on high-level trends and strategic insights rather than detailed data analysis. The dashboard should be tailored specifically to their decision-making needs.

   Source: Adapted from community discussion — 927eb66

   Next question

4. Question 144 · 365 in bank

   An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000:

   

   Which of the following functions did the analyst use to generate the data in the Sales_indicator column?

   • AAggregate
   • BLogical
   • CDate
   • DSort

   Show answer

   Answer: B

   Explanation

   B. The Sales_indicator column in the table appears to be a boolean column that indicates whether sales exceeded $50,000 in a given month. This type of data can be generated using a logical function, which allows the analyst to evaluate a condition (in this case, whether sales exceeded $50,000) and return a boolean value (true or false) depending on the result of the evaluation. In the table, the Sales_indicator column contains the value "True" for those months in which sales exceeded $50,000, and the value "False" for those months in which sales did not exceed $50,000. This indicates that the analyst used a logical function to evaluate the sales data and generate the Sales_indicator column. The other options (aggregate, date, and sort) are not as well suited to generating the data in the Sales_indicator column, as they do not allow the analyst to evaluate a condition and return a boolean value based on the result of the evaluation.

   Source: Adapted from community discussion — CineFeX

   Next question

5. Question 145 · 365 in bank

   While reviewing survey data, an analyst notices respondents entered “Jan,” “January,” and “01” as responses for the month of January. Which of the following steps should be taken to ensure data consistency?

   • ADelete any of the responses that do not have “January” written out.
   • BReplace any of the responses that have “01”.
   • CFilter on any of the responses that do not say “January” and update them to “January”.
   • DSort any of the responses that say “Jan” and update them to “01”.

   Show answer

   Answer: C

   Explanation

   C. Filter on any of the responses that do not say “January” and update them to “January”. To ensure data consistency, it is important to standardize the responses. In this case, the analyst should filter on any responses that do not say “January” and update them to “January” to make sure all responses for the month of January are consistent. This will make it easier to analyze the data and avoid confusion or misinterpretation of the results. The other options (A, B, and D) may not be the best approach as deleting responses, replacing responses with a different value, or sorting and updating the responses may lead to a loss of information or a misinterpretation of the results. It is important to retain as much data as possible while also ensuring that the data is consistent and accurate.

   Source: Adapted from community discussion — ronniehaang

   Next question

6. Question 146 · 365 in bank

   Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?

   • AMissing data
   • BDuplicate data
   • CRedundant data
   • DInvalid data

   Show answer

   Answer: B

   Explanation

   B. A DISTINCT function is used to return unique values in a data set. It removes duplicates from the data set, so when a DISTINCT function is applied, the data cleansing issue of duplicate data will be fixed. Missing data, redundant data, and invalid data are not issues that will be fixed by applying a DISTINCT function. These issues can be addressed using other data cleansing techniques such as imputation for missing data, consolidation for redundant data, and validation for invalid data.

   Source: Adapted from community discussion — CineFeX

   Next question

7. Question 147 · 365 in bank

   A county in Illinois is conducting a survey to determine the mean annual income per household. The county is 427sq mi (2.65q km). Which of the following sampling methods would MOST likely result in a representative sample?

   • AA stratified phone survey of 100 people that is conducted between 2:00 p.m. and 3:00 p.m.
   • BA systematic survey that is sent to 100 single-family homes in the county
   • CSurveys sent to ten randomly selected homes within 5mi (8km) of the county’s office
   • DSurveys sent to 100 randomly selected homes that are reflective of the population

   Show answer

   Answer: D

   Explanation

   D. Surveys sent to 100 randomly selected homes that are reflective of the population is the most likely method to result in a representative sample. This is because it ensures that the sample is taken from a broad range of the population, and not just limited to a specific area or time. It also ensures that the sample is a random selection, which minimizes the risk of selection bias. This is considered a better method than the other options, which may result in a biased sample due to the specific methods used (such as only surveying homes within a specific area or at a specific time).

   Source: Adapted from community discussion — ronniehaang

   Next question

8. Question 148 · 365 in bank

   Which of the following statistical methods requires two or more categorical variables?

   • ASimple linear regression
   • BChi-squared test
   • CZ-test
   • DTwo-sample t-test

   Show answer

   Answer: B

   Explanation

   B. Chi-squared test requires two or more categorical variables. A chi-squared test is a statistical method used to determine if there is a significant relationship between two categorical variables. It is used to determine if the observed frequencies of a variable are different from what would be expected based on a theoretical probability distribution. For example, a chi-squared test could be used to determine if there is a significant difference in the number of people who smoke and the number of people who have lung cancer. To perform a chi-squared test, the data must be in the form of a contingency table, with each cell representing the count of observations for each combination of categories for the two variables being tested. The test statistic is calculated based on the observed and expected frequencies, and the results are compared to a critical value from a chi-squared distribution to determine if the relationship between the two variables is significant.

   Source: Adapted from community discussion — ronniehaang

   Next question

9. Question 149 · 365 in bank

   Which of the following data manipulation techniques is an example of a logical function?

   • AWHERE
   • BAGGREGATE
   • CBOOLEAN
   • DIF

   Show answer

   Answer: D

   Explanation

   D. D. IF The IF function is a logical function that allows you to perform a certain action based on a condition being met or not met. For example, you might use the IF function to determine whether a certain value is greater than or equal to a certain threshold. If the value is greater than or equal to the threshold, the function will return one result; if the value is less than the threshold, the function will return another result. WHERE, AGGREGATE, and BOOLEAN are not examples of logical functions. WHERE is a clause in SQL that is used to filter records based on specific conditions. AGGREGATE is a function that performs a calculation on a set of values and returns a single value. BOOLEAN is a data type that can represent one of two values: true or false.

   Source: Adapted from community discussion — CineFeX

   Next question

10. Question 150 · 365 in bank

    A sales team wants visibility of current sales numbers, pipeline, and team performance. The team would also like to see calculations of individuals’ earned commissions and projected commissions based on sales, but they want that information to be kept confidential. Which of the following would be the BEST way to provide this visibility?

    • ACreate a dashboard displaying a data refresh date so users know the current sales numbers and configure permissions to control access.
    • BCreate a dashboard for sales numbers, pipeline, and team and individual performance for the management team.
    • CCreate a dashboard with filters for the overall team, individuals, and management. Users can filter to see the data they want.
    • DCreate a dashboard with views for team, individuals, and management. Configure permissions to control access.

    Show answer

    Answer: A

    Explanation

    The BEST way to provide this visibility would be option A. Create a dashboard displaying a data refresh date so users know the current sales numbers and configure permissions to control access. This option allows the sales team to have a general visibility of the sales numbers, pipeline, and team performance, while also providing the calculation of individuals' earned and projected commissions based on sales. The data refresh date ensures that the sales team is aware of the most up-to-date information. Additionally, the configuration of permissions to control access ensures that the confidential information regarding individual commissions is only available to authorized users.

    Source: Adapted from community discussion — ronniehaang

    Next question

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

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