DAC DAC Business Intelligence & Analytics Strategy 2

Question 1

What is ETL in data analytics?

Accepted Answer

Extract, Transform, Load — the process of moving data from sources into a target data store

Answer

ETL stands for Extract, Transform, Load — the pipeline process of pulling data from source systems, transforming it for analysis, and loading it into a target data warehouse.

Question 2

Which of the following best describes a data lake?

Accepted Answer

A repository that stores vast amounts of raw data in its native format until needed

Answer

A data lake stores large volumes of raw, unstructured, semi-structured, and structured data in its native format, offering flexible schema-on-read capabilities.

Question 3

What is the difference between OLTP and OLAP systems?

Accepted Answer

OLTP supports high-volume transactional operations; OLAP is optimized for complex analytical and historical queries

Answer

OLTP (Online Transaction Processing) handles frequent, short operational transactions, while OLAP (Online Analytical Processing) is designed for complex queries over large historical datasets.

Question 4

In a balanced scorecard approach to analytics strategy, which of the following is NOT one of the four perspectives?

Accepted Answer

Technology Infrastructure

Answer

The Balanced Scorecard's four perspectives are Financial, Customer, Internal Business Processes, and Learning & Growth — technology infrastructure is not one of the four.

Question 5

What is self-service BI?

Accepted Answer

An approach allowing business users to access, analyze, and visualize data without relying on IT or data teams

Answer

Self-service BI empowers non-technical business users to independently explore data, create reports, and derive insights using intuitive tools without IT dependency.

Data Analytics Certifications (DAC) Practice Test

Data Analytics Certifications (DAC) Practice Test

DAC DAC Business Intelligence & Analytics Strategy 2