ADP study notes
- Data preparation and ingestion Associate Data Practitioner notes on ETL, ELT and ETLT, quality and cleaning, transfer tools, file formats, extraction and load tools, choosing a storage service and location type, and loading with gcloud, bq and client libraries. 30%
- Data analysis and presentation Associate Data Practitioner notes on BigQuery SQL and cost control, Colab Enterprise notebooks, Looker versus Looker Studio, LookML basics, BigQuery ML, AutoML, remote LLM models and the Model Registry. 27%
- Data pipeline orchestration Associate Data Practitioner notes on choosing Dataproc, Dataflow, Cloud Data Fusion, Cloud Composer and Dataform, ELT versus ETL, scheduling, Workflows, monitoring with Dataflow UI, Logging and Monitoring, Pub/Sub to BigQuery and Eventarc. 18%
- Data management Associate Data Practitioner notes on IAM for data services, Cloud Storage access control, Analytics Hub, storage classes and lifecycle rules, archiving, backups, replication, high availability, CMEK, CSEK, GMEK and encryption in transit and at rest. 25%