IT Specialist : Data Analytics Practice Exam 1. An analyst would like to obtain a subset of their data. What should they do to the data? A. Append B. Transpose C. Slice D. Merge 2. You want to display the continuous change of the money in your savings account over a period of 10 years. Which chart type should you use? A. Bar chart B. Scatter plot C. Pie chart D. Line graph 3. Your manager has asked for a report that explains the return on investment made from hiring additional staff members last year. What type of data should you use? A. Descriptive B. Prescriptive C. Diagnostic D. Predictive 4. A weather station records the average annual snowfall in inches for five years in three locations. The weather station wants to determine the distribution of the data set and whether it contains outliers. Which chart should they choose? Select the correct chart in the answer area. A. B. C. D. Answer:B 5. Answer each question about by p-values by selecting the correct option from each drop-down list. A. Which p-value indicates that you should reject the null hypothesis under a 95% confidence interval? Answer:.03. B. Which p-value indicates that the results likely occurred by chance under a 95% confidence interval? Answer:.97 C. What does a p-value of 0.01 indicate under a 95% confidence interval? Answer:The results are likely caused by the independent variable 6. A sports analyst wants to store and apply statistics to the total number of hits made by each baseball player in the league over the course of a season. Each entry will contain only one numerical value. Which variable type should they use to store this data? A. String B. Array C. Integer D. Boolean 7. Which scenario is an example of hypothesis testing? A. A company reviews its data regarding what clients prefer and suggests more of the same. B. A company reviews its data regarding subscription prices and offers a subset of its customers a reduced price to see if cancellations decrease. C. A company identifies a spike in cancellations during the month of November. D. A company analyzes the reasons subscribers give for cancelling their subscriptions to determine why people cancel the service. 8. For each type of data, select Yes if it represents personally identifiable information (PII) or No if it does not. A. Your passport number Answer:YES. B. Your portrait Answer:YES C. Your ZIP or postal code Answer:NO D. Your first name Answer:NO 9. A _____ is an effective chart type to display flow data from one category into another category. A common example is a breakdown of one's income into subcategories such as groceries, rent, utilities, entertainment, etc. This diagram typically flows from the left to the right. The values of each subcategory displayed on the right should add up to the total value of the original category on the left. A. Sankey B. Bubble C. Scatter D. Histogram 10. Which action is the most secure way to handle sensitive data? A. Create a shared generic password for all users on-site and unique, comple passwords for remote users. B. Encrypt and store all customer information, even if you may not use it in the future. C. Retrieve and decrypt sensitive documents, print the documents, and throw them away when you are done using them. D. Encrypt data that is electronically transmitted and restrict access to sensitive data.