DATA ENGINEERING PROFESSIONAL EXAM
COMPREHENSIVE SCRIPT 2026 FULL
SOLUTION TESTED ITEMS
◉ Data Store Data Organization. Answer: entities are grouped by
kind (category)
entities can be hierarchical (nested)
each entity has one or more properties (each object has one or more
individual data for an object)
◉ Data Store: Index Types. Answer: built-in - default option
composite - specific with index configuration file (index.yaml)
◉ Exploding Indexes on Data Store. Answer: create an entry for
every possible combo of property values
cons - higher storage and degraded performance
◉ solutions for exploding indexes on Data Store. Answer: use
custom index.yaml
don't index properties that don't need indexing
,◉ How to add composite index on Data Store. Answer: run
CloudShell
type vim index.yaml
◉ Data Store: Difference between strong consistency and eventual
consistency. Answer: (order) strong consistency - financial
transaction - you need to see updates immediately
(out of order) eventual consistency - census population - order of
information is not important as long as you get all the information
needed
◉ What is BigTable $$. Answer: - high performance, massively
scalable, NoSQL DB
- ideal for large analytical workloads
◉ Use Big Table for. Answer: high throughput data analytics
huge datasets
◉ Big Table use cases. Answer: Financial Data
IoT Data
Marketing Data - purchase histories
, ◉ BigTable Infrastructure. Answer: Front-End server pool
Nodes
SSTable
SharedLog
◉ What is Node used for in BigTable. Answer: Nodes handle cluster
requests. No data is stored on Node except for metadata to direct
requests to the correct tablet (SSTable)
◉ What is a SSTable on BigTable. Answer: it's a tablet -- tablets are
associated with a Node
◉ Big Table: Define Colossus. Answer: Google's File System
(SSTable)
◉ What does "Instance" mean on Big Table?. Answer: an entire
BigTable project which is nodes grouped into however many clusters
(all nodes and clusters)
◉ Is BigTable ops or No ops? Why. Answer: ops - must configure
nodes
◉ Big Table: Instance types. Answer: Development - low cost, single
node (no replication)
COMPREHENSIVE SCRIPT 2026 FULL
SOLUTION TESTED ITEMS
◉ Data Store Data Organization. Answer: entities are grouped by
kind (category)
entities can be hierarchical (nested)
each entity has one or more properties (each object has one or more
individual data for an object)
◉ Data Store: Index Types. Answer: built-in - default option
composite - specific with index configuration file (index.yaml)
◉ Exploding Indexes on Data Store. Answer: create an entry for
every possible combo of property values
cons - higher storage and degraded performance
◉ solutions for exploding indexes on Data Store. Answer: use
custom index.yaml
don't index properties that don't need indexing
,◉ How to add composite index on Data Store. Answer: run
CloudShell
type vim index.yaml
◉ Data Store: Difference between strong consistency and eventual
consistency. Answer: (order) strong consistency - financial
transaction - you need to see updates immediately
(out of order) eventual consistency - census population - order of
information is not important as long as you get all the information
needed
◉ What is BigTable $$. Answer: - high performance, massively
scalable, NoSQL DB
- ideal for large analytical workloads
◉ Use Big Table for. Answer: high throughput data analytics
huge datasets
◉ Big Table use cases. Answer: Financial Data
IoT Data
Marketing Data - purchase histories
, ◉ BigTable Infrastructure. Answer: Front-End server pool
Nodes
SSTable
SharedLog
◉ What is Node used for in BigTable. Answer: Nodes handle cluster
requests. No data is stored on Node except for metadata to direct
requests to the correct tablet (SSTable)
◉ What is a SSTable on BigTable. Answer: it's a tablet -- tablets are
associated with a Node
◉ Big Table: Define Colossus. Answer: Google's File System
(SSTable)
◉ What does "Instance" mean on Big Table?. Answer: an entire
BigTable project which is nodes grouped into however many clusters
(all nodes and clusters)
◉ Is BigTable ops or No ops? Why. Answer: ops - must configure
nodes
◉ Big Table: Instance types. Answer: Development - low cost, single
node (no replication)
