Analytics and Data Warehousing Quiz

What type of database is used in analytics and is ideal for systematic analysis of data?

• Transactional databases

• Relational databases

• Data warehouses

• NoSQL databases

Compared to "normal" databases, data warehouses are:

• Less suitable for complex queries

• Slower at handling queries

• More flexible

• More efficient at handling very complex queries

Transactional databases facilitate transactions involving:

• Analysis of data

• Exchange of information and money

• Storage of large volumes of data

• Generation of reports

Which of the following is an example of a situation where analysis can be applied to big data?

• Calculating the total sales in a small retail store

• Determining how many girls under the age of 18 visited an emergency room in a specific month

• Tracking the number of books borrowed from a local library

• Recording the attendance of a small workshop

What is the main advantage of a data warehouse over a regular database when dealing with large amounts of data?

• Data warehouses require specialized software to operate.

• Data warehouses are suitable for handling large amounts of data.

• Data warehouses are tied to one application, one form, and one purpose.

• Data warehouses operate exactly like regular warehouses.

What is data mining?

• The process of setting up specialized software for data warehouses.

• The process of extracting data from multiple sources and storing it in a central place.

• The process of querying data in a regular database.

• The process of shipping out data from data warehouses.

What is the primary use of data collected through data mining?

• To be stored in multiple locations

• For analytical purposes and made available to business analysts

• To improve the functionality of the internet

• To collect user names and phone numbers

What is anonymized data?

• Data that includes personal details like names and phone numbers

• Data that is exclusively used for market research

• Data that has been stripped of identifying information

• Data that can only be accessed by data miners

Why do phone companies use data mining?

• To collect data on phone usage statistics and improve products

• To store data in a data warehouse

• To transfer data to multiple locations

• To develop new internet technologies

According to the text, how common is proficiency in data mining among computer science graduates?

• Most computer science graduates are proficient in it

• It is a rare skill even below the level of computer science graduates

• All computer science graduates are required to be proficient in it

• Only data analysts are proficient in it