Review the basics Flashcards
A collection of values or information is known as?
Data
An organized collection of data is known as?
Database
What are the three data types?
Structured, Semi-Structured, Unstructured
What type of data structure is typically stored in tables and has predefined schemas?
Structured
What does OLTP stand for?
Online transactional processing
What does OLAP stand for?
Online analytical processing
What is the best suitable data structure for OLTP & OLAP workloads?
Structured
True or False
Semi-Structured data is constrained by a fixed schema.
False
If you were designing a system where you would be working with big data and required low latency which data type would you use?
Semi-structured
A record of this data type is generally made up of XML or JSON
Semi-Structured
A folder on your computer which has all of your videos in it, is what type of data structure?
Unstructured
A computer file system or AWS S3 is an example of what data type?
Unstructured
Which type of database supports joins?
Relational Databases
MySQL, PostgresSQL, MariaDB, Oracle, Microsoft SQL are all what type of database?
Relational Databases
Which service(s) in AWS would be best used for OLTP workloads?
RDS and Aurora