Data Modelling and Analytics Quiz

Predictive analytics aims to:

• a) Describe historical data

• b) Forecast future outcomes based on data

• c) Optimize current processes

• d) Provide real-time data updates

Which of the following is NOT a key skill for a data scientist?

• a) Applied Statistics

• b) Machine Learning

• c) Network Administration

• d) Domain Knowledge

Which type of analytics provides recommendations for actions based on data analysis?

• a) Descriptive analytics

• b) Predictive analytics

• c) Prescriptive analytics

• d) Diagnostic analytics

Descriptive analytics is primarily used to:

• a) Predict future trends

• b) Optimize decision-making processes

• c) Describe past data

• d) Prescribe actions based on data

What is data modelling?

• a) The process of collecting raw data

• b) The process of creating a data structure that organizes data elements

• c) The visualization of data

• d) The analysis of data trends

In the context of data science, what is meant by 'data warehousing'?

• a) The collection of real-time data

• b) The storage of large amounts of data for analysis and reporting

• c) The visualization of data trends

• d) The process of data cleaning and preprocessing

Which data modelling technique uses Entity-Relationship Diagrams (ERDs)?

• a) Conceptual modelling

• b) Logical modelling

• c) Physical modelling

• d) All of the above

Which of the following is a type of data model?

• a) Conceptual

• b) Logical

• c) Physical

• d) All of the above

What is the primary goal of data modelling in decision-making?

• a) To collect as much data as possible

• b) To create complex algorithms

• c) To provide a structured format for data that supports decision-making

• d) To visualize data trends

Which data modelling tool is known for supporting SQL and NoSQL databases?

• a) ER/Studio

• b) PowerDesigner

• c) SQL Developer Data Modeler

• d) All of the above