Queries, Modeling and Transformation

What is the goal of Reverse ETL?

• Extracting data from databases into warehouses

• Moving data from a data warehouse into operational tools

• Performing batch transformations

• Loading data from APIs to databases

What is data transformation?

• Changing raw data into a structured format

• Deleting unnecessary data

• Storing raw data in a database

• Sending data to an external server

Which database is best suited for handling real-time streaming data?

• PostgreSQL

• Apache Kafka

• MySQL

• SQLite

What is the primary goal of data modeling?

• To design an efficient database structure

• To speed up internet browsing

• To reduce CPU usage

• To eliminate data redundancy

What is the purpose of data warehousing?

• To store large volumes of data for analysis

• To manage network traffic

• To perform real-time data processing

• To create user interfaces for applications

What does ETL stand for in data processing?

• Encode, Transfer, Log

• Evaluate, Test, Launch

• Extract, Transform, Load

• Extract, Transfer, Load

Which of the following is a common data visualization tool?

• Apache Spark

• MongoDB

• MySQL

• Tableau

Which of the following frameworks is widely used for streaming queries?

• Apache Hive

• Apache Spark Streaming

• MySQL

• SQLite

What is the main goal of a query optimizer?

• Maximize the number of queries

• Reduce query execution time

• Increase the number of tables used

• Ignore indexes for execution

Which of the following is a popular programming language for data analysis?

• C++

• HTML

• Python

• Java