Following are the most important topics in bigquery. This is also important topics in a perspective of GCP Profession Data Engineer exam.
- BigQuery basic concepts
- wildcard tables
- _table_suffix
- External Table vs Internal Table
- partition and clustering:-https://youtu.be/wapi0aR4BZE?si=iwkrC9fUY2ConUgB
- shad tables
- Bigquery optimization
- Anonymous Dataset – what is the Anonymous dataset in big query
- Time travel
- federated queries
- View vs Materialized view vs Authorized view
- Bigquery Slots
- BigQuery Omni.
- BIgQuery Data Transfer Service
- Dry run
- Bigquery file format support
- CSV (if the data is in a json or scv format, bigquery can auto detect schema, but manual verification is recommended)
- JSON
- AVRO (If your data is in avro format, which is self describing, bigQuery can determine the schema directly)
- DATASTORE_BACKUP
- PARAQUET
- ORC
- BigQuery Iam Roles and permission(100 perecent 1 question form this)