RCE 3 - Data

What type of data would "total monthly revenue" be classified as?

• Media

• Numeric

• Text

• Temporal

Answer explanation

Total monthly revenue is a quantifiable figure representing income, making it a type of numeric data. It is not media, text, or temporal, as those categories do not apply to financial figures.

What is an example of temporal data?

• Timestamped logs of website visits

• Customer feedback

• Photos for marketing

• Boolean values for account status

Answer explanation

Timestamped logs of website visits are a clear example of temporal data, as they record specific times when events occur, allowing for analysis of patterns over time. The other options do not inherently include time-related information.

Which of the following is an external source of data?

• Employee attendance records

• Supplier inventory data

• Social media engagement metrics

• Daily sales figures

Answer explanation

Supplier inventory data is an external source of data as it comes from outside the organization, unlike employee attendance records, social media engagement metrics, and daily sales figures, which are internal.

What type of storage would a file repository accessible to all staff represent?

• NAS Devices

• File Servers

• Hard Drives

• Elastic Cloud

Answer explanation

A file repository accessible to all staff is best represented by File Servers, as they are designed to store and manage files that can be accessed by multiple users over a network, unlike NAS devices or hard drives which serve different purposes.

Which cloud-based service is used for scalable data analysis?

• Google BigQuery

• AWS S3

• Azure Blob Storage

• NAS Devices

Answer explanation

Google BigQuery is a fully managed, serverless data warehouse that enables scalable data analysis. Unlike AWS S3 and Azure Blob Storage, which are primarily for storage, BigQuery is specifically designed for querying large datasets efficiently.

What process involves merging sales and customer feedback data for insights?

• Remove

• Integrate

• Analyse

• Update

Answer explanation

The process of integrating sales and customer feedback data allows businesses to combine insights from both areas, leading to better decision-making and improved strategies. Thus, 'Integrate' is the correct choice.

Which of the following is NOT a function of information systems?

• Input

• Feedback Loop

• Validation

• Output

Answer explanation

Validation is not a primary function of information systems. The main functions include Input (data entry), Output (data presentation), and Feedback Loop (system performance monitoring), making Validation the correct choice.

What data model links sales and inventory through connected nodes?

• Network Model

• Hierarchical Database Model

• Entity Relationship Model

• Relational Database Model

Answer explanation

The Network Model effectively links sales and inventory through interconnected nodes, allowing for complex relationships and efficient data retrieval, making it the correct choice for this scenario.

What tool visualises how information flows in an order processing system?

• ERD

• DFD

• Heat Map

• Dashboard

Answer explanation

A Data Flow Diagram (DFD) visualizes how information flows within an order processing system, showing the movement of data between processes, data stores, and external entities, making it the correct choice.

What does validation in data entry ensure?

• Complying with GDPR

• Allocating staff effectively

• Checking correct data format

• Budgeting for new software

Answer explanation

Validation in data entry ensures that the data entered follows the correct format, which is crucial for maintaining data integrity and usability. Thus, the correct answer is 'Checking correct data format'.