Week 1 Review - Alooma/Industry Concepts | Take the Quiz

What does SQL stand for? (Choose Best Answer)

Standard Query Language

Simple Query Language

Standard Question List

Structured Query Language

What is one reason that SQL is important? (Choose best answer)

It allows you to speak to dylan

It allows you to dream about sunshine on a cloudy day

It allows you to communicate with a database

It solves every problem in a pipeline

What is schema? (Choose best answer)

Method to connect tables inside SQL

A series of complicated schemes (capers)

A non-structured approach to a data warehouse

Organization of data within a database (e.g. Names and data types)

What is an example of a NoSQL database that Alooma supports? (Select all)

MongoDB

Cassandra

Redis

Postgres

What is a VPN? (Choose Best Answer)

Virtual Private Network

Virtual Personal Network

Visual Private Network

Visual Personal Network

Which Data warehouse(s) does Alooma support? (Select All)

Amazon Big Query

Google Redshift

MySQL

Snowflake

Select the SQL databases that Alooma supports (Select All)

Oracle

Microsoft SQL Server

Postgres

MongoDB

What is a data mart? (Select all)

A condensed and focused subset of a data warehouse pertaining to a specific business line or team

Understood to be associated with a data warehouse if mentioned by a prospect

Place where data can be purchased at a reasonable price

What is a data warehouse? (Select all)

Central source of data for managers who may not have access to operational data

Archive databases and external sources of data

Building where computers are stored

What is CRUD? (Select all)

Database actions

Create, Read, Update, Delete

Create, Read, Use, Delete

Dirt

What is a binary log? (Select All)

Track CRUD that occurs in a database

Protects/secures the router and systems (network)

Data warehouse without a schema

Why use a data warehouse (versus 1 large database)? (select all)

Need to transform or do some sort of action on the source database

Have multiple data sources with different schemas

CRUD is faster

What makes a schema change so difficult for analysts, BI team, or data scientists? (Select all)

They do not have access to the source database

Field is no longer an integer or a column has been moved/renamed

They have to wait on engineers (IT) to fix the pipeline

What is a join? (Select best answer)

Organization of data within a database (e.g. Names and data types)

Method to connect tables inside SQL

Way to sign up for a trial

Why do companies choose Redshift versus Big Query? (Select all)

Redshift is built like a more traditional SQL database

It can be more costly/difficult to use BQ if other applications are Amazon

Redshift is a more managed solution

What is Hadoop? (Select All)

Open Sourced Project

Often compared to Google Big Query

Designed to store extremely large datasets

The quickest data warehouse option

What is a NewSQL database that we support? (Select all)

MySQL

Postgres

MemSQL

Oracle

What is a data lake? (Select all)

Similar to a data warehouse but uses a flat architecture

Has no traditional hierarchy system (i.e. Files or folders to store data)

A storage method for data

What is the purpose of a VPN?

Protects/secures the router and systems (network)

Track CRUD that occur in a database

Data warehouse without a schema

Week 1 Review - Alooma/Industry Concepts

More Quizzes