ELT with Fivetran Quiz

Fill in the blank: ELT begins with data _______.

Which platform focuses on analyzing and monitoring business activity, not running it?

• IT Platform
• ERP
• Data Platform
• CRM

What does a data platform typically store?

• CRM Leads
• Customer Service Logs
• Invoices
• Enriched Data

Which role is primarily responsible for transforming raw data into clean, usable models?

• Business Analyst
• Data Engineer
• Analytics Engineer
• Finance Analyst

Which job role is most likely to handle tools that load into the data platform?

• Business Analyst
• CRM Manager
• Data Analyst
• Finance Admin

Which type of table provides a snapshot at a given point in time?

What does CDC stand for in data pipelines?

• Capture Data Copy
• Central Data Check
• Change Data Capture
• Current Data Cycle

Which of the following are examples of state table limitations?

• Requires historization
• Can track every change
• Cannot track every change
• Stores all events

Which table type is required for deep analysis of changes over time?

• Event Table
• State Table
• OLTP
• Snapshot Table

Which method uses timestamps to sync updated rows?

• Log CDC
• Full Refresh
• Timestamp Tracking
• Trigger CDC