Crowdly

A collection of linked tables storing structured data

A software tool for creating PowerPoint presentations

A storage area for unstructured images and videos

Each order must be linked to a specific customer. Which column should be used to link the Orders Table to the Customers Table?

Customer Name

Product Name

Customer ID

Order ID

What is the best primary key for the Customers Table?

Customer Name

Customer Phone Number

Customer ID

Customer Email

Why would storing data in a single system be useful for ShopSmart?

It makes it harder to analyze past sales

It ensures that only one person can access the data at a time

It makes data retrieval faster and more efficient

It helps keep the data unstructured and scattered

Which of the following is NOT a type of data repository?

Cloud storage systems

Data warehouses

Notebooks with handwritten customer records

Relational databases

What type of system should ShopSmart use to store all its business data in one place?

Multiple spreadsheets in different locations

A whiteboard with handwritten data

Paper records

A relational database

Which of the following is not an advantage of relational databases?

Reducing data cleaning requirements

Minimizing data redundancy

Easily discover relationships between variables

Storing schema free data

100%

All data repositories are databases

Data coming from data streams can only be numeric data.

True

False

Data from APIs can be queried using SQL.

True

False