CET Data Management and Analytics 2

Question 1

Which type of analytics focuses on understanding what has already happened by examining historical data?

Accepted Answer

Descriptive analytics

Answer

Predictive analytics

Answer

Prescriptive analytics

Answer

Cognitive analytics

Question 2

What is the primary purpose of a Key Performance Indicator (KPI) in data analytics?

Accepted Answer

To measure progress toward a specific business objective

Answer

To define the data schema for a reporting database

Answer

To identify anomalies in raw transactional data

Answer

To automate data ingestion from external APIs

Question 3

What does OLAP (Online Analytical Processing) enable that traditional transactional (OLTP) systems do not?

Accepted Answer

Multi-dimensional analysis of large datasets from multiple perspectives

Answer

Real-time processing of individual financial transactions

Answer

High-speed row-level inserts and updates in relational tables

Answer

Secure authentication and role-based access control for databases

Question 4

Which analytical method uses historical data and statistical algorithms to forecast future outcomes?

Accepted Answer

Predictive analytics

Answer

Descriptive analytics

Answer

Diagnostic analytics

Answer

Prescriptive analytics

Question 5

In data analytics, what is the role of data visualization?

Accepted Answer

To represent data graphically so that patterns, trends, and outliers are quickly understandable

Answer

To encrypt sensitive data fields before presenting them to end users

Answer

To convert raw datasets into compressed binary formats for storage efficiency

Answer

To validate data schema compliance before loading into a data warehouse

Question 6

What is the difference between supervised and unsupervised machine learning in the context of data analytics?

Accepted Answer

Supervised learning uses labeled training data; unsupervised learning discovers patterns in unlabeled data

Answer

Supervised learning operates without human input; unsupervised learning requires constant human oversight

Answer

Supervised learning is used only for image recognition; unsupervised learning is used only for text analysis

Answer

Supervised learning runs in real time; unsupervised learning processes data in batch mode only

Question 7

Which statistical measure best describes the central tendency of a dataset that contains significant outliers?

Accepted Answer

Median

Answer

Mean (arithmetic average)

Answer

Standard deviation

Answer

Variance