IT Specialist : Data Analytics Practice Exam 1. You survey 899 people regarding transportation to and from work. The following table shows the data: Transportation Mode Train Walk Bus Car or Truck Bicycle Number of People 123 23 232 455 66 You want to visualize the relative percentage of each transportation mode. Which chart type reports this data correctly? A. B. C. D. Answer:A 2. Why should you use an ETL tool? A. To create a data set from two different systems B. To create a regression analysis C. To calculate a confidence interval for a forecast D. To create a visualization for a presentation 3. A school gathers population data for nearby coyotes and rabbits Year 1990 1991 1992 1993 1994 1995 1996 Coyote 50 68 89 62 39 51 63 Rabbit 216 175 145 181 245 210 198 The school creates a visualization to display the data. For each conclusion about the visualization and data, select Yes if it is true or No if it is false. A. Between 1994 and 1995, coyotes ate 35 rabbits. Answer:NO B. The coyote population increased from 1990 - 1992. Answer:YES C. When the rabbit population increases, the coyote population decreases Answer:NO 4. A school holds a fundraiser for three months. Five different clubs participate in the fundraiser. The school creates the following visualization. For each statement, select Yes if the chart supports this type of analysis or No if it does not. A. Determine whether any club consistently raised more money than the others. Answer:YES B. Determine in which month the most money was earned. Answer:YES C. Determine whether there is a correlation between the number of clubs raising money and the total amount earned. Answer:YES 5. Which variable is a Boolean variable? A. True B. 0.00 C. customer 123 D. 42.34 6. You need to run an analysis to determine whether a variable of interest had statistically significant impact of an event using a 95% confidence interval When you look at the statistical output of your analysis, you notice the p-value for the impact of your variable on the event was p < 0.05 What should you conclude? A. We cannot determine statistical significance from the p-value, only from the tvalue B. The variable of interest had a statistically significant impact on the event C. The variable of interest did not have a statistically significant impact on the event D. We can partially determine statistical significance from the p-value, but need more information 7. You are working with a software developer to incorporate data into a software application. Because of the amount of data involved, you need to choose a compact file format. Which file format should you choose? A. XML B. JSON C. TXT D. CSV 8. A department store website sells all types of clothing. By clicking the "shirts" button, all items except for shirts will be hidden. What is the name of this process? A. Truncating B. Sorting C. Filtering D. Appending 9. A company administers a survey to identify student political affiliations. To protect survey respondents, they replace the name of each respondent with a number. The original names are deleted entirely and are unrecoverable to ensure the students will never be identifiable from their data Which process was used? A. Pseudonymization B. Anonymization C. Filtering D. Data Cleaning 10. A dessert shop has hired you to help determine how to maximize profits. The manager has provided you with a list of cupcake sales for the past 5 years. She wants to know which cupcakes the store should promote to maximize profits. Which data analysis method should you use? A. Backward propagation B. Classification C. Regression analysis D. Clustering