1st Challenge

What Modeling Schema allows for Dimensions connected to other Dimensions?

• Star Schema

• Snowflake Schema

• Compound Schema

• Cloud Schema

How many types of solutions do we have for Slowly Changing Dimensions?

• 6

• 4

• 2

• 1

What is the name of a key that was created automatically to identify each row of a table without Primary Keys?

• Ordinary

• Foreign

• Surrogate

• Index

What is the main purpose of Hadoop?

• Scale MLOps Vertically

• Scale Storage and Processing Vertically

• Scale Storage Horizontally

• Scale Storage and Processing Horizontally

What is the analytics engine that sits on top of the YARN layer in Hadoop?

• Apache Spark

• Apache Airflow

• Snowflake

• Hive

In a Snowflake Schema, what is something a Fact table will always have?

• Measures

• KPIs

• Foreign Keys

• Surrogate keys

Why were Data Warehouses initially invented?

• Losing the strict structure from Relational DBs

• Taking the load off from the Operational DBs for analysis

• Creating Ad-Hoc queries on the fly for executives

• Having a sandbox for staging changes to the Operational DB

In OLTP and OLAP What does the L and A stand for?

• Transactional and Analytical

• Timeline and Ad-Hoc

• Transform and Area

• Tier and Ascend

Which of the following is a Data Streaming Platform?

• Hadoop

• Spark

• Kafka

• All of them

Which of the following is not a data storage solution?

• S3

• Azure Blobs

• HDFS

• EC2