Data Dynamos Quiz Day 2

1. Which system is optimized for transactional processing?

• OLTP

• OLAP

• Both

• Neither

Which type of database is designed for unstructured data and scalability?

•  SQL

• NoSQL

• Both

• Neither

What is primarily used for analytical querying and reporting?

• Database

• Data Warehouse

• Data Lake

• All of the above

What type of processing system is Apache Spark primarily used for?

• OLAP

• OLTP

• Both A and B

• Neither A nor B

Scenario:

In a banking system where account data must prioritize consistency and availability over partition tolerance, which type of database technology would be most suitable?

• Distributed NoSQL Database

• Traditional SQL Database like MariaDB

• Big Data System like Hadoop

• Real-time Streaming Service

Scenario:

An e-commerce platform needs a database system that can handle a high volume of transactions across a distributed network. The platform prioritizes availability and partition tolerance (AP) due to its global user base and the need to handle numerous transactions simultaneously. Which type of technology is most suitable for this scenario?

• Traditional SQL Database like MySQL

• Distributed NoSQL Database like Cassandra

• Big Data System like Hadoop

• Cloud-based SQL Database like Amazon RDS

Scenario: A hospital's electronic health record (EHR) system requires a database technology that ensures data consistency and partition tolerance (CP), especially during network failures. This system must maintain accurate, up-to-date patient records even if parts of the network become unavailable. Which type of database technology is most appropriate for this scenario?

•  Traditional SQL Database like Oracle

•  NoSQL Database like MongoDB

• Distributed Database like Apache ZooKeeper

• Cloud-based NoSQL Database like Google Cloud Datastore

What feature does Snowflake offer that allows for creating full copies of databases, schemas, or tables without additional storage costs?

•  Data Sharing

• Time Travel

• Cloning

• Federated Query

What is the unique architectural layer in Snowflake that separates compute from storage?

•  Multi-cluster Warehouse

• Virtual Warehouse

• Cloud Services Layer

• Storage Layer

What is dbt primarily used for in the data stack?

• Data Transformation

• Data Integration

• Data Visualization

• Data Modeling