IT Specialist : Data Analytics Practice Exam 1. What are two reasons you should organize data? (Choose 2.) A. To conserve computer processing power B. To focus on meaningful and relevant data C. To calculate confidence intervals D. To alter the existing data elements 2. Which data manipulation technique affects the granularity of the displayed data? A. Filtering B. Sorting C. Aggregation D. Transposing 3. For each statement, select Yes if the statement about machine learning algorithm is true or No if it is not. A. A machine learning algorithm is a good choice for categorizing data when the rules of categorization cannot easily be encoded. Answer:YES B. A machine learning algorithm is a good choice when a well-understood set of rules consistently solves a problem. Answer:NO C. A machine learning algorithm is a good choice when the scale of problem-solving goes beyond practical human capability. Answer:YES D. A machine learning algorithm is a good choice for when there is little or limited data to work with. Answer:NO 4. For each statement, select Yes if the statement about machine learning algorithm is true or No if it is not. A. A machine learning algorithm is a good choice for categorizing data when the rules of categorization cannot easily be encoded. Answer:YES B. A machine learning algorithm is a good choice when a well-understood set of rules consistently solves a problem. Answer:NO C. A machine learning algorithm is a good choice when the scale of problem-solving goes beyond practical human capability. Answer:YES D. A machine learning algorithm is a good choice for when there is little or limited data to work with. Answer:NO 5. You want to start a wellness program where you work. Your employer wants to know how much interest employees have in tha type of program. You survey all employees and keep results for employees who want to participate. Which type of bias may affect your interpretation of the data? A. Sampling bias B. Anchoring bias C. Motivational bias D. Confirmation bias 6. You work for an airline company. Your manager has requested that you create a report that gives the total amount of fuel used for the past year. A database contains detailed information about fuel usage for each plane. Which aggregate function should you use to determine the total amount of fuel used? A. COUNT B. SUM C. AVG D. MAX