File Chap 5 Part 2

Question 1

Queries are written in a querying language that is unique to the database management system (Ex: SQL)

Answer 1

Query Language

Question 2

logical diagram of a database’s structure and organization

Answer 2

Schema

Question 3

the capability of a database to manage increasing demands.

Answer 3

Database Scalability

Question 4

A database that is connected to an information system that is used for transactions in a business process is a production database. This database is “live”—the data is created and stored in real time as a result of a transaction being processed

Answer 4

Production Database

Question 5

Incoming data goes into the lake in its raw form

Answer 5

Data Lake

Question 6

Incoming data is cleaned and organized into a single consistent schema before being put into the warehouse

Answer 6

Data Warehouse