BA_Quiz2

Which of the following best differentiates RDBMS from NoSQL databases?

• a) RDBMS uses structured query language (SQL), while NoSQL does not.

• b) RDBMS is designed for unstructured data, while NoSQL is for structured data.

• c) NoSQL databases do not allow indexing, while RDBMS supports indexing.

• d) NoSQL databases do not support scalability, whereas RDBMS does.

Which component of a data warehouse is responsible for extracting, transforming, and loading (ETL) data?

• a) Data Mart

• b) OLAP Server

• c) Staging Area

• d) Metadata Repository

Which type of visualization is best suited for showing hierarchical relationships in data?

• a) Line Chart

• b) Bar Chart

• c) Treemap

• d) Scatter Plot

Which principle should be followed when creating an effective dashboard?

• a) Include as much data as possible on a single screen

• b) Use multiple colors without a clear pattern

• c) Highlight key performance indicators (KPIs) for quick insights

• d) Avoid interactive elements for simplicity

Which type of database is most suitable for handling large volumes of semi-structured and unstructured data?

• a) Relational Database

• b) NoSQL Database

• c) Data Warehouse

• d) OLAP Database

In Power BI, what is the primary purpose of DAX (Data Analysis Expressions)?

• a) To create and manage relational databases

• b) To manipulate and analyze data using formulas and expressions

• c) To visualize real-time data from IoT devices

• d) To perform machine learning analysis

Which visualization technique is best for analyzing trends over time?

• a) Pie Chart

• b) Line Chart

• c) Box Plot

• d) Histogram

Which type of visualization is most effective for comparing the distribution of a dataset?

• a) Line Chart

• b) Histogram

• c) Pie Chart

• d) Heatmap

Which visualization technique is useful for showing relationships between two continuous variables?

• a) Bar Chart

• b) Scatter Plot

• c) Pie Chart

• d) Treemap

Which visualization is best suited for comparing multiple categorical variables?

• a) Line Chart

• b) Bar Chart

• c) Scatter Plot

• d) Heatmap