Data Analytics Practice Exam #10

IT Specialist : Data Analytics Practice Exam 1. Which data type can only contain one of two possible values? A. Integer B. String C. Boolean D. Character 2. An analyst has two data sets they would like to combine by adding the second data set to the end of the first data set. Which operation should they perform on the data? A. Trim B. Transpose C. Append D. Truncate 3. You gather data from an automobile dealership regarding vehicles sold last month. You need to determine which visualization to use to answer questions about the data. Move each chart type from the list on the left to the correct question that it can answer on the right. A. How many more cars were sold than trucks? Answer:Column Chart. B. Which vehicle make had the most sales? Answer:Pie Chart C. Which day had the highest vehicle sales? Answer:Line Graph 4. A store owner runs different types of data analysis to investigate inventory needs. Move each data analysis type from the list on the left to the correct example on the right. A. The owner decides to order twice as many video gaming consoles this summer because last summer, the store had a backlog in inventory. Answer:Predictive Analysis. B. The owner reviews a store report that shows a backlog in the inventory of video games last summer. Answer:Descriptive Analysis C. The data analysis reveals that the reason the backlog in inventory occurred is because of a miscalculation in the ordering system. Answer:Diagnostic Analysis D. The data analysis indicates that a script should be rewritten to calculate th number of gaming consoles to order every week Answer:Prescriptive Analysis 5. Which US law protects healthcare patients' private information by imposing limitations on how healthcare providers can share and access data? A. FERPA B. IRB C. HIPAA D. GDPR 6. Examine the data, chart and analysis. For each statement, select Yes if it is true or No if it is false. March Salesperson A 1000 Salesperson B 600 April 500 600 May 250 600 For each statement, select Yes if it is true or No if it is false Total 1750 1800 A. Salesperson A had the highest sales for any individual month Answer:YES. B. Salesperson B will sell the same amount in Juni Answer:NO C. Salesperson A sold more than the Overall Average twice Answer:NO D. Salesperson B had the most overall sales for the three-month period Answer:YES 7. Which visualization shows a perfect, positive correlation between values? Select the correct visualization in the answer area. A. B. C. D. Answer:B 8. What is metadata? A. Data that can be observed and is descriptive B. Data that can be counted and measured C. A lot of data collected very quickly from a wide range of sources D. A description and context of data 9. A CEO wants to visualize how the company's annual profits compare to the annual profits of its competitors. Which visualization should the CEO use? A. Bar Chart B. Scatter Plot C. Tree Map D. Line Chart 10. Move each file type from the list on the left to the correct description on the right A. Consists of rows of records with associated data stored in columns that are separated by a character Answer:Delimited Data Files. B. A markup language designed to store data along with metadata such as comments Answer:XML C. Stores data structures consisting of name:value pairs Answer:JSON D. A markup language that instructs a web browser on how to display text, images, or other media Answer:HTML