# Fivetran & Airbyte - Ingesti Data (Data Engineering)

> Connector, sync modes (full, incremental), CDC, schema evolution, transformasi, monitoring

- 20 pertanyaan wawancara
- Mid-Level
- [Pertanyaan Wawancara: Data Engineering](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara.md)

## 1. Apa perbedaan utama antara Fivetran dan Airbyte dalam hal model deployment?

**Jawaban**

Fivetran adalah solusi SaaS fully managed di mana infrastruktur dikelola oleh Fivetran, sementara Airbyte menawarkan model open-source self-hosted selain penawaran cloud. Airbyte memungkinkan deployment solusi pada infrastruktur Anda sendiri (Docker, Kubernetes), memberikan lebih banyak kontrol atas data dan biaya, sedangkan Fivetran menyederhanakan operasi dengan mengelola seluruh maintenance.

## 2. Apa itu connector dalam konteks Fivetran atau Airbyte?

**Jawaban**

Connector adalah komponen pre-configured yang mengekstrak data dari source tertentu (database, API, SaaS) ke destination (data warehouse, data lake). Setiap connector menangani autentikasi, pagination, error handling, dan schema mapping untuk source tertentu, menghindari kebutuhan menulis kode integrasi kustom.

## 3. Apa perbedaan antara sinkronisasi Full Refresh dan Incremental?

**Jawaban**

Full Refresh mengekstrak semua data dari source pada setiap sinkronisasi dan menggantikan data yang ada di destination. Incremental hanya mentransfer data baru atau perubahan sejak sinkronisasi terakhir, menggunakan cursor (timestamp, ID auto-increment). Incremental lebih efisien dari segi waktu, biaya, dan beban pada source.

## 17 pertanyaan lagi tersedia

- Apa itu CDC (Change Data Capture) dan mengapa digunakan dalam tools ingesti?
- Apa keunggulan utama yang diberikan CDC dibandingkan sinkronisasi incremental berbasis timestamp?

Daftar gratis: https://sharpskill.dev/id/login

## Topik wawancara Data Engineering lainnya

- [Linux & Shell - Dasar-dasar](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/linux-shell-basics.md): 20 pertanyaan, Junior
- [Git & GitHub - Dasar-dasar](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/git-github-fundamentals.md): 20 pertanyaan, Junior
- [Python lanjutan untuk Data Engineering](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/python-advanced-de.md): 25 pertanyaan, Junior
- [Docker - Dasar-dasar](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/docker-fundamentals.md): 25 pertanyaan, Junior
- [Google Cloud Platform - Dasar-Dasar](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/gcp-fundamentals.md): 20 pertanyaan, Junior
- [CI/CD dan Kualitas Kode](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/ci-cd-code-quality.md): 20 pertanyaan, Mid-Level
- [Docker Compose](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/docker-compose.md): 20 pertanyaan, Mid-Level
- [FastAPI - API Data](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/fastapi.md): 20 pertanyaan, Mid-Level
- [SQL Lanjutan untuk Data Engineering](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/sql-advanced-de.md): 20 pertanyaan, Mid-Level
- [Data Lake - Arsitektur dan Ingesti](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/data-lake.md): 20 pertanyaan, Mid-Level
- [BigQuery untuk Data Engineering](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/bigquery-de.md): 20 pertanyaan, Mid-Level
- [PostgreSQL - Administrasi](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/postgresql-admin.md): 20 pertanyaan, Mid-Level
- [Data Modeling untuk Data Engineering](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/data-modeling-de.md): 20 pertanyaan, Mid-Level
- [dbt - Dasar](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/dbt-fundamentals-de.md): 20 pertanyaan, Mid-Level
- [Apache Airflow - Dasar-Dasar](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/airflow-fundamentals.md): 20 pertanyaan, Mid-Level
- [Kubernetes - Dasar-Dasar](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/kubernetes-fundamentals.md): 20 pertanyaan, Mid-Level
- [dbt - Fitur lanjutan](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/dbt-advanced-de.md): 20 pertanyaan, Senior
- [Pola ETL / ELT / ETLT](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/etl-elt-patterns.md): 20 pertanyaan, Senior
- [Apache Airflow - Lanjutan](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/airflow-advanced.md): 20 pertanyaan, Senior
- [Airflow + dbt - Orkestrasi Pipeline](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/airflow-dbt-integration.md): 20 pertanyaan, Senior
- [PySpark - Pemrosesan Skala Besar](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/pyspark.md): 20 pertanyaan, Senior
- [Google Pub/Sub - Streaming Data](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/pubsub-streaming.md): 20 pertanyaan, Senior
- [Apache Beam & Dataflow](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/apache-beam-dataflow.md): 20 pertanyaan, Senior
- [Kubernetes - Produksi dan Penskalaan](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/kubernetes-advanced.md): 20 pertanyaan, Senior
- [Terraform - Infrastructure as Code](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/terraform.md): 20 pertanyaan, Senior
- [Database NoSQL](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/nosql-databases.md): 20 pertanyaan, Senior
- [Data Architecture Modern](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/data-architecture.md): 20 pertanyaan, Senior
- [Monitoring dan Observability](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/monitoring-observability.md): 20 pertanyaan, Senior
- [IAM dan Keamanan Data](https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/iam-security-de.md): 20 pertanyaan, Senior

---

Source: SharpSkill (https://sharpskill.dev), tech interview preparation for your real stack.
HTML version of this page: https://sharpskill.dev/id/technologies/data-engineering/pertanyaan-wawancara/fivetran-airbyte