Data Analytics Quiz

Which stage of the analytics maturity model focuses on using historical data to understand what happened in the past, often involving basic reporting and visualization techniques?

• Descriptive Analytics

• Predictive Analytics

• Prescriptive Analytics

• Diagnostic Analytics

When making decisions, if an individual relies on past experiences, intuition, and rules of thumb without explicitly analyzing data or following a systematic approach, what decision-making approach are they likely using?

• Heuristic Decision Making

• Data-Driven Decision Making

• Analytic Decision Making

• Systematic Decision Making

In a business environment, what is the primary purpose of a production database compared to a reporting database?

• Production database is designed for transactional processes, serving as the system of record, while reporting database is tailored for analytical queries and generating insights.

• Production database is optimized for read-heavy operations, while reporting database is optimized for write-heavy operations.

• Production database is used exclusively for data analysis and reporting, while reporting database handles day-to-day transactional activities.

• Production database and reporting database are terms used interchangeably, referring to the same underlying database system.

What is metadata in the context of data management?

• Data that provides information about other data, such as data attributes, format, and relationships.

• Very large quantities of data

• Data without a predefined data model, allowing for flexible and dynamic storage.

• Data from the parent company of Facebook

Which of the following is not a typical production database system?

• Excel

• MySQL

• Oracle

• MySQL

Which of the following best describes the difference between tacit and explicit knowledge?

• Tacit knowledge is practical, experiential, and difficult to codify, while explicit knowledge is codified and easily transferable through documentation.

• Tacit knowledge is theoretical and abstract, while explicit knowledge is context-dependent and grounded in real-world applications.

• Tacit knowledge is easily transferable through written or verbal communication, while explicit knowledge is difficult to articulate.

• Tacit knowledge is formalized and documented, while explicit knowledge is based on personal experiences and insights.

What is the primary purpose of a data warehouse?

• Long-term storage of historical data

• Real-time data processing

• Transactional processing

• Short-term data analytics

Which of the following best describes the ETL process?

• Extracting, Transforming, and Loading data

• Encrypting, Transmitting, and Loading data

• Evaluating, Testing, and Launching data

• Excluding, Transferring, and Logging data

One way to ensure that the representation of numbers is in proportion to numerical quantities is:

• To set the axis of the chart at zero

• To color the bars appropriately

• To sort the bars correctly

• To manually adjust their sizes

3 Dimensional charts should be used:

• When there are 3 dimensions of data

• Never

• To add flare to the chart

• Whenever software allows