Business Analytics Quiz2

Which of the following best describes the advantage of NoSQL databases over RDBMS?

• NoSQL databases enforce strict schema requirements

• NoSQL databases scale horizontally more efficiently than RDBMS

• NoSQL databases do not support distributed computing

• NoSQL databases use only ACID transactions

Which technique is used to handle missing data in a dataset?

• Feature extraction

• Data imputation

• Principal Component Analysis (PCA)

• Clustering

Which of the following data visualization techniques is most effective for analyzing the distribution of a single variable?

• Bar Chart

• Scatter Plot

• Histogram

• Line Chart

What is the main advantage of using a star schema in a data warehouse?

• It minimizes data redundancy

• It requires complex joins for querying

• It normalizes the data completely

• It does not require indexing

Which type of database is best suited for applications that require complex transactions and strong consistency?

• NoSQL Database

• Graph Database

• Relational Database

• Document Store

Which data transformation technique is used to handle categorical data available as text?

• One-hot encoding

• Principal Component Analysis (PCA)

• K-means clustering

• Decision trees

What is the primary purpose of an ETL (Extract, Transform, Load) process in data warehousing?

• Managing real-time transactions

• Processing SQL queries efficiently

• Collecting, processing, and loading data into a data warehouse

• Encrypting sensitive data

What is the primary use of a heatmap in data visualization?

• To compare numerical values over time

• To visualize categorical data distributions

• To highlight correlations and patterns in large datasets

• To display hierarchical data relationships

Which visualization best shows the proportion of different marketing channels contributing to total website traffic?

• Line Chart

• Pie Chart

• Area Chart

• Bar Chart

Which type of visualization is most appropriate for showing how sales conversions decrease at each stage of a lead generation process?

• Bar Chart

• Funnel Chart

• Line Chart

• Treemap