Download INF 202 Data Analytics Exam and more Exams Technology in PDF only on Docsity!
Question 1. Which of the following best defines Data Analytics? A) The process of designing websites B) The process of examining raw data to draw conclusions C) The process of manufacturing goods D) The process of writing novels Answer: B Explanation: Data Analytics involves examining raw data to uncover patterns, draw conclusions, and aid decision-making. Question 2. What is the primary role of a data analyst in an organization? A) To develop hardware B) To analyze and interpret complex data
C) To manage human resources D) To design buildings Answer: B Explanation: Data analysts collect, process, and perform analyses on data to help organizations make data-driven decisions. Question 3. Which of the following is NOT a type of data analytics? A) Descriptive Analytics B) Diagnostic Analytics C) Predictive Analytics D) Creative Analytics Answer: D
A) Predict future trends B) Explain why something happened C) Summarize data D) Optimize decisions Answer: B Explanation: Diagnostic analytics drills down into data to determine the causes of past outcomes. Question 6. Which analytics type answers the question “What will happen?” A) Descriptive B) Diagnostic C) Predictive
D) Prescriptive Answer: C Explanation: Predictive analytics uses historical data and statistical models to forecast future events. Question 7. Prescriptive analytics is best described as: A) Summarizing past data B) Identifying patterns C) Recommending actions based on analysis D) Collecting data Answer: C Explanation: Prescriptive analytics suggests optimal actions to achieve desired outcomes.
C) Modeling D) Deployment Answer: B Explanation: Clearly defining the problem is the starting point for any data analytics project. Question 10. Which step involves removing duplicate and irrelevant data? A) Data Acquisition B) Data Cleaning and Preparation C) Modeling D) Deployment Answer: B
Explanation: The data cleaning step ensures the data is accurate and ready for analysis. Question 11. What is data wrangling? A) Creating reports B) Gathering data only from the web C) Cleaning and transforming raw data into a usable format D) Ignoring missing values Answer: C Explanation: Data wrangling includes cleaning, structuring, and enriching raw data for analysis. Question 12. What is the purpose of exploratory data analysis (EDA)?
D) Raw Data Answer: B Explanation: Structured data is highly organized, often found in databases as rows and columns. Question 14. JSON and XML are examples of: A) Structured data B) Unstructured data C) Semi-structured data D) NoSQL data Answer: C Explanation: Semi-structured data has organizational properties but does not conform to a rigid schema.
Question 15. Which of the following is an example of unstructured data? A) A CSV file B) An SQL database table C) Free-text documents D) A JSON file Answer: C Explanation: Unstructured data lacks a predefined format and includes text, images, and videos. Question 16. Data collected from a company’s internal CRM system is considered: A) External data
Answer: C Explanation: The SELECT command is used to fetch data from a database table. Question 18. What does the WHERE clause in SQL do? A) Orders the data B) Filters rows based on conditions C) Joins tables D) Groups results Answer: B Explanation: WHERE filters records according to specified criteria. Question 19. Which SQL command is used to add new rows to a table?
A) UPDATE
B) DELETE
C) INSERT
D) SELECT
Answer: C Explanation: The INSERT command adds new records to a table. Question 20. Which SQL clause is used to sort the output? A) GROUP BY B) HAVING C) ORDER BY D) WHERE Answer: C
A) SELECT
B) DELETE
C) INSERT
D) GROUP BY
Answer: B Explanation: DELETE is used to remove records from a database table. Question 23. What is the main advantage of using INNER JOIN in SQL? A) Fetching all records from the left table B) Combining rows with matching values in both tables C) Fetching only unmatched records D) Deleting data Answer: B
Explanation: INNER JOIN returns only rows where there is a match in both tables. Question 24. Which SQL JOIN returns all records from the left table and matched records from the right table? A) INNER JOIN B) LEFT JOIN C) RIGHT JOIN D) FULL JOIN Answer: B Explanation: LEFT JOIN returns all rows from the left table and matched rows from the right table. Question 25. NoSQL databases are mainly used to handle:
Answer: B Explanation: Document databases store data in document-like structures, such as JSON or BSON. Question 27. What is a common use of key-value stores in NoSQL? A) Storing tabular data B) Storing relationships C) Storing simple, fast-access data using unique keys D) Performing JOIN operations Answer: C Explanation: Key-value stores allow quick access to data by associating values with unique keys.
Question 28. Which data quality issue refers to having all necessary data present? A) Consistency B) Completeness C) Accuracy D) Timeliness Answer: B Explanation: Completeness means that all required data is available. Question 29. If data values conform to the required formats, we say the data is: A) Consistent B) Valid
