Data Analytics Practice Exam #13

IT Specialist : Data Analytics Practice Exam 1. Why is data disaggregation important? A. Disaggregated data, by definition, is always more accurate than aggregated data for any dataset B. The aggregated summary statistics of a data never capture the patterns of its underlying disaggregated subgroups C. Disaggregated data will generally contain trends that are contradictory to the overall aggregate trends of the dataset D. The trends observed in different groups within the dataset may be just as insightful as the dataset-level trend 2. A website collects user contact information and stores it in a database. The stored phone numbers are in a variety of formats (e.g., 123-555-0123 and 1235550123). You need to ensure these numbers all adhere to the same formatting rules. What should you do to the data? A. Sort the data B. Remove duplicates in the data C. Standardize the data D. Filter the data 3. Move each expression from the list on the left to the correct data type used to store the variable on the right. A. owner = true Answer:Boolean. B. owner = “true” Answer:String C. owner = 1+2+3+4+5+6 Answer:Numeric 4. For each statement, select Yes if it is true or No if it is false. A. In a typical data table, rows run horizontally and contain data related to a single entity (such as a person or a company). Answer:YES B. In a typical data table, columns run horizontally and contain data related to a single entity (such as a person or a company) Answer:NO C. In a typical data table rows run horizontally and each row contains only one specified data type (such as text or numbers). Answer:NO D. In a typical data table, columns run vertically and contain data values of a specified type (such as text or numbers). Answer:YES 5. For each example, select Yes if it is a method of using artificial intelligence in data analytics and No if it is not. A. A company creates an algorithm that predicts buying patterns for its customers. Answer:YES B. A salesperson reads a spreadsheet to determine the average sales for a year. Answer:NO C. A meteorologist visually examines cloud movements to predict chances of rain. Answer:NO 6. Which two of the following are a feature of a typical data table? (Choose 2.) A. The top row is called a column header and contains information about the column B. Each column must contain numerical data C. Each row corresponds to a single record D. The left-most column is called the column key and contains numerical information 7. You need to organize a dataset in a table that shows customer demographics. You want to be able to easily scroll through the table to see states and cities alphabetical order. What data organization technique should you use A. Transpose B. Group C. Filter D. Sort 8. Which condition would cause problems in a regression analysis? A. A dependent variable B. Linear relationship C. Outliers D. Small sample size 9. Complete the sentences by selecting the correct option from each drop-down list. A. _____ is a data record in a relational database. Answer:ROW. B. _____ contains the values of a single field or attribute. Answer:COLUMN C. _____ stores elements in brackets and is designed for easy retrieval of data by indices. Answer:LIST 10. You visit a website that plays songs. After you listen to a few songs, the website recommends a new song that is similar to the songs you already chose. Which type of data analytics is the site using? A. Descriptive analytics B. Diagnostic analytics C. Prescriptive analytics D. Predictive analytics