Data Analytics Practice Exam #5

IT Specialist : Data Analytics Practice Exam 1. You need to combine two datasets by a variable that they have in common. Which data manipulation technique gives you a final dataset with all columns from both sources? A. Appending B. Inner Join C. Concatenation D. Grouping 2. You need to run a linear regression where the output variable 'Y denotes the price of a house, the feature 'X1' denotes the number of rooms, and the feature "X2' denotes whether a factory or power plant is within 10 miles of the house lot. You find that your linear regression model outputs the following equation: Y = 0.13(X1)-0.02(X2) + 0.01 Which two conclusions about the relative impacts of features X1 and X2 to your output variable Y are correct? (Choose 2.) A. There is a negative association between price of the house and whether the house is near a factory or power plant B. There is a positive association between price of the house and whether the house is near a factory or power plant C. There is a positive association between price of the house and number of rooms in the house D. There is a negative association between price of the house and number of rooms in the house 3. You received a file you need to import and retrieve data from. A portion of the file is shown below. ("coord": { "lon":-100, "lat" 25 }) Which format does this data follow? A. CSV B. Array C. XML D. JSON 4. Which branch of analytics is most closely associated with the concept of anomaly detection? A. Predictive Analytics B. Diagnostic Analytics C. Hypothesis Testing D. Prescriptive Analytics 5. You have been asked to organize this data so that each product is displayed on a row, with the columns being titled ProductID, Color, Cost, ListPrice, Size, and Shipping Weight Product Table ProductID Color Cost ListPrice Size ShippingWeight 680 Black 1559 14.31 S 14 706 Red 10.59 14.31 M 14 707 Red 13.08 34.99 S 708 Black 13.08 34.99 L 31 31 Which organization technique fulfills the request? A. Slice B. Sort C. Filter D. Transpose 6. For each statement, select Yes if it is true or No if it is false. A. Data is the smallest factual unit Answer:YES B. Data can be processed to generate information. Answer:YES C. Data can be qualitative or quantitative. 709 White 3.39 9.5 M 23 Answer:YES D. Data can be processed with statistics. Answer:YES 7. You gather data about the type of entertainment people prefer during a given year. 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 it can answer on the right. A. How many people attend concerts and sports games during each season of the year? Answer: Stacked Column Chart B. Does movie attendance tend to fluctuate throughout the year? Answer: Line Graph C. What type of entertainment is experienced by the lowest percentage of people? Answer: Pie Chart 8. You've been given a set of data that represents test scores for students in the third grade. You've been asked to identify the students with exceptional scores. Which exploratory data analysis method should you use? A. Correlation analysis B. Outlier detection C. Frequent pattern discovery D. Backward propagation 9. Which option alone is considered sensitive Personally Identifiable Information (PII)? A. Race B. Age C. Phone number D. Gender 10. What are two reasons data analysts would use artificial intelligence when working with data? (Choose 2.) A. To analyze large quantities of data faster than humans B. To make predictions and recommendations based on existing data C. To decide which business data to collect D. To cleanse and verify data