Business Analytics

Which of the following is a key element in executing a successful BI program?

• Data warehousing only

• Advanced data mining techniques

• The underlying BI architecture

• Machine learning algorithms

What does the BI architecture serve as when referring to the collection, organization, and management of BI data?

• Technology benchmark

• Technology blueprint

• Data warehouse

• Metadata repository

Which data integration technology is most commonly used for BI applications, and what variant loads data as-is before transformation?

• ETL; ELT

• Data virtualization; ETL

• ELT; ETL

• Change data capture; data virtualization

Which component of a BI architecture acts as an interim repository for data before it goes into a data warehouse?

• Data lake

• Data mart

• Operational data store (ODS)

• Data catalog

In BI architecture, which criteria are important in the data source selection process?

• Data relevancy, currency, quality, and level of detail

• Data type, volume, velocity, and variety

• Data format, access speed, cost, and storage size

• Data redundancy, encryption, compression, and access control

Which BI tool offers a drag-and-drop interface for data analysis and the creation of interactive business dashboards?

• GoodData

• Dundas BI

• Datapine

• Zoho Analytics

What is the primary function of data profiling tools in a BI architecture?

• To visualize data trends

• To provide self-service analytics

• To identify and fix data quality issues

• To automate report generation

Which of the following BI tools is known for its focus on multi-tenancy and centralizing both decentralized and centralized data?

• Microsoft Power BI

• Infor Birst

• Oracle Business Intelligence

• SAS Business Intelligence

What type of data is typically stored in a data warehouse within a BI architecture?

• Semi-structured data

• Unstructured data

• Structured data

• Raw data

Which method of data integration supports real-time analytics applications by combining data from different source systems virtually?

• Extract, transform, load (ETL)

• Extract, load, transform (ELT)

• Data virtualization

• Batch processing