CTP CTP Data Management & Analytics

Question 1

Which data modeling technique is most appropriate for designing a relational database to support complex reporting requirements in an enterprise system?

Accepted Answer

Dimensional modeling with star schema

Answer

Flat file storage with CSV exports

Answer

Key-value pair storage only

Answer

Unstructured blob storage

Question 2

What is the primary purpose of data normalization in relational database design?

Accepted Answer

To reduce data redundancy and improve data integrity

Answer

To increase query response time by duplicating data

Answer

To compress binary files for storage savings

Answer

To encrypt sensitive fields automatically

Question 3

A CTP candidate is evaluating ETL pipeline performance. Which metric best indicates pipeline throughput?

Accepted Answer

Records processed per second

Answer

Number of source tables

Answer

Total disk space used

Answer

Count of transformation rules

Question 4

Which approach best handles slowly changing dimensions (SCD) in a data warehouse?

Accepted Answer

SCD Type 2: adding new rows with effective date ranges

Answer

Deleting old records and inserting new ones

Answer

Storing only the latest value in a flat table

Answer

Using real-time streaming for all historical data

Question 5

What does ACID stand for in the context of database transactions?

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

Accuracy, Completeness, Integrity, Distribution

Answer

Automation, Consistency, Integration, Data

Answer

Atomicity, Compression, Isolation, Delivery

Question 6

A technical professional must choose between OLTP and OLAP systems. Which system is best suited for complex analytical queries across large historical datasets?

Accepted Answer

OLAP (Online Analytical Processing)

Answer

OLTP (Online Transaction Processing)

Answer

A simple flat-file reporting system

Answer

A real-time event streaming platform only