Crowdly

A storage area for unstructured images and videos

A collection of linked tables storing structured data

A software tool for creating PowerPoint presentations

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

Order ID

Customer ID

Customer Name

Product Name

What is the best primary key for the Customers Table?

Customer ID

Customer Email

Customer Name

Customer Phone Number

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

It helps keep the data unstructured and scattered

It makes it harder to analyze past sales

It makes data retrieval faster and more efficient

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

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

Cloud storage systems

Relational databases

Notebooks with handwritten customer records

Data warehouses

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

Multiple spreadsheets in different locations

A relational database

A whiteboard with handwritten data

Paper records

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

Reducing data cleaning requirements

Storing schema free data

100%

Easily discover relationships between variables

Minimizing data redundancy

All data repositories are databases

True

False

Data coming from data streams can only be numeric data.

True

False

Data from APIs can be queried using SQL.

True

False