Module 2 Quiz – Analytics Engineering

Question 1: Which of the following is an example of a structured data type? *

A) Text file

B) SQL table

C) Image file

D) Audio recording

Question 2: What is a common use for the "VARCHAR" data type? *

A) Storing numbers

B) Storing true/false values

C) Storing date/time values

D) Storing variable-length text

Question 3: What is the key difference between an array and a list in programming languages? *

A) Arrays are unlimited in size

B) Lists must contain only text

C) Arrays typically have fixed size and type; lists are more flexible

D) Lists are only used in Excel

Question 4: What is the primary purpose of a Data Warehouse? *

A) Storing raw unstructured logs

B) Running mobile applications

C) Centralizing and analyzing historical business data

D) Hosting websites

Question 5: In a data warehouse, what is a "fact table"? *

A) A table that stores metadata

B) A table that contains descriptive information

C) A lookup table

D) A table that stores numerical measures and business events

Question 6: What is the role of a "dimension table" in a star schema? *

A) To describe attributes related to facts (e.g., customer, product)

B) To normalize fact tables

C) To store transactional logs

D) To calculate measures

Question 7: What is data denormalization often used for in data warehouses? *

A) To reduce data duplication

B) To make OLTP faster

C) To simplify queries and improve performance

D) To enforce referential integrity

Question 8: Which layer of a data warehouse architecture is responsible for storing raw data? *

A) Presentation Layer

B) Staging Layer

C) Analytics Layer

D) Reporting Layer

Question 9: What does the ETL process stand for? *

A) Encode, Translate, Load

B) Extract, Transfer, Load

C) Extract, Transform, Load

D) Evaluate, Test, Log

Question 10: What is the purpose of the Semantic Layer in a modern data stack? *

A) To define user roles

B) To handle data encryption

C) To provide a consistent and business-friendly view of the data

D) To manage cloud billing