CS215_Lab4

The foreign key must have the same data type and size of the primary key but they can have different names.

• True

• False

Converting an ERD into a relational model is called -------.

• Conceptual modelling

• Relational Mapping

You need to process data that is generated continuously and near real-time responses are required, you should use ------.

• Batch processing

• Scheduled data processing

• Buffering and processing

• Streaming data processing

The technique that provides recommended actions that you should take to achieve a goal or target is called _____________ analytics.

• Descriptive

• Prescriptive

• Predictive

• Diagnostic

The process of splitting an entity into more than one table to reduce data redundancy is called _____.

• Deduplication

• Denormalization

• Normalization

• Optimization

Azure SQL Database is an example of __________ -as-a-service.

• Platform

• Software

• Infrastructure

• Application

The act of increasing or decreasing the resources that are available for a service is called: ________.

• Computing

• Provisioning

• Networking

• Scaling